2024-02-04 01:00:02 -- 將會員中心id寫入data-lake 2024-02-04 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-02-03%'; 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '25' WHERE ordernumber = 'P180203095818344' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '369707' WHERE ordernumber = 'P180203110347566' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '255343' WHERE ordernumber = 'P190203110410525' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '364663' WHERE ordernumber = 'P190203110517648' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375200' WHERE ordernumber = 'P180203110526470' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '288219' WHERE ordernumber = 'P190203110615562' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '243828' WHERE ordernumber = 'P200203110625534' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '254082' WHERE ordernumber = 'P180203110656696' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '343509' WHERE ordernumber = 'P190203110741584' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375204' WHERE ordernumber = 'P190203110845887' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375204' WHERE ordernumber = 'P190203110916260' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '76999' WHERE ordernumber = 'P200203110950577' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '210496' WHERE ordernumber = 'P180203111030770' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '363658' WHERE ordernumber = 'P190203111238145' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375197' WHERE ordernumber = 'P180203111407956' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '130468' WHERE ordernumber = 'P200203111445324' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375202' WHERE ordernumber = 'P190203111506237' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '140773' WHERE ordernumber = 'P180203111542896' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375202' WHERE ordernumber = 'P190203111603488' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375208' WHERE ordernumber = 'P420203111634500' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '85019' WHERE ordernumber = 'P180203111647993' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '375215' WHERE ordernumber = 'P190203111716735' 2024-02-04 01:00:02 -- UPDATE `omo_order_list` SET userId = '98936' WHERE ordernumber = 'P190203111839334' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375216' WHERE ordernumber = 'P180203111846610' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375213' WHERE ordernumber = 'P420203112008760' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375236' WHERE ordernumber = 'P180203112027464' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375219' WHERE ordernumber = 'P180203112123638' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375221' WHERE ordernumber = 'P180203112218652' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '325074' WHERE ordernumber = 'P180203112421421' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375217' WHERE ordernumber = 'P190203112456472' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '325074' WHERE ordernumber = 'P180203112609337' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '97587' WHERE ordernumber = 'P420203112730400' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375228' WHERE ordernumber = 'P180203112748127' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375230' WHERE ordernumber = 'P190203112918136' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375242' WHERE ordernumber = 'P180203112925841' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375220' WHERE ordernumber = 'P180203113034805' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375218' WHERE ordernumber = 'P190203113101288' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375212' WHERE ordernumber = 'P420203113129196' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375212' WHERE ordernumber = 'P420203113212716' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375243' WHERE ordernumber = 'P190203113334940' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375225' WHERE ordernumber = 'P180203113420734' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375243' WHERE ordernumber = 'P190203113447150' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '297533' WHERE ordernumber = 'P420203113515802' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '312854' WHERE ordernumber = 'P200203113839671' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375222' WHERE ordernumber = 'P190203113930498' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375211' WHERE ordernumber = 'P420203113938668' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375223' WHERE ordernumber = 'P180203114045702' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '122253' WHERE ordernumber = 'P190203114249662' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375223' WHERE ordernumber = 'P180203114321404' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '257723' WHERE ordernumber = 'P190203114419454' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '352410' WHERE ordernumber = 'P190203114552304' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375224' WHERE ordernumber = 'P180203114632119' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375226' WHERE ordernumber = 'P190203114720299' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '372854' WHERE ordernumber = 'P200203114912944' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '338843' WHERE ordernumber = 'P420203115018291' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375229' WHERE ordernumber = 'P190203115042627' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '343422' WHERE ordernumber = 'P420203115156626' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '230432' WHERE ordernumber = 'P190203115241360' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375251' WHERE ordernumber = 'P180203115244856' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '358901' WHERE ordernumber = 'P200203115323907' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375237' WHERE ordernumber = 'P190203115549894' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375162' WHERE ordernumber = 'P180203115556483' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375238' WHERE ordernumber = 'P190203115800321' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375247' WHERE ordernumber = 'P180203115820495' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '359500' WHERE ordernumber = 'P190203115912791' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '374400' WHERE ordernumber = 'P180203115946161' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375244' WHERE ordernumber = 'P180203120101347' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375252' WHERE ordernumber = 'P180203120248857' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375233' WHERE ordernumber = 'P190203120320891' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375233' WHERE ordernumber = 'P190203120402972' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375246' WHERE ordernumber = 'P180203120435586' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375240' WHERE ordernumber = 'P180203120702211' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '229232' WHERE ordernumber = 'P190203120750463' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375261' WHERE ordernumber = 'P180203120844144' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '350287' WHERE ordernumber = 'P200203121013925' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '209926' WHERE ordernumber = 'P180203121014239' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '372666' WHERE ordernumber = 'P420203121016172' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375239' WHERE ordernumber = 'P180203121115579' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375259' WHERE ordernumber = 'P180203121217871' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375241' WHERE ordernumber = 'P190203121218598' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375260' WHERE ordernumber = 'P180203121331564' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375255' WHERE ordernumber = 'P190203121455207' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375257' WHERE ordernumber = 'P180203121519255' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375265' WHERE ordernumber = 'P180203121617112' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '333115' WHERE ordernumber = 'P420203121637838' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '104438' WHERE ordernumber = 'P200203121911876' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375248' WHERE ordernumber = 'P180203121955332' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375256' WHERE ordernumber = 'P180203122117194' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375266' WHERE ordernumber = 'P180203122405874' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375258' WHERE ordernumber = 'P190203122450656' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375263' WHERE ordernumber = 'P180203122518120' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '371202' WHERE ordernumber = 'P180203122635458' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '263180' WHERE ordernumber = 'P420203122652135' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '372364' WHERE ordernumber = 'P200203122653886' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '208616' WHERE ordernumber = 'P190203122728476' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '262097' WHERE ordernumber = 'P200203122733390' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '343581' WHERE ordernumber = 'P180203122759635' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375283' WHERE ordernumber = 'P200203122829538' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '321213' WHERE ordernumber = 'P180203122856222' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375262' WHERE ordernumber = 'P190203122902280' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375268' WHERE ordernumber = 'P190203123113150' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '370826' WHERE ordernumber = 'P200203123151260' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375286' WHERE ordernumber = 'P200203123320893' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375250' WHERE ordernumber = 'P180203123343961' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375285' WHERE ordernumber = 'P420203123345311' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '360025' WHERE ordernumber = 'P200203123449314' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '81113' WHERE ordernumber = 'P200203123654770' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '262851' WHERE ordernumber = 'P190203123701587' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375293' WHERE ordernumber = 'P200203123954847' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375269' WHERE ordernumber = 'P190203124105321' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375269' WHERE ordernumber = 'P190203124146351' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '270496' WHERE ordernumber = 'P190203124240169' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375254' WHERE ordernumber = 'P180203124332920' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '222163' WHERE ordernumber = 'P200203124401895' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375295' WHERE ordernumber = 'P200203124517704' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '375235' WHERE ordernumber = 'P420203124535142' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '371935' WHERE ordernumber = 'P200203124932650' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '219238' WHERE ordernumber = 'P180203125028561' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '138153' WHERE ordernumber = 'P200203125043793' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '374501' WHERE ordernumber = 'P420203125256872' 2024-02-04 01:00:03 -- UPDATE `omo_order_list` SET userId = '367270' WHERE ordernumber = 'P420203125525799' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375282' WHERE ordernumber = 'P190203125607188' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375281' WHERE ordernumber = 'P180203125610849' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '274990' WHERE ordernumber = 'P200203125649392' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '110974' WHERE ordernumber = 'P200203125831997' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375289' WHERE ordernumber = 'P180203125919584' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375279' WHERE ordernumber = 'P180203130350875' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375294' WHERE ordernumber = 'P180203130705608' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '228009' WHERE ordernumber = 'P200203130756718' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375290' WHERE ordernumber = 'P190203131053625' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '276379' WHERE ordernumber = 'P190203131141869' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375304' WHERE ordernumber = 'P180203131222889' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '58692' WHERE ordernumber = 'P200203131233974' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '138142' WHERE ordernumber = 'P200203131554835' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375308' WHERE ordernumber = 'P200203131656702' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375298' WHERE ordernumber = 'P180203131732732' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '160339' WHERE ordernumber = 'P200203131733435' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375298' WHERE ordernumber = 'P180203131749828' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '322770' WHERE ordernumber = 'P200203131806653' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '160508' WHERE ordernumber = 'P190203131906152' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '135805' WHERE ordernumber = 'P200203131941903' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '335718' WHERE ordernumber = 'P180203131956855' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375299' WHERE ordernumber = 'P190203132013881' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '307758' WHERE ordernumber = 'P180203132201599' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375312' WHERE ordernumber = 'P420203132328475' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375278' WHERE ordernumber = 'P180203132507370' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375278' WHERE ordernumber = 'P180203132526476' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375301' WHERE ordernumber = 'P180203133412741' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '126005' WHERE ordernumber = 'P200203133444172' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '69962' WHERE ordernumber = 'P190203133752375' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '69962' WHERE ordernumber = 'P190203133823618' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375310' WHERE ordernumber = 'P190203134148832' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '122723' WHERE ordernumber = 'P180203134154368' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375310' WHERE ordernumber = 'P190203134214696' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '337886' WHERE ordernumber = 'P200203134253790' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '99445' WHERE ordernumber = 'P200203134543436' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '351288' WHERE ordernumber = 'P180203134713685' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '292403' WHERE ordernumber = 'P180203134908502' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '352479' WHERE ordernumber = 'P200203134909698' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '364393' WHERE ordernumber = 'P200203134947225' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375313' WHERE ordernumber = 'P180203135011649' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '88195' WHERE ordernumber = 'P180203135038796' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '314336' WHERE ordernumber = 'P180203135159984' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '236250' WHERE ordernumber = 'P200203135231657' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375309' WHERE ordernumber = 'P190203135359512' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375316' WHERE ordernumber = 'P180203135455613' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '351442' WHERE ordernumber = 'P180203135649756' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '99941' WHERE ordernumber = 'P180203135824141' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '99941' WHERE ordernumber = 'P180203135914876' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '159321' WHERE ordernumber = 'P200203140001364' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '350556' WHERE ordernumber = 'P420203140058768' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '263810' WHERE ordernumber = 'P180203140158712' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '366837' WHERE ordernumber = 'P180203140244241' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '367050' WHERE ordernumber = 'P190203140300332' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375326' WHERE ordernumber = 'P420203140323946' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375327' WHERE ordernumber = 'P200203140507334' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375317' WHERE ordernumber = 'P180203140649590' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375317' WHERE ordernumber = 'P180203140812780' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375321' WHERE ordernumber = 'P180203141031155' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375325' WHERE ordernumber = 'P180203141150261' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '296801' WHERE ordernumber = 'P420203141208192' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '329550' WHERE ordernumber = 'P200203141234633' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '274011' WHERE ordernumber = 'P420203141351253' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375329' WHERE ordernumber = 'P420203141520131' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375322' WHERE ordernumber = 'P180203141620461' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375323' WHERE ordernumber = 'P180203141658513' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375323' WHERE ordernumber = 'P180203141723478' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375324' WHERE ordernumber = 'P190203141805282' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375330' WHERE ordernumber = 'P420203141855720' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375324' WHERE ordernumber = 'P190203141906281' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '160744' WHERE ordernumber = 'P200203141924215' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '235754' WHERE ordernumber = 'P190203142043311' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375331' WHERE ordernumber = 'P420203142046800' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '346862' WHERE ordernumber = 'P200203142113691' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375333' WHERE ordernumber = 'P200203142241867' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '368802' WHERE ordernumber = 'P200203142324927' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375337' WHERE ordernumber = 'P200203142549951' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '250584' WHERE ordernumber = 'P420203142616649' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '355290' WHERE ordernumber = 'P420203142737292' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '334889' WHERE ordernumber = 'P190203143226849' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375334' WHERE ordernumber = 'P180203143656900' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '369912' WHERE ordernumber = 'P200203143839732' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375340' WHERE ordernumber = 'P180203143903369' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '365581' WHERE ordernumber = 'P200203144123960' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '351470' WHERE ordernumber = 'P200203144448284' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '212503' WHERE ordernumber = 'P200203144635648' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '367046' WHERE ordernumber = 'P200203145203823' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '120276' WHERE ordernumber = 'P200203145424250' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '165608' WHERE ordernumber = 'P180203145647324' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '262644' WHERE ordernumber = 'P420203145916335' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '375353' WHERE ordernumber = 'P420203150214263' 2024-02-04 01:00:04 -- UPDATE `omo_order_list` SET userId = '37323' WHERE ordernumber = 'P180203150315991' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '88468' WHERE ordernumber = 'P530203150520947' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375348' WHERE ordernumber = 'P180203150554779' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '87432' WHERE ordernumber = 'P180203150730397' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '358938' WHERE ordernumber = 'P190203150914681' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '358938' WHERE ordernumber = 'P190203151005961' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '94436' WHERE ordernumber = 'P190203151309721' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '275674' WHERE ordernumber = 'P180203151530939' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '343066' WHERE ordernumber = 'P420203151744962' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375364' WHERE ordernumber = 'P420203152105442' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375362' WHERE ordernumber = 'P180203152121383' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '366677' WHERE ordernumber = 'P190203152205156' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375365' WHERE ordernumber = 'P420203152224785' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '373891' WHERE ordernumber = 'P200203152249221' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '162814' WHERE ordernumber = 'P190203152437151' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '96967' WHERE ordernumber = 'P200203152444716' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '365784' WHERE ordernumber = 'P420203152607599' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '340673' WHERE ordernumber = 'P200203152619711' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '365784' WHERE ordernumber = 'P420203152704406' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '365790' WHERE ordernumber = 'P420203152740880' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '365790' WHERE ordernumber = 'P420203152829610' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375368' WHERE ordernumber = 'P420203153454650' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375369' WHERE ordernumber = 'P420203153833565' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375370' WHERE ordernumber = 'P200203153929351' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375372' WHERE ordernumber = 'P420203154415697' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '329411' WHERE ordernumber = 'P420203154533327' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '374078' WHERE ordernumber = 'P200203155036465' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '285958' WHERE ordernumber = 'P180203155110245' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375374' WHERE ordernumber = 'P200203155157481' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '229396' WHERE ordernumber = 'P180203160003910' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375376' WHERE ordernumber = 'P420203160006806' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375378' WHERE ordernumber = 'P420203160235350' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375379' WHERE ordernumber = 'P420203160417368' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375379' WHERE ordernumber = 'P420203160454609' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375381' WHERE ordernumber = 'P420203160633247' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '337116' WHERE ordernumber = 'P200203160802762' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '268877' WHERE ordernumber = 'P420203160830430' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375383' WHERE ordernumber = 'P420203161016326' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375384' WHERE ordernumber = 'P420203161223467' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '250259' WHERE ordernumber = 'P180203161405853' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '135710' WHERE ordernumber = 'P200203161405912' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '356437' WHERE ordernumber = 'P200203161548622' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '53920' WHERE ordernumber = 'P200203161653655' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '358796' WHERE ordernumber = 'P180203161736622' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '163392' WHERE ordernumber = 'P420203161911520' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375385' WHERE ordernumber = 'P420203162130565' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '273479' WHERE ordernumber = 'P180203162347544' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375387' WHERE ordernumber = 'P420203162349796' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375388' WHERE ordernumber = 'P200203162431762' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375389' WHERE ordernumber = 'P420203162507984' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '368912' WHERE ordernumber = 'P420203162600180' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '224573' WHERE ordernumber = 'P200203162713407' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '372868' WHERE ordernumber = 'P200203162747419' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '163392' WHERE ordernumber = 'P420203163353206' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '105692' WHERE ordernumber = 'P200203163432837' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '365692' WHERE ordernumber = 'P420203163531472' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '361133' WHERE ordernumber = 'P180203163547724' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '361133' WHERE ordernumber = 'P180203163616493' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375391' WHERE ordernumber = 'P420203163632618' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375392' WHERE ordernumber = 'P420203163744344' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '363149' WHERE ordernumber = 'P200203164504111' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375395' WHERE ordernumber = 'P200203164836505' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375038' WHERE ordernumber = 'P200203165228681' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375398' WHERE ordernumber = 'P420203165342985' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375399' WHERE ordernumber = 'P420203165448408' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '317218' WHERE ordernumber = 'P420203165610952' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375401' WHERE ordernumber = 'P200203165615860' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '294267' WHERE ordernumber = 'P200203165806396' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '371998' WHERE ordernumber = 'P200203170218841' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '372185' WHERE ordernumber = 'P200203170251722' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '271243' WHERE ordernumber = 'P180203170335927' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '41785' WHERE ordernumber = 'P200203171056471' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '373915' WHERE ordernumber = 'P200203171136639' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '373915' WHERE ordernumber = 'P200203171334931' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '138340' WHERE ordernumber = 'P180203172010642' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '130793' WHERE ordernumber = 'P180203172244409' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '358831' WHERE ordernumber = 'P200203172517142' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '354331' WHERE ordernumber = 'P420203172815716' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '23794' WHERE ordernumber = 'P200203173205274' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '146267' WHERE ordernumber = 'P190203173341651' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '359824' WHERE ordernumber = 'P180203174420224' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375416' WHERE ordernumber = 'P180203174758371' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375417' WHERE ordernumber = 'P190203175016573' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '361198' WHERE ordernumber = 'P180203175223524' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '361198' WHERE ordernumber = 'P180203175307315' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '310546' WHERE ordernumber = 'P180203175358267' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '348959' WHERE ordernumber = 'P180203175523363' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '336162' WHERE ordernumber = 'P420203181842334' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375428' WHERE ordernumber = 'P180203182524816' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375429' WHERE ordernumber = 'P420203182539380' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '354037' WHERE ordernumber = 'P180203182801333' 2024-02-04 01:00:05 -- UPDATE `omo_order_list` SET userId = '375430' WHERE ordernumber = 'P200203183048800' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375431' WHERE ordernumber = 'P180203183200476' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375434' WHERE ordernumber = 'P180203183351920' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375428' WHERE ordernumber = 'P180203183500320' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '284725' WHERE ordernumber = 'P200203183835329' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '349347' WHERE ordernumber = 'P200203184232445' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '328235' WHERE ordernumber = 'P420203184537275' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375437' WHERE ordernumber = 'P420203184910862' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '344817' WHERE ordernumber = 'P420203190147119' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375446' WHERE ordernumber = 'P420203190938492' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '259843' WHERE ordernumber = 'P180203191015948' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375447' WHERE ordernumber = 'P200203191305429' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '344135' WHERE ordernumber = 'P180203191357489' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375448' WHERE ordernumber = 'P420203191905739' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '100921' WHERE ordernumber = 'P420203192245515' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '312843' WHERE ordernumber = 'P200203192248460' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375451' WHERE ordernumber = 'P420203192407525' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '372379' WHERE ordernumber = 'P420203193555858' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '104035' WHERE ordernumber = 'P190203194002428' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '118908' WHERE ordernumber = 'P190203194201856' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '307088' WHERE ordernumber = 'P190203194428858' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '255573' WHERE ordernumber = 'P190203194618782' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '307088' WHERE ordernumber = 'P190203194714525' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '96007' WHERE ordernumber = 'P190203195747146' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '146448' WHERE ordernumber = 'P190203200100305' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '339561' WHERE ordernumber = 'P420203200106129' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375465' WHERE ordernumber = 'P420203200935452' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375473' WHERE ordernumber = 'P420203203543347' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375475' WHERE ordernumber = 'P420203204113987' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375477' WHERE ordernumber = 'P420203204312756' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '375478' WHERE ordernumber = 'P420203204539130' 2024-02-04 01:00:06 -- UPDATE `omo_order_list` SET userId = '318317' WHERE ordernumber = 'P420203205955431'