By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
areas_id | is_in_or_out | min_ts | max_ts |
---|---|---|---|
22 | 0 | 2020-08-07 07:00:06 | 2020-08-07 07:03:21 |
23 | 0 | 2020-08-07 07:00:06 | 2020-08-07 07:03:36 |
24 | 0 | 2020-08-07 07:00:06 | 2020-08-07 07:03:36 |
25 | 1 | 2020-08-07 07:00:06 | 2020-08-07 07:00:36 |
25 | 0 | 2020-08-07 07:00:51 | 2020-08-07 07:01:21 |
25 | 1 | 2020-08-07 07:01:36 | 2020-08-07 07:03:36 |
26 | 0 | 2020-08-07 07:00:06 | 2020-08-07 07:00:36 |
26 | 1 | 2020-08-07 07:00:51 | 2020-08-07 07:00:51 |
26 | 0 | 2020-08-07 07:01:06 | 2020-08-07 07:03:36 |
27 | 0 | 2020-08-07 07:00:06 | 2020-08-07 07:00:51 |
27 | 1 | 2020-08-07 07:01:06 | 2020-08-07 07:01:21 |
27 | 0 | 2020-08-07 07:01:36 | 2020-08-07 07:03:36 |