본문내용 바로가기 주메뉴 바로가기

HOME <The Addiction < Senior

Senior

Elder  Senior  Young  Junior  Kid  Baby

Result : 8 item(s) Found

  • New
  • Popularity
  • Low price
  • High price
  • Name

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 'c020%' or i.ca_id2 like 'c020%' or i.ca_id3 like 'c020%') and i.it_use_en = '1' order by i.it_amount_en%20asc , i.it_order desc limit 0, 20

1054 : Unknown Į '20asc' in 'order clause'

error file : /home/shop/list.php