select a.* FROM shop_goods a LEFT JOIN shop_goods_cate b ON ( a.index_no = b.goods_idx ) LEFT JOIN shop_cate_blse c ON ( b.gcate = c.catecode ) WHERE a.shop_state = '0' AND a.shop_open = '0' AND a.isopen < '3' AND c.u_hide = '0' AND (LEFT(a.user_id,3)='AP-' OR a.user_id = 'admin' OR a.user_id = 'blse' ) AND find_in_set('blse', a.use_hide) = '0' AND c.p_hide = '0' and left(b.gcate,9)='038002006' group by a.index_no order by a.listup desc, a.index_no desc limit 0, 30
카테고리배너

위니아 (TOTAL 38 PRODUCTS)

가격대별
브랜드
렌탈사
평형
타입