holidays_wk_ts_query.sql

-- HK
SELECT DISTINCT scheduled_transactions.id AS scheduled_transactions_id,
    user.country_id AS user_country_id,
    scheduled_transactions.user_id
FROM scheduled_transactions
    INNER JOIN user ON user.id = scheduled_transactions.user_id
WHERE user.country_id = 1
    AND scheduled_transactions.deleted IS FALSE
    AND scheduled_transactions.arrival_date IN(
        '2021-05-19',
        '2021-06-14',
        '2021-07-01',
        '2021-09-22',
        '2021-10-01',
        '2021-10-14',
        '2021-12-25',
        '2021-12-26',
        '2021-05-23',
        '2021-05-30',
        '2021-06-06',
        '2021-06-13',
        '2021-06-20',
        '2021-06-27',
        '2021-07-04',
        '2021-07-11',
        '2021-07-18',
        '2021-07-25',
        '2021-08-01',
        '2021-08-08',
        '2021-08-15',
        '2021-08-22',
        '2021-08-29',
        '2021-09-05',
        '2021-09-12',
        '2021-09-19',
        '2021-09-26',
        '2021-10-03',
        '2021-10-10',
        '2021-10-17',
        '2021-10-24',
        '2021-10-31',
        '2021-11-07',
        '2021-11-14',
        '2021-11-21',
        '2021-11-28',
        '2021-12-05',
        '2021-12-12',
        '2021-12-19',
        '2021-12-26',
        '2021-05-22',
        '2021-05-29',
        '2021-06-05',
        '2021-06-12',
        '2021-06-19',
        '2021-06-26',
        '2021-07-03',
        '2021-07-10',
        '2021-07-17',
        '2021-07-24',
        '2021-07-31',
        '2021-08-07',
        '2021-08-14',
        '2021-08-21',
        '2021-08-28',
        '2021-09-04',
        '2021-09-11',
        '2021-09-18',
        '2021-09-25',
        '2021-10-02',
        '2021-10-09',
        '2021-10-16',
        '2021-10-23',
        '2021-10-30',
        '2021-11-06',
        '2021-11-13',
        '2021-11-20',
        '2021-11-27',
        '2021-12-04',
        '2021-12-11',
        '2021-12-18',
        '2021-12-25'
    )
-- SGP
SELECT DISTINCT scheduled_transactions.id AS scheduled_transactions_id,
    user.country_id AS user_country_id,
    scheduled_transactions.user_id
FROM scheduled_transactions
    INNER JOIN user ON user.id = scheduled_transactions.user_id
WHERE user.country_id = 2
    AND scheduled_transactions.deleted IS FALSE
    AND scheduled_transactions.arrival_date IN(
        '2021-05-13',
        '2021-05-26',
        '2021-07-20',
        '2021-08-09',
        '2021-11-04',
        '2021-12-25',
        '2021-05-23',
        '2021-05-30',
        '2021-06-06',
        '2021-06-13',
        '2021-06-20',
        '2021-06-27',
        '2021-07-04',
        '2021-07-11',
        '2021-07-18',
        '2021-07-25',
        '2021-08-01',
        '2021-08-08',
        '2021-08-15',
        '2021-08-22',
        '2021-08-29',
        '2021-09-05',
        '2021-09-12',
        '2021-09-19',
        '2021-09-26',
        '2021-10-03',
        '2021-10-10',
        '2021-10-17',
        '2021-10-24',
        '2021-10-31',
        '2021-11-07',
        '2021-11-14',
        '2021-11-21',
        '2021-11-28',
        '2021-12-05',
        '2021-12-12',
        '2021-12-19',
        '2021-12-26',
        '2021-05-22',
        '2021-05-29',
        '2021-06-05',
        '2021-06-12',
        '2021-06-19',
        '2021-06-26',
        '2021-07-03',
        '2021-07-10',
        '2021-07-17',
        '2021-07-24',
        '2021-07-31',
        '2021-08-07',
        '2021-08-14',
        '2021-08-21',
        '2021-08-28',
        '2021-09-04',
        '2021-09-11',
        '2021-09-18',
        '2021-09-25',
        '2021-10-02',
        '2021-10-09',
        '2021-10-16',
        '2021-10-23',
        '2021-10-30',
        '2021-11-06',
        '2021-11-13',
        '2021-11-20',
        '2021-11-27',
        '2021-12-04',
        '2021-12-11',
        '2021-12-18',
        '2021-12-25'
    )