출첵
좋아요
장바구니
기획전본문
소르샵
#유니크 #스트릿 #포인트업
매일 입고 싶은 옷, 소르샵 베이직한 옷도 힙하고 트렌디하게!
-
select shop_goods.index_no, shop_goods.gname, shop_goods.account, shop_goods.simg6, shop_goods.simg6, shop_goods.saccount, shop_goods.discount, shop_goods.dis_sdate, shop_goods.dis_edate, shop_goods.opendate, shop_goods.newtosale, shop_goods.saccount, shop_goods.icons, shop_goods.opendate_s, shop_goods.isopen, shop_goods.opendate_s, shop_goods.isopen, shop_goods.gname_pre, shop_goods.gname_pre_color, shop_goods.istoday, shop_goods.account
from shop_goods_cate, shop_goods where catecode = '4501' and isshow='Y' and isopen = '2' and shop_goods_cate.goods_idx = shop_goods.index_no and shop_goods.isopen = '2' order by shop_goods_cate.new_orders asc , shop_goods_cate.sort_date desc, shop_goods.opendate desc, shop_goods.index_no desc limit 0,100
