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

HOME <Elemental Guardians < Junior

Junior

Elder  Senior  Young  Junior  Baby

Result : 1 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 '1030%' or i.ca_id2 like '1030%' or i.ca_id3 like '1030%') 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