SELECT holiday_name, description, link, CONCAT( LPAD(begin_month, 2, '0'), '/', LPAD(begin_day, 2, '0'), ' - ', LPAD(end_month, 2, '0'), '/', LPAD(end_day, 2, '0') ) AS period, holiday_type, CASE -- Holiday starts and ends in current month WHEN begin_month = MONTH(CURDATE()) AND end_month = MONTH(CURDATE()) THEN CONCAT('Day ', DAY(CURDATE()) - begin_day + 1, ' of ', duration_days) -- Holiday starts this month but ends later WHEN begin_month = MONTH(CURDATE()) AND end_month > MONTH(CURDATE()) THEN CONCAT('Day ', DAY(CURDATE()) - begin_day + 1, ' of ', duration_days) -- Holiday started before this month but ends this month WHEN end_month = MONTH(CURDATE()) AND begin_month < MONTH(CURDATE()) THEN CONCAT('Day ', duration_days - (end_day - DAY(CURDATE())), ' of ', duration_days) -- Holiday spans multiple months, current month is in the middle WHEN MONTH(CURDATE()) > begin_month AND MONTH(CURDATE()) < end_month THEN CONCAT('Day ~', FLOOR(duration_days / 2), ' of ', duration_days) ELSE NULL END AS progress, duration_days FROM tuxm_holidays WHERE enabled = 1 AND end_month IS NOT NULL AND end_day IS NOT NULL -- Country filter AND (countries = 'WL' OR FIND_IN_SET('us', REPLACE(countries, ' ', '')) > 0) -- Year filter AND ( (begin_year = 0 AND end_year = 0) OR (begin_year = YEAR(CURDATE()) AND end_year = YEAR(CURDATE())) OR (begin_year = YEAR(CURDATE()) AND end_year = 0) OR (begin_year = 0 AND end_year = YEAR(CURDATE())) OR (YEAR(CURDATE()) BETWEEN begin_year AND end_year) ) -- Current date within holiday range AND ( (begin_month = end_month AND MONTH(CURDATE()) = begin_month AND DAY(CURDATE()) BETWEEN begin_day AND end_day) OR (begin_month = MONTH(CURDATE()) AND DAY(CURDATE()) >= begin_day) OR (end_month = MONTH(CURDATE()) AND DAY(CURDATE()) <= end_day) OR (MONTH(CURDATE()) > begin_month AND MONTH(CURDATE()) < end_month) ) ORDER BY begin_month, begin_day Xnxx - Lesbian girlfriends Alyssa Bounty & Alya Stark lick each other | Foxdeo - We pay for your posts
⚽ #AFCON Earn 1,000 $ for Every Goal Scored! .