2024-01-10 01:00:02 -- 將會員中心id寫入data-lake 2024-01-10 01:00:02 -- 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-01-09%'; 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '289381' WHERE ordernumber = 'P420109110156218' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '125423' WHERE ordernumber = 'P180109110251770' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '16468' WHERE ordernumber = 'P200109110333710' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '358119' WHERE ordernumber = 'P180109110345491' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '358119' WHERE ordernumber = 'P180109110420548' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '363005' WHERE ordernumber = 'P420109110450458' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '123899' WHERE ordernumber = 'P190109110452984' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '363007' WHERE ordernumber = 'P180109110650311' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '275910' WHERE ordernumber = 'P180109110847204' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '313001' WHERE ordernumber = 'P420109110907257' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '363008' WHERE ordernumber = 'P180109111016292' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '363009' WHERE ordernumber = 'P420109111153461' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '251911' WHERE ordernumber = 'P180109111342395' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '363010' WHERE ordernumber = 'P420109111353524' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '255596' WHERE ordernumber = 'P190109111434381' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '99126' WHERE ordernumber = 'P190109111503231' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '287930' WHERE ordernumber = 'P190109111910824' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '111094' WHERE ordernumber = 'P190109112102115' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '363007' WHERE ordernumber = 'P180109112324292' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '251836' WHERE ordernumber = 'P420109112352205' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '266034' WHERE ordernumber = 'P190109112441735' 2024-01-10 01:00:02 -- UPDATE `omo_order_list` SET userId = '363018' WHERE ordernumber = 'P420109112533415' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '63197' WHERE ordernumber = 'P180109112705877' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363019' WHERE ordernumber = 'P420109112751503' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363025' WHERE ordernumber = 'P190109113148354' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363024' WHERE ordernumber = 'P200109113154427' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '63197' WHERE ordernumber = 'P190109113247812' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363026' WHERE ordernumber = 'P200109113252509' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '236095' WHERE ordernumber = 'P200109113325472' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '354491' WHERE ordernumber = 'P190109113459557' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363033' WHERE ordernumber = 'P420109113650626' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '299840' WHERE ordernumber = 'P200109113813872' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363036' WHERE ordernumber = 'P180109114056156' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363039' WHERE ordernumber = 'P180109114736319' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '32399' WHERE ordernumber = 'P180109114852179' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363041' WHERE ordernumber = 'P420109114947548' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '286251' WHERE ordernumber = 'P200109115306625' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363042' WHERE ordernumber = 'P420109115317772' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363046' WHERE ordernumber = 'P180109115422359' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '137065' WHERE ordernumber = 'P190109115456787' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '281413' WHERE ordernumber = 'P180109115556984' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '330795' WHERE ordernumber = 'P190109115756636' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '280918' WHERE ordernumber = 'P420109120014654' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363051' WHERE ordernumber = 'P190109120225169' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '353295' WHERE ordernumber = 'P180109120307715' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363055' WHERE ordernumber = 'P180109120536178' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '246060' WHERE ordernumber = 'P190109120620293' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '338590' WHERE ordernumber = 'P420109120635283' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '255560' WHERE ordernumber = 'P190109121103861' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '84659' WHERE ordernumber = 'P180109121126515' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363065' WHERE ordernumber = 'P420109121358491' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '342614' WHERE ordernumber = 'P180109121411864' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363059' WHERE ordernumber = 'P180109121502994' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '227957' WHERE ordernumber = 'P180109121812626' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '124724' WHERE ordernumber = 'P180109121945818' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '348545' WHERE ordernumber = 'P420109122021662' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '354473' WHERE ordernumber = 'P180109122352586' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363074' WHERE ordernumber = 'P180109122651895' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '324323' WHERE ordernumber = 'P200109122923427' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '354218' WHERE ordernumber = 'P420109123440794' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363080' WHERE ordernumber = 'P200109123456793' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363084' WHERE ordernumber = 'P420109123716689' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '348860' WHERE ordernumber = 'P200109123754475' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363086' WHERE ordernumber = 'P420109123858520' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '315213' WHERE ordernumber = 'P420109124005677' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '331947' WHERE ordernumber = 'P180109124454512' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363095' WHERE ordernumber = 'P200109124639167' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363099' WHERE ordernumber = 'P420109124942869' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '265356' WHERE ordernumber = 'P200109124949788' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363102' WHERE ordernumber = 'P200109125107243' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363104' WHERE ordernumber = 'P180109125125819' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '254032' WHERE ordernumber = 'P180109125355852' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363106' WHERE ordernumber = 'P200109125529697' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '227617' WHERE ordernumber = 'P180109125614609' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363112' WHERE ordernumber = 'P420109130119319' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '122118' WHERE ordernumber = 'P420109131144490' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '362848' WHERE ordernumber = 'P200109131315460' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363130' WHERE ordernumber = 'P200109131602331' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '100637' WHERE ordernumber = 'P200109131742176' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '160627' WHERE ordernumber = 'P200109132031174' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '311610' WHERE ordernumber = 'P180109132209839' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '238908' WHERE ordernumber = 'P190109132550995' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '341070' WHERE ordernumber = 'P200109132618176' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '311610' WHERE ordernumber = 'P180109132714517' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363143' WHERE ordernumber = 'P190109132938813' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '261512' WHERE ordernumber = 'P190109133048625' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363144' WHERE ordernumber = 'P180109133050541' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '314788' WHERE ordernumber = 'P420109133219317' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '355943' WHERE ordernumber = 'P180109133324506' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '355943' WHERE ordernumber = 'P180109133420867' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363149' WHERE ordernumber = 'P200109133646399' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '303002' WHERE ordernumber = 'P200109134239791' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '220329' WHERE ordernumber = 'P200109134355182' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '222007' WHERE ordernumber = 'P190109134456534' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363151' WHERE ordernumber = 'P420109134805725' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363159' WHERE ordernumber = 'P200109134815606' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363159' WHERE ordernumber = 'P200109134841267' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '305238' WHERE ordernumber = 'P200109134907690' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '284789' WHERE ordernumber = 'P200109135008780' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '167614' WHERE ordernumber = 'P200109135123709' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '305238' WHERE ordernumber = 'P200109135208362' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363166' WHERE ordernumber = 'P200109135400254' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363165' WHERE ordernumber = 'P420109135403830' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363170' WHERE ordernumber = 'P180109135606584' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '119536' WHERE ordernumber = 'P180109135815567' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363173' WHERE ordernumber = 'P180109135937324' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '248185' WHERE ordernumber = 'P180109140017234' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363175' WHERE ordernumber = 'P420109140057339' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '136812' WHERE ordernumber = 'P200109140435475' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363182' WHERE ordernumber = 'P420109140624204' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363187' WHERE ordernumber = 'P200109140647853' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363188' WHERE ordernumber = 'P180109140723992' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363198' WHERE ordernumber = 'P180109141804864' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363202' WHERE ordernumber = 'P420109142009324' 2024-01-10 01:00:03 -- UPDATE `omo_order_list` SET userId = '363206' WHERE ordernumber = 'P180109142313742' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '343585' WHERE ordernumber = 'P180109142648248' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '343585' WHERE ordernumber = 'P190109142915663' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '44396' WHERE ordernumber = 'P200109142926657' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363213' WHERE ordernumber = 'P420109143120438' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363211' WHERE ordernumber = 'P200109143138951' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '354453' WHERE ordernumber = 'P180109143243270' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '286120' WHERE ordernumber = 'P180109143310767' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363219' WHERE ordernumber = 'P420109143846199' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '217719' WHERE ordernumber = 'P420109143950281' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363221' WHERE ordernumber = 'P420109144137124' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '347630' WHERE ordernumber = 'P420109144357743' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '88985' WHERE ordernumber = 'P180109144851828' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363223' WHERE ordernumber = 'P190109144948381' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363223' WHERE ordernumber = 'P190109145009763' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '214813' WHERE ordernumber = 'P200109145127501' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363228' WHERE ordernumber = 'P180109145142430' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '342010' WHERE ordernumber = 'P200109145217873' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '349894' WHERE ordernumber = 'P190109145255149' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363230' WHERE ordernumber = 'P190109145355291' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363231' WHERE ordernumber = 'P200109145514540' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363233' WHERE ordernumber = 'P180109145528971' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '280802' WHERE ordernumber = 'P420109145617412' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '106009' WHERE ordernumber = 'P200109145632558' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '300627' WHERE ordernumber = 'P190109145636424' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363237' WHERE ordernumber = 'P180109145903679' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363240' WHERE ordernumber = 'P190109150203791' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '357828' WHERE ordernumber = 'P200109150328231' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '342315' WHERE ordernumber = 'P190109150431560' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363247' WHERE ordernumber = 'P200109150643899' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '245652' WHERE ordernumber = 'P200109150759240' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '277973' WHERE ordernumber = 'P180109151136917' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '268813' WHERE ordernumber = 'P190109151235278' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '282613' WHERE ordernumber = 'P180109151303869' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363252' WHERE ordernumber = 'P200109151332613' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '268813' WHERE ordernumber = 'P190109151408972' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '99505' WHERE ordernumber = 'P190109151756614' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363257' WHERE ordernumber = 'P420109151846290' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363258' WHERE ordernumber = 'P420109152005961' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363265' WHERE ordernumber = 'P190109152259681' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363266' WHERE ordernumber = 'P180109152303956' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363262' WHERE ordernumber = 'P200109152321501' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '360344' WHERE ordernumber = 'P190109152438708' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363267' WHERE ordernumber = 'P180109152520897' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363269' WHERE ordernumber = 'P180109152657325' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '326754' WHERE ordernumber = 'P420109153003694' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363271' WHERE ordernumber = 'P180109153017305' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363273' WHERE ordernumber = 'P190109153026652' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '212334' WHERE ordernumber = 'P190109153909750' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '358495' WHERE ordernumber = 'P190109154050855' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '101914' WHERE ordernumber = 'P200109154059205' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '245297' WHERE ordernumber = 'P200109154144910' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '96963' WHERE ordernumber = 'P200109154225997' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363290' WHERE ordernumber = 'P420109154608813' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363292' WHERE ordernumber = 'P180109154704160' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363295' WHERE ordernumber = 'P180109154756989' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '52165' WHERE ordernumber = 'P200109154932938' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363299' WHERE ordernumber = 'P190109154939279' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363301' WHERE ordernumber = 'P180109155030273' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '348408' WHERE ordernumber = 'P200109155203148' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363307' WHERE ordernumber = 'P420109155358459' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '256568' WHERE ordernumber = 'P190109155436733' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363308' WHERE ordernumber = 'P180109155620959' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363310' WHERE ordernumber = 'P190109155634645' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '256568' WHERE ordernumber = 'P190109155708310' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363312' WHERE ordernumber = 'P190109155945125' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363314' WHERE ordernumber = 'P190109160111268' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363315' WHERE ordernumber = 'P180109160335216' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '286596' WHERE ordernumber = 'P180109160638210' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '348967' WHERE ordernumber = 'P200109160642554' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '281440' WHERE ordernumber = 'P200109160757459' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '287688' WHERE ordernumber = 'P200109160846732' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363323' WHERE ordernumber = 'P200109161027634' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '116454' WHERE ordernumber = 'P190109161038707' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363324' WHERE ordernumber = 'P180109161048378' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363314' WHERE ordernumber = 'P180109161142480' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '353096' WHERE ordernumber = 'P180109161954463' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363334' WHERE ordernumber = 'P420109162029478' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '138293' WHERE ordernumber = 'P190109162053383' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '128310' WHERE ordernumber = 'P420109162138534' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '352011' WHERE ordernumber = 'P190109162246395' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '268561' WHERE ordernumber = 'P200109162400694' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '340648' WHERE ordernumber = 'P200109162528623' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363339' WHERE ordernumber = 'P200109162634212' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '90674' WHERE ordernumber = 'P190109162917466' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363344' WHERE ordernumber = 'P200109162926530' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '268561' WHERE ordernumber = 'P200109163405822' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363352' WHERE ordernumber = 'P190109163647128' 2024-01-10 01:00:04 -- UPDATE `omo_order_list` SET userId = '363354' WHERE ordernumber = 'P420109163903743' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363358' WHERE ordernumber = 'P200109164410370' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '266825' WHERE ordernumber = 'P420109164616983' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '279525' WHERE ordernumber = 'P190109164730389' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363365' WHERE ordernumber = 'P200109165447139' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '257088' WHERE ordernumber = 'P190109165455835' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '95943' WHERE ordernumber = 'P200109165630947' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363366' WHERE ordernumber = 'P420109165717527' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '353472' WHERE ordernumber = 'P200109165752373' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '251367' WHERE ordernumber = 'P420109165923886' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363370' WHERE ordernumber = 'P420109170100671' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '172513' WHERE ordernumber = 'P200109170237210' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '299840' WHERE ordernumber = 'P200109170356462' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '130193' WHERE ordernumber = 'P200109170554894' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '279538' WHERE ordernumber = 'P200109171436388' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363382' WHERE ordernumber = 'P420109171454213' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '254829' WHERE ordernumber = 'P180109171524995' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '231568' WHERE ordernumber = 'P200109171548238' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '232251' WHERE ordernumber = 'P180109171650364' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '266560' WHERE ordernumber = 'P180109171902168' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363387' WHERE ordernumber = 'P180109172317809' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '287142' WHERE ordernumber = 'P180109172646181' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '328235' WHERE ordernumber = 'P420109172716245' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363395' WHERE ordernumber = 'P190109173012652' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363398' WHERE ordernumber = 'P180109173339734' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '279461' WHERE ordernumber = 'P200109173442792' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '343266' WHERE ordernumber = 'P180109173450866' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '279461' WHERE ordernumber = 'P200109173810899' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '296316' WHERE ordernumber = 'P420109173901276' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '357778' WHERE ordernumber = 'P180109173916563' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363400' WHERE ordernumber = 'P200109173920626' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '358831' WHERE ordernumber = 'P200109174055200' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363400' WHERE ordernumber = 'P200109174306614' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363404' WHERE ordernumber = 'P180109174344399' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '297300' WHERE ordernumber = 'P420109174606431' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '275037' WHERE ordernumber = 'P180109174943224' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363412' WHERE ordernumber = 'P180109175140580' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '353814' WHERE ordernumber = 'P420109175215851' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '299690' WHERE ordernumber = 'P200109175225952' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '299690' WHERE ordernumber = 'P200109175258862' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363413' WHERE ordernumber = 'P180109175430168' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363414' WHERE ordernumber = 'P180109175538568' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '114734' WHERE ordernumber = 'P200109175655792' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '224174' WHERE ordernumber = 'P200109175855662' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363416' WHERE ordernumber = 'P180109180008112' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '243723' WHERE ordernumber = 'P200109180029345' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '98115' WHERE ordernumber = 'P180109180308454' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '81113' WHERE ordernumber = 'P200109180432927' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '356083' WHERE ordernumber = 'P200109180746802' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363423' WHERE ordernumber = 'P180109180813199' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '81113' WHERE ordernumber = 'P200109180833136' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '182519' WHERE ordernumber = 'P180109180902602' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '329434' WHERE ordernumber = 'P180109181345220' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '360345' WHERE ordernumber = 'P190109181607300' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363429' WHERE ordernumber = 'P200109181953714' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363433' WHERE ordernumber = 'P200109182234547' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '357946' WHERE ordernumber = 'P200109182259240' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363436' WHERE ordernumber = 'P190109182508255' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363435' WHERE ordernumber = 'P200109182512656' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '248374' WHERE ordernumber = 'P200109182605823' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363438' WHERE ordernumber = 'P200109182735471' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '305066' WHERE ordernumber = 'P200109182814793' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363439' WHERE ordernumber = 'P180109182928633' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363441' WHERE ordernumber = 'P200109183001449' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363443' WHERE ordernumber = 'P190109183134386' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '269120' WHERE ordernumber = 'P180109183238447' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363446' WHERE ordernumber = 'P180109183402649' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '254652' WHERE ordernumber = 'P180109183439133' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363441' WHERE ordernumber = 'P200109183508848' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '237232' WHERE ordernumber = 'P180109183513573' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363448' WHERE ordernumber = 'P200109183544430' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '229518' WHERE ordernumber = 'P180109183846174' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '358895' WHERE ordernumber = 'P200109183906216' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363445' WHERE ordernumber = 'P190109183911304' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363445' WHERE ordernumber = 'P190109184021706' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '318466' WHERE ordernumber = 'P200109184056149' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363445' WHERE ordernumber = 'P190109184129750' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '192108' WHERE ordernumber = 'P200109184247280' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '99654' WHERE ordernumber = 'P200109184757322' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363465' WHERE ordernumber = 'P200109184922310' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363466' WHERE ordernumber = 'P200109185040151' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '346650' WHERE ordernumber = 'P190109185152215' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363469' WHERE ordernumber = 'P420109185349331' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '76607' WHERE ordernumber = 'P190109185425324' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363474' WHERE ordernumber = 'P420109185634986' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363473' WHERE ordernumber = 'P200109185727328' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363475' WHERE ordernumber = 'P190109185741384' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '169372' WHERE ordernumber = 'P190109185828914' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '238568' WHERE ordernumber = 'P190109185920489' 2024-01-10 01:00:05 -- UPDATE `omo_order_list` SET userId = '363478' WHERE ordernumber = 'P420109190024151' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363473' WHERE ordernumber = 'P200109190036879' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363483' WHERE ordernumber = 'P200109190424801' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363482' WHERE ordernumber = 'P190109190429532' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '213925' WHERE ordernumber = 'P190109190553698' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363486' WHERE ordernumber = 'P190109190724561' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363488' WHERE ordernumber = 'P190109190835754' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '118999' WHERE ordernumber = 'P200109190955823' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '271162' WHERE ordernumber = 'P190109191201755' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '101825' WHERE ordernumber = 'P200109191349384' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363502' WHERE ordernumber = 'P190109192106638' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '234461' WHERE ordernumber = 'P190109192446730' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363505' WHERE ordernumber = 'P420109192523401' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363498' WHERE ordernumber = 'P420109192633479' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '93404' WHERE ordernumber = 'P190109192727730' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '270218' WHERE ordernumber = 'P200109192835867' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '237609' WHERE ordernumber = 'P200109192937568' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363511' WHERE ordernumber = 'P200109193025593' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '247854' WHERE ordernumber = 'P190109193053617' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '304297' WHERE ordernumber = 'P200109193123662' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '306940' WHERE ordernumber = 'P190109193219156' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '297233' WHERE ordernumber = 'P420109193544761' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363517' WHERE ordernumber = 'P190109193604817' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '95439' WHERE ordernumber = 'P190109194050692' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363530' WHERE ordernumber = 'P190109194728502' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '303771' WHERE ordernumber = 'P200109194821803' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '152191' WHERE ordernumber = 'P200109194915468' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '178334' WHERE ordernumber = 'P200109195050962' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363535' WHERE ordernumber = 'P190109195137792' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363535' WHERE ordernumber = 'P190109195343447' 2024-01-10 01:00:06 -- UPDATE `omo_order_list` SET userId = '363535' WHERE ordernumber = 'P190109195459579'