| aba6a3 | N85SV | LJ35 | 347 | N85SV |
| 4241e2 | VP-CYW | A319 | 4228 | VPCYW |
| 4241e2 | VP-CYW | A319 | 4228 | VPCYW |
| 4d2038 | 9H-AFK | A319 | 2592 | KMM103 |
| aa79f6 | N774XF | A319 | 2019 | AA0013 |
| 86d607 | JA824P | A320 | 8835 | APJ710 |
| e08594 | LV-HVT | A320 | 8574 | JES3203 |
| 86d629 | JA825P | A320 | 8847 | APJ304 |
| 7585b3 | RP-C8948 | A320 | 5547 | APG942 |
| 02a1b4 | TS-INU | A320 | 3827 | LBT612 |
Sunday, 16th Jun
| 0101de | SU-GEU | B789 | 38802 | MSR952 |
| 76bd4a | 9V-OJJ | B789 | 37131 | TGW893 |
| c05219 | C-GFCI | A320 | 3286 | ROU1999 |
| a4bb8a | N404AN | A21N | 8758 | AAL2297 |
| 4d21ea | 9H-QAB | B738 | 44792 | RYR449A |
Saturday, 15th Jun
| ace60c | N930DZ | B739 | 63539 | DAL2425 |
| a420af | N365UP | B763 | 65788 | UPS340 |
| 4d012d | LX-KCL | B744 | 35236 | CLX6236 |
| a2cf34 | N280NN | E75L | 17000800 | ENY4155 |
| a7dbaa | N605UX | E75L | 17000802 | SKW5720 |
| 4bb325 | TC-LYE | B39M | 60066 | THY4YV |
| a46e40 | N385DZ | A321 | 8975 | DAL2324 |
Premiere: first RFDS PC-24 landing on an unpaved strip in the Australian Outback
MySQL conditional updates
INSERT INTO daily_events
(created_on, last_event_id, last_event_created_at)
VALUES
('2010-01-19', 23, '2010-01-19 10:23:11')
ON DUPLICATE KEY UPDATE
last_event_id = IF(last_event_created_at < VALUES(last_event_created_at), VALUES(last_event_id), last_event_id),
last_event_created_at = IF(last_event_created_at < VALUES(last_event_created_at), VALUES(last_event_created_at), last_event_created_at);
Source: https://thewebfellas.com/blog/conditional-duplicate-key-updates-with-mysql/