Результат поиска : 2 шт. товара 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 'e0%' or i.ca_id2 like 'e0%' or i.ca_id3 like 'e0%') and i.it_use_ru = '1' order by i.it_amount_ru%20asc , i.it_order desc limit 0, 10 1054 : Unknown Į '20asc' in 'order clause' error file : /home/shop/list.php |