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 
        WHEN begin_month = MONTH(CURDATE()) AND end_month = MONTH(CURDATE())
        THEN CONCAT('Day ', DAY(CURDATE()) - begin_day + 1, ' of ', duration_days)

        WHEN begin_month = MONTH(CURDATE()) AND end_month > MONTH(CURDATE())
        THEN CONCAT('Day ', DAY(CURDATE()) - begin_day + 1, ' of ', duration_days)
      
        WHEN end_month = MONTH(CURDATE()) AND begin_month < MONTH(CURDATE())
        THEN CONCAT('Day ', 
                   duration_days - (end_day - DAY(CURDATE())), 
                   ' of ', duration_days)
     
        WHEN MONTH(CURDATE()) > begin_month AND MONTH(CURDATE()) < end_month
        THEN CONCAT('Day ~', 
                   FLOOR(duration_days / 2), 
                   ' of ', duration_days)
    END as progress,
    duration_days
FROM tuxm_holidays 
WHERE (countries = 'WL' OR FIND_IN_SET('us', REPLACE(countries, ' ', '')) > 0)
  AND enabled = 1
  AND end_month IS NOT NULL 
  AND end_day IS NOT NULL


  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) 
  )
  
  AND (
    (begin_month = end_month AND begin_month = MONTH(CURDATE()) 
     AND DAY(CURDATE()) > begin_day AND DAY(CURDATE()) < end_day)
    OR
    (begin_month = MONTH(CURDATE()) AND begin_day < DAY(CURDATE()))
    OR
    (end_month = MONTH(CURDATE()) AND end_day > DAY(CURDATE()))
    OR
    (MONTH(CURDATE()) > begin_month AND MONTH(CURDATE()) < end_month)
  )