2024-10-21 01:00:02 -- 將會員中心id寫入data-lake
2024-10-21 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-20%';
        
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426752'
                WHERE ordernumber = 'P181020110342328' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '413457'
                WHERE ordernumber = 'P421020110425528' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248399'
                WHERE ordernumber = 'P191020110438549' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417256'
                WHERE ordernumber = 'P421020110647655' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426753'
                WHERE ordernumber = 'P181020110852270' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257823'
                WHERE ordernumber = 'P201020111034632' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344219'
                WHERE ordernumber = 'P181020111059409' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426754'
                WHERE ordernumber = 'P421020111318499' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348106'
                WHERE ordernumber = 'P201020111827253' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426756'
                WHERE ordernumber = 'P421020112037241' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426757'
                WHERE ordernumber = 'P181020112511267' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161168'
                WHERE ordernumber = 'P631020112810172' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426758'
                WHERE ordernumber = 'P181020113354453' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108125'
                WHERE ordernumber = 'P181020113534125' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426760'
                WHERE ordernumber = 'P201020113835786' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380615'
                WHERE ordernumber = 'P201020114006420' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415337'
                WHERE ordernumber = 'P181020114013835' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347520'
                WHERE ordernumber = 'P191020114118377' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '138142'
                WHERE ordernumber = 'P201020114213611' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426761'
                WHERE ordernumber = 'P181020114223157' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353236'
                WHERE ordernumber = 'P181020114858214' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353236'
                WHERE ordernumber = 'P181020114941549' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426762'
                WHERE ordernumber = 'P421020114945792' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426763'
                WHERE ordernumber = 'P421020115305557' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283028'
                WHERE ordernumber = 'P421020115412983' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238986'
                WHERE ordernumber = 'P181020115700708' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '155896'
                WHERE ordernumber = 'P201020120203323' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209380'
                WHERE ordernumber = 'P181020120330983' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426765'
                WHERE ordernumber = 'P191020120507394' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426766'
                WHERE ordernumber = 'P771020121343613' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P201020121636466' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425598'
                WHERE ordernumber = 'P181020121643790' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262644'
                WHERE ordernumber = 'P201020122409715' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426769'
                WHERE ordernumber = 'P181020123438285' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426771'
                WHERE ordernumber = 'P181020123723278' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426631'
                WHERE ordernumber = 'P201020123922265' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426631'
                WHERE ordernumber = 'P201020124015701' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426772'
                WHERE ordernumber = 'P711020124122345' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426770'
                WHERE ordernumber = 'P181020124343184' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259713'
                WHERE ordernumber = 'P201020125037302' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426774'
                WHERE ordernumber = 'P421020125230599' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426773'
                WHERE ordernumber = 'P771020125252231' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426777'
                WHERE ordernumber = 'P771020125755574' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '217662'
                WHERE ordernumber = 'P771020125942418' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426778'
                WHERE ordernumber = 'P181020130017794' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426776'
                WHERE ordernumber = 'P181020130209918' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93611'
                WHERE ordernumber = 'P771020130216599' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426776'
                WHERE ordernumber = 'P181020130259730' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426779'
                WHERE ordernumber = 'P421020131113454' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286388'
                WHERE ordernumber = 'P201020131606236' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426782'
                WHERE ordernumber = 'P771020131700724' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426784'
                WHERE ordernumber = 'P181020131739753' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97170'
                WHERE ordernumber = 'P191020132416687' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285070'
                WHERE ordernumber = 'P181020132418294' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426785'
                WHERE ordernumber = 'P201020132759199' 
            
