query

select a.*, b.catno, (select price from mini_goods_opt where goodsno=b.goodsno and type=0 and idx=0 order by no limit 1) as price, (select price1 from mini_goods_opt where goodsno=b.goodsno and type=0 and idx=0 order by no limit 1) as price1, (select primeprice from mini_goods_opt where goodsno=b.goodsno and type=0 and idx=0 order by no limit 1) as primeprice from mini_goods as a left join mini_goods_link as b on a.goodsno = b.goodsno where b.catno like '181001002002%' and a.state=1 group by b.goodsno order by b.nsort asc

file

/home/jumbo/public_html/goods/view_ifra.php (line:11) /home/jumbo/public_html/lib/template_/Template_.class.php (line:89) /home/jumbo/public_html/lib/template_/Template_.class.php (line:155) /home/jumbo/public_html/_compile/fashion/goods/view_ifra.htm.php (line:50) /home/jumbo/public_html/lib/template_/tpl_plugin/function.f_getGoodsDatSub_Data.php (line:15)