query

select /*/goods/request_list.php*/ sql_calc_found_rows a.*, (select price1 from mini_goods_opt where goodsno=a.goodsno and type=0 and idx=0 order by no limit 1) as price, (select sum(stock-rstock) from mini_goods_stock where goodsno=a.goodsno and part=0) as totstock, (select price1 from mini_goods_opt where goodsno=a.goodsno and type=0 and idx=0 order by no limit 1) as price1, (select primeprice from mini_goods_opt where goodsno=a.goodsno and type=0 and idx=0 order by no limit 1) as primeprice,b.goodsno from mini_goods as a ,mini_goods_link as b where a.goodsno = b.goodsno and left(b.catno,6) = '173001' and a.state=1 group by b.goodsno order by b.sort asc, b.goodsno desc limit 0,9999

file

/home/jumbo/public_html/goods/request_list.php (line:83) /home/jumbo/public_html/lib/class.page.php (line:86) /home/jumbo/public_html/lib/class.page.php (line:60)