2024-09-27 01:00:02 -- 將會員中心id寫入data-lake 2024-09-27 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-26%'; 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422956' WHERE ordernumber = 'P420926110220920' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '238986' WHERE ordernumber = 'P180926110254221' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '238986' WHERE ordernumber = 'P180926110405343' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422958' WHERE ordernumber = 'P190926110738937' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422959' WHERE ordernumber = 'P190926110859254' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '377713' WHERE ordernumber = 'P180926111009640' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '377713' WHERE ordernumber = 'P180926111050876' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '405142' WHERE ordernumber = 'P420926111213689' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '365633' WHERE ordernumber = 'P420926111300637' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422960' WHERE ordernumber = 'P180926111531856' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '315690' WHERE ordernumber = 'P200926111708127' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '312010' WHERE ordernumber = 'P180926111758737' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422961' WHERE ordernumber = 'P420926111807963' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '389740' WHERE ordernumber = 'P420926111944951' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422963' WHERE ordernumber = 'P180926112042739' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422961' WHERE ordernumber = 'P420926112049642' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '413290' WHERE ordernumber = 'P180926112241618' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '390816' WHERE ordernumber = 'P630926112331311' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422964' WHERE ordernumber = 'P200926112453480' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '216274' WHERE ordernumber = 'P180926112515378' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '422965' WHERE ordernumber = 'P200926112607474' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '236613' WHERE ordernumber = 'P180926112610193' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '360048' WHERE ordernumber = 'P180926113516224' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '404047' WHERE ordernumber = 'P180926113754935' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '404015' WHERE ordernumber = 'P200926113835952' 2024-09-27 01:00:02 -- UPDATE `omo_order_list` SET userId = '69642' WHERE ordernumber = 'P180926113932991' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422967' WHERE ordernumber = 'P710926113933871' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422968' WHERE ordernumber = 'P730926113932547' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '69642' WHERE ordernumber = 'P190926114208553' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422969' WHERE ordernumber = 'P180926114544432' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '161064' WHERE ordernumber = 'P180926114747652' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422970' WHERE ordernumber = 'P730926114945290' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '416764' WHERE ordernumber = 'P420926115206238' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422975' WHERE ordernumber = 'P200926115729248' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422976' WHERE ordernumber = 'P200926115944816' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422972' WHERE ordernumber = 'P710926115959603' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422978' WHERE ordernumber = 'P180926120127482' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422980' WHERE ordernumber = 'P200926120255197' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422981' WHERE ordernumber = 'P420926120322771' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422982' WHERE ordernumber = 'P180926120329969' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422983' WHERE ordernumber = 'P420926120436177' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422984' WHERE ordernumber = 'P180926120602799' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422977' WHERE ordernumber = 'P180926120647437' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422979' WHERE ordernumber = 'P180926120730152' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '113793' WHERE ordernumber = 'P190926120749772' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422985' WHERE ordernumber = 'P200926120900660' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '232257' WHERE ordernumber = 'P200926121254866' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422986' WHERE ordernumber = 'P710926121432948' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '420990' WHERE ordernumber = 'P420926121437812' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '279802' WHERE ordernumber = 'P200926121628431' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '405313' WHERE ordernumber = 'P200926121714368' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '256505' WHERE ordernumber = 'P180926122141338' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '256505' WHERE ordernumber = 'P180926122156482' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422988' WHERE ordernumber = 'P710926122327139' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '397967' WHERE ordernumber = 'P180926122335267' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '348065' WHERE ordernumber = 'P420926122949173' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422990' WHERE ordernumber = 'P180926123253166' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422989' WHERE ordernumber = 'P710926123320600' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '326727' WHERE ordernumber = 'P420926123508350' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '121404' WHERE ordernumber = 'P200926123535333' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422987' WHERE ordernumber = 'P420926123658959' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422991' WHERE ordernumber = 'P180926123803820' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422992' WHERE ordernumber = 'P420926123927535' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '338991' WHERE ordernumber = 'P180926124022821' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '74576' WHERE ordernumber = 'P200926124507362' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422993' WHERE ordernumber = 'P730926124535890' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422994' WHERE ordernumber = 'P420926124551292' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422995' WHERE ordernumber = 'P420926124738352' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '349879' WHERE ordernumber = 'P200926124826550' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422997' WHERE ordernumber = 'P420926124931953' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422999' WHERE ordernumber = 'P180926125032716' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '287450' WHERE ordernumber = 'P180926125140969' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '287450' WHERE ordernumber = 'P180926125157713' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '356480' WHERE ordernumber = 'P420926125206396' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '257880' WHERE ordernumber = 'P200926125257715' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423000' WHERE ordernumber = 'P180926125420188' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422998' WHERE ordernumber = 'P730926125522505' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423001' WHERE ordernumber = 'P710926125824660' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423002' WHERE ordernumber = 'P200926125850262' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '421072' WHERE ordernumber = 'P180926125935437' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423004' WHERE ordernumber = 'P180926130603124' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180926130703135' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423006' WHERE ordernumber = 'P420926130713565' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423007' WHERE ordernumber = 'P200926130825749' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '344831' WHERE ordernumber = 'P180926130915641' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '120333' WHERE ordernumber = 'P200926130935486' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423005' WHERE ordernumber = 'P710926131120132' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423009' WHERE ordernumber = 'P180926131203746' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '120333' WHERE ordernumber = 'P200926131206827' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '330740' WHERE ordernumber = 'P180926131337849' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '346750' WHERE ordernumber = 'P200926131352558' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '406092' WHERE ordernumber = 'P180926131804144' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '354707' WHERE ordernumber = 'P420926131852601' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423010' WHERE ordernumber = 'P180926131916152' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423011' WHERE ordernumber = 'P180926132013618' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423013' WHERE ordernumber = 'P200926132303164' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423012' WHERE ordernumber = 'P180926132433361' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '308887' WHERE ordernumber = 'P200926132443248' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423014' WHERE ordernumber = 'P420926132605603' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '100823' WHERE ordernumber = 'P200926132657441' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '415286' WHERE ordernumber = 'P180926132704370' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423016' WHERE ordernumber = 'P180926132831703' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '97739' WHERE ordernumber = 'P180926132923508' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423015' WHERE ordernumber = 'P710926133009969' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423017' WHERE ordernumber = 'P200926133025472' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423018' WHERE ordernumber = 'P200926133232843' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '398370' WHERE ordernumber = 'P420926133307659' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '399646' WHERE ordernumber = 'P180926133616229' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '276447' WHERE ordernumber = 'P180926133920759' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '277727' WHERE ordernumber = 'P200926133936368' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P180926134021577' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423021' WHERE ordernumber = 'P180926134147950' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423020' WHERE ordernumber = 'P200926134229368' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '423019' WHERE ordernumber = 'P730926134306311' 2024-09-27 01:00:03 -- UPDATE `omo_order_list` SET userId = '422892' WHERE ordernumber = 'P180926134326728' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '25' WHERE ordernumber = 'P180926134506391' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '313265' WHERE ordernumber = 'P710926134908179' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423023' WHERE ordernumber = 'P180926134917335' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423024' WHERE ordernumber = 'P730926134943486' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '121845' WHERE ordernumber = 'P180926135404364' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '236725' WHERE ordernumber = 'P200926135435837' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '402528' WHERE ordernumber = 'P420926135512926' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '349574' WHERE ordernumber = 'P180926135640875' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '422203' WHERE ordernumber = 'P710926135653283' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '393875' WHERE ordernumber = 'P200926135750932' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423025' WHERE ordernumber = 'P730926140024642' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '248366' WHERE ordernumber = 'P200926140335229' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423029' WHERE ordernumber = 'P420926140735277' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '364203' WHERE ordernumber = 'P180926141056379' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423030' WHERE ordernumber = 'P200926141226498' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '164584' WHERE ordernumber = 'P420926141507339' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '66860' WHERE ordernumber = 'P180926142321347' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423031' WHERE ordernumber = 'P200926142557663' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '353938' WHERE ordernumber = 'P420926142809856' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '353938' WHERE ordernumber = 'P420926143002538' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423033' WHERE ordernumber = 'P180926143051654' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423032' WHERE ordernumber = 'P180926143140573' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '295205' WHERE ordernumber = 'P200926143157429' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423035' WHERE ordernumber = 'P200926143713316' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423037' WHERE ordernumber = 'P420926143853711' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423038' WHERE ordernumber = 'P180926143854630' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '351456' WHERE ordernumber = 'P710926143911344' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423036' WHERE ordernumber = 'P420926143931124' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423040' WHERE ordernumber = 'P710926144132502' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423039' WHERE ordernumber = 'P730926144149586' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423041' WHERE ordernumber = 'P180926144246805' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423042' WHERE ordernumber = 'P730926144546640' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '130531' WHERE ordernumber = 'P180926144715505' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '283649' WHERE ordernumber = 'P630926144827987' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423044' WHERE ordernumber = 'P420926144939678' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423043' WHERE ordernumber = 'P710926145011998' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '420214' WHERE ordernumber = 'P420926145027849' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423047' WHERE ordernumber = 'P180926145548218' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '228801' WHERE ordernumber = 'P180926145628261' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423048' WHERE ordernumber = 'P180926145756162' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423046' WHERE ordernumber = 'P420926145818186' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '402399' WHERE ordernumber = 'P630926145914159' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423049' WHERE ordernumber = 'P420926145918157' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '422204' WHERE ordernumber = 'P710926145919599' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423050' WHERE ordernumber = 'P180926145944427' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423051' WHERE ordernumber = 'P180926150057886' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423052' WHERE ordernumber = 'P180926150227926' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '27427' WHERE ordernumber = 'P710926150316432' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '234335' WHERE ordernumber = 'P200926150403565' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '419016' WHERE ordernumber = 'P420926150617431' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423055' WHERE ordernumber = 'P710926151121389' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423058' WHERE ordernumber = 'P200926151325962' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423053' WHERE ordernumber = 'P200926151453142' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '222060' WHERE ordernumber = 'P200926151541390' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '98741' WHERE ordernumber = 'P200926151643525' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '148024' WHERE ordernumber = 'P180926151730555' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '127593' WHERE ordernumber = 'P200926151848148' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423063' WHERE ordernumber = 'P180926152130244' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '359064' WHERE ordernumber = 'P200926152213853' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423062' WHERE ordernumber = 'P710926152445433' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423064' WHERE ordernumber = 'P200926152448942' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '100813' WHERE ordernumber = 'P200926152609817' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '386637' WHERE ordernumber = 'P180926152737701' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423063' WHERE ordernumber = 'P180926152828765' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '412163' WHERE ordernumber = 'P180926152959859' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '331478' WHERE ordernumber = 'P180926153915550' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '233874' WHERE ordernumber = 'P420926154304558' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '132682' WHERE ordernumber = 'P180926154409458' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423067' WHERE ordernumber = 'P710926154752892' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423068' WHERE ordernumber = 'P420926154849665' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423069' WHERE ordernumber = 'P710926155131882' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423070' WHERE ordernumber = 'P180926155242494' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '217067' WHERE ordernumber = 'P180926155601383' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423071' WHERE ordernumber = 'P710926155715564' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '422214' WHERE ordernumber = 'P180926155811901' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '229774' WHERE ordernumber = 'P200926155858464' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423074' WHERE ordernumber = 'P180926160337842' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423075' WHERE ordernumber = 'P200926160840612' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '121498' WHERE ordernumber = 'P200926161011763' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423076' WHERE ordernumber = 'P200926161102133' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '313559' WHERE ordernumber = 'P180926161155321' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '102656' WHERE ordernumber = 'P180926161243804' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423080' WHERE ordernumber = 'P180926161908752' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '403120' WHERE ordernumber = 'P420926161921145' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423081' WHERE ordernumber = 'P200926162151581' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '391561' WHERE ordernumber = 'P180926162438714' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423082' WHERE ordernumber = 'P200926162633831' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423083' WHERE ordernumber = 'P180926162646338' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '384979' WHERE ordernumber = 'P200926162755619' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '423078' WHERE ordernumber = 'P710926162822177' 2024-09-27 01:00:04 -- UPDATE `omo_order_list` SET userId = '142615' WHERE ordernumber = 'P200926162915613' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '107391' WHERE ordernumber = 'P180926163037185' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '272022' WHERE ordernumber = 'P200926163114800' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423084' WHERE ordernumber = 'P710926163204903' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '158636' WHERE ordernumber = 'P180926163211397' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '114279' WHERE ordernumber = 'P200926163408292' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '310339' WHERE ordernumber = 'P200926163730225' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423085' WHERE ordernumber = 'P180926163752571' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '296922' WHERE ordernumber = 'P420926163831252' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423087' WHERE ordernumber = 'P420926163934118' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '348622' WHERE ordernumber = 'P180926163958418' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '422727' WHERE ordernumber = 'P200926164055571' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '391255' WHERE ordernumber = 'P200926164142686' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '393063' WHERE ordernumber = 'P200926164255949' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423089' WHERE ordernumber = 'P200926164354808' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423090' WHERE ordernumber = 'P180926164403612' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '375577' WHERE ordernumber = 'P180926164506711' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '249384' WHERE ordernumber = 'P180926164600553' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423086' WHERE ordernumber = 'P730926164650942' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423093' WHERE ordernumber = 'P180926164741368' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423094' WHERE ordernumber = 'P200926164803207' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423091' WHERE ordernumber = 'P710926164818821' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423092' WHERE ordernumber = 'P710926165005450' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423093' WHERE ordernumber = 'P190926165033789' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423097' WHERE ordernumber = 'P180926165328894' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423098' WHERE ordernumber = 'P180926165543637' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '401701' WHERE ordernumber = 'P420926165659262' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '378553' WHERE ordernumber = 'P730926165712651' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423099' WHERE ordernumber = 'P180926165814330' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423100' WHERE ordernumber = 'P180926170105370' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '401701' WHERE ordernumber = 'P420926170115900' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '97739' WHERE ordernumber = 'P180926170318155' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '381512' WHERE ordernumber = 'P180926170530557' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '400868' WHERE ordernumber = 'P200926170639849' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423097' WHERE ordernumber = 'P180926170706309' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423101' WHERE ordernumber = 'P730926171006365' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '212476' WHERE ordernumber = 'P180926171153348' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423102' WHERE ordernumber = 'P200926171337451' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423103' WHERE ordernumber = 'P180926171505173' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '262498' WHERE ordernumber = 'P180926171610459' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '422226' WHERE ordernumber = 'P420926172011863' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '422226' WHERE ordernumber = 'P420926172041191' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '287926' WHERE ordernumber = 'P200926172101307' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '237107' WHERE ordernumber = 'P180926172132276' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423104' WHERE ordernumber = 'P180926172259345' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423105' WHERE ordernumber = 'P420926172359501' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423107' WHERE ordernumber = 'P180926172447654' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423106' WHERE ordernumber = 'P200926172454435' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '80996' WHERE ordernumber = 'P180926172536458' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423108' WHERE ordernumber = 'P420926172538227' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423110' WHERE ordernumber = 'P180926173625481' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '405970' WHERE ordernumber = 'P180926173936859' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423111' WHERE ordernumber = 'P420926174024284' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '339771' WHERE ordernumber = 'P180926174550889' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '273196' WHERE ordernumber = 'P200926174714438' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423112' WHERE ordernumber = 'P710926174723419' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423113' WHERE ordernumber = 'P180926174836863' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423114' WHERE ordernumber = 'P180926174931191' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '76607' WHERE ordernumber = 'P180926175157872' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423115' WHERE ordernumber = 'P710926175319288' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423117' WHERE ordernumber = 'P180926175354859' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423120' WHERE ordernumber = 'P180926175848820' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423119' WHERE ordernumber = 'P200926175852555' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423121' WHERE ordernumber = 'P180926180059561' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '409220' WHERE ordernumber = 'P200926180119272' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '309074' WHERE ordernumber = 'P180926180136583' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423122' WHERE ordernumber = 'P180926180403857' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '229471' WHERE ordernumber = 'P200926180522764' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '229471' WHERE ordernumber = 'P200926180633748' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '313973' WHERE ordernumber = 'P190926180754237' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423123' WHERE ordernumber = 'P710926181142255' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423125' WHERE ordernumber = 'P420926181548181' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423124' WHERE ordernumber = 'P200926181551306' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423126' WHERE ordernumber = 'P200926181834382' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423128' WHERE ordernumber = 'P190926181944440' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '302233' WHERE ordernumber = 'P420926182108573' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423127' WHERE ordernumber = 'P710926182139649' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '258964' WHERE ordernumber = 'P200926182420191' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '212442' WHERE ordernumber = 'P190926182508357' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '389397' WHERE ordernumber = 'P190926182616703' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423129' WHERE ordernumber = 'P200926182648917' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '310479' WHERE ordernumber = 'P190926182831519' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423130' WHERE ordernumber = 'P710926182914399' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '385765' WHERE ordernumber = 'P630926183106471' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '347055' WHERE ordernumber = 'P190926183437839' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423132' WHERE ordernumber = 'P190926183508220' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423131' WHERE ordernumber = 'P710926183628784' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423133' WHERE ordernumber = 'P710926184005351' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423134' WHERE ordernumber = 'P200926185008763' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '100514' WHERE ordernumber = 'P190926185133351' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423135' WHERE ordernumber = 'P190926185342169' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '404494' WHERE ordernumber = 'P200926185718281' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423136' WHERE ordernumber = 'P190926185732348' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '302708' WHERE ordernumber = 'P190926190254679' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '421068' WHERE ordernumber = 'P190926190528355' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423137' WHERE ordernumber = 'P200926190745826' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '201938' WHERE ordernumber = 'P710926190848290' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423138' WHERE ordernumber = 'P200926190908120' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '423139' WHERE ordernumber = 'P190926190927528' 2024-09-27 01:00:05 -- UPDATE `omo_order_list` SET userId = '245954' WHERE ordernumber = 'P190926191343144' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423142' WHERE ordernumber = 'P190926191630447' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423142' WHERE ordernumber = 'P190926191711628' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '422748' WHERE ordernumber = 'P190926191924579' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423143' WHERE ordernumber = 'P730926191934837' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423144' WHERE ordernumber = 'P190926192127951' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423145' WHERE ordernumber = 'P200926192232763' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423146' WHERE ordernumber = 'P190926192258473' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423147' WHERE ordernumber = 'P190926192400226' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '404367' WHERE ordernumber = 'P190926192552605' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423148' WHERE ordernumber = 'P200926192722591' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '82588' WHERE ordernumber = 'P200926192836678' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423149' WHERE ordernumber = 'P710926192911746' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423150' WHERE ordernumber = 'P190926192912686' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '206906' WHERE ordernumber = 'P190926193329756' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '234843' WHERE ordernumber = 'P190926193645358' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423151' WHERE ordernumber = 'P730926194244401' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '82850' WHERE ordernumber = 'P730926194735311' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '337495' WHERE ordernumber = 'P710926195112810' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423152' WHERE ordernumber = 'P200926195435970' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423153' WHERE ordernumber = 'P730926195807532' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '113518' WHERE ordernumber = 'P200926195909938' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423154' WHERE ordernumber = 'P200926200027385' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423155' WHERE ordernumber = 'P710926201024243' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423156' WHERE ordernumber = 'P710926202553753' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '204335' WHERE ordernumber = 'P730926202558561' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423158' WHERE ordernumber = 'P710926204125705' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423157' WHERE ordernumber = 'P730926204245187' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423159' WHERE ordernumber = 'P710926205604259' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '130358' WHERE ordernumber = 'P710926210412600' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423160' WHERE ordernumber = 'P710926210828690' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '132299' WHERE ordernumber = 'P710926211238589' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423161' WHERE ordernumber = 'P710926211519405' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423162' WHERE ordernumber = 'P710926212111138' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '423163' WHERE ordernumber = 'P730926213113526' 2024-09-27 01:00:06 -- UPDATE `omo_order_list` SET userId = '377485' WHERE ordernumber = 'P710926214408906'