Merlin (2020)

Sanity 1 - check T_LIST against T_LIST_ARCH

field by field, checking 16240
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;
L595089127 :: Harry Potter and the Cursed Child - Part Two (Palace Theatre, West End) :: S1223519245
f_list_pl: 15 (live)<>0 (archive) f_list_ph: 65 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "15" where f_list_id="L595089127" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "65" where f_list_id="L595089127" limit 1;
L780325741 :: Harry Potter and the Cursed Child - Part One (Palace Theatre, West End) :: S1223519245
f_list_pl: 15 (live)<>0 (archive) f_list_ph: 65 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "15" where f_list_id="L780325741" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "65" where f_list_id="L780325741" limit 1;
Done ...