a455cd | N379FX | E55P | 50500524 | LXJ379 |
4241e2 | VP-CIA | A319 | 4228 | VPCYW |
4241e2 | VP-CIA | A319 | 4228 | VPCYW |
4d2038 | 9H-MCE | A319 | 2592 | KMM492 |
aa79f6 | N774XF | A319 | 2019 | AAL2163 |
346156 | EC-NBD | A319 | 1901 | VOE506 |
4d2023 | 9H-AEM | A319 | 2382 | EWG6881 |
a6104c | N490CB | CL30 | 20147 | N490CB |
86d607 | JA824P | A320 | 8835 | APJ483 |
710432 | HZ-FAK | A320 | 8673 | FAD753 |
e08594 | LV-HVT | A320 | 8574 | JES3815 |
7c0d46 | VH-CWO | BE20 | BL-72 | CWO |
86d629 | JA825P | A320 | 8847 | APJ924 |
7585b3 | RP-C8948 | A320 | 5547 | APG351 |
7cf9f4 | A54-029 | PC21 | ROLR28 | |
a9c2ad | N728QL | C750 | 750-0295 | N728QL |
02a1b4 | TS-INU | A320 | 3827 | LBT7294 |
adf61a | N999WV | C208 | 208B2082 | N999WV |
Sunday, 16th Jun
0101de | SU-GEU | B789 | 38802 | MSR954 |
76bd4a | 9V-OJJ | B789 | 37131 | TGW452 |
a1f4b3 | N225MM | AC90 | 11462 | N225MM |
c05219 | C-GFCI | A320 | 3286 | ROU1913 |
a4bb8a | N404AN | A21N | 8758 | AAL1474 |
4d21ea | 9H-QAB | B738 | 44792 | RYR1TY |
8a07a5 | PK-SNM | C208 | PKSNM |
Saturday, 15th Jun
ace60c | N930DZ | B739 | 63539 | DAL682 |
a420af | N365UP | B763 | 65788 | UPS5301 |
c0753b | C-GSKG | B190 | UC-22 | SLQ727 |
4d012d | LX-KCL | B744 | 35236 | CLX67W |
78175a | B-606R | GLF5 | MJC682 | |
a10c3e | N167FT | C68A | 680A0204 | EJM53 |
a2cf34 | N280NN | E75L | 17000800 | ENY3562 |
a7dbaa | N605UX | E75L | 17000802 | SKW5685 |
49d3ac | OK-AST | C56X | 560-5068 | BOH712 |
4bb325 | TC-LYE | B39M | 60066 | THY3ML |
c059c9 | C-GIAA | AC90 | 11505 | FGD137 |
a46e40 | N385DZ | A321 | 8975 | DAL1251 |
3d5005 | D-FCOB | P46T | DFCOB | |
ab73f5 | N837SK | CRJ9 | 15466 | SKW4173 |
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/