设为首页 加入收藏

道菜谱

春节家宴 吉祥满屋

    {get sql="SELECT DISTINCT * FROM `phpcms_content` c,`phpcms_content_tag` t WHERE c.contentid=t.contentid and c.`status`=99 AND t.`tag` ='酸辣口味' ORDER BY c.contentid DESC" rows="15" }

  • 春节家宴
  • {/get}

    {get sql="SELECT DISTINCT * FROM `phpcms_content` c,`phpcms_content_tag` t WHERE c.contentid=t.contentid and c.`status`=99 AND t.`tag` ='咸酸口味' ORDER BY c.contentid DESC" rows="15" }

  • 春节家宴
  • {/get}

    {get sql="SELECT DISTINCT * FROM `phpcms_content` c,`phpcms_content_tag` t WHERE c.contentid=t.contentid and c.`status`=99 AND t.`tag` ='甜味口味' ORDER BY c.contentid DESC" rows="15" }

  • 春节家宴
  • {/get}

    {get sql="SELECT * FROM `phpcms_content` c,`phpcms_content_count` n WHERE updatetime>'.TIME.'-7*86400 and `thumb`!='' and c.contentid=n.contentid AND c.`status`=99 and catid in (177) ORDER BY n.hits DESC" rows="15"}

  • 春节家宴
  • {/get}

    {get sql="SELECT DISTINCT * FROM `phpcms_content` c,`phpcms_content_tag` t WHERE c.contentid=t.contentid and c.`status`=99 AND t.`tag` ='年夜饭' ORDER BY c.contentid DESC" rows="15" }

  • 春节家宴
  • {/get}
    {get sql="SELECT DISTINCT * FROM `phpcms_content` c,`phpcms_content_tag` t WHERE c.contentid=t.contentid and c.`status`=99 AND t.`tag` ='春节' and c.catid!=115 and c.catid!=105 and c.catid!=106 and c.catid!=107 and c.catid!=156 and c.catid!=157 and c.catid!=158 and c.catid!=159 and c.catid!=173 and c.catid!=126 and c.catid!=196 and c.catid!=197 and c.catid!=217 and c.catid!=304 and c.catid!=338 and c.catid!=350 and c.catid!=351 and c.catid!=161 and c.catid!=177 and c.catid!=145 and c.catid!=160 and c.catid!=409 and c.catid!=410 and c.catid!=413 and c.catid!=418 and c.catid!=419 and c.catid!=254 and c.catid!=255 and c.catid!=256 and c.catid!=257 and c.catid!=258 and c.catid!=259 and c.catid!=260 and c.catid!=261 and c.catid!=262 and c.catid!=277 and c.catid!=357 and c.catid!=358 and c.catid!=432 and c.catid!=264267 and c.catid!=269 and c.catid!=271 and c.catid!=272 and c.catid!=273 and c.catid!=274 and c.catid!=275 and c.catid!=270 and c.catid!=278 and c.catid!=280 and c.catid!=266 and c.catid!=283 and c.catid!=343 and c.catid!=346 and c.catid!=411 ORDER BY c.contentid DESC" rows="20" }
  • 春节家宴
  • {/get}