2024-05-11 01:00:01 -- 將會員中心id寫入data-lake 2024-05-11 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 '2024-05-10%'; 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '386070' WHERE ordernumber = 'P630510104657668' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '161924' WHERE ordernumber = 'P200510110422618' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389247' WHERE ordernumber = 'P190510110524952' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389248' WHERE ordernumber = 'P200510110545368' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389249' WHERE ordernumber = 'P190510110622928' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389250' WHERE ordernumber = 'P200510110704772' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '343014' WHERE ordernumber = 'P420510110740445' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389251' WHERE ordernumber = 'P190510110847919' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '295216' WHERE ordernumber = 'P200510110906709' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389252' WHERE ordernumber = 'P190510110945542' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '383210' WHERE ordernumber = 'P190510111052180' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389254' WHERE ordernumber = 'P200510111116461' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '124230' WHERE ordernumber = 'P190510111259180' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389254' WHERE ordernumber = 'P200510111308238' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '279309' WHERE ordernumber = 'P180510111709173' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '388513' WHERE ordernumber = 'P180510111804751' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '289367' WHERE ordernumber = 'P200510111813532' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '124230' WHERE ordernumber = 'P180510111837165' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389257' WHERE ordernumber = 'P180510112051324' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389256' WHERE ordernumber = 'P630510112059123' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389258' WHERE ordernumber = 'P190510112131947' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389259' WHERE ordernumber = 'P420510112202895' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389240' WHERE ordernumber = 'P180510112600958' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389239' WHERE ordernumber = 'P180510112805342' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389260' WHERE ordernumber = 'P200510112912997' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '337407' WHERE ordernumber = 'P190510112916700' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '217473' WHERE ordernumber = 'P180510112958220' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389261' WHERE ordernumber = 'P420510113019301' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '163743' WHERE ordernumber = 'P200510113432112' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389262' WHERE ordernumber = 'P180510113656785' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '206952' WHERE ordernumber = 'P180510113913307' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '387919' WHERE ordernumber = 'P180510114537852' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '344875' WHERE ordernumber = 'P180510114736934' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389263' WHERE ordernumber = 'P190510114826415' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '363042' WHERE ordernumber = 'P420510114913981' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389265' WHERE ordernumber = 'P180510115013477' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '320796' WHERE ordernumber = 'P180510115108640' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '239316' WHERE ordernumber = 'P790510115324707' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '131531' WHERE ordernumber = 'P180510115351826' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '284943' WHERE ordernumber = 'P180510115439219' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389266' WHERE ordernumber = 'P420510115539569' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '130787' WHERE ordernumber = 'P180510115551648' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '296766' WHERE ordernumber = 'P420510115837426' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389267' WHERE ordernumber = 'P630510115927570' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '206917' WHERE ordernumber = 'P180510120002269' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389268' WHERE ordernumber = 'P180510120239959' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '239316' WHERE ordernumber = 'P790510120558314' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389270' WHERE ordernumber = 'P180510120645540' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389271' WHERE ordernumber = 'P630510120933983' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389272' WHERE ordernumber = 'P200510120944836' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '117888' WHERE ordernumber = 'P180510121022192' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '358516' WHERE ordernumber = 'P200510121050844' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '343725' WHERE ordernumber = 'P200510121711366' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389273' WHERE ordernumber = 'P180510121723196' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389274' WHERE ordernumber = 'P630510122056671' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '388529' WHERE ordernumber = 'P200510122143777' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '222035' WHERE ordernumber = 'P180510122218506' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '289710' WHERE ordernumber = 'P200510122513380' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '130789' WHERE ordernumber = 'P180510122631537' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '388767' WHERE ordernumber = 'P180510122754273' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389276' WHERE ordernumber = 'P180510122857590' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '279806' WHERE ordernumber = 'P180510123113339' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389277' WHERE ordernumber = 'P630510123129274' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389279' WHERE ordernumber = 'P180510123340162' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389275' WHERE ordernumber = 'P420510123426651' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '388767' WHERE ordernumber = 'P180510123710819' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389233' WHERE ordernumber = 'P200510123947508' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389233' WHERE ordernumber = 'P200510124133130' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '88985' WHERE ordernumber = 'P180510124155758' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '271483' WHERE ordernumber = 'P200510124203723' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389280' WHERE ordernumber = 'P790510124553951' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389282' WHERE ordernumber = 'P200510124759761' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389281' WHERE ordernumber = 'P790510124807582' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '281905' WHERE ordernumber = 'P200510124849141' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389283' WHERE ordernumber = 'P630510124854779' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '262780' WHERE ordernumber = 'P200510125212277' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '358320' WHERE ordernumber = 'P420510125242463' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389100' WHERE ordernumber = 'P630510125251758' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '348545' WHERE ordernumber = 'P420510125415592' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '358462' WHERE ordernumber = 'P200510125424829' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389164' WHERE ordernumber = 'P180510125616345' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '129132' WHERE ordernumber = 'P180510125648131' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389278' WHERE ordernumber = 'P630510130130544' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389287' WHERE ordernumber = 'P790510130450195' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389289' WHERE ordernumber = 'P180510130717917' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '160219' WHERE ordernumber = 'P180510130826605' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389290' WHERE ordernumber = 'P200510131042787' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389291' WHERE ordernumber = 'P180510131156493' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389292' WHERE ordernumber = 'P180510131317174' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '350085' WHERE ordernumber = 'P180510131355615' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '107702' WHERE ordernumber = 'P200510131658457' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '343382' WHERE ordernumber = 'P420510132011522' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '351153' WHERE ordernumber = 'P180510132017803' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '376600' WHERE ordernumber = 'P180510132137340' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '299403' WHERE ordernumber = 'P420510132526963' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389294' WHERE ordernumber = 'P200510132527846' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '385187' WHERE ordernumber = 'P180510132729947' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '95584' WHERE ordernumber = 'P180510132825511' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389295' WHERE ordernumber = 'P200510132858518' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '131531' WHERE ordernumber = 'P180510133018704' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '388752' WHERE ordernumber = 'P180510133720572' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389296' WHERE ordernumber = 'P420510133947304' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389297' WHERE ordernumber = 'P420510134100937' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '360315' WHERE ordernumber = 'P200510134208461' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389298' WHERE ordernumber = 'P180510134415895' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '350995' WHERE ordernumber = 'P200510134810872' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '389299' WHERE ordernumber = 'P180510134839864' 2024-05-11 01:00:02 -- UPDATE `omo_order_list` SET userId = '303073' WHERE ordernumber = 'P590510134925516' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '385609' WHERE ordernumber = 'P420510135001703' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '80514' WHERE ordernumber = 'P200510135010378' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '97197' WHERE ordernumber = 'P200510135105227' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '305444' WHERE ordernumber = 'P420510135157391' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389300' WHERE ordernumber = 'P180510135207874' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389301' WHERE ordernumber = 'P200510135328123' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '84172' WHERE ordernumber = 'P200510135403503' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389302' WHERE ordernumber = 'P180510135409838' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389294' WHERE ordernumber = 'P200510135716823' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180510135724329' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '383315' WHERE ordernumber = 'P200510135816714' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '370898' WHERE ordernumber = 'P200510140453186' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '383239' WHERE ordernumber = 'P180510140516522' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '383343' WHERE ordernumber = 'P180510140728954' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389305' WHERE ordernumber = 'P180510140856649' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '385723' WHERE ordernumber = 'P180510140956144' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '385500' WHERE ordernumber = 'P200510141104456' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '275450' WHERE ordernumber = 'P180510141214334' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '104613' WHERE ordernumber = 'P200510141239792' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '386540' WHERE ordernumber = 'P420510142138171' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '380693' WHERE ordernumber = 'P630510142156730' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389253' WHERE ordernumber = 'P180510142400770' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389050' WHERE ordernumber = 'P630510142420170' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389306' WHERE ordernumber = 'P630510142817367' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389307' WHERE ordernumber = 'P180510143002770' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '385079' WHERE ordernumber = 'P180510143407531' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389308' WHERE ordernumber = 'P630510143456344' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389309' WHERE ordernumber = 'P790510143627931' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '55289' WHERE ordernumber = 'P180510143830334' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '308228' WHERE ordernumber = 'P200510143909902' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '386742' WHERE ordernumber = 'P180510143914603' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '258889' WHERE ordernumber = 'P180510144158219' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '344546' WHERE ordernumber = 'P420510144341243' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389311' WHERE ordernumber = 'P790510144545789' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '115196' WHERE ordernumber = 'P180510145156536' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389312' WHERE ordernumber = 'P420510145248507' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389313' WHERE ordernumber = 'P420510145412705' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389315' WHERE ordernumber = 'P790510145558945' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389316' WHERE ordernumber = 'P180510145629441' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '269154' WHERE ordernumber = 'P180510145704949' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '378909' WHERE ordernumber = 'P200510145735430' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389317' WHERE ordernumber = 'P180510145912729' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389319' WHERE ordernumber = 'P200510150328270' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389320' WHERE ordernumber = 'P180510150601912' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389321' WHERE ordernumber = 'P790510150642189' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '83824' WHERE ordernumber = 'P180510151022927' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '90938' WHERE ordernumber = 'P200510151135917' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '167252' WHERE ordernumber = 'P180510151503890' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '244781' WHERE ordernumber = 'P200510151548492' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '62031' WHERE ordernumber = 'P200510151708600' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389324' WHERE ordernumber = 'P180510151948120' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389325' WHERE ordernumber = 'P790510152006220' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389326' WHERE ordernumber = 'P790510152232599' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389323' WHERE ordernumber = 'P630510152238275' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389328' WHERE ordernumber = 'P180510152747542' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389330' WHERE ordernumber = 'P190510152846737' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389331' WHERE ordernumber = 'P180510152855793' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389329' WHERE ordernumber = 'P420510152903905' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '385825' WHERE ordernumber = 'P180510153157907' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '203578' WHERE ordernumber = 'P190510153225746' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '274039' WHERE ordernumber = 'P420510154021360' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389332' WHERE ordernumber = 'P190510154141155' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389334' WHERE ordernumber = 'P200510154144557' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '166111' WHERE ordernumber = 'P630510154354448' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '360315' WHERE ordernumber = 'P200510154521288' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389335' WHERE ordernumber = 'P190510154538526' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389335' WHERE ordernumber = 'P190510154608482' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '344394' WHERE ordernumber = 'P190510154753263' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389336' WHERE ordernumber = 'P200510154907757' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389337' WHERE ordernumber = 'P190510155152266' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '310643' WHERE ordernumber = 'P190510155228514' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '245369' WHERE ordernumber = 'P200510155249825' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '310643' WHERE ordernumber = 'P190510155256341' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '94190' WHERE ordernumber = 'P190510155318911' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '316417' WHERE ordernumber = 'P200510155426988' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '138293' WHERE ordernumber = 'P190510155501281' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '354098' WHERE ordernumber = 'P630510155800557' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '108179' WHERE ordernumber = 'P190510155949394' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '215024' WHERE ordernumber = 'P200510160004642' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389339' WHERE ordernumber = 'P790510160200424' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389340' WHERE ordernumber = 'P180510160419403' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389341' WHERE ordernumber = 'P630510160522450' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389342' WHERE ordernumber = 'P180510160544714' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389343' WHERE ordernumber = 'P790510161241662' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '275250' WHERE ordernumber = 'P200510161344886' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389344' WHERE ordernumber = 'P200510161736637' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '313372' WHERE ordernumber = 'P420510161903617' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '374458' WHERE ordernumber = 'P630510162048635' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389346' WHERE ordernumber = 'P190510162244949' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '381508' WHERE ordernumber = 'P190510162504152' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389348' WHERE ordernumber = 'P200510162701955' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389347' WHERE ordernumber = 'P190510162717493' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '356342' WHERE ordernumber = 'P200510162803775' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389347' WHERE ordernumber = 'P190510162810946' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389350' WHERE ordernumber = 'P190510162929439' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '227016' WHERE ordernumber = 'P190510163011161' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389351' WHERE ordernumber = 'P190510163130695' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '346456' WHERE ordernumber = 'P420510163304170' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389352' WHERE ordernumber = 'P190510163608818' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389353' WHERE ordernumber = 'P200510163626976' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '244138' WHERE ordernumber = 'P190510163923263' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389237' WHERE ordernumber = 'P630510164355213' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '313529' WHERE ordernumber = 'P200510164358278' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P180510164458843' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389355' WHERE ordernumber = 'P190510164616244' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '304185' WHERE ordernumber = 'P200510164650828' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389356' WHERE ordernumber = 'P790510164653315' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389357' WHERE ordernumber = 'P180510164742944' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389358' WHERE ordernumber = 'P200510164814517' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389358' WHERE ordernumber = 'P200510164849447' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389359' WHERE ordernumber = 'P190510164935550' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389354' WHERE ordernumber = 'P190510165026301' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '161622' WHERE ordernumber = 'P630510165122271' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '24' WHERE ordernumber = 'P200510165252406' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389360' WHERE ordernumber = 'P180510165348337' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '383515' WHERE ordernumber = 'P200510165423403' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389362' WHERE ordernumber = 'P200510165753512' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389363' WHERE ordernumber = 'P790510165836406' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '100454' WHERE ordernumber = 'P180510165848277' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '247665' WHERE ordernumber = 'P190510170521982' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389364' WHERE ordernumber = 'P190510170647760' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '305865' WHERE ordernumber = 'P200510170817623' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '389365' WHERE ordernumber = 'P190510171019400' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '296784' WHERE ordernumber = 'P420510171059800' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '228025' WHERE ordernumber = 'P190510171244906' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '106911' WHERE ordernumber = 'P200510171528882' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '215988' WHERE ordernumber = 'P790510171801398' 2024-05-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '269846' WHERE ordernumber = 'P190510172156984' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389368' WHERE ordernumber = 'P190510172337160' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '342900' WHERE ordernumber = 'P190510172407598' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389367' WHERE ordernumber = 'P420510172435215' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '151134' WHERE ordernumber = 'P790510172552717' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '300227' WHERE ordernumber = 'P190510172727846' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389369' WHERE ordernumber = 'P180510172918778' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '386524' WHERE ordernumber = 'P180510173055673' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '365098' WHERE ordernumber = 'P420510173324193' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '286015' WHERE ordernumber = 'P200510173614271' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389370' WHERE ordernumber = 'P180510173639895' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389371' WHERE ordernumber = 'P180510173754860' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389372' WHERE ordernumber = 'P200510174016444' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389373' WHERE ordernumber = 'P200510174250307' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '228764' WHERE ordernumber = 'P180510174631763' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389374' WHERE ordernumber = 'P790510174803899' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389375' WHERE ordernumber = 'P200510174943594' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '98869' WHERE ordernumber = 'P200510175120226' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '272791' WHERE ordernumber = 'P180510175412291' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '294040' WHERE ordernumber = 'P420510175605992' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389377' WHERE ordernumber = 'P180510175914298' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389376' WHERE ordernumber = 'P420510175935262' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '162381' WHERE ordernumber = 'P630510180041640' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '339562' WHERE ordernumber = 'P420510180150900' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389378' WHERE ordernumber = 'P180510180326551' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389379' WHERE ordernumber = 'P630510180413467' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '379635' WHERE ordernumber = 'P200510180505445' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '279045' WHERE ordernumber = 'P180510180540991' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389380' WHERE ordernumber = 'P630510180756247' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '344474' WHERE ordernumber = 'P180510181151742' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389382' WHERE ordernumber = 'P180510181332838' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389383' WHERE ordernumber = 'P180510181445512' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '313065' WHERE ordernumber = 'P180510181548569' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '295100' WHERE ordernumber = 'P200510181656275' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389384' WHERE ordernumber = 'P180510181759859' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '274676' WHERE ordernumber = 'P630510182119154' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389385' WHERE ordernumber = 'P200510182144621' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389386' WHERE ordernumber = 'P420510182638331' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '384070' WHERE ordernumber = 'P180510182641748' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389387' WHERE ordernumber = 'P420510182819448' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389388' WHERE ordernumber = 'P190510182907357' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '384070' WHERE ordernumber = 'P180510182913975' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389390' WHERE ordernumber = 'P180510183349918' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389389' WHERE ordernumber = 'P630510183523244' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389391' WHERE ordernumber = 'P180510183600216' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389392' WHERE ordernumber = 'P200510183726476' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '378832' WHERE ordernumber = 'P200510183819696' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389393' WHERE ordernumber = 'P180510183859378' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '225794' WHERE ordernumber = 'P180510184038463' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389394' WHERE ordernumber = 'P200510184140582' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '4568' WHERE ordernumber = 'P420510184141920' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '274759' WHERE ordernumber = 'P200510184210969' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389396' WHERE ordernumber = 'P200510184259953' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389395' WHERE ordernumber = 'P180510184310510' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389171' WHERE ordernumber = 'P200510184358940' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '387506' WHERE ordernumber = 'P180510184503451' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '356488' WHERE ordernumber = 'P200510184611371' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389395' WHERE ordernumber = 'P180510184633731' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '102500' WHERE ordernumber = 'P180510184913975' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '161057' WHERE ordernumber = 'P420510184928294' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389397' WHERE ordernumber = 'P180510185020623' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '312499' WHERE ordernumber = 'P200510185059830' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389398' WHERE ordernumber = 'P200510185603589' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389400' WHERE ordernumber = 'P200510185814787' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389399' WHERE ordernumber = 'P200510185923659' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '236530' WHERE ordernumber = 'P200510190156885' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389402' WHERE ordernumber = 'P200510190415119' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '133413' WHERE ordernumber = 'P180510190436784' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389403' WHERE ordernumber = 'P180510190635859' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389403' WHERE ordernumber = 'P180510190721895' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389404' WHERE ordernumber = 'P190510190749169' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389405' WHERE ordernumber = 'P200510190915781' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '327478' WHERE ordernumber = 'P180510191049405' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389406' WHERE ordernumber = 'P180510191652312' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '240336' WHERE ordernumber = 'P190510191842136' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389407' WHERE ordernumber = 'P790510192408561' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389013' WHERE ordernumber = 'P420510192421533' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389408' WHERE ordernumber = 'P200510192428704' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '267354' WHERE ordernumber = 'P420510192520535' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389409' WHERE ordernumber = 'P420510192714406' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '338918' WHERE ordernumber = 'P190510193822930' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389410' WHERE ordernumber = 'P790510194230982' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '279465' WHERE ordernumber = 'P190510194334246' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389411' WHERE ordernumber = 'P190510194431554' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '269298' WHERE ordernumber = 'P200510194623391' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '240510' WHERE ordernumber = 'P190510194743447' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '292306' WHERE ordernumber = 'P200510194835120' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '386165' WHERE ordernumber = 'P200510195028875' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389412' WHERE ordernumber = 'P190510195147950' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389413' WHERE ordernumber = 'P200510195339699' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389414' WHERE ordernumber = 'P790510195711172' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389417' WHERE ordernumber = 'P630510200913916' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389419' WHERE ordernumber = 'P790510202048373' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '362620' WHERE ordernumber = 'P790510203407170' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '89660' WHERE ordernumber = 'P630510203734769' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389421' WHERE ordernumber = 'P790510203848145' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389422' WHERE ordernumber = 'P790510204012166' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389423' WHERE ordernumber = 'P790510204408290' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389424' WHERE ordernumber = 'P630510204731597' 2024-05-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '389425' WHERE ordernumber = 'P790510204758153'