2024-01-19 01:00:02 -- 將會員中心id寫入data-lake 2024-01-19 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-01-18%'; 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '294738' WHERE ordernumber = 'P420118110308207' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368550' WHERE ordernumber = 'P190118110420708' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368547' WHERE ordernumber = 'P190118110505922' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '162040' WHERE ordernumber = 'P420118110546529' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '365107' WHERE ordernumber = 'P200118110656901' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '359054' WHERE ordernumber = 'P420118110704718' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '16214' WHERE ordernumber = 'P420118110811646' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368555' WHERE ordernumber = 'P200118110901404' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '260405' WHERE ordernumber = 'P200118110951381' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '138942' WHERE ordernumber = 'P200118111053317' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '358006' WHERE ordernumber = 'P190118111140348' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368556' WHERE ordernumber = 'P430118111255858' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '266737' WHERE ordernumber = 'P200118111351658' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368559' WHERE ordernumber = 'P190118111417435' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '235055' WHERE ordernumber = 'P200118111526739' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368560' WHERE ordernumber = 'P420118111533230' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '231706' WHERE ordernumber = 'P190118111554888' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '201492' WHERE ordernumber = 'P200118111640553' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '248233' WHERE ordernumber = 'P190118111741713' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '240942' WHERE ordernumber = 'P200118111752754' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368561' WHERE ordernumber = 'P420118111837439' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368564' WHERE ordernumber = 'P200118111951712' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368565' WHERE ordernumber = 'P190118112002614' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '367468' WHERE ordernumber = 'P180118112047113' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '367468' WHERE ordernumber = 'P180118112051954' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '3830' WHERE ordernumber = 'P190118112206316' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368569' WHERE ordernumber = 'P200118112254307' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368571' WHERE ordernumber = 'P420118112347720' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '317251' WHERE ordernumber = 'P200118112418383' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '279560' WHERE ordernumber = 'P190118112434976' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '249481' WHERE ordernumber = 'P420118112442871' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '220159' WHERE ordernumber = 'P190118112605577' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '246001' WHERE ordernumber = 'P200118112635748' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '220159' WHERE ordernumber = 'P190118112640527' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '55471' WHERE ordernumber = 'P200118112719803' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '300801' WHERE ordernumber = 'P420118112749600' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '300801' WHERE ordernumber = 'P420118112837287' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '342830' WHERE ordernumber = 'P420118113057149' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '278592' WHERE ordernumber = 'P200118113154998' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '312950' WHERE ordernumber = 'P180118113211529' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368574' WHERE ordernumber = 'P420118113236703' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '276041' WHERE ordernumber = 'P420118113325123' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368577' WHERE ordernumber = 'P190118113408137' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '343783' WHERE ordernumber = 'P190118113632330' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '366462' WHERE ordernumber = 'P200118113734521' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368579' WHERE ordernumber = 'P190118114045418' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '268464' WHERE ordernumber = 'P200118114110902' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '247184' WHERE ordernumber = 'P180118114207874' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '130241' WHERE ordernumber = 'P190118114240903' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '99933' WHERE ordernumber = 'P200118114243687' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '239481' WHERE ordernumber = 'P180118114436997' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '266373' WHERE ordernumber = 'P200118114456614' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368583' WHERE ordernumber = 'P190118114457608' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368584' WHERE ordernumber = 'P190118114558694' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '268464' WHERE ordernumber = 'P200118114653153' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368585' WHERE ordernumber = 'P200118114730131' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '288246' WHERE ordernumber = 'P190118114751313' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '364642' WHERE ordernumber = 'P180118114912817' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368587' WHERE ordernumber = 'P190118114932847' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '244432' WHERE ordernumber = 'P200118115017879' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '330124' WHERE ordernumber = 'P180118115055691' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '321100' WHERE ordernumber = 'P190118115114846' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368588' WHERE ordernumber = 'P200118115320992' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368584' WHERE ordernumber = 'P180118115406690' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368584' WHERE ordernumber = 'P180118115432340' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180118115512222' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368232' WHERE ordernumber = 'P200118120124944' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '327842' WHERE ordernumber = 'P180118120130876' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368589' WHERE ordernumber = 'P420118120205426' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '296947' WHERE ordernumber = 'P420118120453995' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368590' WHERE ordernumber = 'P200118120655531' 2024-01-19 01:00:03 -- UPDATE `omo_order_list` SET userId = '368592' WHERE ordernumber = 'P180118120721990' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '168033' WHERE ordernumber = 'P200118120912729' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368594' WHERE ordernumber = 'P200118121048790' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '129005' WHERE ordernumber = 'P420118121048394' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '358654' WHERE ordernumber = 'P180118121057279' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '275482' WHERE ordernumber = 'P180118121217759' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '243227' WHERE ordernumber = 'P200118121329602' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '232257' WHERE ordernumber = 'P200118121400222' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368596' WHERE ordernumber = 'P420118121446971' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368597' WHERE ordernumber = 'P200118121514963' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '243227' WHERE ordernumber = 'P200118121553610' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368598' WHERE ordernumber = 'P180118121621969' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '261718' WHERE ordernumber = 'P200118122044425' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368602' WHERE ordernumber = 'P420118122129396' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '137475' WHERE ordernumber = 'P200118122213574' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '348046' WHERE ordernumber = 'P180118122331657' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '67607' WHERE ordernumber = 'P420118122349502' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '67607' WHERE ordernumber = 'P420118122434221' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '345520' WHERE ordernumber = 'P180118122632965' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '245523' WHERE ordernumber = 'P200118122634770' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '125988' WHERE ordernumber = 'P180118122709776' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368608' WHERE ordernumber = 'P200118122823312' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '324099' WHERE ordernumber = 'P420118122825479' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '238945' WHERE ordernumber = 'P420118122923256' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '276271' WHERE ordernumber = 'P200118122927233' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368609' WHERE ordernumber = 'P180118123003484' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '191305' WHERE ordernumber = 'P200118123054441' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '234358' WHERE ordernumber = 'P190118123233785' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '266751' WHERE ordernumber = 'P180118123241969' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368611' WHERE ordernumber = 'P420118123258832' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368612' WHERE ordernumber = 'P420118123406510' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368613' WHERE ordernumber = 'P200118123413986' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368614' WHERE ordernumber = 'P180118123443327' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368615' WHERE ordernumber = 'P180118123544581' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '299656' WHERE ordernumber = 'P420118123730271' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '251046' WHERE ordernumber = 'P180118124030496' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '290010' WHERE ordernumber = 'P180118124221884' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368618' WHERE ordernumber = 'P420118124357586' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '300769' WHERE ordernumber = 'P420118124525485' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '220338' WHERE ordernumber = 'P180118124544259' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '290010' WHERE ordernumber = 'P190118124633695' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '279592' WHERE ordernumber = 'P200118124730550' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '133133' WHERE ordernumber = 'P190118124732276' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '344546' WHERE ordernumber = 'P420118124749428' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '226753' WHERE ordernumber = 'P180118124801271' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368620' WHERE ordernumber = 'P200118124852638' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '84800' WHERE ordernumber = 'P190118124915261' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '84800' WHERE ordernumber = 'P190118124957556' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368622' WHERE ordernumber = 'P420118125017366' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368623' WHERE ordernumber = 'P200118125050639' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '236921' WHERE ordernumber = 'P200118125135982' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368624' WHERE ordernumber = 'P190118125137412' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368625' WHERE ordernumber = 'P200118125242959' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '84668' WHERE ordernumber = 'P180118125309607' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368628' WHERE ordernumber = 'P190118125433170' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368630' WHERE ordernumber = 'P200118125512351' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '365565' WHERE ordernumber = 'P180118125514406' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '356216' WHERE ordernumber = 'P190118125744409' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368634' WHERE ordernumber = 'P180118125800364' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368627' WHERE ordernumber = 'P200118125824572' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368627' WHERE ordernumber = 'P200118125916393' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '275535' WHERE ordernumber = 'P200118130005993' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '296904' WHERE ordernumber = 'P420118130116644' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '258944' WHERE ordernumber = 'P180118130152263' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '296904' WHERE ordernumber = 'P420118130256143' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368636' WHERE ordernumber = 'P200118130307444' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '367180' WHERE ordernumber = 'P420118130721673' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368641' WHERE ordernumber = 'P200118130932269' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '124577' WHERE ordernumber = 'P200118131049191' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368643' WHERE ordernumber = 'P180118131140842' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '356216' WHERE ordernumber = 'P190118131323415' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368645' WHERE ordernumber = 'P200118131324399' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '359022' WHERE ordernumber = 'P180118131424984' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '104699' WHERE ordernumber = 'P190118131537198' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '94648' WHERE ordernumber = 'P200118131607546' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '362314' WHERE ordernumber = 'P180118131639971' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '311190' WHERE ordernumber = 'P190118131825250' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '170343' WHERE ordernumber = 'P420118131835821' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '294908' WHERE ordernumber = 'P190118131937912' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '349895' WHERE ordernumber = 'P200118132110906' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '289319' WHERE ordernumber = 'P420118132204758' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368654' WHERE ordernumber = 'P190118132410281' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368655' WHERE ordernumber = 'P180118132452987' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368656' WHERE ordernumber = 'P190118132543654' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '107590' WHERE ordernumber = 'P180118132819211' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368659' WHERE ordernumber = 'P200118133059468' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368659' WHERE ordernumber = 'P200118133121111' 2024-01-19 01:00:04 -- UPDATE `omo_order_list` SET userId = '368660' WHERE ordernumber = 'P180118133145196' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '102118' WHERE ordernumber = 'P180118133305925' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368665' WHERE ordernumber = 'P180118133819767' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368666' WHERE ordernumber = 'P180118134105915' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368666' WHERE ordernumber = 'P180118134145344' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '145685' WHERE ordernumber = 'P200118134418529' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368670' WHERE ordernumber = 'P420118134425250' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368672' WHERE ordernumber = 'P420118134613161' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368671' WHERE ordernumber = 'P200118134628474' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '236420' WHERE ordernumber = 'P200118134811973' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368673' WHERE ordernumber = 'P180118134823285' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368674' WHERE ordernumber = 'P180118134928816' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '312373' WHERE ordernumber = 'P180118135037688' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368677' WHERE ordernumber = 'P200118135057621' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368678' WHERE ordernumber = 'P180118135242431' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '312373' WHERE ordernumber = 'P180118135353450' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368679' WHERE ordernumber = 'P200118135421149' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368682' WHERE ordernumber = 'P180118135521203' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368684' WHERE ordernumber = 'P420118135609242' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368685' WHERE ordernumber = 'P180118135732519' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368687' WHERE ordernumber = 'P420118135811517' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368688' WHERE ordernumber = 'P200118135839593' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368688' WHERE ordernumber = 'P200118140005514' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368691' WHERE ordernumber = 'P420118140243918' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368693' WHERE ordernumber = 'P180118140336159' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '292220' WHERE ordernumber = 'P200118140428940' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368695' WHERE ordernumber = 'P180118140448876' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368696' WHERE ordernumber = 'P420118140524406' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '253391' WHERE ordernumber = 'P180118140533242' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '266835' WHERE ordernumber = 'P420118140747340' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '343413' WHERE ordernumber = 'P200118140807707' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '342053' WHERE ordernumber = 'P420118140909656' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '284955' WHERE ordernumber = 'P180118140925383' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '353938' WHERE ordernumber = 'P420118141010389' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368699' WHERE ordernumber = 'P420118141127462' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '141462' WHERE ordernumber = 'P420118141234359' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '142266' WHERE ordernumber = 'P180118141333813' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368706' WHERE ordernumber = 'P420118141703903' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368696' WHERE ordernumber = 'P420118141758935' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '148666' WHERE ordernumber = 'P180118141804293' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368707' WHERE ordernumber = 'P190118141825508' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368708' WHERE ordernumber = 'P200118141912289' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368709' WHERE ordernumber = 'P420118141927823' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '362211' WHERE ordernumber = 'P180118141955543' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368710' WHERE ordernumber = 'P180118142232643' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368711' WHERE ordernumber = 'P200118142319463' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368712' WHERE ordernumber = 'P180118142332675' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '310632' WHERE ordernumber = 'P180118142404858' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '114985' WHERE ordernumber = 'P180118142501404' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368716' WHERE ordernumber = 'P420118142559615' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '290010' WHERE ordernumber = 'P180118142644547' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '129110' WHERE ordernumber = 'P180118142844297' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368691' WHERE ordernumber = 'P420118142902895' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368719' WHERE ordernumber = 'P190118142904525' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368188' WHERE ordernumber = 'P200118142942638' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '356522' WHERE ordernumber = 'P200118143051276' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '135637' WHERE ordernumber = 'P200118143204952' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368722' WHERE ordernumber = 'P180118143240965' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368725' WHERE ordernumber = 'P420118143332956' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '215349' WHERE ordernumber = 'P180118143437823' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368726' WHERE ordernumber = 'P420118143443324' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '310663' WHERE ordernumber = 'P190118143445799' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '271304' WHERE ordernumber = 'P180118143536688' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368727' WHERE ordernumber = 'P420118143548192' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '363267' WHERE ordernumber = 'P190118143656700' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368728' WHERE ordernumber = 'P420118143742805' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '347863' WHERE ordernumber = 'P180118143806201' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368730' WHERE ordernumber = 'P190118143820164' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368732' WHERE ordernumber = 'P420118143856667' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368735' WHERE ordernumber = 'P180118143927462' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '363955' WHERE ordernumber = 'P420118143949749' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '360728' WHERE ordernumber = 'P190118144219740' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '360728' WHERE ordernumber = 'P190118144243238' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '304679' WHERE ordernumber = 'P200118144305791' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '215349' WHERE ordernumber = 'P180118144441293' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368737' WHERE ordernumber = 'P190118144453437' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '350565' WHERE ordernumber = 'P190118144633438' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '208869' WHERE ordernumber = 'P180118144903349' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368738' WHERE ordernumber = 'P200118145018427' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '291564' WHERE ordernumber = 'P420118145056437' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '309225' WHERE ordernumber = 'P200118145130697' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368739' WHERE ordernumber = 'P180118145131832' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368745' WHERE ordernumber = 'P200118145833303' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '87091' WHERE ordernumber = 'P180118145849314' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '365258' WHERE ordernumber = 'P420118150200668' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368750' WHERE ordernumber = 'P180118150713309' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '142066' WHERE ordernumber = 'P180118151344468' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368762' WHERE ordernumber = 'P420118151604336' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368764' WHERE ordernumber = 'P420118151752445' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368760' WHERE ordernumber = 'P180118152301875' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '368757' WHERE ordernumber = 'P180118152354594' 2024-01-19 01:00:05 -- UPDATE `omo_order_list` SET userId = '248929' WHERE ordernumber = 'P200118152413447' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '367020' WHERE ordernumber = 'P200118152530759' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '263029' WHERE ordernumber = 'P180118152900309' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '352864' WHERE ordernumber = 'P420118153058502' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '115591' WHERE ordernumber = 'P200118153101543' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368767' WHERE ordernumber = 'P180118153109699' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '364314' WHERE ordernumber = 'P200118153413866' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '352520' WHERE ordernumber = 'P420118153504666' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368771' WHERE ordernumber = 'P200118153555873' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '351440' WHERE ordernumber = 'P180118153636701' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368773' WHERE ordernumber = 'P420118153748315' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '281598' WHERE ordernumber = 'P200118153821870' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '334525' WHERE ordernumber = 'P420118153911252' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '314154' WHERE ordernumber = 'P200118153944957' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '304726' WHERE ordernumber = 'P420118154152954' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368776' WHERE ordernumber = 'P420118154306791' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368777' WHERE ordernumber = 'P420118154404762' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '66538' WHERE ordernumber = 'P190118154601456' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '291939' WHERE ordernumber = 'P190118154733954' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '364605' WHERE ordernumber = 'P200118155046714' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '291643' WHERE ordernumber = 'P200118155221571' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '152944' WHERE ordernumber = 'P200118155329833' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '214006' WHERE ordernumber = 'P200118155439545' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368781' WHERE ordernumber = 'P180118155551938' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '291643' WHERE ordernumber = 'P200118155621561' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368779' WHERE ordernumber = 'P190118155659453' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '33352' WHERE ordernumber = 'P420118155749457' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '282101' WHERE ordernumber = 'P180118155811409' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '237044' WHERE ordernumber = 'P200118155812673' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368785' WHERE ordernumber = 'P200118155950151' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368786' WHERE ordernumber = 'P420118160020491' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '335265' WHERE ordernumber = 'P200118160143125' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '315998' WHERE ordernumber = 'P420118160303743' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '213201' WHERE ordernumber = 'P190118160412537' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368788' WHERE ordernumber = 'P180118160520715' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368747' WHERE ordernumber = 'P180118160823191' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '155222' WHERE ordernumber = 'P200118160824593' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '356054' WHERE ordernumber = 'P180118160859602' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368779' WHERE ordernumber = 'P180118161052694' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '230296' WHERE ordernumber = 'P180118161214798' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '68604' WHERE ordernumber = 'P420118161220432' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368792' WHERE ordernumber = 'P200118161341938' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368793' WHERE ordernumber = 'P200118161431408' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368794' WHERE ordernumber = 'P180118161545450' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368795' WHERE ordernumber = 'P200118161631290' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '334039' WHERE ordernumber = 'P180118161836111' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368798' WHERE ordernumber = 'P200118161932232' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '334039' WHERE ordernumber = 'P180118162025211' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '348932' WHERE ordernumber = 'P180118162118748' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '298942' WHERE ordernumber = 'P180118162248116' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368802' WHERE ordernumber = 'P200118162518950' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368755' WHERE ordernumber = 'P200118162728246' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368804' WHERE ordernumber = 'P420118162932791' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '268438' WHERE ordernumber = 'P200118163032732' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368806' WHERE ordernumber = 'P420118163058613' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368808' WHERE ordernumber = 'P420118163212537' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '89585' WHERE ordernumber = 'P200118163316455' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368810' WHERE ordernumber = 'P180118163355131' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368810' WHERE ordernumber = 'P180118163444850' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '170751' WHERE ordernumber = 'P420118163459766' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368620' WHERE ordernumber = 'P200118163659778' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368812' WHERE ordernumber = 'P180118163741154' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368811' WHERE ordernumber = 'P200118163747137' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '113696' WHERE ordernumber = 'P180118163836259' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '270574' WHERE ordernumber = 'P200118163842923' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '259457' WHERE ordernumber = 'P180118163907314' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368815' WHERE ordernumber = 'P180118164100892' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368816' WHERE ordernumber = 'P180118164153861' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '362468' WHERE ordernumber = 'P180118164341637' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '237076' WHERE ordernumber = 'P420118164511364' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '212202' WHERE ordernumber = 'P180118164554654' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368818' WHERE ordernumber = 'P420118164601428' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368821' WHERE ordernumber = 'P180118164717574' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '273582' WHERE ordernumber = 'P180118164757309' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '237368' WHERE ordernumber = 'P180118165044442' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '129139' WHERE ordernumber = 'P180118165132351' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '220614' WHERE ordernumber = 'P200118165342664' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '312252' WHERE ordernumber = 'P180118165416183' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '75090' WHERE ordernumber = 'P200118165446941' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '129011' WHERE ordernumber = 'P200118165607244' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368822' WHERE ordernumber = 'P200118165721806' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368161' WHERE ordernumber = 'P420118165805901' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '98626' WHERE ordernumber = 'P200118165939450' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '280528' WHERE ordernumber = 'P420118170138257' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '222035' WHERE ordernumber = 'P180118170155588' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '270147' WHERE ordernumber = 'P200118170203993' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '250283' WHERE ordernumber = 'P180118170303808' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368824' WHERE ordernumber = 'P200118170316277' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '368825' WHERE ordernumber = 'P200118170410332' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '364002' WHERE ordernumber = 'P200118171045249' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '277442' WHERE ordernumber = 'P200118171307474' 2024-01-19 01:00:06 -- UPDATE `omo_order_list` SET userId = '288589' WHERE ordernumber = 'P200118171433807' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '289440' WHERE ordernumber = 'P200118171719379' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '271866' WHERE ordernumber = 'P200118171848331' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '154081' WHERE ordernumber = 'P180118172427477' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '97994' WHERE ordernumber = 'P200118172640793' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '363806' WHERE ordernumber = 'P420118172819191' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '104293' WHERE ordernumber = 'P200118172826800' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '207972' WHERE ordernumber = 'P200118173009523' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '154081' WHERE ordernumber = 'P180118173029202' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '247410' WHERE ordernumber = 'P190118173043429' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '154081' WHERE ordernumber = 'P180118173141279' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368838' WHERE ordernumber = 'P420118173231360' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368545' WHERE ordernumber = 'P180118173343609' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '367731' WHERE ordernumber = 'P200118173644291' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368839' WHERE ordernumber = 'P420118173703751' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '164169' WHERE ordernumber = 'P200118173704759' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368841' WHERE ordernumber = 'P200118173815968' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368843' WHERE ordernumber = 'P200118173910459' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '267345' WHERE ordernumber = 'P180118173919990' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '217246' WHERE ordernumber = 'P420118173922664' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '367922' WHERE ordernumber = 'P200118174335728' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368692' WHERE ordernumber = 'P200118174338811' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368692' WHERE ordernumber = 'P200118174341485' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '367922' WHERE ordernumber = 'P200118174346558' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368844' WHERE ordernumber = 'P200118174544417' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368845' WHERE ordernumber = 'P420118174719166' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368846' WHERE ordernumber = 'P200118174738626' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '320241' WHERE ordernumber = 'P200118174852204' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368850' WHERE ordernumber = 'P180118174944148' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '347940' WHERE ordernumber = 'P420118175044210' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368854' WHERE ordernumber = 'P200118175123306' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368840' WHERE ordernumber = 'P180118175149453' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368850' WHERE ordernumber = 'P180118175350440' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '299530' WHERE ordernumber = 'P200118175623766' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '363039' WHERE ordernumber = 'P180118175734348' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '341040' WHERE ordernumber = 'P180118175911533' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '238771' WHERE ordernumber = 'P200118175954405' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '238771' WHERE ordernumber = 'P200118180051165' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '238771' WHERE ordernumber = 'P200118180126958' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368255' WHERE ordernumber = 'P180118180312311' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '336746' WHERE ordernumber = 'P200118180542719' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368859' WHERE ordernumber = 'P420118180606590' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368861' WHERE ordernumber = 'P420118180717637' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368862' WHERE ordernumber = 'P180118180834977' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '343453' WHERE ordernumber = 'P420118181310540' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '252901' WHERE ordernumber = 'P200118181625947' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '365229' WHERE ordernumber = 'P420118181632569' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368866' WHERE ordernumber = 'P420118181840899' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '252901' WHERE ordernumber = 'P200118181924720' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '306573' WHERE ordernumber = 'P200118182216265' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368870' WHERE ordernumber = 'P180118182329817' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '277598' WHERE ordernumber = 'P180118182448190' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '64180' WHERE ordernumber = 'P200118182529127' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '363859' WHERE ordernumber = 'P200118182559634' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '220798' WHERE ordernumber = 'P200118183105867' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368871' WHERE ordernumber = 'P180118183116968' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368872' WHERE ordernumber = 'P180118183324799' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '344170' WHERE ordernumber = 'P180118183801401' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '344170' WHERE ordernumber = 'P180118183836221' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '338506' WHERE ordernumber = 'P200118183839726' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '344170' WHERE ordernumber = 'P180118183854778' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '156328' WHERE ordernumber = 'P180118183950408' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '250455' WHERE ordernumber = 'P180118184254229' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368877' WHERE ordernumber = 'P200118184345840' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368878' WHERE ordernumber = 'P420118184501508' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368881' WHERE ordernumber = 'P190118184851573' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368882' WHERE ordernumber = 'P200118184856757' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368884' WHERE ordernumber = 'P190118185031548' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368886' WHERE ordernumber = 'P200118185359772' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368889' WHERE ordernumber = 'P190118185535631' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368886' WHERE ordernumber = 'P200118185631624' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '363858' WHERE ordernumber = 'P190118185736638' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '352173' WHERE ordernumber = 'P190118185930858' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368893' WHERE ordernumber = 'P200118190029394' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368896' WHERE ordernumber = 'P190118190222734' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '269946' WHERE ordernumber = 'P200118190342741' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '121270' WHERE ordernumber = 'P190118190458831' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368899' WHERE ordernumber = 'P200118190654237' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368901' WHERE ordernumber = 'P200118190808584' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '137782' WHERE ordernumber = 'P190118190824499' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '299885' WHERE ordernumber = 'P420118190850978' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '141777' WHERE ordernumber = 'P200118190909218' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '232303' WHERE ordernumber = 'P190118191108820' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '232303' WHERE ordernumber = 'P190118191143861' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '249362' WHERE ordernumber = 'P200118191319509' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '50816' WHERE ordernumber = 'P190118191417467' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '50816' WHERE ordernumber = 'P190118191527498' 2024-01-19 01:00:07 -- UPDATE `omo_order_list` SET userId = '368905' WHERE ordernumber = 'P200118191533604' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '282020' WHERE ordernumber = 'P190118191858892' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '130773' WHERE ordernumber = 'P190118192154125' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '76045' WHERE ordernumber = 'P420118192247520' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '138130' WHERE ordernumber = 'P420118192534124' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '182519' WHERE ordernumber = 'P190118192714688' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '76045' WHERE ordernumber = 'P420118192801390' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368910' WHERE ordernumber = 'P420118193008293' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368913' WHERE ordernumber = 'P420118193337154' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368914' WHERE ordernumber = 'P200118193450582' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368915' WHERE ordernumber = 'P420118193512772' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368917' WHERE ordernumber = 'P420118193726624' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368917' WHERE ordernumber = 'P420118194036560' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '207020' WHERE ordernumber = 'P190118194044463' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368919' WHERE ordernumber = 'P200118194053442' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368920' WHERE ordernumber = 'P190118194131913' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '290642' WHERE ordernumber = 'P200118194514590' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '82124' WHERE ordernumber = 'P190118194733492' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368923' WHERE ordernumber = 'P200118194921417' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '207020' WHERE ordernumber = 'P190118194931180' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '284627' WHERE ordernumber = 'P190118195042604' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368924' WHERE ordernumber = 'P190118195236924' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368925' WHERE ordernumber = 'P190118195348323' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368927' WHERE ordernumber = 'P420118195408177' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '128493' WHERE ordernumber = 'P420118195557390' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '233083' WHERE ordernumber = 'P190118195831247' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368932' WHERE ordernumber = 'P200118200031815' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '321347' WHERE ordernumber = 'P200118200208633' 2024-01-19 01:00:08 -- UPDATE `omo_order_list` SET userId = '368935' WHERE ordernumber = 'P190118200254403'