2024-10-06 01:00:02 -- 將會員中心id寫入data-lake
2024-10-06 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-10-05%';
        
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422156'
                WHERE ordernumber = 'P181005110503753' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424193'
                WHERE ordernumber = 'P191005110712361' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105654'
                WHERE ordernumber = 'P181005110905862' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313854'
                WHERE ordernumber = 'P421005110931660' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307276'
                WHERE ordernumber = 'P191005110938543' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '83694'
                WHERE ordernumber = 'P191005111214579' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424196'
                WHERE ordernumber = 'P181005111623136' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424194'
                WHERE ordernumber = 'P191005111807323' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368482'
                WHERE ordernumber = 'P181005111835655' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424198'
                WHERE ordernumber = 'P181005112118466' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96948'
                WHERE ordernumber = 'P181005112225675' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424197'
                WHERE ordernumber = 'P191005112301367' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159649'
                WHERE ordernumber = 'P421005112315843' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181005112417547' 
            
2024-10-06 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118995'
                WHERE ordernumber = 'P191005112733825' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424200'
                WHERE ordernumber = 'P201005113051648' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P191005113146324' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169848'
                WHERE ordernumber = 'P421005113622639' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '8048'
                WHERE ordernumber = 'P181005113915800' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371594'
                WHERE ordernumber = 'P421005114217619' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328651'
                WHERE ordernumber = 'P181005114242550' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380800'
                WHERE ordernumber = 'P191005114542934' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380678'
                WHERE ordernumber = 'P201005114840781' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423048'
                WHERE ordernumber = 'P181005114928573' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424203'
                WHERE ordernumber = 'P421005115008478' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424204'
                WHERE ordernumber = 'P181005115646148' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424205'
                WHERE ordernumber = 'P181005115911235' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424206'
                WHERE ordernumber = 'P201005120503414' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392843'
                WHERE ordernumber = 'P201005120555711' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246452'
                WHERE ordernumber = 'P181005120952241' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '150598'
                WHERE ordernumber = 'P421005121236931' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279863'
                WHERE ordernumber = 'P201005121251607' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216847'
                WHERE ordernumber = 'P181005121345242' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287695'
                WHERE ordernumber = 'P201005121451663' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424208'
                WHERE ordernumber = 'P711005121824725' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343681'
                WHERE ordernumber = 'P421005121858336' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424209'
                WHERE ordernumber = 'P421005122243284' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424211'
                WHERE ordernumber = 'P181005122424717' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137563'
                WHERE ordernumber = 'P201005122437227' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424212'
                WHERE ordernumber = 'P201005123248306' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424214'
                WHERE ordernumber = 'P201005123507420' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424213'
                WHERE ordernumber = 'P181005123620360' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '85019'
                WHERE ordernumber = 'P181005123753130' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424215'
                WHERE ordernumber = 'P711005123924789' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424216'
                WHERE ordernumber = 'P421005124107738' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424217'
                WHERE ordernumber = 'P421005124156183' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424219'
                WHERE ordernumber = 'P421005124353430' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362075'
                WHERE ordernumber = 'P631005124628290' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228456'
                WHERE ordernumber = 'P181005124714123' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424218'
                WHERE ordernumber = 'P421005124716906' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301210'
                WHERE ordernumber = 'P191005124747533' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424220'
                WHERE ordernumber = 'P201005124844642' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420032'
                WHERE ordernumber = 'P421005125019321' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378769'
                WHERE ordernumber = 'P421005125634155' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424222'
                WHERE ordernumber = 'P711005125738794' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424213'
                WHERE ordernumber = 'P191005125924440' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424221'
                WHERE ordernumber = 'P181005130252858' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424224'
                WHERE ordernumber = 'P421005130512778' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424223'
                WHERE ordernumber = 'P181005130704297' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424213'
                WHERE ordernumber = 'P181005130838656' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424225'
                WHERE ordernumber = 'P711005130903845' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359360'
                WHERE ordernumber = 'P201005131136182' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422983'
                WHERE ordernumber = 'P421005131204816' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217348'
                WHERE ordernumber = 'P201005131241413' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424230'
                WHERE ordernumber = 'P201005131426794' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162239'
                WHERE ordernumber = 'P201005131629206' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424229'
                WHERE ordernumber = 'P421005131726937' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424228'
                WHERE ordernumber = 'P421005131812148' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424226'
                WHERE ordernumber = 'P181005131828486' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384355'
                WHERE ordernumber = 'P201005131845612' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424227'
                WHERE ordernumber = 'P181005131852429' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424232'
                WHERE ordernumber = 'P421005131939415' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424050'
                WHERE ordernumber = 'P421005132118920' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424233'
                WHERE ordernumber = 'P181005132404168' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424234'
                WHERE ordernumber = 'P181005132935440' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '323918'
                WHERE ordernumber = 'P711005133043820' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212232'
                WHERE ordernumber = 'P181005133248390' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107737'
                WHERE ordernumber = 'P201005133327824' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391540'
                WHERE ordernumber = 'P421005133400439' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424236'
                WHERE ordernumber = 'P711005133702302' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316273'
                WHERE ordernumber = 'P181005133817936' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424235'
                WHERE ordernumber = 'P181005133933734' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P421005134016290' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424215'
                WHERE ordernumber = 'P711005134827823' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '423830'
                WHERE ordernumber = 'P201005135322681' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424239'
                WHERE ordernumber = 'P421005135330631' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424238'
                WHERE ordernumber = 'P711005135501546' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409340'
                WHERE ordernumber = 'P181005135615856' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310240'
                WHERE ordernumber = 'P421005135618836' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424237'
                WHERE ordernumber = 'P731005135717972' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424241'
                WHERE ordernumber = 'P711005135830408' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424240'
                WHERE ordernumber = 'P421005135832144' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424242'
                WHERE ordernumber = 'P181005135947812' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P201005140135997' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424243'
                WHERE ordernumber = 'P201005140733456' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424244'
                WHERE ordernumber = 'P421005141047799' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424245'
                WHERE ordernumber = 'P421005141114673' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424247'
                WHERE ordernumber = 'P181005141139187' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41301'
                WHERE ordernumber = 'P201005141241351' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424246'
                WHERE ordernumber = 'P711005141354513' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424248'
                WHERE ordernumber = 'P731005141356307' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424249'
                WHERE ordernumber = 'P711005141605564' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424251'
                WHERE ordernumber = 'P201005141818346' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424250'
                WHERE ordernumber = 'P731005141836314' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424252'
                WHERE ordernumber = 'P731005142319269' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419610'
                WHERE ordernumber = 'P421005142409696' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112548'
                WHERE ordernumber = 'P181005142504499' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424253'
                WHERE ordernumber = 'P201005142556588' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424254'
                WHERE ordernumber = 'P731005142628715' 
            
