By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ID | Name |
---|---|
1 | First event |
2 | Second event |
3 | Third event |
4 | Fourth event |
5 | Fifth event |
ID | EventID | MetaKey | MetaValue |
---|---|---|---|
1 | 2 | date_expired | 2023-02-09 00:00:00 |
2 | 2 | date_expired | 2023-01-23 00:00:00 |
3 | 3 | date_expired | 2023-04-30 00:00:00 |
4 | 3 | date_expired | 2023-01-22 00:00:00 |
5 | 4 | date | 2023-06-12 00:00:00 |
6 | 4 | date | 2023-02-03 00:00:00 |
7 | 5 | date_expired | 2023-02-13 00:00:00 |
8 | 5 | date | 2023-01-02 00:00:00 |
9 | 5 | date | 2023-01-01 00:00:00 |
Name | sorting_key_1 | sorting_key_2 |
---|---|---|
First event | null | null |
Third event | null | 2023-01-22 00:00:00 |
Second event | null | 2023-01-23 00:00:00 |
Fifth event | 2023-01-01 00:00:00 | 2023-02-13 00:00:00 |
Fourth event | 2023-02-03 00:00:00 | null |
Name | sorting_key_1 | sorting_key_2 |
---|---|---|
Fifth event | 2023-01-01 00:00:00 | 2023-02-13 00:00:00 |
Fourth event | 2023-02-03 00:00:00 | 9999-12-31 |
Third event | 9999-12-31 | 2023-01-22 00:00:00 |
Second event | 9999-12-31 | 2023-01-23 00:00:00 |
First event | 9999-12-31 | 9999-12-31 |
Name |
---|
Fifth event |
Fourth event |
Third event |
Second event |
First event |