2024-09-28 01:00:02 -- 將會員中心id寫入data-lake 2024-09-28 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-09-27%'; 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '122195' WHERE ordernumber = 'P710927105910364' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423180' WHERE ordernumber = 'P190927110206314' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423182' WHERE ordernumber = 'P420927110255169' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423183' WHERE ordernumber = 'P190927110905636' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '237250' WHERE ordernumber = 'P200927110959396' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '237250' WHERE ordernumber = 'P200927111009748' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423184' WHERE ordernumber = 'P420927111156910' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '354202' WHERE ordernumber = 'P200927111244416' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423186' WHERE ordernumber = 'P420927111252502' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '354202' WHERE ordernumber = 'P200927111511832' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423185' WHERE ordernumber = 'P710927111533465' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '422468' WHERE ordernumber = 'P180927111554909' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423187' WHERE ordernumber = 'P420927111851268' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '207610' WHERE ordernumber = 'P190927112330122' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '338383' WHERE ordernumber = 'P180927112546649' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '308889' WHERE ordernumber = 'P190927112608986' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423189' WHERE ordernumber = 'P190927112729519' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '358656' WHERE ordernumber = 'P200927113339193' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '191268' WHERE ordernumber = 'P200927113717733' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '294872' WHERE ordernumber = 'P180927114654221' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '420075' WHERE ordernumber = 'P420927115606861' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423190' WHERE ordernumber = 'P420927115814307' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '98260' WHERE ordernumber = 'P180927120016621' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423191' WHERE ordernumber = 'P710927120107378' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '314798' WHERE ordernumber = 'P420927120220262' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423194' WHERE ordernumber = 'P200927120510704' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '314514' WHERE ordernumber = 'P180927120607394' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '376350' WHERE ordernumber = 'P180927120713391' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423195' WHERE ordernumber = 'P710927121938392' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423196' WHERE ordernumber = 'P420927121943170' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '82997' WHERE ordernumber = 'P180927122326315' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '106857' WHERE ordernumber = 'P420927122417331' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '271209' WHERE ordernumber = 'P420927122458299' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '305997' WHERE ordernumber = 'P420927123126164' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '170361' WHERE ordernumber = 'P180927123158767' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '257642' WHERE ordernumber = 'P180927123303531' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423198' WHERE ordernumber = 'P710927123534148' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423199' WHERE ordernumber = 'P710927123843755' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423200' WHERE ordernumber = 'P710927124347478' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '342730' WHERE ordernumber = 'P420927124433672' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '342730' WHERE ordernumber = 'P420927124537123' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423203' WHERE ordernumber = 'P200927124724972' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423204' WHERE ordernumber = 'P200927124910248' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '285414' WHERE ordernumber = 'P200927125101450' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '96065' WHERE ordernumber = 'P200927125403194' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '334388' WHERE ordernumber = 'P180927125406369' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423205' WHERE ordernumber = 'P710927125512763' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423206' WHERE ordernumber = 'P200927125754463' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '207104' WHERE ordernumber = 'P180927125838856' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '282648' WHERE ordernumber = 'P420927130235335' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '414034' WHERE ordernumber = 'P200927130256237' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423208' WHERE ordernumber = 'P710927130626854' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '422789' WHERE ordernumber = 'P180927130904523' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '273560' WHERE ordernumber = 'P200927131104625' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '422788' WHERE ordernumber = 'P200927131420140' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423209' WHERE ordernumber = 'P200927131517611' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423210' WHERE ordernumber = 'P200927131639420' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '92088' WHERE ordernumber = 'P420927131931957' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423212' WHERE ordernumber = 'P180927132327918' 2024-09-28 01:00:02 -- UPDATE `omo_order_list` SET userId = '423211' WHERE ordernumber = 'P200927132412156' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '318228' WHERE ordernumber = 'P180927132435344' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423213' WHERE ordernumber = 'P420927132453122' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423214' WHERE ordernumber = 'P200927132627156' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423215' WHERE ordernumber = 'P180927132701694' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423216' WHERE ordernumber = 'P200927132751593' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '312498' WHERE ordernumber = 'P180927132934872' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '213710' WHERE ordernumber = 'P730927133054902' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '396508' WHERE ordernumber = 'P180927133258794' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423222' WHERE ordernumber = 'P180927133537327' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423217' WHERE ordernumber = 'P180927133807440' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '278230' WHERE ordernumber = 'P590927134013606' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423220' WHERE ordernumber = 'P180927134136949' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423226' WHERE ordernumber = 'P200927134623275' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423227' WHERE ordernumber = 'P710927134830653' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '120333' WHERE ordernumber = 'P200927134921781' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423201' WHERE ordernumber = 'P710927135539159' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423229' WHERE ordernumber = 'P200927135703196' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423230' WHERE ordernumber = 'P420927135744456' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423232' WHERE ordernumber = 'P200927140516120' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423231' WHERE ordernumber = 'P710927140629714' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423233' WHERE ordernumber = 'P710927140914335' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '87593' WHERE ordernumber = 'P180927140934524' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '334578' WHERE ordernumber = 'P200927141022603' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '294471' WHERE ordernumber = 'P180927141024543' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '288454' WHERE ordernumber = 'P180927141127586' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423234' WHERE ordernumber = 'P180927141240116' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423235' WHERE ordernumber = 'P710927141521847' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423236' WHERE ordernumber = 'P730927141811407' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '402453' WHERE ordernumber = 'P200927142705654' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423238' WHERE ordernumber = 'P180927142737133' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423239' WHERE ordernumber = 'P180927143010331' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423240' WHERE ordernumber = 'P180927143139998' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '99845' WHERE ordernumber = 'P180927143333790' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423241' WHERE ordernumber = 'P710927143359562' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423242' WHERE ordernumber = 'P200927143444678' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423243' WHERE ordernumber = 'P180927143625489' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423242' WHERE ordernumber = 'P200927143655527' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423244' WHERE ordernumber = 'P730927143822719' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423245' WHERE ordernumber = 'P180927144217549' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423247' WHERE ordernumber = 'P420927144219546' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '370596' WHERE ordernumber = 'P200927144549915' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '421439' WHERE ordernumber = 'P420927144829604' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423248' WHERE ordernumber = 'P730927144856646' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423249' WHERE ordernumber = 'P200927145027802' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '286101' WHERE ordernumber = 'P180927145121382' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '365672' WHERE ordernumber = 'P420927145213191' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '294019' WHERE ordernumber = 'P420927145259800' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '422052' WHERE ordernumber = 'P180927145327871' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423250' WHERE ordernumber = 'P200927145519201' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423246' WHERE ordernumber = 'P180927145522951' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '230823' WHERE ordernumber = 'P180927145656697' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '422061' WHERE ordernumber = 'P730927145952743' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423251' WHERE ordernumber = 'P730927150216404' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423252' WHERE ordernumber = 'P200927150518836' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '368106' WHERE ordernumber = 'P420927150906361' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '237042' WHERE ordernumber = 'P200927151027900' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423254' WHERE ordernumber = 'P420927151412231' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '247064' WHERE ordernumber = 'P200927151419683' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '295025' WHERE ordernumber = 'P200927151554325' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423255' WHERE ordernumber = 'P710927151633723' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '343888' WHERE ordernumber = 'P180927152008489' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423256' WHERE ordernumber = 'P730927152118267' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423257' WHERE ordernumber = 'P180927152237915' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '279847' WHERE ordernumber = 'P200927152357545' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423259' WHERE ordernumber = 'P180927152525239' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423258' WHERE ordernumber = 'P200927152538208' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423260' WHERE ordernumber = 'P730927153245310' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '422265' WHERE ordernumber = 'P710927153349583' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423261' WHERE ordernumber = 'P420927153432290' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '86113' WHERE ordernumber = 'P180927153651139' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '403307' WHERE ordernumber = 'P420927154134621' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423263' WHERE ordernumber = 'P200927154223794' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423264' WHERE ordernumber = 'P180927154329465' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '345407' WHERE ordernumber = 'P200927154331650' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '38390' WHERE ordernumber = 'P180927155216281' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423266' WHERE ordernumber = 'P420927155241155' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '224596' WHERE ordernumber = 'P200927155808649' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423267' WHERE ordernumber = 'P200927160048178' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423268' WHERE ordernumber = 'P180927160129806' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423270' WHERE ordernumber = 'P180927160250282' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423271' WHERE ordernumber = 'P180927160444200' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '100104' WHERE ordernumber = 'P190927160520195' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423272' WHERE ordernumber = 'P180927160559895' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '287188' WHERE ordernumber = 'P180927160708822' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '344253' WHERE ordernumber = 'P180927160748305' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '315224' WHERE ordernumber = 'P180927161409612' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '295216' WHERE ordernumber = 'P200927161519242' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '228397' WHERE ordernumber = 'P180927162028137' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423273' WHERE ordernumber = 'P180927162208307' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423274' WHERE ordernumber = 'P200927162724689' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '281512' WHERE ordernumber = 'P190927162941616' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '134860' WHERE ordernumber = 'P180927163321510' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P180927163502988' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423276' WHERE ordernumber = 'P200927163709117' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '266600' WHERE ordernumber = 'P180927163923208' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '399288' WHERE ordernumber = 'P200927164001498' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '237107' WHERE ordernumber = 'P180927164713649' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '423277' WHERE ordernumber = 'P200927164744926' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '389162' WHERE ordernumber = 'P190927165413978' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '80774' WHERE ordernumber = 'P180927165810261' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '80774' WHERE ordernumber = 'P180927165958235' 2024-09-28 01:00:03 -- UPDATE `omo_order_list` SET userId = '80774' WHERE ordernumber = 'P180927170111210' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '343591' WHERE ordernumber = 'P180927170438681' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '217650' WHERE ordernumber = 'P190927170828854' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '415130' WHERE ordernumber = 'P630927171023688' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '421539' WHERE ordernumber = 'P630927171058308' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423281' WHERE ordernumber = 'P420927171300692' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '324722' WHERE ordernumber = 'P630927172001509' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '380303' WHERE ordernumber = 'P180927172523848' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '265340' WHERE ordernumber = 'P710927172631686' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423282' WHERE ordernumber = 'P180927173050637' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '421813' WHERE ordernumber = 'P180927173138775' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423283' WHERE ordernumber = 'P180927173450408' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '416907' WHERE ordernumber = 'P200927173501562' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '412762' WHERE ordernumber = 'P200927174124998' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '121648' WHERE ordernumber = 'P630927174226719' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '378768' WHERE ordernumber = 'P180927174353352' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '94437' WHERE ordernumber = 'P180927174822601' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423284' WHERE ordernumber = 'P730927175049766' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '138938' WHERE ordernumber = 'P180927175104251' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423286' WHERE ordernumber = 'P180927175311131' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '422721' WHERE ordernumber = 'P180927180018862' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423288' WHERE ordernumber = 'P420927180347810' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '99718' WHERE ordernumber = 'P200927180349222' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423289' WHERE ordernumber = 'P180927180456647' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '422888' WHERE ordernumber = 'P420927180716447' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '421591' WHERE ordernumber = 'P180927180817913' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423290' WHERE ordernumber = 'P730927180921523' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '322666' WHERE ordernumber = 'P180927181147756' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '412290' WHERE ordernumber = 'P420927181246411' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423291' WHERE ordernumber = 'P420927181414615' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423292' WHERE ordernumber = 'P200927181505643' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '309303' WHERE ordernumber = 'P180927181940882' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423293' WHERE ordernumber = 'P420927182047803' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '317600' WHERE ordernumber = 'P180927183049679' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '398036' WHERE ordernumber = 'P180927183219453' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '274811' WHERE ordernumber = 'P200927183253998' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '350391' WHERE ordernumber = 'P200927183329197' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423294' WHERE ordernumber = 'P710927183726993' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '223688' WHERE ordernumber = 'P180927183841769' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '348486' WHERE ordernumber = 'P200927184056751' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '105666' WHERE ordernumber = 'P180927184611528' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '406458' WHERE ordernumber = 'P200927184812929' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '290721' WHERE ordernumber = 'P200927184855481' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '280396' WHERE ordernumber = 'P200927185417114' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '309245' WHERE ordernumber = 'P200927185622563' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '116693' WHERE ordernumber = 'P190927190003891' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423295' WHERE ordernumber = 'P200927190020998' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423296' WHERE ordernumber = 'P730927190624451' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '326954' WHERE ordernumber = 'P200927190638241' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423297' WHERE ordernumber = 'P710927190835929' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '269795' WHERE ordernumber = 'P190927191029936' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423298' WHERE ordernumber = 'P200927191143683' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '422323' WHERE ordernumber = 'P190927191413972' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423300' WHERE ordernumber = 'P710927192413343' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '376070' WHERE ordernumber = 'P190927192448851' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423301' WHERE ordernumber = 'P200927192521538' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423304' WHERE ordernumber = 'P200927193813119' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '94717' WHERE ordernumber = 'P200927194130238' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '311284' WHERE ordernumber = 'P200927195701114' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '218050' WHERE ordernumber = 'P190927195935679' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423306' WHERE ordernumber = 'P710927200450246' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423307' WHERE ordernumber = 'P710927201845389' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '421897' WHERE ordernumber = 'P710927202120930' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423309' WHERE ordernumber = 'P710927203133595' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '124279' WHERE ordernumber = 'P710927203545578' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423312' WHERE ordernumber = 'P710927211006481' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423313' WHERE ordernumber = 'P710927211241851' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423314' WHERE ordernumber = 'P710927212633904' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '423320' WHERE ordernumber = 'P710927221147139' 2024-09-28 01:00:04 -- UPDATE `omo_order_list` SET userId = '233343' WHERE ordernumber = 'P710927221344180'