2024-10-21 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426767'
                WHERE ordernumber = 'P201020132907693' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387164'
                WHERE ordernumber = 'P711020133035541' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305438'
                WHERE ordernumber = 'P181020133133969' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426786'
                WHERE ordernumber = 'P181020133153257' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '28794'
                WHERE ordernumber = 'P421020133853640' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P201020133928763' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324599'
                WHERE ordernumber = 'P191020134139940' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426787'
                WHERE ordernumber = 'P191020134355489' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303690'
                WHERE ordernumber = 'P201020135240111' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426788'
                WHERE ordernumber = 'P191020135315735' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426789'
                WHERE ordernumber = 'P191020135452849' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426790'
                WHERE ordernumber = 'P191020135822923' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426791'
                WHERE ordernumber = 'P421020140326761' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421593'
                WHERE ordernumber = 'P731020140402487' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38901'
                WHERE ordernumber = 'P201020140416211' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426792'
                WHERE ordernumber = 'P191020140453434' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426793'
                WHERE ordernumber = 'P201020140514702' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426794'
                WHERE ordernumber = 'P421020140803727' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426796'
                WHERE ordernumber = 'P191020141050334' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112007'
                WHERE ordernumber = 'P191020141204658' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426797'
                WHERE ordernumber = 'P631020141351270' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426781'
                WHERE ordernumber = 'P421020141428957' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426801'
                WHERE ordernumber = 'P181020141549998' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426798'
                WHERE ordernumber = 'P421020141613504' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426799'
                WHERE ordernumber = 'P711020141726730' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426800'
                WHERE ordernumber = 'P421020141810338' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426803'
                WHERE ordernumber = 'P711020141937625' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426802'
                WHERE ordernumber = 'P771020142156331' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426804'
                WHERE ordernumber = 'P421020142344863' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285964'
                WHERE ordernumber = 'P181020142501627' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425746'
                WHERE ordernumber = 'P711020142503832' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426795'
                WHERE ordernumber = 'P191020142822537' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346169'
                WHERE ordernumber = 'P201020143019318' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346169'
                WHERE ordernumber = 'P201020143102391' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348596'
                WHERE ordernumber = 'P201020143240964' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426806'
                WHERE ordernumber = 'P181020143710470' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426807'
                WHERE ordernumber = 'P711020143812625' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P181020144121997' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426809'
                WHERE ordernumber = 'P731020144123885' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426808'
                WHERE ordernumber = 'P711020144303814' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422715'
                WHERE ordernumber = 'P421020144938876' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426810'
                WHERE ordernumber = 'P771020145055648' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426811'
                WHERE ordernumber = 'P711020145134848' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396134'
                WHERE ordernumber = 'P201020145247598' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255693'
                WHERE ordernumber = 'P771020145252228' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426812'
                WHERE ordernumber = 'P421020145354862' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412290'
                WHERE ordernumber = 'P421020145533504' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410336'
                WHERE ordernumber = 'P201020145603813' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300327'
                WHERE ordernumber = 'P181020145914550' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364633'
                WHERE ordernumber = 'P421020145942172' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426813'
                WHERE ordernumber = 'P201020150106867' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172504'
                WHERE ordernumber = 'P711020150419628' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426816'
                WHERE ordernumber = 'P181020150545233' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426814'
                WHERE ordernumber = 'P711020150644733' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426815'
                WHERE ordernumber = 'P181020150702160' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426817'
                WHERE ordernumber = 'P201020150943344' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387244'
                WHERE ordernumber = 'P181020151333884' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218039'
                WHERE ordernumber = 'P201020151351612' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426820'
                WHERE ordernumber = 'P181020151854902' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426818'
                WHERE ordernumber = 'P181020152115477' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374004'
                WHERE ordernumber = 'P421020152246248' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296292'
                WHERE ordernumber = 'P201020152319523' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377920'
                WHERE ordernumber = 'P421020152401805' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173422'
                WHERE ordernumber = 'P771020152433158' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426821'
                WHERE ordernumber = 'P421020152502597' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426822'
                WHERE ordernumber = 'P201020152638654' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426824'
                WHERE ordernumber = 'P181020152729869' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273849'
                WHERE ordernumber = 'P771020152743514' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338473'
                WHERE ordernumber = 'P771020152859410' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426532'
                WHERE ordernumber = 'P771020153202211' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426825'
                WHERE ordernumber = 'P201020153345667' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319084'
                WHERE ordernumber = 'P711020153356247' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426826'
                WHERE ordernumber = 'P201020153635738' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310371'
                WHERE ordernumber = 'P181020153654650' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422806'
                WHERE ordernumber = 'P421020153707434' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426827'
                WHERE ordernumber = 'P421020153930327' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426828'
                WHERE ordernumber = 'P771020153950758' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426829'
                WHERE ordernumber = 'P201020153959282' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229506'
                WHERE ordernumber = 'P181020154239768' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426830'
                WHERE ordernumber = 'P421020154625248' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285398'
                WHERE ordernumber = 'P201020154633843' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426831'
                WHERE ordernumber = 'P421020154715139' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426834'
                WHERE ordernumber = 'P201020154732853' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426833'
                WHERE ordernumber = 'P711020154859746' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227909'
                WHERE ordernumber = 'P421020154906800' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426836'
                WHERE ordernumber = 'P181020155238211' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426835'
                WHERE ordernumber = 'P771020155313963' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426838'
                WHERE ordernumber = 'P771020160059550' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '396061'
                WHERE ordernumber = 'P201020160550884' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426840'
                WHERE ordernumber = 'P201020160812852' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392084'
                WHERE ordernumber = 'P201020160941985' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390888'
                WHERE ordernumber = 'P711020161509641' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315804'
                WHERE ordernumber = 'P201020161724917' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315804'
                WHERE ordernumber = 'P201020161937482' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426842'
                WHERE ordernumber = 'P421020162030485' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389210'
                WHERE ordernumber = 'P201020162143806' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426841'
                WHERE ordernumber = 'P181020162333547' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426843'
                WHERE ordernumber = 'P201020162424529' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425139'
                WHERE ordernumber = 'P181020162559784' 
            
