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,
    CONCAT(
        'Day ', 
        DATEDIFF(
            STR_TO_DATE(CONCAT(YEAR(CURDATE()), '-', begin_month, '-', begin_day), '%Y-%m-%d'),
            STR_TO_DATE(CONCAT(YEAR(CURDATE()), '-', begin_month, '-', begin_day), '%Y-%m-%d')
        ) + 1,
        ' of ', duration_days
    ) AS progress,
    duration_days
FROM tuxm_holidays
WHERE enabled = 1
  AND end_month IS NOT NULL
  AND end_day IS NOT NULL
  AND (countries = 'WL' OR FIND_IN_SET('us', REPLACE(countries, ' ', '')) > 0)

  AND (
        (begin_year = 2026 AND end_year = dateyear)
        OR (YEAR(CURDATE()) BETWEEN begin_year AND end_year)
        OR (begin_year = YEAR(CURDATE()) AND end_year = 2026)
        OR (begin_year = 2026 AND end_year = YEAR(CURDATE()))
      )

  AND STR_TO_DATE(CONCAT(YEAR(CURDATE()), '-', begin_month, '-', begin_day), '%Y-%m-%d') 
      <= CURDATE()
  AND STR_TO_DATE(CONCAT(YEAR(CURDATE()), '-', end_month, '-', end_day), '%Y-%m-%d') 
      >= CURDATE()
ORDER BY begin_month, begin_day