2024-06-30 01:00:02 -- 將會員中心id寫入data-lake 2024-06-30 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-06-29%'; 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '389140' WHERE ordernumber = 'P630629100955250' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398750' WHERE ordernumber = 'P630629103635218' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398751' WHERE ordernumber = 'P630629104024286' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '150175' WHERE ordernumber = 'P630629104416764' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398752' WHERE ordernumber = 'P630629104555555' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398753' WHERE ordernumber = 'P630629104717972' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '392145' WHERE ordernumber = 'P630629105255356' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '396657' WHERE ordernumber = 'P630629110025231' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '266014' WHERE ordernumber = 'P180629110217160' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398754' WHERE ordernumber = 'P180629110329225' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '340409' WHERE ordernumber = 'P190629110359119' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398755' WHERE ordernumber = 'P180629110617550' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398756' WHERE ordernumber = 'P200629110837873' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398757' WHERE ordernumber = 'P420629111148805' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '312628' WHERE ordernumber = 'P200629111331933' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398758' WHERE ordernumber = 'P180629111333811' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '368550' WHERE ordernumber = 'P180629111430766' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398759' WHERE ordernumber = 'P190629111439594' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '398758' WHERE ordernumber = 'P180629111516360' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '371594' WHERE ordernumber = 'P420629111533380' 2024-06-30 01:00:02 -- UPDATE `omo_order_list` SET userId = '279910' WHERE ordernumber = 'P180629111734444' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398761' WHERE ordernumber = 'P180629111940864' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398760' WHERE ordernumber = 'P630629112047747' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398763' WHERE ordernumber = 'P180629112754179' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '170609' WHERE ordernumber = 'P190629112909299' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '396983' WHERE ordernumber = 'P200629113151808' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '365387' WHERE ordernumber = 'P190629113240136' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '347019' WHERE ordernumber = 'P630629113507762' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398764' WHERE ordernumber = 'P180629113604315' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398765' WHERE ordernumber = 'P190629113630622' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398764' WHERE ordernumber = 'P190629113737791' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398766' WHERE ordernumber = 'P630629113858837' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398767' WHERE ordernumber = 'P780629114028332' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398768' WHERE ordernumber = 'P420629114039475' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398769' WHERE ordernumber = 'P630629114112415' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398770' WHERE ordernumber = 'P180629114344321' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '232438' WHERE ordernumber = 'P180629114505854' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '30677' WHERE ordernumber = 'P630629114530423' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '254880' WHERE ordernumber = 'P180629114628415' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '334955' WHERE ordernumber = 'P200629115034893' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398772' WHERE ordernumber = 'P180629115120535' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398773' WHERE ordernumber = 'P180629115355697' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398774' WHERE ordernumber = 'P190629115501282' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398775' WHERE ordernumber = 'P420629115801166' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398777' WHERE ordernumber = 'P200629120018816' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398778' WHERE ordernumber = 'P180629120102451' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '343605' WHERE ordernumber = 'P190629120106984' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398779' WHERE ordernumber = 'P190629120247381' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398780' WHERE ordernumber = 'P420629120309519' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398781' WHERE ordernumber = 'P190629120402724' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398782' WHERE ordernumber = 'P630629120442515' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398783' WHERE ordernumber = 'P190629120515728' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398784' WHERE ordernumber = 'P180629120658151' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398786' WHERE ordernumber = 'P630629120854132' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398787' WHERE ordernumber = 'P190629121012227' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398788' WHERE ordernumber = 'P190629121238501' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398789' WHERE ordernumber = 'P420629121557495' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398791' WHERE ordernumber = 'P630629121843945' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '131354' WHERE ordernumber = 'P180629121943783' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398792' WHERE ordernumber = 'P200629122243473' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398794' WHERE ordernumber = 'P180629122504129' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398795' WHERE ordernumber = 'P630629122719268' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398796' WHERE ordernumber = 'P200629122827654' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398797' WHERE ordernumber = 'P180629122829394' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '277801' WHERE ordernumber = 'P200629123104674' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '389567' WHERE ordernumber = 'P200629123544255' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '381914' WHERE ordernumber = 'P420629123601255' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '384279' WHERE ordernumber = 'P180629123639702' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398798' WHERE ordernumber = 'P630629123813898' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398799' WHERE ordernumber = 'P420629124035816' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398800' WHERE ordernumber = 'P420629124341134' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '177823' WHERE ordernumber = 'P630629124420694' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398802' WHERE ordernumber = 'P630629124756884' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '337863' WHERE ordernumber = 'P420629124805338' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '397553' WHERE ordernumber = 'P190629124909600' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398803' WHERE ordernumber = 'P180629124913354' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '397553' WHERE ordernumber = 'P190629124953118' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398804' WHERE ordernumber = 'P420629125025706' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398805' WHERE ordernumber = 'P200629125041981' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398806' WHERE ordernumber = 'P180629125135170' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398807' WHERE ordernumber = 'P180629125359460' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '125335' WHERE ordernumber = 'P190629125512904' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398808' WHERE ordernumber = 'P180629125711473' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398810' WHERE ordernumber = 'P200629125836379' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '1592' WHERE ordernumber = 'P190629130041855' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '389128' WHERE ordernumber = 'P180629130505328' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398811' WHERE ordernumber = 'P780629130546220' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '251614' WHERE ordernumber = 'P180629130659251' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398812' WHERE ordernumber = 'P200629131051962' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '318094' WHERE ordernumber = 'P420629131827962' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398813' WHERE ordernumber = 'P630629131851300' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '250334' WHERE ordernumber = 'P200629131942992' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398814' WHERE ordernumber = 'P420629132013350' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398815' WHERE ordernumber = 'P630629132025170' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '94016' WHERE ordernumber = 'P630629132907866' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398816' WHERE ordernumber = 'P780629133030491' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398818' WHERE ordernumber = 'P630629133210825' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398817' WHERE ordernumber = 'P200629133225551' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398819' WHERE ordernumber = 'P420629133238191' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '223688' WHERE ordernumber = 'P180629133246737' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '384960' WHERE ordernumber = 'P200629133531442' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398809' WHERE ordernumber = 'P180629133536676' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '392145' WHERE ordernumber = 'P630629133730842' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398820' WHERE ordernumber = 'P200629133903370' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398821' WHERE ordernumber = 'P420629134152123' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '358787' WHERE ordernumber = 'P180629134210776' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '135323' WHERE ordernumber = 'P200629134235331' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398823' WHERE ordernumber = 'P630629134357298' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398824' WHERE ordernumber = 'P630629134428596' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '395384' WHERE ordernumber = 'P180629134426772' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398825' WHERE ordernumber = 'P630629134827326' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398122' WHERE ordernumber = 'P180629134852479' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '338106' WHERE ordernumber = 'P190629135023309' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '302233' WHERE ordernumber = 'P420629135103904' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398827' WHERE ordernumber = 'P630629135446155' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398826' WHERE ordernumber = 'P200629135536200' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398828' WHERE ordernumber = 'P630629135605887' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398829' WHERE ordernumber = 'P180629135752335' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '392687' WHERE ordernumber = 'P630629135944280' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '345470' WHERE ordernumber = 'P200629135947605' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398830' WHERE ordernumber = 'P420629140108353' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '397139' WHERE ordernumber = 'P200629140234258' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398832' WHERE ordernumber = 'P200629140439873' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '390220' WHERE ordernumber = 'P200629140652438' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '398834' WHERE ordernumber = 'P200629140909681' 2024-06-30 01:00:03 -- UPDATE `omo_order_list` SET userId = '281053' WHERE ordernumber = 'P180629141026970' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398835' WHERE ordernumber = 'P200629141155830' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398836' WHERE ordernumber = 'P180629141229265' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398837' WHERE ordernumber = 'P420629141735846' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '353647' WHERE ordernumber = 'P180629141745264' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398838' WHERE ordernumber = 'P420629141901273' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398839' WHERE ordernumber = 'P420629142333823' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398841' WHERE ordernumber = 'P190629142521343' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398840' WHERE ordernumber = 'P180629142624452' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398842' WHERE ordernumber = 'P190629142758235' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '365964' WHERE ordernumber = 'P630629142913134' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '322480' WHERE ordernumber = 'P180629142919483' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '322480' WHERE ordernumber = 'P180629143539744' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398643' WHERE ordernumber = 'P200629144008703' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398844' WHERE ordernumber = 'P630629144213932' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398845' WHERE ordernumber = 'P180629144435354' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '84727' WHERE ordernumber = 'P180629144714928' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398846' WHERE ordernumber = 'P200629145033297' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398831' WHERE ordernumber = 'P180629145047471' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398847' WHERE ordernumber = 'P200629145249313' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '365876' WHERE ordernumber = 'P780629145411877' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398848' WHERE ordernumber = 'P180629145439151' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398849' WHERE ordernumber = 'P190629145553704' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '349641' WHERE ordernumber = 'P180629145817661' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '349641' WHERE ordernumber = 'P180629145917621' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '292471' WHERE ordernumber = 'P420629145955386' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398851' WHERE ordernumber = 'P420629150243456' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '141896' WHERE ordernumber = 'P180629150259751' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398853' WHERE ordernumber = 'P180629150521431' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398854' WHERE ordernumber = 'P420629151103864' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398506' WHERE ordernumber = 'P630629151452237' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398855' WHERE ordernumber = 'P180629152231776' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '384507' WHERE ordernumber = 'P180629152412395' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398856' WHERE ordernumber = 'P200629153003796' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398858' WHERE ordernumber = 'P200629153506163' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398857' WHERE ordernumber = 'P180629153511403' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398859' WHERE ordernumber = 'P420629153648515' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '105630' WHERE ordernumber = 'P200629153656563' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398860' WHERE ordernumber = 'P180629153729677' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398861' WHERE ordernumber = 'P420629153818332' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '214268' WHERE ordernumber = 'P630629153928674' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398862' WHERE ordernumber = 'P420629154236872' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398864' WHERE ordernumber = 'P420629154401904' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398863' WHERE ordernumber = 'P630629154418495' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398866' WHERE ordernumber = 'P180629154540277' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '6064' WHERE ordernumber = 'P180629155000652' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398867' WHERE ordernumber = 'P630629155306584' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398868' WHERE ordernumber = 'P630629155425214' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398869' WHERE ordernumber = 'P630629155628866' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398870' WHERE ordernumber = 'P200629155640845' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398871' WHERE ordernumber = 'P420629155744589' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398872' WHERE ordernumber = 'P180629155928498' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '27800' WHERE ordernumber = 'P630629155949613' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398873' WHERE ordernumber = 'P420629160032954' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398874' WHERE ordernumber = 'P200629160158985' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '142945' WHERE ordernumber = 'P190629160228575' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '293405' WHERE ordernumber = 'P180629160347725' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '287880' WHERE ordernumber = 'P190629160412430' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398876' WHERE ordernumber = 'P200629160508366' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '126003' WHERE ordernumber = 'P190629160736533' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '390060' WHERE ordernumber = 'P180629160908594' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398877' WHERE ordernumber = 'P200629160910474' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398878' WHERE ordernumber = 'P420629161001216' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '390589' WHERE ordernumber = 'P200629161214644' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398879' WHERE ordernumber = 'P180629161219628' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398883' WHERE ordernumber = 'P630629161506762' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398884' WHERE ordernumber = 'P420629161835118' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398886' WHERE ordernumber = 'P180629162344113' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398887' WHERE ordernumber = 'P190629162428694' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398888' WHERE ordernumber = 'P420629162519612' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398889' WHERE ordernumber = 'P190629162649348' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398889' WHERE ordernumber = 'P180629163000736' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398890' WHERE ordernumber = 'P190629163027629' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398891' WHERE ordernumber = 'P190629163431854' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '390693' WHERE ordernumber = 'P190629163533338' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '238134' WHERE ordernumber = 'P200629163614763' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '339374' WHERE ordernumber = 'P190629163634829' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398892' WHERE ordernumber = 'P180629164035951' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398893' WHERE ordernumber = 'P420629164229879' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '94237' WHERE ordernumber = 'P200629164239984' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398894' WHERE ordernumber = 'P180629164300988' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398895' WHERE ordernumber = 'P180629164409880' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398896' WHERE ordernumber = 'P420629164418507' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398897' WHERE ordernumber = 'P190629164439450' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398898' WHERE ordernumber = 'P180629164654433' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '243284' WHERE ordernumber = 'P420629164732192' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '397445' WHERE ordernumber = 'P180629164734788' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398899' WHERE ordernumber = 'P190629164736399' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '270849' WHERE ordernumber = 'P420629164816766' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398900' WHERE ordernumber = 'P190629164834487' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '216284' WHERE ordernumber = 'P190629165005833' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398902' WHERE ordernumber = 'P200629165035901' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398904' WHERE ordernumber = 'P630629165202636' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398903' WHERE ordernumber = 'P420629165145586' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '318992' WHERE ordernumber = 'P180629165057870' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '357105' WHERE ordernumber = 'P630629165312277' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398905' WHERE ordernumber = 'P420629165451284' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398906' WHERE ordernumber = 'P180629165516755' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '336251' WHERE ordernumber = 'P420629165658777' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '39363' WHERE ordernumber = 'P590629165749973' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398907' WHERE ordernumber = 'P420629165859200' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398908' WHERE ordernumber = 'P180629170009925' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '396305' WHERE ordernumber = 'P180629170206589' 2024-06-30 01:00:04 -- UPDATE `omo_order_list` SET userId = '398909' WHERE ordernumber = 'P180629170340277' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398910' WHERE ordernumber = 'P630629170624697' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '278762' WHERE ordernumber = 'P190629170924826' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '27910' WHERE ordernumber = 'P420629171017404' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '245948' WHERE ordernumber = 'P420629171207723' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398911' WHERE ordernumber = 'P180629171404252' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '286124' WHERE ordernumber = 'P180629171750796' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398913' WHERE ordernumber = 'P180629172042303' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '318170' WHERE ordernumber = 'P180629172155864' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '331452' WHERE ordernumber = 'P420629172205204' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '392042' WHERE ordernumber = 'P190629172213437' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398914' WHERE ordernumber = 'P420629172327715' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398915' WHERE ordernumber = 'P190629172349856' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '393021' WHERE ordernumber = 'P630629172439585' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '123671' WHERE ordernumber = 'P200629172506568' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398916' WHERE ordernumber = 'P630629172632391' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398917' WHERE ordernumber = 'P180629172714188' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398918' WHERE ordernumber = 'P420629172814791' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '396599' WHERE ordernumber = 'P180629173126872' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '317028' WHERE ordernumber = 'P180629173416674' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398919' WHERE ordernumber = 'P200629173459590' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '128604' WHERE ordernumber = 'P180629173711255' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '276783' WHERE ordernumber = 'P200629173717402' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '328733' WHERE ordernumber = 'P630629173912727' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '158919' WHERE ordernumber = 'P180629174821251' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398920' WHERE ordernumber = 'P190629174932204' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398922' WHERE ordernumber = 'P420629175254245' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398921' WHERE ordernumber = 'P180629175407964' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '78682' WHERE ordernumber = 'P630629175408538' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398924' WHERE ordernumber = 'P180629175727474' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '307242' WHERE ordernumber = 'P180629175835515' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '141288' WHERE ordernumber = 'P200629180017705' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398925' WHERE ordernumber = 'P630629180126708' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398926' WHERE ordernumber = 'P630629180233216' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '165412' WHERE ordernumber = 'P200629180419320' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '67284' WHERE ordernumber = 'P420629180439978' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398927' WHERE ordernumber = 'P420629180630362' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '396967' WHERE ordernumber = 'P590629180956220' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '332962' WHERE ordernumber = 'P200629181044545' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398928' WHERE ordernumber = 'P630629181159730' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398929' WHERE ordernumber = 'P180629181247918' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398930' WHERE ordernumber = 'P630629181301134' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398931' WHERE ordernumber = 'P420629181630392' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '103631' WHERE ordernumber = 'P590629181749734' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '303700' WHERE ordernumber = 'P180629181850642' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '96181' WHERE ordernumber = 'P180629182216449' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '336537' WHERE ordernumber = 'P180629182302283' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398933' WHERE ordernumber = 'P630629182313177' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398934' WHERE ordernumber = 'P200629182402465' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398935' WHERE ordernumber = 'P420629182439964' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '94701' WHERE ordernumber = 'P180629182559514' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398936' WHERE ordernumber = 'P180629182728467' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398411' WHERE ordernumber = 'P180629182837725' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '384463' WHERE ordernumber = 'P420629183037987' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398938' WHERE ordernumber = 'P420629183150264' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398939' WHERE ordernumber = 'P420629183328971' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398793' WHERE ordernumber = 'P200629183357606' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '369293' WHERE ordernumber = 'P420629183431921' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '97763' WHERE ordernumber = 'P180629183459869' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398940' WHERE ordernumber = 'P200629183901982' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '351753' WHERE ordernumber = 'P420629183956694' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '387084' WHERE ordernumber = 'P420629184335461' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398941' WHERE ordernumber = 'P420629184736217' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '280371' WHERE ordernumber = 'P420629184848599' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398942' WHERE ordernumber = 'P180629184923668' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398943' WHERE ordernumber = 'P420629185010220' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398944' WHERE ordernumber = 'P180629185019385' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '386343' WHERE ordernumber = 'P420629185059283' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '301407' WHERE ordernumber = 'P190629185447293' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398945' WHERE ordernumber = 'P190629185551211' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398946' WHERE ordernumber = 'P200629185706679' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '121774' WHERE ordernumber = 'P190629190112618' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398923' WHERE ordernumber = 'P190629190831387' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398947' WHERE ordernumber = 'P200629191115943' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398948' WHERE ordernumber = 'P190629191124804' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398949' WHERE ordernumber = 'P630629191701690' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398923' WHERE ordernumber = 'P190629191805922' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398950' WHERE ordernumber = 'P630629191914464' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '253218' WHERE ordernumber = 'P630629192107783' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398952' WHERE ordernumber = 'P190629192216118' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398953' WHERE ordernumber = 'P190629192445680' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '372726' WHERE ordernumber = 'P200629192746857' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398954' WHERE ordernumber = 'P200629192938125' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '233993' WHERE ordernumber = 'P200629193102293' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398951' WHERE ordernumber = 'P200629193150494' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398956' WHERE ordernumber = 'P630629193829985' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '284400' WHERE ordernumber = 'P190629193921369' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398957' WHERE ordernumber = 'P630629193928437' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '380361' WHERE ordernumber = 'P200629194455838' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398958' WHERE ordernumber = 'P780629194748298' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '385961' WHERE ordernumber = 'P200629194824907' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398489' WHERE ordernumber = 'P190629195003694' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398960' WHERE ordernumber = 'P200629195101720' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398962' WHERE ordernumber = 'P190629195127389' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '394228' WHERE ordernumber = 'P200629195504814' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398963' WHERE ordernumber = 'P630629195531133' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '114172' WHERE ordernumber = 'P190629195622809' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398964' WHERE ordernumber = 'P630629195825611' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '264506' WHERE ordernumber = 'P190629195839699' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398965' WHERE ordernumber = 'P200629200422158' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '378810' WHERE ordernumber = 'P630629200530997' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '390727' WHERE ordernumber = 'P630629200855157' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398967' WHERE ordernumber = 'P630629201701979' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398968' WHERE ordernumber = 'P630629202312401' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398969' WHERE ordernumber = 'P630629202642719' 2024-06-30 01:00:05 -- UPDATE `omo_order_list` SET userId = '398971' WHERE ordernumber = 'P630629205005952' 2024-06-30 01:00:06 -- UPDATE `omo_order_list` SET userId = '226218' WHERE ordernumber = 'P630629205130630' 2024-06-30 01:00:06 -- UPDATE `omo_order_list` SET userId = '398572' WHERE ordernumber = 'P780629210127655' 2024-06-30 01:00:06 -- UPDATE `omo_order_list` SET userId = '398973' WHERE ordernumber = 'P630629210230211' 2024-06-30 01:00:06 -- UPDATE `omo_order_list` SET userId = '398974' WHERE ordernumber = 'P630629215047650'