이벤트/기획전
-
(
-- ev_type = 5 중 조건을 만족하는 최신 하나만
SELECT *
FROM wm_shop_event
WHERE ev_use = '1' AND ev_section = '기획전'
AND ev_type = 5
AND CURDATE() BETWEEN ev_event_start5 AND ev_event_end5
ORDER BY ev_id DESC
LIMIT 1
)
UNION ALL
(
-- 나머지 ev_type != 5인 모든 항목
SELECT *
FROM wm_shop_event
WHERE ev_use = '1' AND ev_section = '기획전'
AND ev_type != 5
)
ORDER BY ev_id DESC