출첵
좋아요
장바구니
기획전본문
제이로그
#러블리 #모던 #데일리 #페미닌
나만 알고싶은 곳, 제이로그 일상에 사랑스러움을 더해보세요!
-
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 = '4517' 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