2024-02-25 01:00:02 -- 將會員中心id寫入data-lake 2024-02-25 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-24%'; 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '356625' WHERE ordernumber = 'P420224100539217' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378636' WHERE ordernumber = 'P420224110108673' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '90015' WHERE ordernumber = 'P200224110153324' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '90015' WHERE ordernumber = 'P200224110235208' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378637' WHERE ordernumber = 'P180224110307779' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378638' WHERE ordernumber = 'P180224110456674' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378628' WHERE ordernumber = 'P420224110543591' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378628' WHERE ordernumber = 'P420224110613743' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378639' WHERE ordernumber = 'P200224110643502' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378640' WHERE ordernumber = 'P200224110810217' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378641' WHERE ordernumber = 'P200224110945568' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '135453' WHERE ordernumber = 'P180224111137891' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '347005' WHERE ordernumber = 'P190224111151355' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378642' WHERE ordernumber = 'P200224111157892' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '135710' WHERE ordernumber = 'P200224111319678' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378643' WHERE ordernumber = 'P190224111406667' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '221222' WHERE ordernumber = 'P180224111409769' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '272111' WHERE ordernumber = 'P190224111644484' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378644' WHERE ordernumber = 'P420224111648480' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '129909' WHERE ordernumber = 'P180224111649860' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '269419' WHERE ordernumber = 'P180224111922505' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378646' WHERE ordernumber = 'P200224112312813' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378645' WHERE ordernumber = 'P420224112354269' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378647' WHERE ordernumber = 'P180224112552734' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '356322' WHERE ordernumber = 'P180224112725201' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '345205' WHERE ordernumber = 'P180224112819130' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378648' WHERE ordernumber = 'P180224113027509' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378650' WHERE ordernumber = 'P190224113830122' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '98048' WHERE ordernumber = 'P200224113911373' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378649' WHERE ordernumber = 'P180224113938790' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '289921' WHERE ordernumber = 'P190224113951456' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '208658' WHERE ordernumber = 'P200224114009844' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378607' WHERE ordernumber = 'P190224114117258' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '301307' WHERE ordernumber = 'P180224114241478' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '378651' WHERE ordernumber = 'P190224114355595' 2024-02-25 01:00:02 -- UPDATE `omo_order_list` SET userId = '353938' WHERE ordernumber = 'P420224114414323' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '259013' WHERE ordernumber = 'P200224114417501' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '113482' WHERE ordernumber = 'P180224114748590' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378653' WHERE ordernumber = 'P180224114935237' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '284766' WHERE ordernumber = 'P180224115059507' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '375525' WHERE ordernumber = 'P180224115142757' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378654' WHERE ordernumber = 'P200224115549228' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '301407' WHERE ordernumber = 'P180224115744117' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378655' WHERE ordernumber = 'P200224115802313' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '243343' WHERE ordernumber = 'P180224120330532' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378657' WHERE ordernumber = 'P180224120427457' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378658' WHERE ordernumber = 'P180224120628535' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378659' WHERE ordernumber = 'P180224120815597' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '325003' WHERE ordernumber = 'P180224120953211' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '367171' WHERE ordernumber = 'P180224121159562' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '81671' WHERE ordernumber = 'P180224121338776' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '352364' WHERE ordernumber = 'P180224121419806' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '310111' WHERE ordernumber = 'P200224121431634' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378419' WHERE ordernumber = 'P180224122243209' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378055' WHERE ordernumber = 'P420224122427503' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378662' WHERE ordernumber = 'P180224122500132' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '262503' WHERE ordernumber = 'P180224122612718' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378664' WHERE ordernumber = 'P420224122741520' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378665' WHERE ordernumber = 'P420224122848391' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '303554' WHERE ordernumber = 'P180224123048632' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '307431' WHERE ordernumber = 'P190224123322924' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378666' WHERE ordernumber = 'P190224123519828' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378667' WHERE ordernumber = 'P180224124318932' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378670' WHERE ordernumber = 'P180224124633217' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '248141' WHERE ordernumber = 'P200224124751509' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378671' WHERE ordernumber = 'P180224124803164' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378672' WHERE ordernumber = 'P420224124941808' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378673' WHERE ordernumber = 'P420224125048739' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378674' WHERE ordernumber = 'P180224125706686' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '313963' WHERE ordernumber = 'P180224125829120' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378675' WHERE ordernumber = 'P420224130147170' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378676' WHERE ordernumber = 'P200224130247182' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '283578' WHERE ordernumber = 'P180224130518973' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378678' WHERE ordernumber = 'P420224130656147' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378680' WHERE ordernumber = 'P200224130731728' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378681' WHERE ordernumber = 'P200224130837336' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '357970' WHERE ordernumber = 'P200224130935259' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '334735' WHERE ordernumber = 'P200224131104934' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '367697' WHERE ordernumber = 'P420224131532585' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378682' WHERE ordernumber = 'P180224131654216' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378112' WHERE ordernumber = 'P420224132445779' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '105688' WHERE ordernumber = 'P200224132751200' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '321341' WHERE ordernumber = 'P180224132813355' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378685' WHERE ordernumber = 'P420224133110240' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378684' WHERE ordernumber = 'P180224133205773' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378686' WHERE ordernumber = 'P420224133443967' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '283493' WHERE ordernumber = 'P180224133552113' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378687' WHERE ordernumber = 'P420224133626252' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '351726' WHERE ordernumber = 'P200224133902306' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378688' WHERE ordernumber = 'P180224134017134' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '206345' WHERE ordernumber = 'P180224134323569' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '206890' WHERE ordernumber = 'P180224134526744' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '207147' WHERE ordernumber = 'P180224134855502' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378691' WHERE ordernumber = 'P180224135204428' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '280056' WHERE ordernumber = 'P180224135313914' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378693' WHERE ordernumber = 'P180224135517912' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378695' WHERE ordernumber = 'P180224135704198' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378694' WHERE ordernumber = 'P180224135805797' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378697' WHERE ordernumber = 'P180224140520585' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '356048' WHERE ordernumber = 'P200224140558136' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378698' WHERE ordernumber = 'P420224140605896' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378184' WHERE ordernumber = 'P200224140723542' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '368514' WHERE ordernumber = 'P420224140745130' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378696' WHERE ordernumber = 'P200224140751218' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378699' WHERE ordernumber = 'P420224140939202' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378700' WHERE ordernumber = 'P180224140945722' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378701' WHERE ordernumber = 'P180224141202798' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378689' WHERE ordernumber = 'P180224141342286' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378690' WHERE ordernumber = 'P180224141432411' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '300157' WHERE ordernumber = 'P180224141536823' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '300157' WHERE ordernumber = 'P180224141553928' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378702' WHERE ordernumber = 'P190224141742557' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '281661' WHERE ordernumber = 'P190224141854246' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378703' WHERE ordernumber = 'P180224141916794' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378704' WHERE ordernumber = 'P420224141923353' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378706' WHERE ordernumber = 'P420224142016711' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '377673' WHERE ordernumber = 'P180224142146406' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '72183' WHERE ordernumber = 'P200224142211881' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '335369' WHERE ordernumber = 'P200224142456301' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '238800' WHERE ordernumber = 'P180224142519904' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378708' WHERE ordernumber = 'P180224142625591' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378668' WHERE ordernumber = 'P180224142838750' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '307181' WHERE ordernumber = 'P180224142944338' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '109255' WHERE ordernumber = 'P180224143049166' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378709' WHERE ordernumber = 'P420224143115984' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '331749' WHERE ordernumber = 'P420224143314338' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378256' WHERE ordernumber = 'P420224143525736' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '270587' WHERE ordernumber = 'P180224144043705' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378710' WHERE ordernumber = 'P180224144407534' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378711' WHERE ordernumber = 'P420224144510836' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378712' WHERE ordernumber = 'P420224144611425' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378713' WHERE ordernumber = 'P180224144948766' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '160854' WHERE ordernumber = 'P200224145005955' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '378714' WHERE ordernumber = 'P420224145425852' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '238942' WHERE ordernumber = 'P190224145655519' 2024-02-25 01:00:03 -- UPDATE `omo_order_list` SET userId = '377630' WHERE ordernumber = 'P180224145727171' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378715' WHERE ordernumber = 'P420224145800270' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '90174' WHERE ordernumber = 'P200224150124196' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378716' WHERE ordernumber = 'P420224150137851' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378717' WHERE ordernumber = 'P180224150312147' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '286571' WHERE ordernumber = 'P200224150659379' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '132818' WHERE ordernumber = 'P200224150743368' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '257540' WHERE ordernumber = 'P180224150951511' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378718' WHERE ordernumber = 'P420224151246143' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '345964' WHERE ordernumber = 'P420224151430513' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '370397' WHERE ordernumber = 'P180224151526856' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378719' WHERE ordernumber = 'P180224151639484' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '274772' WHERE ordernumber = 'P420224151752482' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378721' WHERE ordernumber = 'P180224151934950' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '302227' WHERE ordernumber = 'P200224152053165' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378722' WHERE ordernumber = 'P180224152109356' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378722' WHERE ordernumber = 'P180224152153231' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378723' WHERE ordernumber = 'P200224152222347' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378724' WHERE ordernumber = 'P200224152514310' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378722' WHERE ordernumber = 'P180224152523548' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378725' WHERE ordernumber = 'P180224152928762' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '276791' WHERE ordernumber = 'P200224153118625' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378725' WHERE ordernumber = 'P180224153233294' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378725' WHERE ordernumber = 'P180224153408211' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '222534' WHERE ordernumber = 'P180224153701263' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378726' WHERE ordernumber = 'P420224153746810' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378727' WHERE ordernumber = 'P180224154132545' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '282143' WHERE ordernumber = 'P200224154143818' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378728' WHERE ordernumber = 'P180224154249357' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378729' WHERE ordernumber = 'P200224154312632' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '81576' WHERE ordernumber = 'P180224154406312' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378730' WHERE ordernumber = 'P190224154421527' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378731' WHERE ordernumber = 'P180224154919847' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '106086' WHERE ordernumber = 'P180224155020173' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '309283' WHERE ordernumber = 'P180224155228178' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378732' WHERE ordernumber = 'P180224155431222' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '377294' WHERE ordernumber = 'P200224155645838' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '322' WHERE ordernumber = 'P180224155706468' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378733' WHERE ordernumber = 'P420224155817873' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '295295' WHERE ordernumber = 'P180224160021781' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '37371' WHERE ordernumber = 'P200224160050159' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378735' WHERE ordernumber = 'P420224160207164' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378736' WHERE ordernumber = 'P420224160344165' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378737' WHERE ordernumber = 'P420224160445958' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378738' WHERE ordernumber = 'P420224160903622' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378720' WHERE ordernumber = 'P180224161500854' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378720' WHERE ordernumber = 'P180224161516753' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '354753' WHERE ordernumber = 'P180224161621593' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '172513' WHERE ordernumber = 'P200224161732483' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '316947' WHERE ordernumber = 'P180224161742816' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378739' WHERE ordernumber = 'P420224161811442' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '294893' WHERE ordernumber = 'P180224161842944' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378740' WHERE ordernumber = 'P420224161914451' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378741' WHERE ordernumber = 'P420224162017456' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '365698' WHERE ordernumber = 'P420224162548601' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '348885' WHERE ordernumber = 'P180224162727935' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '240030' WHERE ordernumber = 'P180224163251170' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '289110' WHERE ordernumber = 'P200224163303632' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378743' WHERE ordernumber = 'P420224163713803' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378744' WHERE ordernumber = 'P180224163823384' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378746' WHERE ordernumber = 'P420224163854422' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378748' WHERE ordernumber = 'P420224164106199' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378749' WHERE ordernumber = 'P180224164225943' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378750' WHERE ordernumber = 'P200224164308307' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '277610' WHERE ordernumber = 'P200224164359722' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378751' WHERE ordernumber = 'P180224164435592' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '265519' WHERE ordernumber = 'P200224164531363' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378752' WHERE ordernumber = 'P180224164544662' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378754' WHERE ordernumber = 'P420224164657530' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '131777' WHERE ordernumber = 'P180224164659446' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378755' WHERE ordernumber = 'P190224164745534' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '255002' WHERE ordernumber = 'P180224164951192' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378756' WHERE ordernumber = 'P200224164957962' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378757' WHERE ordernumber = 'P180224165231407' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '373285' WHERE ordernumber = 'P420224165506619' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378751' WHERE ordernumber = 'P180224165523183' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '347580' WHERE ordernumber = 'P180224165733226' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '78489' WHERE ordernumber = 'P420224165750942' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378759' WHERE ordernumber = 'P200224165852627' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '121877' WHERE ordernumber = 'P200224170043448' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378758' WHERE ordernumber = 'P190224170128517' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378760' WHERE ordernumber = 'P420224170142750' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '307098' WHERE ordernumber = 'P190224170242303' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '272767' WHERE ordernumber = 'P180224170310520' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '307098' WHERE ordernumber = 'P190224170357556' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '307098' WHERE ordernumber = 'P190224170647208' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378761' WHERE ordernumber = 'P200224170714920' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '111805' WHERE ordernumber = 'P180224170909976' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378763' WHERE ordernumber = 'P200224171241434' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '272413' WHERE ordernumber = 'P180224171331788' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378765' WHERE ordernumber = 'P200224171618766' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378766' WHERE ordernumber = 'P200224171727802' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '365257' WHERE ordernumber = 'P200224171828386' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '170493' WHERE ordernumber = 'P180224171845827' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '221484' WHERE ordernumber = 'P200224171913388' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '143775' WHERE ordernumber = 'P420224171921811' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '170493' WHERE ordernumber = 'P180224171929500' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '277769' WHERE ordernumber = 'P200224171944395' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '308306' WHERE ordernumber = 'P200224172022413' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378767' WHERE ordernumber = 'P180224172132443' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '124369' WHERE ordernumber = 'P180224172307891' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '286821' WHERE ordernumber = 'P180224172343963' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '308306' WHERE ordernumber = 'P200224172604426' 2024-02-25 01:00:04 -- UPDATE `omo_order_list` SET userId = '378768' WHERE ordernumber = 'P180224172618396' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378769' WHERE ordernumber = 'P420224172753971' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378770' WHERE ordernumber = 'P200224173008259' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378771' WHERE ordernumber = 'P420224173043709' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '366214' WHERE ordernumber = 'P420224173439245' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378772' WHERE ordernumber = 'P420224173640129' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '312194' WHERE ordernumber = 'P180224173646628' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '370057' WHERE ordernumber = 'P200224173713574' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378773' WHERE ordernumber = 'P180224174002651' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '342641' WHERE ordernumber = 'P180224174048336' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '230767' WHERE ordernumber = 'P180224174239975' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378775' WHERE ordernumber = 'P420224174321251' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378776' WHERE ordernumber = 'P420224174635710' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '375565' WHERE ordernumber = 'P200224174752272' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378778' WHERE ordernumber = 'P200224174920190' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378780' WHERE ordernumber = 'P420224175216843' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378779' WHERE ordernumber = 'P200224175219156' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378781' WHERE ordernumber = 'P200224175253443' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378782' WHERE ordernumber = 'P200224175336680' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378783' WHERE ordernumber = 'P200224175416439' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378784' WHERE ordernumber = 'P200224175529840' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378785' WHERE ordernumber = 'P200224175906723' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '91816' WHERE ordernumber = 'P420224180030569' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '369941' WHERE ordernumber = 'P420224180406498' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378787' WHERE ordernumber = 'P200224180725571' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '365094' WHERE ordernumber = 'P200224180944967' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378787' WHERE ordernumber = 'P200224181031224' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378788' WHERE ordernumber = 'P180224181036979' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '106167' WHERE ordernumber = 'P180224181133171' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '132129' WHERE ordernumber = 'P180224181214516' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378789' WHERE ordernumber = 'P200224181243546' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378447' WHERE ordernumber = 'P200224181435359' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378790' WHERE ordernumber = 'P180224181438501' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '296766' WHERE ordernumber = 'P420224181940758' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378789' WHERE ordernumber = 'P200224182000573' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '274832' WHERE ordernumber = 'P190224182113940' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '274832' WHERE ordernumber = 'P180224182338399' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378792' WHERE ordernumber = 'P190224182347284' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '245296' WHERE ordernumber = 'P180224182928263' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378794' WHERE ordernumber = 'P180224183151239' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '287156' WHERE ordernumber = 'P180224183733768' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378795' WHERE ordernumber = 'P190224184200201' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '238243' WHERE ordernumber = 'P190224184720114' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378796' WHERE ordernumber = 'P190224184925971' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '369941' WHERE ordernumber = 'P420224185004908' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378270' WHERE ordernumber = 'P190224185024585' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378797' WHERE ordernumber = 'P200224185324460' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '99718' WHERE ordernumber = 'P200224185414815' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '322190' WHERE ordernumber = 'P200224185825544' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '322190' WHERE ordernumber = 'P200224185959409' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '240328' WHERE ordernumber = 'P190224190033635' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378798' WHERE ordernumber = 'P200224190111638' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378799' WHERE ordernumber = 'P420224190359307' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378800' WHERE ordernumber = 'P420224190700665' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '97810' WHERE ordernumber = 'P190224191146909' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378801' WHERE ordernumber = 'P200224191230262' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378802' WHERE ordernumber = 'P420224191312706' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '338208' WHERE ordernumber = 'P190224191617304' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378803' WHERE ordernumber = 'P420224192316774' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378805' WHERE ordernumber = 'P200224192332123' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '314307' WHERE ordernumber = 'P200224192505392' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '345359' WHERE ordernumber = 'P200224192811750' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '81113' WHERE ordernumber = 'P200224192859936' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378806' WHERE ordernumber = 'P200224193610546' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '129743' WHERE ordernumber = 'P420224193753265' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378809' WHERE ordernumber = 'P200224194804343' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '114594' WHERE ordernumber = 'P190224194818603' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '229357' WHERE ordernumber = 'P200224195043326' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '253185' WHERE ordernumber = 'P200224195230220' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '253185' WHERE ordernumber = 'P200224195350656' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378810' WHERE ordernumber = 'P420224195447164' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '284076' WHERE ordernumber = 'P190224195458198' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378811' WHERE ordernumber = 'P420224195539691' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '246465' WHERE ordernumber = 'P190224195631832' 2024-02-25 01:00:05 -- UPDATE `omo_order_list` SET userId = '378812' WHERE ordernumber = 'P420224201541798'