By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| meta_id | post_id | meta_key | meta_value |
|---|---|---|---|
| 1 | 500 | performance_date_1 | 20220303 |
| 2 | 500 | performance_time_1 | 20:00:00 |
| 3 | 500 | performance_date_2 | 20220202 |
| 4 | 500 | performance_time_2 | 20:00:00 |
| 5 | 501 | performance_date_1 | 20220403 |
| 6 | 501 | performance_time_1 | 20:00:00 |
| 7 | 501 | performance_date_2 | 20220407 |
| 8 | 501 | performance_time_2 | 19:00:00 |
| post_id | new_date_1 | new_time_1 |
|---|---|---|
| 500 | 20220303 | 20:00:00 |
| 500 | 20220202 | 20:00:00 |
| 501 | 20220403 | 20:00:00 |
| 501 | 20220407 | 19:00:00 |