query

select /*/goods/print_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) price, (select sum(stock-rstock) from mini_goods_stock where goodsno=a.goodsno and part=0) totstock, (select price1 from mini_goods_opt where goodsno=a.goodsno and type=0 and idx=0 order by no limit 1) price1, (select primeprice from mini_goods_opt where goodsno=a.goodsno and type=0 and idx=0 order by no limit 1) primeprice from mini_goods as a where a.state=1 order by b.nsort asc limit 0,12

file

/home/jumbo/public_html/goods/print_list.php (line:141) /home/jumbo/public_html/lib/class.page_list.php (line:86) /home/jumbo/public_html/lib/class.page_list.php (line:60)