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

HOME <Carved Heritage < Senior

Senior

Hercules  Elder  Senior  Young  Junior

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

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

error file : /home/shop/list.php