인기순 최근등록순 판매수량순 SELECT DISTINCT p.*, p.prod_code AS p_code , CASE WHEN INSTR(badge, 'best') AND IFNULL(badge_best_date1, '') <= SUBSTR(NOW(), 1, 10) AND IFNULL(badge_best_date2, '') >= SUBSTR(NOW(), 1, 10) THEN 'Y' ELSE 'N' END badge_best_yn , CASE WHEN INSTR(badge, 'new') AND IFNULL(badge_new_date1, '') <= SUBSTR(NOW(), 1, 10) AND IFNULL(badge_new_date2, '') >= SUBSTR(NOW(), 1, 10) THEN 'Y' ELSE 'N' END badge_new_yn FROM itm_product p LEFT JOIN itm_prod_recomm r ON r.prod_code = p.prod_code AND r.del_yn = 'N' WHERE p.del_yn = 'N' AND p.mall_id = 'mimt' GROUP BY p.prod_code ORDER BY p.idx DESC LIMIT 0, 6

Medflex(2") 0원 70,000원	플라즈마멸균제 0원 171,600원
F TnI (1Box, 5EA) 0원 110,000원	C TnI (1Box, 5EA) 0원 110,000원
CryoPen N2o 카트리지 0원 150,000원	초음파수술기(소노블레이드) 0원 6,600,000원

더보기