출첵
좋아요
장바구니
기획전본문
베이직
-
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.ticons, 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 = '040701' 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