2024-10-06 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424255'
                WHERE ordernumber = 'P711005142656202' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '422967'
                WHERE ordernumber = 'P711005142945408' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424256'
                WHERE ordernumber = 'P421005143036918' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424257'
                WHERE ordernumber = 'P731005143245294' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424258'
                WHERE ordernumber = 'P201005143721476' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424260'
                WHERE ordernumber = 'P201005144130165' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '419600'
                WHERE ordernumber = 'P421005144233591' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252055'
                WHERE ordernumber = 'P631005144248864' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424259'
                WHERE ordernumber = 'P181005144357379' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P181005144836593' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401614'
                WHERE ordernumber = 'P421005144951653' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424263'
                WHERE ordernumber = 'P201005145456663' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '372517'
                WHERE ordernumber = 'P421005145513637' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '403645'
                WHERE ordernumber = 'P711005145917684' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243742'
                WHERE ordernumber = 'P181005150047445' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424265'
                WHERE ordernumber = 'P421005150215404' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283649'
                WHERE ordernumber = 'P631005150223749' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424268'
                WHERE ordernumber = 'P181005150238640' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229781'
                WHERE ordernumber = 'P201005150254118' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424267'
                WHERE ordernumber = 'P731005150302531' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424264'
                WHERE ordernumber = 'P731005150708405' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424270'
                WHERE ordernumber = 'P421005150835992' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424272'
                WHERE ordernumber = 'P181005151157793' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424273'
                WHERE ordernumber = 'P201005151234846' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286609'
                WHERE ordernumber = 'P201005151355452' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424276'
                WHERE ordernumber = 'P201005151636149' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424277'
                WHERE ordernumber = 'P711005151743247' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424279'
                WHERE ordernumber = 'P421005151845741' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423792'
                WHERE ordernumber = 'P201005151913768' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234062'
                WHERE ordernumber = 'P181005151953224' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424202'
                WHERE ordernumber = 'P201005152133535' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424280'
                WHERE ordernumber = 'P711005152214805' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424278'
                WHERE ordernumber = 'P181005152224903' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424202'
                WHERE ordernumber = 'P201005152242203' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424274'
                WHERE ordernumber = 'P711005152430510' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424282'
                WHERE ordernumber = 'P421005152614153' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424281'
                WHERE ordernumber = 'P201005152617137' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424283'
                WHERE ordernumber = 'P421005153012664' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424288'
                WHERE ordernumber = 'P201005153059761' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424286'
                WHERE ordernumber = 'P711005153159282' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424285'
                WHERE ordernumber = 'P181005153214119' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424287'
                WHERE ordernumber = 'P201005153219421' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424289'
                WHERE ordernumber = 'P181005153401483' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394292'
                WHERE ordernumber = 'P181005153448863' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424291'
                WHERE ordernumber = 'P181005153635706' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305830'
                WHERE ordernumber = 'P201005153927994' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '138882'
                WHERE ordernumber = 'P711005154114573' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424292'
                WHERE ordernumber = 'P421005154139998' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424295'
                WHERE ordernumber = 'P201005154256960' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355406'
                WHERE ordernumber = 'P181005154430671' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424294'
                WHERE ordernumber = 'P181005154720552' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421519'
                WHERE ordernumber = 'P421005154905490' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424293'
                WHERE ordernumber = 'P181005155041303' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424296'
                WHERE ordernumber = 'P421005155117955' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424298'
                WHERE ordernumber = 'P421005155423523' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424299'
                WHERE ordernumber = 'P181005155706920' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424300'
                WHERE ordernumber = 'P421005155715486' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421671'
                WHERE ordernumber = 'P711005155753790' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424301'
                WHERE ordernumber = 'P421005160036748' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316347'
                WHERE ordernumber = 'P421005160221784' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373686'
                WHERE ordernumber = 'P201005160447832' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102960'
                WHERE ordernumber = 'P201005160909733' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235375'
                WHERE ordernumber = 'P201005161215120' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424243'
                WHERE ordernumber = 'P201005161246556' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424303'
                WHERE ordernumber = 'P421005161737305' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37851'
                WHERE ordernumber = 'P201005162046268' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '216940'
                WHERE ordernumber = 'P181005162222506' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424304'
                WHERE ordernumber = 'P181005162306757' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297426'
                WHERE ordernumber = 'P201005162352620' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424306'
                WHERE ordernumber = 'P421005162438908' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297426'
                WHERE ordernumber = 'P201005162612421' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280256'
                WHERE ordernumber = 'P181005162618609' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424309'
                WHERE ordernumber = 'P421005163015506' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424307'
                WHERE ordernumber = 'P181005163017449' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357058'
                WHERE ordernumber = 'P181005163229585' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '134008'
                WHERE ordernumber = 'P731005163247170' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349269'
                WHERE ordernumber = 'P421005163331754' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424308'
                WHERE ordernumber = 'P181005163425143' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424311'
                WHERE ordernumber = 'P711005163449169' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424313'
                WHERE ordernumber = 'P711005163606819' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424310'
                WHERE ordernumber = 'P421005163614834' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424314'
                WHERE ordernumber = 'P201005163753991' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424312'
                WHERE ordernumber = 'P181005164057817' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424315'
                WHERE ordernumber = 'P731005164233420' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306952'
                WHERE ordernumber = 'P181005164254454' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424262'
                WHERE ordernumber = 'P201005164328659' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P421005164400720' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267490'
                WHERE ordernumber = 'P181005164428734' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424317'
                WHERE ordernumber = 'P421005164838992' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P201005165009492' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315852'
                WHERE ordernumber = 'P421005165103294' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164918'
                WHERE ordernumber = 'P181005165319578' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399286'
                WHERE ordernumber = 'P181005165358511' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424316'
                WHERE ordernumber = 'P181005165539266' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292182'
                WHERE ordernumber = 'P421005165801362' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270078'
                WHERE ordernumber = 'P201005165916585' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424318'
                WHERE ordernumber = 'P421005170020431' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135329'
                WHERE ordernumber = 'P201005170024962' 
            
