1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
SELECT *
FROM
(
(
(
SELECT
person_id,
p.first_name AS person_first_name,
p.last_name AS person_last_name,
created_at,
'metro' AS place,
station_id AS place_id
FROM transport.metro_usage_logs
INNER JOIN public.people AS p
ON p.id = person_id
WHERE
created_at BETWEEN timestamp '2059-12-03 17:00:00' AND timestamp '2059-12-03 21:59:59'
)
UNION
(
SELECT
person_id,
p.first_name AS person_first_name,
p.last_name AS person_last_name,
created_at,
'shop' AS place,
shop_id AS place_id
FROM public.shop_entrance_logs
INNER JOIN public.people AS p
ON p.id = person_id
WHERE
created_at BETWEEN timestamp '2059-12-03 17:00:00' AND timestamp '2059-12-03 21:59:59'
)
)
UNION
(
SELECT
person_id,
p.first_name AS person_first_name,
p.last_name AS person_last_name,
created_at,
'street' AS place,
street_id AS place_id
FROM public.street_logs
INNER JOIN public.people AS p
ON p.id = person_id
WHERE
created_at BETWEEN timestamp '2059-12-03 17:00:00' AND timestamp '2059-12-03 21:59:59'
)
) AS res
ORDER BY created_at ASC, person_id ASC
|
