2024-02-09 01:00:02 -- 將會員中心id寫入data-lake 2024-02-09 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-02-08%'; 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '272744' WHERE ordernumber = 'P200208110130664' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '352784' WHERE ordernumber = 'P420208110139396' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '216949' WHERE ordernumber = 'P420208110211283' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '376535' WHERE ordernumber = 'P190208110235604' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '376533' WHERE ordernumber = 'P200208110241142' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '376537' WHERE ordernumber = 'P180208110303165' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '285985' WHERE ordernumber = 'P190208110413493' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '359797' WHERE ordernumber = 'P190208110554948' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '85714' WHERE ordernumber = 'P180208110600255' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '352970' WHERE ordernumber = 'P200208110827359' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '352970' WHERE ordernumber = 'P200208110926384' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '220138' WHERE ordernumber = 'P190208110933279' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '376539' WHERE ordernumber = 'P180208110935541' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '376536' WHERE ordernumber = 'P190208111036455' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '376549' WHERE ordernumber = 'P190208111143859' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '119196' WHERE ordernumber = 'P200208111159772' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '93631' WHERE ordernumber = 'P180208111211858' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '344155' WHERE ordernumber = 'P190208111257730' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '376452' WHERE ordernumber = 'P190208111345434' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '244221' WHERE ordernumber = 'P180208111352841' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '343743' WHERE ordernumber = 'P420208111401719' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '266434' WHERE ordernumber = 'P200208111411870' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '364942' WHERE ordernumber = 'P200208111527752' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '345259' WHERE ordernumber = 'P190208111546466' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '321220' WHERE ordernumber = 'P420208111604945' 2024-02-09 01:00:02 -- UPDATE `omo_order_list` SET userId = '321220' WHERE ordernumber = 'P420208111631353' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376538' WHERE ordernumber = 'P190208111722740' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '159425' WHERE ordernumber = 'P200208111747877' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '298481' WHERE ordernumber = 'P420208111845674' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '313542' WHERE ordernumber = 'P200208111850587' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376550' WHERE ordernumber = 'P180208112026318' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '267230' WHERE ordernumber = 'P190208112057763' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376560' WHERE ordernumber = 'P420208112116715' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '267230' WHERE ordernumber = 'P190208112239941' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376540' WHERE ordernumber = 'P190208112340722' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '281001' WHERE ordernumber = 'P200208112424994' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '100338' WHERE ordernumber = 'P200208112606346' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '40495' WHERE ordernumber = 'P180208112634147' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376541' WHERE ordernumber = 'P180208112853484' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376565' WHERE ordernumber = 'P190208113100825' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376459' WHERE ordernumber = 'P180208113231323' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376556' WHERE ordernumber = 'P190208113240945' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '89667' WHERE ordernumber = 'P200208113357944' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376558' WHERE ordernumber = 'P190208113450710' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '95353' WHERE ordernumber = 'P190208113648138' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376532' WHERE ordernumber = 'P180208113919770' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376564' WHERE ordernumber = 'P190208113957527' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '94310' WHERE ordernumber = 'P200208114054258' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376551' WHERE ordernumber = 'P190208114106495' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376551' WHERE ordernumber = 'P190208114120136' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '166285' WHERE ordernumber = 'P180208114313225' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '166285' WHERE ordernumber = 'P180208114414871' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376546' WHERE ordernumber = 'P190208114416300' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376542' WHERE ordernumber = 'P190208114620389' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376573' WHERE ordernumber = 'P420208114629491' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '94310' WHERE ordernumber = 'P200208114649273' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '167363' WHERE ordernumber = 'P200208114805578' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376561' WHERE ordernumber = 'P190208114818940' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376530' WHERE ordernumber = 'P180208114858839' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376574' WHERE ordernumber = 'P420208114859204' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '277922' WHERE ordernumber = 'P200208115057299' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376567' WHERE ordernumber = 'P190208115144622' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '133833' WHERE ordernumber = 'P200208115231992' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '316459' WHERE ordernumber = 'P190208115438709' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '339010' WHERE ordernumber = 'P190208115552370' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376545' WHERE ordernumber = 'P180208115643128' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376568' WHERE ordernumber = 'P190208115706645' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376545' WHERE ordernumber = 'P180208115716361' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '166845' WHERE ordernumber = 'P200208120033874' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '354381' WHERE ordernumber = 'P190208120325855' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376569' WHERE ordernumber = 'P190208120557482' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '358258' WHERE ordernumber = 'P200208120635576' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376553' WHERE ordernumber = 'P190208120811355' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '306235' WHERE ordernumber = 'P190208121006790' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '359307' WHERE ordernumber = 'P180208121025973' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376563' WHERE ordernumber = 'P190208121242372' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '365967' WHERE ordernumber = 'P200208121337221' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '81255' WHERE ordernumber = 'P180208121426272' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376587' WHERE ordernumber = 'P420208121633409' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376576' WHERE ordernumber = 'P190208121713896' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '98228' WHERE ordernumber = 'P200208121753348' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376590' WHERE ordernumber = 'P420208121755650' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '98528' WHERE ordernumber = 'P180208121826891' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376572' WHERE ordernumber = 'P190208121900301' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376572' WHERE ordernumber = 'P190208121915379' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '345715' WHERE ordernumber = 'P420208122004462' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376571' WHERE ordernumber = 'P190208122406549' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '313755' WHERE ordernumber = 'P200208122545177' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '370980' WHERE ordernumber = 'P200208122642214' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '368791' WHERE ordernumber = 'P420208122731322' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '368791' WHERE ordernumber = 'P420208122803371' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '360209' WHERE ordernumber = 'P180208123322702' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '142030' WHERE ordernumber = 'P200208123330992' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '118908' WHERE ordernumber = 'P190208123357404' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '294611' WHERE ordernumber = 'P190208123614399' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '366745' WHERE ordernumber = 'P190208123630813' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '375026' WHERE ordernumber = 'P420208123649224' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376584' WHERE ordernumber = 'P180208123817143' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376586' WHERE ordernumber = 'P190208123945456' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376557' WHERE ordernumber = 'P180208124144550' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376577' WHERE ordernumber = 'P190208124200339' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '297109' WHERE ordernumber = 'P420208124318311' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '248848' WHERE ordernumber = 'P200208124422790' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376601' WHERE ordernumber = 'P420208124443457' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376575' WHERE ordernumber = 'P190208124644557' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376605' WHERE ordernumber = 'P420208124729742' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376579' WHERE ordernumber = 'P190208124742805' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '136185' WHERE ordernumber = 'P420208124822843' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376579' WHERE ordernumber = 'P190208124832896' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376601' WHERE ordernumber = 'P420208124959421' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376578' WHERE ordernumber = 'P190208125001432' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376596' WHERE ordernumber = 'P180208125056680' 2024-02-09 01:00:03 -- UPDATE `omo_order_list` SET userId = '376308' WHERE ordernumber = 'P200208125105980' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '324836' WHERE ordernumber = 'P200208125246307' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376608' WHERE ordernumber = 'P420208125333545' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376581' WHERE ordernumber = 'P180208125616444' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '314370' WHERE ordernumber = 'P420208125728724' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376589' WHERE ordernumber = 'P180208130041521' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376597' WHERE ordernumber = 'P190208130100266' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376610' WHERE ordernumber = 'P180208130237841' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376588' WHERE ordernumber = 'P190208130245267' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376591' WHERE ordernumber = 'P180208130348302' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '368715' WHERE ordernumber = 'P420208130435376' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '279261' WHERE ordernumber = 'P200208130520144' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '279261' WHERE ordernumber = 'P200208130604340' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '363339' WHERE ordernumber = 'P200208130725265' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376604' WHERE ordernumber = 'P180208130728193' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376600' WHERE ordernumber = 'P190208130812349' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '363339' WHERE ordernumber = 'P200208130844527' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376613' WHERE ordernumber = 'P420208130853525' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376600' WHERE ordernumber = 'P190208130901451' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '371458' WHERE ordernumber = 'P200208130912886' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376603' WHERE ordernumber = 'P180208130926724' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '332664' WHERE ordernumber = 'P200208131006727' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376602' WHERE ordernumber = 'P180208131052498' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '317097' WHERE ordernumber = 'P200208131116622' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '345365' WHERE ordernumber = 'P200208131216442' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '109923' WHERE ordernumber = 'P190208131217949' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '209801' WHERE ordernumber = 'P200208131325908' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376614' WHERE ordernumber = 'P200208131432358' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376606' WHERE ordernumber = 'P190208131504926' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '84798' WHERE ordernumber = 'P190208131643544' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '340926' WHERE ordernumber = 'P200208131717841' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '218612' WHERE ordernumber = 'P190208131832242' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '258844' WHERE ordernumber = 'P190208131932143' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '276292' WHERE ordernumber = 'P200208132018547' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '98465' WHERE ordernumber = 'P200208132503482' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '319134' WHERE ordernumber = 'P200208133143305' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '285895' WHERE ordernumber = 'P200208133509343' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '295537' WHERE ordernumber = 'P200208133605670' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '161047' WHERE ordernumber = 'P200208133823812' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376625' WHERE ordernumber = 'P420208133824491' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376617' WHERE ordernumber = 'P190208134441202' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '373748' WHERE ordernumber = 'P420208134505129' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '356443' WHERE ordernumber = 'P200208134722261' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '202061' WHERE ordernumber = 'P190208134833437' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376579' WHERE ordernumber = 'P190208134944769' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376618' WHERE ordernumber = 'P180208134958294' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376632' WHERE ordernumber = 'P420208135109949' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376633' WHERE ordernumber = 'P190208135217255' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '9071' WHERE ordernumber = 'P420208135240263' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376639' WHERE ordernumber = 'P420208135626371' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '307982' WHERE ordernumber = 'P420208135754746' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376626' WHERE ordernumber = 'P190208135759575' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '295537' WHERE ordernumber = 'P200208140349342' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376629' WHERE ordernumber = 'P180208140443775' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '279153' WHERE ordernumber = 'P190208140502242' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376631' WHERE ordernumber = 'P180208140613821' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376635' WHERE ordernumber = 'P180208140656276' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376643' WHERE ordernumber = 'P200208140703221' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '374177' WHERE ordernumber = 'P420208140720350' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376636' WHERE ordernumber = 'P190208140759144' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376637' WHERE ordernumber = 'P180208140908672' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376646' WHERE ordernumber = 'P420208141143267' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '318790' WHERE ordernumber = 'P200208141357120' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376650' WHERE ordernumber = 'P420208141505236' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376653' WHERE ordernumber = 'P420208141736940' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '312498' WHERE ordernumber = 'P180208141830632' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376655' WHERE ordernumber = 'P420208141954850' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '309367' WHERE ordernumber = 'P190208141956389' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '198722' WHERE ordernumber = 'P420208142024998' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '319282' WHERE ordernumber = 'P180208142224705' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '305837' WHERE ordernumber = 'P190208142351715' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376652' WHERE ordernumber = 'P190208142423231' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '339660' WHERE ordernumber = 'P420208142450794' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376657' WHERE ordernumber = 'P420208142603668' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376651' WHERE ordernumber = 'P190208143255860' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376645' WHERE ordernumber = 'P190208143555464' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376663' WHERE ordernumber = 'P200208143628886' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376656' WHERE ordernumber = 'P180208143823311' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376649' WHERE ordernumber = 'P190208143837401' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '357591' WHERE ordernumber = 'P180208143924777' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '224958' WHERE ordernumber = 'P190208143925911' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '280922' WHERE ordernumber = 'P180208144039443' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376654' WHERE ordernumber = 'P190208144132438' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376654' WHERE ordernumber = 'P190208144148501' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '103865' WHERE ordernumber = 'P180208144312144' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '313698' WHERE ordernumber = 'P180208144433881' 2024-02-09 01:00:04 -- UPDATE `omo_order_list` SET userId = '376659' WHERE ordernumber = 'P190208144436843' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376660' WHERE ordernumber = 'P190208144608747' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '245317' WHERE ordernumber = 'P190208144723268' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '157592' WHERE ordernumber = 'P190208144827323' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '276571' WHERE ordernumber = 'P190208145003697' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '356208' WHERE ordernumber = 'P190208145612601' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '365498' WHERE ordernumber = 'P180208145715680' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376673' WHERE ordernumber = 'P420208145820435' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '241954' WHERE ordernumber = 'P190208145915811' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376676' WHERE ordernumber = 'P420208150324550' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '39039' WHERE ordernumber = 'P200208150502713' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '297481' WHERE ordernumber = 'P420208150507347' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '304021' WHERE ordernumber = 'P180208150537972' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '374660' WHERE ordernumber = 'P190208150639701' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376669' WHERE ordernumber = 'P190208150817331' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '234037' WHERE ordernumber = 'P200208150845782' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '272356' WHERE ordernumber = 'P530208150933411' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '372793' WHERE ordernumber = 'P420208151120488' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '372793' WHERE ordernumber = 'P420208151220442' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '168933' WHERE ordernumber = 'P200208151236541' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376669' WHERE ordernumber = 'P190208151632541' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '65135' WHERE ordernumber = 'P420208151659254' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '100154' WHERE ordernumber = 'P200208151724968' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '168933' WHERE ordernumber = 'P200208151748338' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376315' WHERE ordernumber = 'P420208151923774' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '81121' WHERE ordernumber = 'P180208151934457' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '163287' WHERE ordernumber = 'P200208152014254' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '308784' WHERE ordernumber = 'P200208152323760' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '225545' WHERE ordernumber = 'P200208152519151' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '370405' WHERE ordernumber = 'P180208152641964' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '284832' WHERE ordernumber = 'P200208152833610' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '271635' WHERE ordernumber = 'P190208152950520' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '351041' WHERE ordernumber = 'P420208153514677' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '160751' WHERE ordernumber = 'P190208153736414' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '72182' WHERE ordernumber = 'P200208153812517' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '314562' WHERE ordernumber = 'P190208154053933' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '120580' WHERE ordernumber = 'P180208154222895' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376685' WHERE ordernumber = 'P180208154351559' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '109713' WHERE ordernumber = 'P180208154621522' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '254122' WHERE ordernumber = 'P180208154837331' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '301293' WHERE ordernumber = 'P180208154909437' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376691' WHERE ordernumber = 'P420208154935631' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '346604' WHERE ordernumber = 'P200208154935705' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376687' WHERE ordernumber = 'P180208155007281' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '352458' WHERE ordernumber = 'P420208155011986' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '373792' WHERE ordernumber = 'P180208155116656' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376690' WHERE ordernumber = 'P180208155155955' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '353309' WHERE ordernumber = 'P190208155215867' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '373882' WHERE ordernumber = 'P180208155328651' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '273961' WHERE ordernumber = 'P200208155427999' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '350446' WHERE ordernumber = 'P180208155648927' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '224896' WHERE ordernumber = 'P200208155813411' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '256331' WHERE ordernumber = 'P180208155858928' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '137563' WHERE ordernumber = 'P200208160008766' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '77463' WHERE ordernumber = 'P420208160023357' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '89792' WHERE ordernumber = 'P180208160606825' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376696' WHERE ordernumber = 'P420208160653832' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376698' WHERE ordernumber = 'P420208160846535' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376700' WHERE ordernumber = 'P420208161501171' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376702' WHERE ordernumber = 'P420208162148477' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '368824' WHERE ordernumber = 'P200208162609255' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '109535' WHERE ordernumber = 'P180208162921264' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '228009' WHERE ordernumber = 'P200208162939240' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '150602' WHERE ordernumber = 'P180208163121603' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '317864' WHERE ordernumber = 'P420208163515410' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376706' WHERE ordernumber = 'P420208164429506' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '266025' WHERE ordernumber = 'P200208165100875' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '344123' WHERE ordernumber = 'P530208165208333' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '240840' WHERE ordernumber = 'P180208165249540' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376683' WHERE ordernumber = 'P200208165502640' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '130994' WHERE ordernumber = 'P420208165618164' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '130740' WHERE ordernumber = 'P190208170014900' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '121542' WHERE ordernumber = 'P200208170332876' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376506' WHERE ordernumber = 'P200208170417965' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376715' WHERE ordernumber = 'P420208170510846' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376718' WHERE ordernumber = 'P190208170856801' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376720' WHERE ordernumber = 'P180208171025188' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '357209' WHERE ordernumber = 'P420208171319237' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '276698' WHERE ordernumber = 'P200208171522138' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '359226' WHERE ordernumber = 'P420208171623844' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '81452' WHERE ordernumber = 'P200208171725554' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '357209' WHERE ordernumber = 'P420208171810904' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '329832' WHERE ordernumber = 'P420208171916370' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '369903' WHERE ordernumber = 'P420208172334957' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376721' WHERE ordernumber = 'P420208172512676' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '329832' WHERE ordernumber = 'P420208172756537' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '298208' WHERE ordernumber = 'P200208173120439' 2024-02-09 01:00:05 -- UPDATE `omo_order_list` SET userId = '376722' WHERE ordernumber = 'P200208173245259' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '99085' WHERE ordernumber = 'P200208173520177' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376729' WHERE ordernumber = 'P420208174010591' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '367527' WHERE ordernumber = 'P420208174258991' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '281094' WHERE ordernumber = 'P200208174427161' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376731' WHERE ordernumber = 'P420208174439579' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376732' WHERE ordernumber = 'P420208174559536' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '314568' WHERE ordernumber = 'P420208174732907' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '295725' WHERE ordernumber = 'P200208175519187' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376729' WHERE ordernumber = 'P420208180053472' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '138053' WHERE ordernumber = 'P420208180558143' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '96678' WHERE ordernumber = 'P200208180721350' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '367377' WHERE ordernumber = 'P180208181043754' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376742' WHERE ordernumber = 'P200208181324907' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '137230' WHERE ordernumber = 'P200208181409815' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376741' WHERE ordernumber = 'P200208181438489' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '209560' WHERE ordernumber = 'P180208181551211' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376743' WHERE ordernumber = 'P180208181844447' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '137008' WHERE ordernumber = 'P200208181938864' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '356443' WHERE ordernumber = 'P200208182054834' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '339897' WHERE ordernumber = 'P420208183145843' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '226896' WHERE ordernumber = 'P200208183151821' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '242508' WHERE ordernumber = 'P200208183329775' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376745' WHERE ordernumber = 'P200208183409365' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '372488' WHERE ordernumber = 'P420208183519152' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '112371' WHERE ordernumber = 'P200208183552687' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '358367' WHERE ordernumber = 'P200208183704331' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '360387' WHERE ordernumber = 'P200208183825923' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '375452' WHERE ordernumber = 'P420208183909834' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '352408' WHERE ordernumber = 'P200208184029898' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '101279' WHERE ordernumber = 'P200208184307420' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '233915' WHERE ordernumber = 'P200208184429929' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '328335' WHERE ordernumber = 'P200208184633714' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '81747' WHERE ordernumber = 'P190208185219212' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '375431' WHERE ordernumber = 'P190208190003479' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '159453' WHERE ordernumber = 'P420208190044527' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '350638' WHERE ordernumber = 'P200208190129867' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '356109' WHERE ordernumber = 'P420208190139691' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376756' WHERE ordernumber = 'P190208191245259' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '354214' WHERE ordernumber = 'P190208191617415' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '328218' WHERE ordernumber = 'P420208192831118' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '84233' WHERE ordernumber = 'P200208193302280' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '98742' WHERE ordernumber = 'P200208193647148' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '363855' WHERE ordernumber = 'P200208194345657' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '357970' WHERE ordernumber = 'P200208194500752' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '363855' WHERE ordernumber = 'P200208194607311' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '376766' WHERE ordernumber = 'P420208204906606' 2024-02-09 01:00:06 -- UPDATE `omo_order_list` SET userId = '334506' WHERE ordernumber = 'P420208205559617'