SELECT
        persisted_date.id_date, org_holiday.org_id, org_holiday.is_holiday, org_holiday.holiday_name, org_holiday.is_easter, org_holiday.is_year_start_mark,
        org_holiday.compensation_shift_for_work, org_holiday.day_in_lieu_for_work, org_holiday.holiday_region,
        persisted_date.YEAR, persisted_date.day_of_week, persisted_date.month_number, persisted_date.is_weekend
      FROM
        org_holiday
          LEFT JOIN
        persisted_date ON org_holiday.id_date = persisted_date.id_date
      WHERE
       org_holiday.is_holiday = 1 AND org_holiday.org_id = {orgId} AND persisted_date.id_date >= {START} AND persisted_date.id_date <= {END}