2023-12-17 01:00:03 -- 將會員ä¸å¿ƒid寫入data-lake 2023-12-17 01:00:03 -- 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-16%'; 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '351922' WHERE ordernumber = 'P421216101530599' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352770' WHERE ordernumber = 'P421216105953417' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '142615' WHERE ordernumber = 'P201216110145766' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '312800' WHERE ordernumber = 'P181216110208380' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '220763' WHERE ordernumber = 'P181216110524244' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352772' WHERE ordernumber = 'P181216110654772' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352773' WHERE ordernumber = 'P421216110819309' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352774' WHERE ordernumber = 'P191216110923823' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '345872' WHERE ordernumber = 'P181216111008377' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352775' WHERE ordernumber = 'P181216111134164' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '267164' WHERE ordernumber = 'P181216111334604' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '306047' WHERE ordernumber = 'P191216111508318' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '287508' WHERE ordernumber = 'P181216111533467' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352778' WHERE ordernumber = 'P201216111601403' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '276893' WHERE ordernumber = 'P181216111618120' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352777' WHERE ordernumber = 'P421216111724924' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '208372' WHERE ordernumber = 'P191216111851395' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352779' WHERE ordernumber = 'P201216111909815' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352780' WHERE ordernumber = 'P181216112050138' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352781' WHERE ordernumber = 'P191216112131500' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352782' WHERE ordernumber = 'P181216112256966' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '339922' WHERE ordernumber = 'P421216112448261' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '342829' WHERE ordernumber = 'P421216112803921' 2023-12-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '352783' WHERE ordernumber = 'P181216112915917' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '266671' WHERE ordernumber = 'P191216112920641' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352784' WHERE ordernumber = 'P421216112935875' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352785' WHERE ordernumber = 'P191216113112500' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352786' WHERE ordernumber = 'P421216113132990' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '221426' WHERE ordernumber = 'P181216113218561' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352787' WHERE ordernumber = 'P191216113244821' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '93731' WHERE ordernumber = 'P191216113610898' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352789' WHERE ordernumber = 'P191216113741919' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352790' WHERE ordernumber = 'P191216114139500' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352364' WHERE ordernumber = 'P191216114212921' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '131676' WHERE ordernumber = 'P181216114423448' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352677' WHERE ordernumber = 'P201216114613663' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '109558' WHERE ordernumber = 'P201216114749159' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352791' WHERE ordernumber = 'P191216114758249' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '313031' WHERE ordernumber = 'P191216114924787' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352792' WHERE ordernumber = 'P191216115102404' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352793' WHERE ordernumber = 'P201216115202905' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '344892' WHERE ordernumber = 'P421216115230536' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '221775' WHERE ordernumber = 'P421216115341504' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352794' WHERE ordernumber = 'P201216115348601' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352791' WHERE ordernumber = 'P191216115400769' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352795' WHERE ordernumber = 'P201216115539867' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352796' WHERE ordernumber = 'P201216115711299' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352797' WHERE ordernumber = 'P201216115830561' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352798' WHERE ordernumber = 'P181216115856292' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352800' WHERE ordernumber = 'P421216120348796' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352801' WHERE ordernumber = 'P191216120415302' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '321391' WHERE ordernumber = 'P181216121058263' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352802' WHERE ordernumber = 'P181216121217230' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '101457' WHERE ordernumber = 'P201216121229339' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '298187' WHERE ordernumber = 'P421216121802627' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352805' WHERE ordernumber = 'P201216121818987' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352806' WHERE ordernumber = 'P201216121855456' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '348746' WHERE ordernumber = 'P181216122228158' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '109698' WHERE ordernumber = 'P191216122229347' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352807' WHERE ordernumber = 'P201216122308540' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352808' WHERE ordernumber = 'P201216122442881' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '233190' WHERE ordernumber = 'P201216122535446' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352809' WHERE ordernumber = 'P421216122624359' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '81350' WHERE ordernumber = 'P191216122628711' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '351150' WHERE ordernumber = 'P421216123119757' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352810' WHERE ordernumber = 'P181216123126514' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352812' WHERE ordernumber = 'P181216123535188' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352813' WHERE ordernumber = 'P191216123555888' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '351986' WHERE ordernumber = 'P201216123737615' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352814' WHERE ordernumber = 'P201216124008162' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '220190' WHERE ordernumber = 'P191216124053880' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '220190' WHERE ordernumber = 'P191216124318375' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '128940' WHERE ordernumber = 'P191216124507345' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352816' WHERE ordernumber = 'P421216124934881' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352817' WHERE ordernumber = 'P421216125201825' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '46247' WHERE ordernumber = 'P181216125305433' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352818' WHERE ordernumber = 'P181216125418253' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '328644' WHERE ordernumber = 'P421216125425572' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '313838' WHERE ordernumber = 'P181216125445530' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '94307' WHERE ordernumber = 'P201216125634938' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '208609' WHERE ordernumber = 'P181216130054935' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352819' WHERE ordernumber = 'P191216130421883' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '306759' WHERE ordernumber = 'P421216130437635' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352820' WHERE ordernumber = 'P191216130600769' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '321276' WHERE ordernumber = 'P191216131022334' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '90191' WHERE ordernumber = 'P201216131217321' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352821' WHERE ordernumber = 'P191216131313253' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352822' WHERE ordernumber = 'P181216131758411' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352823' WHERE ordernumber = 'P191216132140755' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352824' WHERE ordernumber = 'P191216132351836' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '345784' WHERE ordernumber = 'P181216132534299' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352825' WHERE ordernumber = 'P421216133237854' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '76659' WHERE ordernumber = 'P421216133505720' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352826' WHERE ordernumber = 'P421216133628352' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352827' WHERE ordernumber = 'P421216133728181' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '283649' WHERE ordernumber = 'P201216133901620' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '302233' WHERE ordernumber = 'P421216134058634' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352828' WHERE ordernumber = 'P181216134614345' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '321353' WHERE ordernumber = 'P201216134633234' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '300204' WHERE ordernumber = 'P201216134746596' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352259' WHERE ordernumber = 'P181216134911196' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352830' WHERE ordernumber = 'P421216135410882' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352831' WHERE ordernumber = 'P421216135633385' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '115397' WHERE ordernumber = 'P201216135659920' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352832' WHERE ordernumber = 'P181216135736958' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352833' WHERE ordernumber = 'P181216135835644' 2023-12-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '55660' WHERE ordernumber = 'P181216140021600' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '229952' WHERE ordernumber = 'P181216140103764' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352834' WHERE ordernumber = 'P181216140202497' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '276302' WHERE ordernumber = 'P181216140246767' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352835' WHERE ordernumber = 'P181216140348660' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '269566' WHERE ordernumber = 'P201216140508168' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '307276' WHERE ordernumber = 'P181216140510694' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352836' WHERE ordernumber = 'P421216140511414' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '317435' WHERE ordernumber = 'P181216140618689' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '276367' WHERE ordernumber = 'P201216140646505' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '307276' WHERE ordernumber = 'P181216140658745' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352837' WHERE ordernumber = 'P181216141009818' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352838' WHERE ordernumber = 'P181216141157202' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352839' WHERE ordernumber = 'P421216141229594' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352840' WHERE ordernumber = 'P181216141359890' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352841' WHERE ordernumber = 'P181216141544650' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352842' WHERE ordernumber = 'P181216141756448' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352345' WHERE ordernumber = 'P181216141855651' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352843' WHERE ordernumber = 'P421216141928838' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '119106' WHERE ordernumber = 'P181216141951807' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352844' WHERE ordernumber = 'P201216142012681' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352845' WHERE ordernumber = 'P421216142059327' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352846' WHERE ordernumber = 'P181216142101627' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '225901' WHERE ordernumber = 'P201216142101427' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '54918' WHERE ordernumber = 'P181216142151225' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '163304' WHERE ordernumber = 'P181216142300433' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '324635' WHERE ordernumber = 'P201216142337874' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352847' WHERE ordernumber = 'P181216142529166' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '234552' WHERE ordernumber = 'P201216142558729' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352849' WHERE ordernumber = 'P201216142736569' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '295222' WHERE ordernumber = 'P181216143652595' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352850' WHERE ordernumber = 'P181216143844803' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '227900' WHERE ordernumber = 'P421216143954243' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352851' WHERE ordernumber = 'P181216144243803' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '296397' WHERE ordernumber = 'P201216144822722' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352852' WHERE ordernumber = 'P181216144929881' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352853' WHERE ordernumber = 'P201216145037591' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '276173' WHERE ordernumber = 'P201216145134902' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352855' WHERE ordernumber = 'P421216145243805' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '102428' WHERE ordernumber = 'P181216145402462' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352856' WHERE ordernumber = 'P181216145533590' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '287887' WHERE ordernumber = 'P201216145942676' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352858' WHERE ordernumber = 'P181216150229320' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352859' WHERE ordernumber = 'P201216150332995' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '347509' WHERE ordernumber = 'P421216150349873' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352861' WHERE ordernumber = 'P181216150416991' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '262375' WHERE ordernumber = 'P201216150450245' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352675' WHERE ordernumber = 'P181216150543500' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '278645' WHERE ordernumber = 'P201216150601255' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352862' WHERE ordernumber = 'P181216150718667' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352863' WHERE ordernumber = 'P181216150851769' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352864' WHERE ordernumber = 'P421216150924818' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352865' WHERE ordernumber = 'P181216150946468' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '344307' WHERE ordernumber = 'P201216151046334' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352866' WHERE ordernumber = 'P181216151201794' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '225379' WHERE ordernumber = 'P201216151210476' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352868' WHERE ordernumber = 'P181216151429959' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352869' WHERE ordernumber = 'P201216151709645' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '28992' WHERE ordernumber = 'P181216151730301' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '330160' WHERE ordernumber = 'P421216151733509' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '344307' WHERE ordernumber = 'P201216151939540' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352872' WHERE ordernumber = 'P181216152030380' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '139619' WHERE ordernumber = 'P201216152105470' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '325075' WHERE ordernumber = 'P421216152105525' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '218140' WHERE ordernumber = 'P181216152151492' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352873' WHERE ordernumber = 'P181216152458503' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352874' WHERE ordernumber = 'P181216152622368' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '129977' WHERE ordernumber = 'P181216152733482' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '152953' WHERE ordernumber = 'P191216152842160' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352876' WHERE ordernumber = 'P191216153101561' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352875' WHERE ordernumber = 'P201216153140193' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '102962' WHERE ordernumber = 'P191216153141627' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352875' WHERE ordernumber = 'P201216153154860' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '235940' WHERE ordernumber = 'P181216153207278' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '347256' WHERE ordernumber = 'P201216153237633' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '337889' WHERE ordernumber = 'P191216153257264' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352879' WHERE ordernumber = 'P201216153429724' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352878' WHERE ordernumber = 'P191216153435442' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '352881' WHERE ordernumber = 'P191216154112897' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '318173' WHERE ordernumber = 'P181216154253359' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '289795' WHERE ordernumber = 'P201216155002248' 2023-12-17 01:00:05 -- UPDATE `omo_order_list` SET userId = '340704' WHERE ordernumber = 'P201216155114648' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352883' WHERE ordernumber = 'P181216155119370' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '242845' WHERE ordernumber = 'P191216155203317' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352884' WHERE ordernumber = 'P191216155613315' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352886' WHERE ordernumber = 'P191216155823382' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352887' WHERE ordernumber = 'P191216160130152' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '345062' WHERE ordernumber = 'P421216160147755' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '238697' WHERE ordernumber = 'P191216160243403' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '304021' WHERE ordernumber = 'P191216160333157' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352890' WHERE ordernumber = 'P181216160505728' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '227225' WHERE ordernumber = 'P201216160706781' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352892' WHERE ordernumber = 'P181216160803519' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352893' WHERE ordernumber = 'P181216160857680' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '341209' WHERE ordernumber = 'P181216160957163' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '345062' WHERE ordernumber = 'P421216161039127' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '351762' WHERE ordernumber = 'P181216161256893' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '165689' WHERE ordernumber = 'P191216161356670' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '162780' WHERE ordernumber = 'P201216161609435' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '279933' WHERE ordernumber = 'P181216161738151' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352895' WHERE ordernumber = 'P181216161847721' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '351827' WHERE ordernumber = 'P181216161955208' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '350637' WHERE ordernumber = 'P421216162030992' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '78093' WHERE ordernumber = 'P201216162111987' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '312843' WHERE ordernumber = 'P201216162407959' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352897' WHERE ordernumber = 'P191216162946581' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '287919' WHERE ordernumber = 'P191216163041318' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352899' WHERE ordernumber = 'P191216163323394' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352900' WHERE ordernumber = 'P181216163505166' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '240308' WHERE ordernumber = 'P181216163552794' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '213034' WHERE ordernumber = 'P191216163631797' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352902' WHERE ordernumber = 'P421216163827986' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352901' WHERE ordernumber = 'P201216163842500' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352903' WHERE ordernumber = 'P181216163919351' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352904' WHERE ordernumber = 'P201216163937509' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352906' WHERE ordernumber = 'P181216164042628' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352907' WHERE ordernumber = 'P191216164101705' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '310755' WHERE ordernumber = 'P181216164117256' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352905' WHERE ordernumber = 'P421216164118609' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352908' WHERE ordernumber = 'P201216164204388' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '39039' WHERE ordernumber = 'P201216164300197' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '131885' WHERE ordernumber = 'P181216164630939' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352910' WHERE ordernumber = 'P181216165346564' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352911' WHERE ordernumber = 'P181216165701475' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352913' WHERE ordernumber = 'P181216165937328' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352914' WHERE ordernumber = 'P181216170052469' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352916' WHERE ordernumber = 'P181216170221528' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352915' WHERE ordernumber = 'P421216170439405' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352918' WHERE ordernumber = 'P201216170752620' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '101562' WHERE ordernumber = 'P201216170810985' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '275144' WHERE ordernumber = 'P181216170814608' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352919' WHERE ordernumber = 'P181216170849639' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352920' WHERE ordernumber = 'P421216171428208' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '97677' WHERE ordernumber = 'P431216171530981' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '347603' WHERE ordernumber = 'P201216171627922' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352922' WHERE ordernumber = 'P181216171725555' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352925' WHERE ordernumber = 'P181216171841974' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '258778' WHERE ordernumber = 'P181216172317273' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '284600' WHERE ordernumber = 'P181216172533207' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352927' WHERE ordernumber = 'P421216172551584' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352928' WHERE ordernumber = 'P421216172810173' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352930' WHERE ordernumber = 'P201216172824685' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352931' WHERE ordernumber = 'P181216173009791' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352929' WHERE ordernumber = 'P431216173048148' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352933' WHERE ordernumber = 'P181216173136154' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '314822' WHERE ordernumber = 'P421216173220182' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '258778' WHERE ordernumber = 'P181216173230596' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352934' WHERE ordernumber = 'P181216173423761' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352936' WHERE ordernumber = 'P421216173459415' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '112093' WHERE ordernumber = 'P181216173559159' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352937' WHERE ordernumber = 'P181216173727441' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '166843' WHERE ordernumber = 'P201216173847964' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '225299' WHERE ordernumber = 'P201216174142591' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352938' WHERE ordernumber = 'P181216174317869' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352939' WHERE ordernumber = 'P191216174401665' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '310246' WHERE ordernumber = 'P201216174407777' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '328387' WHERE ordernumber = 'P421216174424494' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352940' WHERE ordernumber = 'P191216174450854' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '172077' WHERE ordernumber = 'P201216174454971' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352941' WHERE ordernumber = 'P181216174457197' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352943' WHERE ordernumber = 'P181216174558215' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352942' WHERE ordernumber = 'P191216174611477' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '239428' WHERE ordernumber = 'P181216174711165' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '325307' WHERE ordernumber = 'P181216174902617' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '3006' WHERE ordernumber = 'P431216175025446' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '352944' WHERE ordernumber = 'P181216175100276' 2023-12-17 01:00:06 -- UPDATE `omo_order_list` SET userId = '157061' WHERE ordernumber = 'P201216175321829' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352946' WHERE ordernumber = 'P181216175430664' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '237868' WHERE ordernumber = 'P191216175456670' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352948' WHERE ordernumber = 'P191216175558266' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '108623' WHERE ordernumber = 'P181216180117713' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '108623' WHERE ordernumber = 'P181216180200900' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '318716' WHERE ordernumber = 'P421216180516918' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352950' WHERE ordernumber = 'P181216181442736' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352951' WHERE ordernumber = 'P181216181556228' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352952' WHERE ordernumber = 'P181216181727359' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352953' WHERE ordernumber = 'P181216181858933' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '250733' WHERE ordernumber = 'P181216182003706' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352954' WHERE ordernumber = 'P181216182324130' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352954' WHERE ordernumber = 'P181216182402841' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352955' WHERE ordernumber = 'P181216182521548' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352956' WHERE ordernumber = 'P201216182723432' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352957' WHERE ordernumber = 'P201216182928938' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352644' WHERE ordernumber = 'P181216183047164' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '254549' WHERE ordernumber = 'P181216183144823' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '247610' WHERE ordernumber = 'P201216183232689' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352958' WHERE ordernumber = 'P181216183331458' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '248969' WHERE ordernumber = 'P201216183824729' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352959' WHERE ordernumber = 'P191216183852865' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352960' WHERE ordernumber = 'P191216184357801' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '137625' WHERE ordernumber = 'P421216184725164' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352962' WHERE ordernumber = 'P191216184852238' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '341209' WHERE ordernumber = 'P191216185020760' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '208509' WHERE ordernumber = 'P191216185154859' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352963' WHERE ordernumber = 'P421216185207865' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352964' WHERE ordernumber = 'P201216185907990' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352966' WHERE ordernumber = 'P191216190230513' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352965' WHERE ordernumber = 'P201216190234120' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '121716' WHERE ordernumber = 'P421216190309443' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '303042' WHERE ordernumber = 'P191216190716280' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352967' WHERE ordernumber = 'P201216190758558' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352969' WHERE ordernumber = 'P191216191243700' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352970' WHERE ordernumber = 'P201216191305423' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352971' WHERE ordernumber = 'P421216191558374' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352972' WHERE ordernumber = 'P421216191811802' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352973' WHERE ordernumber = 'P191216191834891' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352968' WHERE ordernumber = 'P421216191923923' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '352975' WHERE ordernumber = 'P191216192911296' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '350091' WHERE ordernumber = 'P191216193006873' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '351381' WHERE ordernumber = 'P201216194917882' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '105986' WHERE ordernumber = 'P191216194947653' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '89714' WHERE ordernumber = 'P191216195138508' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '104419' WHERE ordernumber = 'P191216195639475' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '62324' WHERE ordernumber = 'P191216195854590' 2023-12-17 01:00:07 -- UPDATE `omo_order_list` SET userId = '258248' WHERE ordernumber = 'P191216200113818'