select shop_goods.* from shop_goods_cate,shop_goods where shop_goods_cate.site_code = '1' and shop_goods.site_code = '1' and catecode='0704' and isshow='Y' and shop_goods_cate.goods_idx=shop_goods.index_no order by isopen asc, shop_goods_cate.orders asc limit 0,100
출첵
장바구니
