Merlin (2020)

Sanity 1 - check T_LIST against T_LIST_ARCH

field by field, checking 14618
L02085056096 :: Wicked (Apollo Victoria Theatre, West End) :: S1111972129
f_list_pl: 15 (live)<>0 (archive) f_list_ph: 98 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "15" where f_list_id="L02085056096" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "98" where f_list_id="L02085056096" limit 1;
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;
L02084590274 :: Mamma Mia! (Novello Theatre, West End) :: S0758428499
f_list_pl: 20 (live)<>0 (archive) f_list_ph: 95 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "20" where f_list_id="L02084590274" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "95" where f_list_id="L02084590274" 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;
L0762279636 :: Frankie Valli and The Four Seasons (M&S Bank Arena (formerly Liverpool Echo Arena), Liverpool) :: S02098578423
f_list_pl: 45 (live)<>0 (archive) f_list_ph: 75 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "45" where f_list_id="L0762279636" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "75" where f_list_id="L0762279636" limit 1;
L486693815 :: Frankie Valli and The Four Seasons (Motorpoint Arena Nottingham, Nottingham) :: S02098578423
f_list_pl: 45 (live)<>0 (archive) f_list_ph: 75 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "45" where f_list_id="L486693815" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "75" where f_list_id="L486693815" limit 1;
L0162945248 :: Frankie Valli and The Four Seasons (The Royal Albert Hall, Inner London) :: S02098578423
f_list_pl: 45 (live)<>0 (archive) f_list_ph: 100 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "45" where f_list_id="L0162945248" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "100" where f_list_id="L0162945248" limit 1;
L1080088500 :: George Benson (The Royal Albert Hall, Inner London) :: S0265387042
f_list_pl: 45 (live)<>0 (archive) f_list_ph: 90 (live)<>0 (archive)
update uktw_uktw.T_LIST_ARCH set f_list_pl = "45" where f_list_id="L1080088500" limit 1;
update uktw_uktw.T_LIST_ARCH set f_list_ph = "90" where f_list_id="L1080088500" limit 1;
Done ...