2024-10-06 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135329'
                WHERE ordernumber = 'P201005170111870' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424139'
                WHERE ordernumber = 'P181005170201163' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424319'
                WHERE ordernumber = 'P201005170222386' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424320'
                WHERE ordernumber = 'P711005170421908' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167857'
                WHERE ordernumber = 'P181005170453975' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424321'
                WHERE ordernumber = 'P421005170552293' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424322'
                WHERE ordernumber = 'P421005171116221' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424323'
                WHERE ordernumber = 'P711005171217796' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424324'
                WHERE ordernumber = 'P181005171404346' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423830'
                WHERE ordernumber = 'P201005171535180' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '97994'
                WHERE ordernumber = 'P201005171725178' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424325'
                WHERE ordernumber = 'P421005171811326' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424324'
                WHERE ordernumber = 'P181005172053604' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424326'
                WHERE ordernumber = 'P421005172226507' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424327'
                WHERE ordernumber = 'P421005172254332' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '114576'
                WHERE ordernumber = 'P181005172447458' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424328'
                WHERE ordernumber = 'P421005172556526' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424330'
                WHERE ordernumber = 'P731005172938897' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '374653'
                WHERE ordernumber = 'P201005172957630' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424329'
                WHERE ordernumber = 'P421005173009730' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424331'
                WHERE ordernumber = 'P421005173118135' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329666'
                WHERE ordernumber = 'P181005173207584' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424332'
                WHERE ordernumber = 'P421005173223542' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276877'
                WHERE ordernumber = 'P201005173247406' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424332'
                WHERE ordernumber = 'P421005173252399' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424333'
                WHERE ordernumber = 'P181005173408762' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '287188'
                WHERE ordernumber = 'P191005173440861' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '223553'
                WHERE ordernumber = 'P201005173610415' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '124054'
                WHERE ordernumber = 'P201005173928836' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424336'
                WHERE ordernumber = 'P711005174052141' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424334'
                WHERE ordernumber = 'P421005174136785' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424335'
                WHERE ordernumber = 'P421005174158452' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '279417'
                WHERE ordernumber = 'P421005174240507' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '216128'
                WHERE ordernumber = 'P181005174406421' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424337'
                WHERE ordernumber = 'P201005174414930' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392880'
                WHERE ordernumber = 'P181005174659620' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '210151'
                WHERE ordernumber = 'P731005174830441' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424339'
                WHERE ordernumber = 'P421005174909564' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424340'
                WHERE ordernumber = 'P181005174912403' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '244547'
                WHERE ordernumber = 'P201005175402309' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424343'
                WHERE ordernumber = 'P201005175549239' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347114'
                WHERE ordernumber = 'P421005175810559' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '394397'
                WHERE ordernumber = 'P201005175817366' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424341'
                WHERE ordernumber = 'P181005175901396' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424344'
                WHERE ordernumber = 'P201005175933560' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424342'
                WHERE ordernumber = 'P181005180031379' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '338408'
                WHERE ordernumber = 'P181005180158877' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '64226'
                WHERE ordernumber = 'P421005180431815' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424345'
                WHERE ordernumber = 'P421005180519692' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424346'
                WHERE ordernumber = 'P181005180736516' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424347'
                WHERE ordernumber = 'P421005180740444' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424349'
                WHERE ordernumber = 'P181005180850182' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424349'
                WHERE ordernumber = 'P181005181214423' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424351'
                WHERE ordernumber = 'P201005181236614' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '253301'
                WHERE ordernumber = 'P421005181347784' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424352'
                WHERE ordernumber = 'P201005181442138' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '270861'
                WHERE ordernumber = 'P201005181537876' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424348'
                WHERE ordernumber = 'P421005181652532' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424348'
                WHERE ordernumber = 'P421005181823994' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424353'
                WHERE ordernumber = 'P181005181901143' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '336197'
                WHERE ordernumber = 'P181005182044901' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424128'
                WHERE ordernumber = 'P181005182157729' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424354'
                WHERE ordernumber = 'P191005182245404' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424356'
                WHERE ordernumber = 'P731005182450936' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424357'
                WHERE ordernumber = 'P181005182533647' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '130866'
                WHERE ordernumber = 'P711005182807799' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P201005182847879' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424359'
                WHERE ordernumber = 'P181005182946156' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424360'
                WHERE ordernumber = 'P181005183053349' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424362'
                WHERE ordernumber = 'P181005183321151' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424364'
                WHERE ordernumber = 'P181005183548987' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '167846'
                WHERE ordernumber = 'P191005183625589' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424361'
                WHERE ordernumber = 'P201005183807939' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424363'
                WHERE ordernumber = 'P191005183853303' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '349295'
                WHERE ordernumber = 'P201005184022598' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424366'
                WHERE ordernumber = 'P421005185123189' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '423045'
                WHERE ordernumber = 'P201005185226369' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401896'
                WHERE ordernumber = 'P421005185312612' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424367'
                WHERE ordernumber = 'P731005185541359' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424368'
                WHERE ordernumber = 'P731005185814724' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '417394'
                WHERE ordernumber = 'P421005185939839' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '421268'
                WHERE ordernumber = 'P201005190802875' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '352456'
                WHERE ordernumber = 'P191005190806346' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424369'
                WHERE ordernumber = 'P631005191051386' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424370'
                WHERE ordernumber = 'P201005191130213' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '210125'
                WHERE ordernumber = 'P201005192009262' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '240539'
                WHERE ordernumber = 'P731005192248262' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424290'
                WHERE ordernumber = 'P191005193106395' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '385618'
                WHERE ordernumber = 'P201005193453994' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '79805'
                WHERE ordernumber = 'P731005193516488' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '383410'
                WHERE ordernumber = 'P711005193806308' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424374'
                WHERE ordernumber = 'P191005193808897' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424373'
                WHERE ordernumber = 'P191005194027793' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '361280'
                WHERE ordernumber = 'P201005194602380' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424378'
                WHERE ordernumber = 'P711005195558572' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424380'
                WHERE ordernumber = 'P631005202343880' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '110046'
                WHERE ordernumber = 'P591005211135194' 
            
2024-10-06 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '424384'
                WHERE ordernumber = 'P711005215230914'