K.I.D Limited
Result : 14 item(s) Found select i.*,i2.od_cnt from yc4_item i left join (select it_id,count(it_id) as od_cnt from yc4_cart where on_uid in(select on_uid from yc4_order) group by it_id )i2 on i2.it_id=i.it_id where (i.ca_id like '30a0%' or i.ca_id2 like '30a0%' or i.ca_id3 like '30a0%') and i.it_use_jp = '1' order by i.it_amount_jp%20asc , i.it_order desc limit 0, 15 1054 : Unknown Į '20asc' in 'order clause' error file : /home/shop/list.php |