| aba6a3 | N85SV | LJ35 | 347 | N85SV |
| a455cd | N379FX | E55P | 50500524 | LXJ379 |
| 4ca733 | EI-ECY | A319 | RYR8MX | |
| 4241e2 | VP-CYW | A319 | 4228 | VPCYW |
| 4241e2 | VP-CYW | A319 | 4228 | VPCYW |
| aa79f6 | N774XF | A319 | 2019 | AAL2174 |
| 503d35 | LY-KIT | A319 | 4663 | SZN216 |
| 503d35 | LY-KIT | A319 | 4663 | SZN216 |
| 4ca978 | EI-GKM | A320 | RYR7051 | |
| 86d607 | JA824P | A320 | 8835 | APJ285 |
| 710432 | HZ-FAK | A320 | 8673 | FAD482 |
| e08594 | LV-HVT | A320 | 8574 | JES3064 |
| 7c0d46 | VH-CWO | BE20 | BL-72 | CWO |
| 86d629 | JA825P | A320 | 8847 | APJ213 |
| 7585b3 | RP-C8948 | A320 | 5547 | APG307 |
| 7cf9f4 | A54-029 | PC21 | MUST2 | |
| a9c2ad | N728QL | C750 | 750-0295 | N728QL |
| 02a1b4 | TS-INU | A320 | 3827 | LBT7692 |
| adf61a | N999WV | C208 | 208B2082 | N999WV |
Sunday, 16th Jun
| 0101de | SU-GEU | B789 | 38802 | MSR996 |
| 76bd4a | 9V-OJJ | B789 | 37131 | TGW820 |
| a4bb8a | N404AN | A21N | 8758 | AAL2982 |
| 4d21ea | 9H-QAB | B738 | 44792 | RYR97CB |
| 8a07a5 | PK-SNM | C208 | PKSNM | |
| a62e0d | N498CL | C208 | 208B1299 | N498CL |
Saturday, 15th Jun
| ace60c | N930DZ | B739 | 63539 | DAL2640 |
| a420af | N365UP | B763 | 65788 | UPS401 |
| 4d012d | LX-KCL | B744 | 35236 | CLX4162 |
| 78175a | B-606R | GLF5 | MJC682 | |
| a2cf34 | N280NN | E75L | 17000800 | ENY3717 |
| a7dbaa | N605UX | E75L | 17000802 | SKW5354 |
| 49d3ac | OK-AST | C56X | 560-5068 | BOH712 |
| a46e40 | N385DZ | A321 | 8975 | DAL2809 |
| 3d5005 | D-FCOB | P46T | DFCOB | |
| ab73f5 | N837SK | CRJ9 | 15466 | SKW3752 |
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/