-- Прошедший месяц

-- filter=active
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2019-10-01T00:00:00'::DATE, '2019-10-31T23:59:00'::DATE, '[]'))
AND stop > now()
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=scheduled
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2019-10-01T00:00:00'::DATE, '2019-10-31T23:59:00'::DATE, '[]'))
AND now() <= START
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=finished
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND stop >= '2019-10-01T00:00:00' AND stop <= '2019-10-31T23:59:00'
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=paused
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2019-10-01T00:00:00'::DATE, '2019-10-31T23:59:00'::DATE, '[]'))
AND is_paused = TRUE
ORDER BY id
LIMIT 100 OFFSET 0;


-- Текущий месяц

-- filter=active
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2019-12-01T00:00:00'::DATE, '2019-12-31T23:59:00'::DATE, '[]'))
AND stop > now()
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=scheduled
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2019-12-01T00:00:00'::DATE, '2019-12-31T23:59:00'::DATE, '[]'))
AND now() <= START
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=finished
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND stop >= '2019-12-01T00:00:00' AND stop <= now()
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=paused
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2019-12-01T00:00:00'::DATE, '2019-12-31T23:59:00'::DATE, '[]'))
AND is_paused = TRUE
ORDER BY id
LIMIT 100 OFFSET 0;

-- Будущий месяц

-- filter=active
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2020-01-01T00:00:00'::DATE, '2020-01-31T23:59:00'::DATE, '[]'))
AND stop > now()
AND is_paused = FALSE
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=scheduled
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2020-01-01T00:00:00'::DATE, '2020-10-31T23:59:00'::DATE, '[]'))
AND now() <= START
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=finished
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND stop >= '2020-01-01T00:00:00' AND stop <= '2020-10-31T23:59:00'
ORDER BY id
LIMIT 100 OFFSET 0;

-- filter=paused
SELECT id, START, stop
FROM adroom2_blocks
WHERE campaign_id = 868
AND is_deleted = FALSE
AND (daterange(START::DATE, stop::DATE, '[]') && daterange('2020-01-01T00:00:00'::DATE, '2020-10-31T23:59:00'::DATE, '[]'))
AND is_paused = TRUE
ORDER BY id
LIMIT 100 OFFSET 0;