Merlin (2020)

Sanity 1 - check T_LIST against T_LIST_ARCH

field by field, checking 16162
L0221901986 :: Sunday Social (Royal Vauxhall Tavern, Inner London) :: S478573447
f_list_pl: 0 (live)<>4 (archive) f_list_ph: 0 (live)<>5 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "0" where f_list_id="L0221901986" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "0" where f_list_id="L0221901986" limit 1;
L01920684624 :: Duckie (Royal Vauxhall Tavern, Inner London) :: S274638833
f_list_pl: 0 (live)<>6 (archive) f_list_ph: 0 (live)<>6 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "0" where f_list_id="L01920684624" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "0" where f_list_id="L01920684624" limit 1;
L077432593 :: Dark (Festival Theatre, Paignton) :: S518
f_list_to: 0000-00-00 00:00:00 (live)<>1998-12-31 00:00:00 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_to = "0000-00-00 00:00:00" where f_list_id="L077432593" limit 1;
L974333891 :: Dark (Odeon Norwich, Norwich) :: S518
f_list_to: 0000-00-00 00:00:00 (live)<>2000-10-01 00:00:00 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_to = "0000-00-00 00:00:00" where f_list_id="L974333891" limit 1;
L01743984783 :: KidZania (Entrance) (General, Outer London) :: S0709163582
f_list_pl: 0 (live)<>16.5 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "0" where f_list_id="L01743984783" limit 1;
Done ...