2023-12-31 01:00:01 -- 將會員中心id寫入data-lake 2023-12-31 01:00:01 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2023-12-30%'; 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356566' WHERE ordernumber = 'P421230104850141' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '113488' WHERE ordernumber = 'P181230110220841' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '354331' WHERE ordernumber = 'P421230110251555' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '222823' WHERE ordernumber = 'P181230110433910' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '350632' WHERE ordernumber = 'P201230110547649' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356569' WHERE ordernumber = 'P181230110815604' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '117117' WHERE ordernumber = 'P191230110829253' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356569' WHERE ordernumber = 'P181230110847882' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '126845' WHERE ordernumber = 'P181230110933763' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '210566' WHERE ordernumber = 'P181230111025293' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356572' WHERE ordernumber = 'P191230111200641' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '327300' WHERE ordernumber = 'P201230111311262' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356575' WHERE ordernumber = 'P201230111829556' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '146068' WHERE ordernumber = 'P181230111841251' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356576' WHERE ordernumber = 'P181230112004989' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356577' WHERE ordernumber = 'P201230112054886' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '308932' WHERE ordernumber = 'P201230112155562' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356578' WHERE ordernumber = 'P181230112246189' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '100515' WHERE ordernumber = 'P181230112318647' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356580' WHERE ordernumber = 'P201230112722385' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356582' WHERE ordernumber = 'P181230112830982' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '348002' WHERE ordernumber = 'P421230112906754' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '353350' WHERE ordernumber = 'P201230113054401' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356583' WHERE ordernumber = 'P421230113145988' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '240584' WHERE ordernumber = 'P201230113230464' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356584' WHERE ordernumber = 'P421230113254721' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '258534' WHERE ordernumber = 'P201230113254621' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356585' WHERE ordernumber = 'P181230113315898' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '321135' WHERE ordernumber = 'P191230113538927' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356587' WHERE ordernumber = 'P181230114038934' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '220822' WHERE ordernumber = 'P421230114134277' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '270921' WHERE ordernumber = 'P201230114151171' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '129983' WHERE ordernumber = 'P191230114408321' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356589' WHERE ordernumber = 'P201230114525750' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356591' WHERE ordernumber = 'P421230114608782' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '299626' WHERE ordernumber = 'P201230114614195' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356592' WHERE ordernumber = 'P181230115113202' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '313349' WHERE ordernumber = 'P181230115309965' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '352773' WHERE ordernumber = 'P421230115409901' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '116470' WHERE ordernumber = 'P181230115416918' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356594' WHERE ordernumber = 'P181230115550709' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '275999' WHERE ordernumber = 'P181230115620159' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '98533' WHERE ordernumber = 'P201230115714622' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356596' WHERE ordernumber = 'P421230120049562' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356595' WHERE ordernumber = 'P201230120059150' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356597' WHERE ordernumber = 'P181230120109606' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356598' WHERE ordernumber = 'P421230120215890' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356600' WHERE ordernumber = 'P181230120541256' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '335859' WHERE ordernumber = 'P201230121109977' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356603' WHERE ordernumber = 'P201230121547511' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356604' WHERE ordernumber = 'P421230121733413' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356607' WHERE ordernumber = 'P201230122454685' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '352092' WHERE ordernumber = 'P181230122457658' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356608' WHERE ordernumber = 'P181230122930238' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '225352' WHERE ordernumber = 'P181230123123340' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '103424' WHERE ordernumber = 'P181230123405920' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356610' WHERE ordernumber = 'P181230123550252' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356611' WHERE ordernumber = 'P421230123612501' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356612' WHERE ordernumber = 'P181230123649193' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356614' WHERE ordernumber = 'P181230123837876' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356615' WHERE ordernumber = 'P421230123951928' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '252901' WHERE ordernumber = 'P201230124422473' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356620' WHERE ordernumber = 'P201230124640198' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '278639' WHERE ordernumber = 'P181230124700427' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '321140' WHERE ordernumber = 'P181230124827332' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '356625' WHERE ordernumber = 'P421230125540247' 2023-12-31 01:00:02 -- UPDATE `omo_order_list` SET userId = '349015' WHERE ordernumber = 'P201230130158452' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356627' WHERE ordernumber = 'P421230130722146' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '280152' WHERE ordernumber = 'P181230130750929' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '139617' WHERE ordernumber = 'P201230131054891' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356632' WHERE ordernumber = 'P201230131630436' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '346893' WHERE ordernumber = 'P201230131737808' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356634' WHERE ordernumber = 'P181230131942780' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '217708' WHERE ordernumber = 'P201230132025670' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356635' WHERE ordernumber = 'P421230132056176' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '127136' WHERE ordernumber = 'P421230132214584' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356636' WHERE ordernumber = 'P421230132330857' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '348260' WHERE ordernumber = 'P181230132502810' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '143193' WHERE ordernumber = 'P181230132814639' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356638' WHERE ordernumber = 'P421230132906407' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '28777' WHERE ordernumber = 'P191230133157232' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356642' WHERE ordernumber = 'P421230133440459' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '346646' WHERE ordernumber = 'P181230133626915' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356644' WHERE ordernumber = 'P201230133755192' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356645' WHERE ordernumber = 'P201230134046280' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '271811' WHERE ordernumber = 'P201230134331186' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356647' WHERE ordernumber = 'P421230134527772' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356649' WHERE ordernumber = 'P421230134839426' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356650' WHERE ordernumber = 'P181230134929562' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '224834' WHERE ordernumber = 'P421230134939946' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '146910' WHERE ordernumber = 'P201230134959609' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356652' WHERE ordernumber = 'P421230135810212' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356654' WHERE ordernumber = 'P181230135934928' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356657' WHERE ordernumber = 'P191230140112593' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356659' WHERE ordernumber = 'P181230140253896' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356653' WHERE ordernumber = 'P201230140400444' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356660' WHERE ordernumber = 'P201230140553389' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '259908' WHERE ordernumber = 'P181230140609648' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356661' WHERE ordernumber = 'P191230140649632' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '218859' WHERE ordernumber = 'P181230140805451' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356655' WHERE ordernumber = 'P201230140939703' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356665' WHERE ordernumber = 'P191230141011805' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '248196' WHERE ordernumber = 'P201230141020122' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356666' WHERE ordernumber = 'P421230141102246' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356667' WHERE ordernumber = 'P421230141210589' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '341791' WHERE ordernumber = 'P191230141311128' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '276432' WHERE ordernumber = 'P181230141410983' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '259908' WHERE ordernumber = 'P191230141547727' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '332133' WHERE ordernumber = 'P201230141655550' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356671' WHERE ordernumber = 'P191230141733243' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '338215' WHERE ordernumber = 'P191230141926945' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356673' WHERE ordernumber = 'P421230142138456' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '243030' WHERE ordernumber = 'P191230142142728' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356674' WHERE ordernumber = 'P421230142251595' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356675' WHERE ordernumber = 'P181230142401826' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '271536' WHERE ordernumber = 'P191230142419584' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356676' WHERE ordernumber = 'P421230142500546' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '271536' WHERE ordernumber = 'P191230142522725' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '148677' WHERE ordernumber = 'P181230142706896' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356678' WHERE ordernumber = 'P421230142724775' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356679' WHERE ordernumber = 'P181230142812914' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '343055' WHERE ordernumber = 'P191230142856265' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356681' WHERE ordernumber = 'P201230142913349' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356682' WHERE ordernumber = 'P181230142943558' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356683' WHERE ordernumber = 'P421230142956532' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '87432' WHERE ordernumber = 'P191230143452198' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '100874' WHERE ordernumber = 'P181230143755975' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '255647' WHERE ordernumber = 'P201230144207858' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356688' WHERE ordernumber = 'P421230144242477' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '353079' WHERE ordernumber = 'P181230144346136' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '271536' WHERE ordernumber = 'P191230144356723' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356692' WHERE ordernumber = 'P421230144714189' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356693' WHERE ordernumber = 'P191230144724371' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356694' WHERE ordernumber = 'P201230144919139' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356696' WHERE ordernumber = 'P181230144954727' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356699' WHERE ordernumber = 'P201230145259442' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '269206' WHERE ordernumber = 'P181230145505449' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356701' WHERE ordernumber = 'P421230145529455' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '354852' WHERE ordernumber = 'P191230145537650' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356702' WHERE ordernumber = 'P191230145934505' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '246883' WHERE ordernumber = 'P201230150011385' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356704' WHERE ordernumber = 'P191230150040486' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356705' WHERE ordernumber = 'P181230150126156' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356706' WHERE ordernumber = 'P191230150210258' 2023-12-31 01:00:03 -- UPDATE `omo_order_list` SET userId = '356708' WHERE ordernumber = 'P191230150312798' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356710' WHERE ordernumber = 'P181230150508731' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '296316' WHERE ordernumber = 'P421230150522422' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '276711' WHERE ordernumber = 'P191230150618212' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '189719' WHERE ordernumber = 'P181230150646282' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '355961' WHERE ordernumber = 'P181230150754884' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '355103' WHERE ordernumber = 'P201230150811994' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356714' WHERE ordernumber = 'P421230150856727' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '276711' WHERE ordernumber = 'P191230151109818' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356716' WHERE ordernumber = 'P421230151318295' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '276826' WHERE ordernumber = 'P181230151329267' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '287978' WHERE ordernumber = 'P201230151445971' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '287978' WHERE ordernumber = 'P201230151704166' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '96313' WHERE ordernumber = 'P421230151931448' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356718' WHERE ordernumber = 'P191230152017857' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356719' WHERE ordernumber = 'P421230152220177' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356720' WHERE ordernumber = 'P421230152331232' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356721' WHERE ordernumber = 'P181230152416927' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '106086' WHERE ordernumber = 'P181230152611615' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '269289' WHERE ordernumber = 'P421230152741445' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '301161' WHERE ordernumber = 'P201230152823564' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '331607' WHERE ordernumber = 'P191230152847376' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '118897' WHERE ordernumber = 'P181230152848366' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356725' WHERE ordernumber = 'P421230153025856' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356726' WHERE ordernumber = 'P181230153037667' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356729' WHERE ordernumber = 'P421230153141974' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356731' WHERE ordernumber = 'P421230153322535' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '354931' WHERE ordernumber = 'P181230153336363' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '119574' WHERE ordernumber = 'P201230153411713' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356732' WHERE ordernumber = 'P201230153517146' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356733' WHERE ordernumber = 'P421230153559752' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '313307' WHERE ordernumber = 'P421230153724751' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '250312' WHERE ordernumber = 'P201230153808568' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356739' WHERE ordernumber = 'P421230154024891' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '354442' WHERE ordernumber = 'P421230154324977' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '137784' WHERE ordernumber = 'P191230154420868' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '212315' WHERE ordernumber = 'P201230154621637' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '343775' WHERE ordernumber = 'P181230154629818' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356740' WHERE ordernumber = 'P421230154700544' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356741' WHERE ordernumber = 'P191230154800443' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356743' WHERE ordernumber = 'P201230155050634' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '266352' WHERE ordernumber = 'P181230155430168' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '239591' WHERE ordernumber = 'P181230155618131' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356748' WHERE ordernumber = 'P421230155728995' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356749' WHERE ordernumber = 'P181230155902649' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356750' WHERE ordernumber = 'P421230155923656' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356751' WHERE ordernumber = 'P421230160005804' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '137784' WHERE ordernumber = 'P191230160018737' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356755' WHERE ordernumber = 'P181230160243721' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356754' WHERE ordernumber = 'P191230160332902' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '330275' WHERE ordernumber = 'P181230160333904' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356741' WHERE ordernumber = 'P181230160356522' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356756' WHERE ordernumber = 'P421230160449477' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '229977' WHERE ordernumber = 'P181230160534176' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '345784' WHERE ordernumber = 'P191230160546739' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '312007' WHERE ordernumber = 'P181230160904981' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356759' WHERE ordernumber = 'P191230160918837' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '348868' WHERE ordernumber = 'P181230160956271' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356754' WHERE ordernumber = 'P191230161048956' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '283461' WHERE ordernumber = 'P201230161118265' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356760' WHERE ordernumber = 'P181230161119947' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '255137' WHERE ordernumber = 'P201230161243771' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '351591' WHERE ordernumber = 'P201230161428554' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '120508' WHERE ordernumber = 'P201230161753697' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '160727' WHERE ordernumber = 'P421230161838694' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '272361' WHERE ordernumber = 'P201230161849401' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356763' WHERE ordernumber = 'P201230161924357' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '276001' WHERE ordernumber = 'P201230162138929' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '142452' WHERE ordernumber = 'P201230162221647' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356764' WHERE ordernumber = 'P421230162255311' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '142452' WHERE ordernumber = 'P201230162312497' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '235055' WHERE ordernumber = 'P201230162419684' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '157035' WHERE ordernumber = 'P201230162438873' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356766' WHERE ordernumber = 'P421230162731449' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '137742' WHERE ordernumber = 'P191230162841332' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '283461' WHERE ordernumber = 'P201230163031818' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '337074' WHERE ordernumber = 'P191230163130725' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '352873' WHERE ordernumber = 'P421230163131538' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356767' WHERE ordernumber = 'P191230163323327' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356769' WHERE ordernumber = 'P191230163440294' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '260423' WHERE ordernumber = 'P201230163551331' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356772' WHERE ordernumber = 'P181230163958613' 2023-12-31 01:00:04 -- UPDATE `omo_order_list` SET userId = '356774' WHERE ordernumber = 'P421230164135968' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356775' WHERE ordernumber = 'P191230164239471' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '148757' WHERE ordernumber = 'P181230164309767' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356776' WHERE ordernumber = 'P421230164323746' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356775' WHERE ordernumber = 'P191230164338666' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '143596' WHERE ordernumber = 'P201230164429427' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356777' WHERE ordernumber = 'P181230164547873' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356779' WHERE ordernumber = 'P181230164709348' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '351168' WHERE ordernumber = 'P201230164900447' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356782' WHERE ordernumber = 'P191230165012360' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '183416' WHERE ordernumber = 'P181230165224764' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '162738' WHERE ordernumber = 'P201230165234813' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356784' WHERE ordernumber = 'P421230165542742' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '133873' WHERE ordernumber = 'P201230165658993' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '343221' WHERE ordernumber = 'P421230165752724' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356785' WHERE ordernumber = 'P191230165814180' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356786' WHERE ordernumber = 'P191230170006994' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '288308' WHERE ordernumber = 'P181230170018816' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356789' WHERE ordernumber = 'P421230170529388' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356068' WHERE ordernumber = 'P191230170619441' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356788' WHERE ordernumber = 'P191230170706467' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356788' WHERE ordernumber = 'P191230170732516' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356791' WHERE ordernumber = 'P191230170803691' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '296055' WHERE ordernumber = 'P181230170906161' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356794' WHERE ordernumber = 'P201230171136722' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356795' WHERE ordernumber = 'P191230171203385' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356797' WHERE ordernumber = 'P181230171231279' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356798' WHERE ordernumber = 'P201230171559269' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356335' WHERE ordernumber = 'P421230171731263' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356799' WHERE ordernumber = 'P201230171933870' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '107571' WHERE ordernumber = 'P181230172015128' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '284708' WHERE ordernumber = 'P191230172100491' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356800' WHERE ordernumber = 'P421230172244974' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356801' WHERE ordernumber = 'P181230172314966' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356806' WHERE ordernumber = 'P421230172713531' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356807' WHERE ordernumber = 'P181230172751113' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356802' WHERE ordernumber = 'P201230172803846' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356808' WHERE ordernumber = 'P181230172912365' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '276699' WHERE ordernumber = 'P191230173104259' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356810' WHERE ordernumber = 'P191230173318413' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '318041' WHERE ordernumber = 'P181230173447115' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '105986' WHERE ordernumber = 'P181230173544780' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356811' WHERE ordernumber = 'P421230173710653' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '209362' WHERE ordernumber = 'P191230173959513' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356813' WHERE ordernumber = 'P421230174102841' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '119607' WHERE ordernumber = 'P191230174123112' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356815' WHERE ordernumber = 'P191230174552759' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '310959' WHERE ordernumber = 'P191230174659977' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '251203' WHERE ordernumber = 'P181230174721950' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '100575' WHERE ordernumber = 'P181230175031501' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '353856' WHERE ordernumber = 'P421230175244878' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '351992' WHERE ordernumber = 'P201230175340201' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356817' WHERE ordernumber = 'P421230175402673' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356820' WHERE ordernumber = 'P181230175412463' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356822' WHERE ordernumber = 'P421230175609295' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356824' WHERE ordernumber = 'P181230175814464' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '88654' WHERE ordernumber = 'P181230175934257' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356825' WHERE ordernumber = 'P421230180037919' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356827' WHERE ordernumber = 'P181230180052534' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356829' WHERE ordernumber = 'P181230180207970' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356828' WHERE ordernumber = 'P421230180213879' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '278994' WHERE ordernumber = 'P191230180304320' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356831' WHERE ordernumber = 'P181230180322829' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356828' WHERE ordernumber = 'P421230180553850' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356833' WHERE ordernumber = 'P181230180745352' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '275220' WHERE ordernumber = 'P201230181022296' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '303059' WHERE ordernumber = 'P181230181027706' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356836' WHERE ordernumber = 'P201230181815549' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '171842' WHERE ordernumber = 'P181230181946313' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '352120' WHERE ordernumber = 'P191230182540111' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '99718' WHERE ordernumber = 'P201230182937817' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356841' WHERE ordernumber = 'P181230183021218' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '352257' WHERE ordernumber = 'P201230183531383' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '351322' WHERE ordernumber = 'P181230183856248' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356845' WHERE ordernumber = 'P181230184036874' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '356845' WHERE ordernumber = 'P181230184156870' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '94716' WHERE ordernumber = 'P191230184302220' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '350351' WHERE ordernumber = 'P201230184907241' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '352059' WHERE ordernumber = 'P421230185814281' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '300837' WHERE ordernumber = 'P201230190046530' 2023-12-31 01:00:05 -- UPDATE `omo_order_list` SET userId = '117648' WHERE ordernumber = 'P201230190224826' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356854' WHERE ordernumber = 'P421230190508329' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356858' WHERE ordernumber = 'P421230190736606' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '313372' WHERE ordernumber = 'P421230190804830' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P201230190810456' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356859' WHERE ordernumber = 'P421230190919435' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356860' WHERE ordernumber = 'P421230191010283' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356861' WHERE ordernumber = 'P421230191100776' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356858' WHERE ordernumber = 'P421230192027397' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356865' WHERE ordernumber = 'P201230192100832' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356865' WHERE ordernumber = 'P201230192201398' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '261174' WHERE ordernumber = 'P201230192314428' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '287978' WHERE ordernumber = 'P201230192413799' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '350391' WHERE ordernumber = 'P201230192453949' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '98135' WHERE ordernumber = 'P201230193619120' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356867' WHERE ordernumber = 'P201230194037584' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '235961' WHERE ordernumber = 'P201230194446256' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '343787' WHERE ordernumber = 'P191230194709271' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '356870' WHERE ordernumber = 'P421230194756304' 2023-12-31 01:00:06 -- UPDATE `omo_order_list` SET userId = '136646' WHERE ordernumber = 'P201230195736635'