2024-01-11 01:00:03 -- 將會員中心id寫入data-lake 2024-01-11 01:00:03 -- SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at FROM `purchases` p LEFT JOIN user_relations ur on p.user_relation_id = ur.id LEFT JOIN users u on ur.user_id = u.id WHERE p.order_code LIKE 'P%' and p.created_at like '2024-01-10%'; 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '137563' WHERE ordernumber = 'P200110110513894' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '313001' WHERE ordernumber = 'P420110110541630' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363864' WHERE ordernumber = 'P200110110658538' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '214104' WHERE ordernumber = 'P200110110924862' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '138130' WHERE ordernumber = 'P420110111005734' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '104297' WHERE ordernumber = 'P200110111011211' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '214193' WHERE ordernumber = 'P180110111125179' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363867' WHERE ordernumber = 'P190110111203489' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '143832' WHERE ordernumber = 'P420110111207787' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '231416' WHERE ordernumber = 'P200110111313571' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '247887' WHERE ordernumber = 'P180110111439980' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '94231' WHERE ordernumber = 'P200110111444549' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '338237' WHERE ordernumber = 'P420110111504564' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '287139' WHERE ordernumber = 'P200110111515186' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '235730' WHERE ordernumber = 'P180110111546863' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '309980' WHERE ordernumber = 'P190110111642420' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363868' WHERE ordernumber = 'P180110111708515' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '238986' WHERE ordernumber = 'P180110111802244' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '335158' WHERE ordernumber = 'P420110111852734' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '309980' WHERE ordernumber = 'P190110111913451' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '325603' WHERE ordernumber = 'P180110111944270' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363874' WHERE ordernumber = 'P420110112644563' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '335158' WHERE ordernumber = 'P420110112921973' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363876' WHERE ordernumber = 'P180110113049619' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363876' WHERE ordernumber = 'P180110113118742' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363877' WHERE ordernumber = 'P180110113359625' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '162857' WHERE ordernumber = 'P200110113400121' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '159146' WHERE ordernumber = 'P180110113627953' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '344536' WHERE ordernumber = 'P180110113712626' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363879' WHERE ordernumber = 'P180110113916282' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '81029' WHERE ordernumber = 'P200110113942890' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '351655' WHERE ordernumber = 'P180110114057668' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363881' WHERE ordernumber = 'P200110114230228' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '30257' WHERE ordernumber = 'P180110114245758' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363883' WHERE ordernumber = 'P180110114508360' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363883' WHERE ordernumber = 'P180110114603523' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363886' WHERE ordernumber = 'P200110114848838' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363889' WHERE ordernumber = 'P180110114916407' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '339701' WHERE ordernumber = 'P420110114943939' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '277769' WHERE ordernumber = 'P200110115042634' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '276738' WHERE ordernumber = 'P190110115052188' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '140600' WHERE ordernumber = 'P190110115111743' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '256426' WHERE ordernumber = 'P180110115431227' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '167603' WHERE ordernumber = 'P180110115907971' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363893' WHERE ordernumber = 'P200110115958345' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363894' WHERE ordernumber = 'P180110120108508' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '152024' WHERE ordernumber = 'P420110120121914' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P200110120814596' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363896' WHERE ordernumber = 'P420110121139272' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '100750' WHERE ordernumber = 'P180110121203966' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '164732' WHERE ordernumber = 'P200110121342475' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363409' WHERE ordernumber = 'P180110121448465' 2024-01-11 01:00:03 -- UPDATE `omo_order_list` SET userId = '363409' WHERE ordernumber = 'P180110121516362' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363898' WHERE ordernumber = 'P200110121703112' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363900' WHERE ordernumber = 'P180110121804829' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363899' WHERE ordernumber = 'P200110121806203' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '265964' WHERE ordernumber = 'P200110122026780' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '99761' WHERE ordernumber = 'P180110122114341' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363901' WHERE ordernumber = 'P200110122231969' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '37323' WHERE ordernumber = 'P180110122411821' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363902' WHERE ordernumber = 'P200110122438917' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363903' WHERE ordernumber = 'P200110122551582' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363906' WHERE ordernumber = 'P200110122729505' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363909' WHERE ordernumber = 'P200110122853162' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '107750' WHERE ordernumber = 'P180110123259234' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '319090' WHERE ordernumber = 'P200110123310438' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '107750' WHERE ordernumber = 'P180110123332859' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '227396' WHERE ordernumber = 'P190110123349567' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '322245' WHERE ordernumber = 'P420110123526562' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363913' WHERE ordernumber = 'P180110123619575' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '246001' WHERE ordernumber = 'P200110123734423' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '108997' WHERE ordernumber = 'P200110123849665' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '42138' WHERE ordernumber = 'P180110124042484' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363918' WHERE ordernumber = 'P200110124127160' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363919' WHERE ordernumber = 'P420110124206981' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '133562' WHERE ordernumber = 'P190110124254614' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363920' WHERE ordernumber = 'P420110124357349' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '230134' WHERE ordernumber = 'P180110124458813' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363922' WHERE ordernumber = 'P420110124559962' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363925' WHERE ordernumber = 'P180110124804191' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363924' WHERE ordernumber = 'P200110124815964' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363922' WHERE ordernumber = 'P420110124950123' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363918' WHERE ordernumber = 'P200110125032391' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '93266' WHERE ordernumber = 'P180110125123235' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363929' WHERE ordernumber = 'P200110125607168' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '270895' WHERE ordernumber = 'P200110125907676' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '275669' WHERE ordernumber = 'P180110130055477' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363804' WHERE ordernumber = 'P190110130119395' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '362189' WHERE ordernumber = 'P420110130119985' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363804' WHERE ordernumber = 'P190110130147277' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '81046' WHERE ordernumber = 'P180110130211687' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363934' WHERE ordernumber = 'P180110130419877' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '99983' WHERE ordernumber = 'P200110130428775' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363935' WHERE ordernumber = 'P420110130511651' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '99983' WHERE ordernumber = 'P200110130612997' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '276527' WHERE ordernumber = 'P180110131226852' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '316368' WHERE ordernumber = 'P200110131315260' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363941' WHERE ordernumber = 'P200110131434152' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363299' WHERE ordernumber = 'P180110131606243' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363944' WHERE ordernumber = 'P200110131709696' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363942' WHERE ordernumber = 'P190110131747688' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '225116' WHERE ordernumber = 'P180110132006924' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '214263' WHERE ordernumber = 'P200110132055202' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363947' WHERE ordernumber = 'P200110132249573' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '295092' WHERE ordernumber = 'P190110132300326' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '268454' WHERE ordernumber = 'P420110132304139' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363948' WHERE ordernumber = 'P180110132336875' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363254' WHERE ordernumber = 'P420110132547824' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '275671' WHERE ordernumber = 'P190110132634826' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '155696' WHERE ordernumber = 'P420110132928712' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363950' WHERE ordernumber = 'P420110133308365' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363951' WHERE ordernumber = 'P420110133402310' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363955' WHERE ordernumber = 'P420110133623577' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363956' WHERE ordernumber = 'P420110133933427' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '255988' WHERE ordernumber = 'P200110134044689' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '99264' WHERE ordernumber = 'P180110134215469' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363960' WHERE ordernumber = 'P180110134600631' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363964' WHERE ordernumber = 'P200110135054309' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363966' WHERE ordernumber = 'P420110135104968' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '336720' WHERE ordernumber = 'P180110135404160' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363969' WHERE ordernumber = 'P420110135626500' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363970' WHERE ordernumber = 'P420110135953713' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '153377' WHERE ordernumber = 'P200110140057193' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '352543' WHERE ordernumber = 'P420110140116517' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363973' WHERE ordernumber = 'P420110140308852' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '297128' WHERE ordernumber = 'P200110140438710' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363977' WHERE ordernumber = 'P420110140630710' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '206703' WHERE ordernumber = 'P180110140749682' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363978' WHERE ordernumber = 'P420110140808971' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '338262' WHERE ordernumber = 'P200110140926797' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363979' WHERE ordernumber = 'P420110141015575' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '110061' WHERE ordernumber = 'P200110141215506' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363981' WHERE ordernumber = 'P420110141244254' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363983' WHERE ordernumber = 'P420110141412466' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363982' WHERE ordernumber = 'P200110141430188' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '349026' WHERE ordernumber = 'P180110141517517' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '224178' WHERE ordernumber = 'P200110141529854' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '279177' WHERE ordernumber = 'P200110141816682' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '82659' WHERE ordernumber = 'P200110142045518' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '255466' WHERE ordernumber = 'P180110142440632' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363989' WHERE ordernumber = 'P420110142506974' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '282598' WHERE ordernumber = 'P200110142530119' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363995' WHERE ordernumber = 'P200110142829365' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363996' WHERE ordernumber = 'P180110142852425' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '324082' WHERE ordernumber = 'P200110142900312' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '339281' WHERE ordernumber = 'P200110143228406' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363995' WHERE ordernumber = 'P200110143511524' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '223927' WHERE ordernumber = 'P180110143715960' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '363998' WHERE ordernumber = 'P200110143732845' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '364002' WHERE ordernumber = 'P200110144054838' 2024-01-11 01:00:04 -- UPDATE `omo_order_list` SET userId = '287235' WHERE ordernumber = 'P200110144230799' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364006' WHERE ordernumber = 'P180110144554213' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364010' WHERE ordernumber = 'P190110144823835' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '342097' WHERE ordernumber = 'P180110144900663' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '100425' WHERE ordernumber = 'P190110145053994' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364011' WHERE ordernumber = 'P200110145207167' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '287235' WHERE ordernumber = 'P200110145228593' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '31916' WHERE ordernumber = 'P200110145342464' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364013' WHERE ordernumber = 'P420110145602225' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364018' WHERE ordernumber = 'P180110150354834' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364019' WHERE ordernumber = 'P420110150526994' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364020' WHERE ordernumber = 'P180110150540936' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364021' WHERE ordernumber = 'P180110150656585' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '105116' WHERE ordernumber = 'P200110150751172' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '262484' WHERE ordernumber = 'P180110150809440' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364023' WHERE ordernumber = 'P420110150922649' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '277109' WHERE ordernumber = 'P200110150953492' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '325472' WHERE ordernumber = 'P180110151140547' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364028' WHERE ordernumber = 'P420110151656347' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364029' WHERE ordernumber = 'P180110151713528' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364031' WHERE ordernumber = 'P180110152017768' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '309074' WHERE ordernumber = 'P180110152103843' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '83976' WHERE ordernumber = 'P180110152148436' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364034' WHERE ordernumber = 'P420110152418819' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364033' WHERE ordernumber = 'P200110152538235' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '261024' WHERE ordernumber = 'P200110152719463' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364038' WHERE ordernumber = 'P180110152913723' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '233400' WHERE ordernumber = 'P200110153033923' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364040' WHERE ordernumber = 'P420110153141696' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364042' WHERE ordernumber = 'P420110153459400' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '303837' WHERE ordernumber = 'P200110153515987' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364044' WHERE ordernumber = 'P200110153726614' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364045' WHERE ordernumber = 'P420110153838135' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364047' WHERE ordernumber = 'P180110154150358' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364048' WHERE ordernumber = 'P420110154224947' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364052' WHERE ordernumber = 'P180110154451307' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '351495' WHERE ordernumber = 'P200110154455339' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '312978' WHERE ordernumber = 'P420110154516331' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '312978' WHERE ordernumber = 'P420110154550872' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P200110154640212' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364054' WHERE ordernumber = 'P200110154822122' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364056' WHERE ordernumber = 'P180110154918718' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364057' WHERE ordernumber = 'P200110154955501' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364059' WHERE ordernumber = 'P180110155507182' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '363231' WHERE ordernumber = 'P200110155546384' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '100389' WHERE ordernumber = 'P420110155550947' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '353501' WHERE ordernumber = 'P180110155640707' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364060' WHERE ordernumber = 'P180110155731112' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '352257' WHERE ordernumber = 'P200110155741320' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '304095' WHERE ordernumber = 'P180110155822893' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '314557' WHERE ordernumber = 'P420110160421905' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364063' WHERE ordernumber = 'P200110160446581' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '224596' WHERE ordernumber = 'P200110160812583' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364065' WHERE ordernumber = 'P420110160921462' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '86100' WHERE ordernumber = 'P180110161021752' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '105625' WHERE ordernumber = 'P200110161420140' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '72166' WHERE ordernumber = 'P420110161455360' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '321856' WHERE ordernumber = 'P200110161538544' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364069' WHERE ordernumber = 'P200110161846815' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '361953' WHERE ordernumber = 'P180110161953693' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364070' WHERE ordernumber = 'P200110162235937' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '82231' WHERE ordernumber = 'P200110162316129' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364071' WHERE ordernumber = 'P420110162559712' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '352011' WHERE ordernumber = 'P190110162753315' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '330824' WHERE ordernumber = 'P180110162940163' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364071' WHERE ordernumber = 'P420110162954545' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364075' WHERE ordernumber = 'P420110163148418' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364076' WHERE ordernumber = 'P180110163206954' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '298013' WHERE ordernumber = 'P180110163635333' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364080' WHERE ordernumber = 'P420110163810491' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '329788' WHERE ordernumber = 'P420110163905672' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364081' WHERE ordernumber = 'P190110164009144' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '350014' WHERE ordernumber = 'P200110164151187' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364082' WHERE ordernumber = 'P420110164221692' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364083' WHERE ordernumber = 'P190110164333143' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '229781' WHERE ordernumber = 'P200110164357736' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '290326' WHERE ordernumber = 'P200110164448833' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '254184' WHERE ordernumber = 'P200110164740133' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '358337' WHERE ordernumber = 'P190110164925218' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364087' WHERE ordernumber = 'P190110165025116' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '290995' WHERE ordernumber = 'P200110165514413' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364090' WHERE ordernumber = 'P200110165748840' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '282192' WHERE ordernumber = 'P200110170055917' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364092' WHERE ordernumber = 'P420110170237218' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '71514' WHERE ordernumber = 'P420110170336296' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364095' WHERE ordernumber = 'P200110170736238' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '244819' WHERE ordernumber = 'P200110170853847' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364096' WHERE ordernumber = 'P190110170935536' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '297811' WHERE ordernumber = 'P420110171010661' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364099' WHERE ordernumber = 'P190110171144411' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '344123' WHERE ordernumber = 'P420110171159332' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '114734' WHERE ordernumber = 'P200110171508275' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364103' WHERE ordernumber = 'P200110171846732' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '251353' WHERE ordernumber = 'P180110172056798' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '319038' WHERE ordernumber = 'P180110172142757' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '364106' WHERE ordernumber = 'P180110172447323' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '252044' WHERE ordernumber = 'P200110172451357' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '76805' WHERE ordernumber = 'P180110172608198' 2024-01-11 01:00:05 -- UPDATE `omo_order_list` SET userId = '76805' WHERE ordernumber = 'P180110172657731' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364108' WHERE ordernumber = 'P420110172809523' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364109' WHERE ordernumber = 'P200110172956724' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364110' WHERE ordernumber = 'P200110173135805' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '212202' WHERE ordernumber = 'P190110173412300' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364111' WHERE ordernumber = 'P200110173427663' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '212202' WHERE ordernumber = 'P190110173537376' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364112' WHERE ordernumber = 'P200110173550754' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '344127' WHERE ordernumber = 'P420110173550758' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '339173' WHERE ordernumber = 'P180110173554953' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '216322' WHERE ordernumber = 'P180110173653958' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '114734' WHERE ordernumber = 'P200110173726807' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364114' WHERE ordernumber = 'P200110173819655' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '311437' WHERE ordernumber = 'P200110173915646' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '299910' WHERE ordernumber = 'P200110174100993' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364117' WHERE ordernumber = 'P180110174123236' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '215253' WHERE ordernumber = 'P200110174127545' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '358831' WHERE ordernumber = 'P200110174442491' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '228228' WHERE ordernumber = 'P180110174621329' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364120' WHERE ordernumber = 'P180110174732786' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364121' WHERE ordernumber = 'P180110174820912' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '285557' WHERE ordernumber = 'P200110174920871' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364123' WHERE ordernumber = 'P180110175020546' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '221817' WHERE ordernumber = 'P200110175032627' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364125' WHERE ordernumber = 'P180110175114641' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364124' WHERE ordernumber = 'P420110175117130' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364127' WHERE ordernumber = 'P180110175208281' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '336640' WHERE ordernumber = 'P420110175420532' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '238530' WHERE ordernumber = 'P200110175536153' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364131' WHERE ordernumber = 'P200110180028925' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364132' WHERE ordernumber = 'P420110180135660' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364130' WHERE ordernumber = 'P420110180702717' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364135' WHERE ordernumber = 'P200110181036630' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '363935' WHERE ordernumber = 'P420110181047662' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364137' WHERE ordernumber = 'P200110181246432' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364139' WHERE ordernumber = 'P200110181814328' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364142' WHERE ordernumber = 'P200110182102253' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364145' WHERE ordernumber = 'P190110182325937' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '343932' WHERE ordernumber = 'P180110182329371' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '211888' WHERE ordernumber = 'P190110182501248' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '281264' WHERE ordernumber = 'P420110182549250' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364147' WHERE ordernumber = 'P200110182659456' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '111574' WHERE ordernumber = 'P190110182704709' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364149' WHERE ordernumber = 'P200110182813320' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '96191' WHERE ordernumber = 'P420110182942839' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '154875' WHERE ordernumber = 'P190110183122352' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364153' WHERE ordernumber = 'P420110183503347' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364157' WHERE ordernumber = 'P420110183706484' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '284399' WHERE ordernumber = 'P190110183755975' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364162' WHERE ordernumber = 'P190110184119906' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '284699' WHERE ordernumber = 'P190110184210528' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '361408' WHERE ordernumber = 'P420110184553209' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '361408' WHERE ordernumber = 'P420110184632433' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '128867' WHERE ordernumber = 'P200110184714654' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '349239' WHERE ordernumber = 'P190110184801362' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '283554' WHERE ordernumber = 'P420110185115308' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364167' WHERE ordernumber = 'P200110185125836' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '323094' WHERE ordernumber = 'P200110185636731' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '277849' WHERE ordernumber = 'P190110185726370' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364172' WHERE ordernumber = 'P200110190330723' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '104534' WHERE ordernumber = 'P190110190610371' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364176' WHERE ordernumber = 'P190110190754835' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364173' WHERE ordernumber = 'P200110190836189' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364173' WHERE ordernumber = 'P200110190904253' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '283609' WHERE ordernumber = 'P190110190909884' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364177' WHERE ordernumber = 'P420110190947475' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '62570' WHERE ordernumber = 'P200110191017991' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '81140' WHERE ordernumber = 'P190110191037856' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '313332' WHERE ordernumber = 'P200110191105551' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '232303' WHERE ordernumber = 'P190110191208174' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '232303' WHERE ordernumber = 'P190110191347673' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '247887' WHERE ordernumber = 'P190110191456908' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364181' WHERE ordernumber = 'P420110191508686' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '232303' WHERE ordernumber = 'P190110191633169' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '276792' WHERE ordernumber = 'P200110192656667' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '94254' WHERE ordernumber = 'P190110192734427' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '94254' WHERE ordernumber = 'P190110192835178' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '247854' WHERE ordernumber = 'P190110192929431' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '340908' WHERE ordernumber = 'P420110192931128' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364191' WHERE ordernumber = 'P420110193309887' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '106731' WHERE ordernumber = 'P420110193453744' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364192' WHERE ordernumber = 'P420110194056932' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364193' WHERE ordernumber = 'P190110194059513' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '222657' WHERE ordernumber = 'P200110194533272' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364192' WHERE ordernumber = 'P420110194540839' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '212273' WHERE ordernumber = 'P190110194703301' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364197' WHERE ordernumber = 'P200110194724625' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '251807' WHERE ordernumber = 'P190110194815402' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364200' WHERE ordernumber = 'P420110194827334' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364202' WHERE ordernumber = 'P190110195117429' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364203' WHERE ordernumber = 'P190110195503361' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '95870' WHERE ordernumber = 'P190110195642895' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364206' WHERE ordernumber = 'P200110195656474' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364208' WHERE ordernumber = 'P200110195839970' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364209' WHERE ordernumber = 'P190110195840332' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '115561' WHERE ordernumber = 'P190110195917692' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364212' WHERE ordernumber = 'P190110200219548' 2024-01-11 01:00:06 -- UPDATE `omo_order_list` SET userId = '364214' WHERE ordernumber = 'P190110200354313'