select i.price_m/i.real_sellprice as rates, i.price,i.seq,i.title, i.price_m, i.price_v, i.attach1, i.thumb1, i.thumb2, i.thumb3, i.thumb4, i.thumb5, i.icon2, i.icon3, i.input_date, i.point, b.b_nm, (select count(*) from KBUY_BBS where itemseq=i.seq and cla='r' and view_yn='y' and del_yn='n') as review_qty from KBUY_ITEM i left join KBUY_ITEM_DETAIL d on i.seq=d.i_seq left join KBUY_ITEM_BRAND b on i.brandseq=b.seq where i.price_v>0 and i.price_m>0 and d.stock>0 and (i.view_yn='y' or i.view_yn='w' ) and i.del_yn='n' and i.or_price>0 and i.brandseq in ('91') group by i.seq order by 1 desc , i.ranking desc, i.input_date desc, i.seq aSC limit 4, 32
첫 페이지 이전 페이지
  1. 1
다음 페이지 마지막 페이지