SELECT
    adm_calendar_holliday.cal_holliday_id,
    adm_calendar_holliday.cal_holliday_unit_id,
    adm_calendar_holliday.cal_holliday_enable,
    adm_calendar_holliday.cal_holliday_delete_bit,
    adm_calendar_holliday.cal_holliday_reference,
    adm_calendar_holliday.cal_holliday_type,
    adm_calendar_holliday.cal_holliday_label
FROM adm_calendar_holliday
WHERE adm_calendar_holliday.cal_holliday_type = ANY (ARRAY[9,
    10])
ORDER BY adm_calendar_holliday.cal_holliday_label