2024-10-21 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426844'
                WHERE ordernumber = 'P731020162606150' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106791'
                WHERE ordernumber = 'P771020162840664' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130634'
                WHERE ordernumber = 'P711020163036566' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122981'
                WHERE ordernumber = 'P201020163415843' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '122981'
                WHERE ordernumber = 'P201020163810320' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426846'
                WHERE ordernumber = 'P181020163817476' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426849'
                WHERE ordernumber = 'P421020163956459' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426846'
                WHERE ordernumber = 'P181020164026481' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423577'
                WHERE ordernumber = 'P201020164033911' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426850'
                WHERE ordernumber = 'P191020164552645' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426853'
                WHERE ordernumber = 'P181020164803681' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426854'
                WHERE ordernumber = 'P421020164819239' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426852'
                WHERE ordernumber = 'P771020164849238' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '405212'
                WHERE ordernumber = 'P421020164855514' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426851'
                WHERE ordernumber = 'P771020165035580' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426856'
                WHERE ordernumber = 'P421020165134696' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426855'
                WHERE ordernumber = 'P771020165143551' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426858'
                WHERE ordernumber = 'P771020165347165' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402002'
                WHERE ordernumber = 'P201020165422352' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396439'
                WHERE ordernumber = 'P181020165509634' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423700'
                WHERE ordernumber = 'P711020165554721' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426857'
                WHERE ordernumber = 'P421020165642209' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426859'
                WHERE ordernumber = 'P201020165722256' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426845'
                WHERE ordernumber = 'P421020165732166' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426860'
                WHERE ordernumber = 'P421020165930732' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426864'
                WHERE ordernumber = 'P201020170130689' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426862'
                WHERE ordernumber = 'P421020170200265' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426861'
                WHERE ordernumber = 'P421020170323626' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426863'
                WHERE ordernumber = 'P191020170325756' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293902'
                WHERE ordernumber = 'P771020170445318' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426865'
                WHERE ordernumber = 'P771020170707516' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '30022'
                WHERE ordernumber = 'P421020171113519' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291095'
                WHERE ordernumber = 'P771020171125239' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401315'
                WHERE ordernumber = 'P181020171250134' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426866'
                WHERE ordernumber = 'P771020171410835' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348805'
                WHERE ordernumber = 'P421020171456488' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348805'
                WHERE ordernumber = 'P421020171550608' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426867'
                WHERE ordernumber = 'P771020171642465' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426868'
                WHERE ordernumber = 'P421020171646248' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426869'
                WHERE ordernumber = 'P771020171949272' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337605'
                WHERE ordernumber = 'P421020172000669' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158915'
                WHERE ordernumber = 'P181020172456295' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426870'
                WHERE ordernumber = 'P421020172646113' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426871'
                WHERE ordernumber = 'P181020172726209' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426870'
                WHERE ordernumber = 'P421020172737798' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396477'
                WHERE ordernumber = 'P421020172900826' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426872'
                WHERE ordernumber = 'P421020172948470' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276686'
                WHERE ordernumber = 'P631020173250195' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426873'
                WHERE ordernumber = 'P771020173342664' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306785'
                WHERE ordernumber = 'P421020173457423' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121146'
                WHERE ordernumber = 'P181020173622817' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426877'
                WHERE ordernumber = 'P771020173704241' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426878'
                WHERE ordernumber = 'P771020173823709' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426874'
                WHERE ordernumber = 'P771020174020646' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426881'
                WHERE ordernumber = 'P771020174114453' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426882'
                WHERE ordernumber = 'P181020174308134' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426882'
                WHERE ordernumber = 'P181020174325663' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292269'
                WHERE ordernumber = 'P771020174332681' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '394822'
                WHERE ordernumber = 'P421020174449877' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426875'
                WHERE ordernumber = 'P771020174706501' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426883'
                WHERE ordernumber = 'P201020175125676' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425195'
                WHERE ordernumber = 'P421020175349707' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426884'
                WHERE ordernumber = 'P421020175611869' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '222946'
                WHERE ordernumber = 'P181020175819183' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426885'
                WHERE ordernumber = 'P421020180223208' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423921'
                WHERE ordernumber = 'P731020180357129' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426886'
                WHERE ordernumber = 'P711020180720445' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426888'
                WHERE ordernumber = 'P421020180757245' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '413647'
                WHERE ordernumber = 'P181020180823245' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426887'
                WHERE ordernumber = 'P421020180951894' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '411903'
                WHERE ordernumber = 'P201020181229560' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '264356'
                WHERE ordernumber = 'P771020181243788' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235524'
                WHERE ordernumber = 'P181020181505401' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426848'
                WHERE ordernumber = 'P201020181734799' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345090'
                WHERE ordernumber = 'P201020181834151' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '64852'
                WHERE ordernumber = 'P711020182014751' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426890'
                WHERE ordernumber = 'P201020182057663' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426891'
                WHERE ordernumber = 'P711020183208901' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426892'
                WHERE ordernumber = 'P201020183239908' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426893'
                WHERE ordernumber = 'P421020183549798' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426894'
                WHERE ordernumber = 'P711020183643116' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368215'
                WHERE ordernumber = 'P421020184222450' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426895'
                WHERE ordernumber = 'P191020184339771' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396115'
                WHERE ordernumber = 'P201020184411910' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426896'
                WHERE ordernumber = 'P191020184521712' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426897'
                WHERE ordernumber = 'P421020184845964' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426898'
                WHERE ordernumber = 'P421020185232838' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '115486'
                WHERE ordernumber = 'P191020185356825' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237075'
                WHERE ordernumber = 'P201020185553649' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426901'
                WHERE ordernumber = 'P711020185746520' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388932'
                WHERE ordernumber = 'P631020190034506' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426902'
                WHERE ordernumber = 'P771020191025129' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426903'
                WHERE ordernumber = 'P711020191146165' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426904'
                WHERE ordernumber = 'P201020192454704' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P191020193314664' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353749'
                WHERE ordernumber = 'P201020193345206' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426906'
                WHERE ordernumber = 'P201020193738248' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99721'
                WHERE ordernumber = 'P201020193852967' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426907'
                WHERE ordernumber = 'P711020193922578' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245514'
                WHERE ordernumber = 'P201020194236402' 
            
2024-10-21 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426908'
                WHERE ordernumber = 'P201020194556954' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '24070'
                WHERE ordernumber = 'P711020195724204' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '363438'
                WHERE ordernumber = 'P771020200915409' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426911'
                WHERE ordernumber = 'P591020201120498' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426915'
                WHERE ordernumber = 'P631020201718707' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426917'
                WHERE ordernumber = 'P771020204933855' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426920'
                WHERE ordernumber = 'P771020205916236' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426919'
                WHERE ordernumber = 'P771020210424362' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426921'
                WHERE ordernumber = 'P711020211226574' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426922'
                WHERE ordernumber = 'P771020212718652' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426923'
                WHERE ordernumber = 'P711020214137323' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426925'
                WHERE ordernumber = 'P771020215521867' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426926'
                WHERE ordernumber = 'P771020215715741' 
            
2024-10-21 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '426924'
                WHERE ordernumber = 'P771020215918498'