2024-05-10 01:00:01 -- 將會員中心id寫入data-lake
2024-05-10 01:00:01 -- 
            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-05-09%';
        
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389051'
                WHERE ordernumber = 'P630509100230822' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389054'
                WHERE ordernumber = 'P630509102453312' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389057'
                WHERE ordernumber = 'P630509104231943' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283503'
                WHERE ordernumber = 'P630509105642567' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339374'
                WHERE ordernumber = 'P180509110400280' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389061'
                WHERE ordernumber = 'P630509110411670' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389060'
                WHERE ordernumber = 'P200509110432899' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '713'
                WHERE ordernumber = 'P190509110501274' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389063'
                WHERE ordernumber = 'P190509110749252' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389064'
                WHERE ordernumber = 'P180509110752380' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100914'
                WHERE ordernumber = 'P200509110758733' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389065'
                WHERE ordernumber = 'P190509110942853' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389065'
                WHERE ordernumber = 'P190509111012382' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307996'
                WHERE ordernumber = 'P180509111014336' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '123913'
                WHERE ordernumber = 'P190509111114895' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '371428'
                WHERE ordernumber = 'P630509111852979' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389066'
                WHERE ordernumber = 'P420509111949669' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385355'
                WHERE ordernumber = 'P200509112102745' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389067'
                WHERE ordernumber = 'P180509112152841' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389070'
                WHERE ordernumber = 'P200509112543647' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389036'
                WHERE ordernumber = 'P790509112628523' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389071'
                WHERE ordernumber = 'P420509112826726' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353559'
                WHERE ordernumber = 'P180509112919123' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '314818'
                WHERE ordernumber = 'P180509113212717' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389073'
                WHERE ordernumber = 'P630509113459155' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389074'
                WHERE ordernumber = 'P190509113706546' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389075'
                WHERE ordernumber = 'P200509113939495' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389073'
                WHERE ordernumber = 'P630509114012645' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300621'
                WHERE ordernumber = 'P200509114024523' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '194532'
                WHERE ordernumber = 'P190509114431111' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246060'
                WHERE ordernumber = 'P190509114807899' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381315'
                WHERE ordernumber = 'P420509114910657' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389076'
                WHERE ordernumber = 'P420509115304286' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212232'
                WHERE ordernumber = 'P190509115446951' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389077'
                WHERE ordernumber = 'P190509115644207' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389078'
                WHERE ordernumber = 'P180509115830551' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '363488'
                WHERE ordernumber = 'P180509120957393' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '176426'
                WHERE ordernumber = 'P630509121220384' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '225765'
                WHERE ordernumber = 'P180509121515556' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127781'
                WHERE ordernumber = 'P200509121606215' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389081'
                WHERE ordernumber = 'P180509121700479' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '114985'
                WHERE ordernumber = 'P180509121800716' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388458'
                WHERE ordernumber = 'P790509121832610' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389082'
                WHERE ordernumber = 'P200509121945692' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163291'
                WHERE ordernumber = 'P200509122017569' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251909'
                WHERE ordernumber = 'P420509122330892' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '346672'
                WHERE ordernumber = 'P420509122429126' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107261'
                WHERE ordernumber = 'P200509122433948' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324266'
                WHERE ordernumber = 'P180509122621368' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389083'
                WHERE ordernumber = 'P180509122948858' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389084'
                WHERE ordernumber = 'P630509122958403' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389085'
                WHERE ordernumber = 'P200509123109347' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285539'
                WHERE ordernumber = 'P180509123138385' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389087'
                WHERE ordernumber = 'P180509123358879' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389086'
                WHERE ordernumber = 'P200509123606485' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389089'
                WHERE ordernumber = 'P200509124216537' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216410'
                WHERE ordernumber = 'P200509124405769' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389088'
                WHERE ordernumber = 'P200509124511642' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113960'
                WHERE ordernumber = 'P180509124523995' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389091'
                WHERE ordernumber = 'P200509124610246' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388638'
                WHERE ordernumber = 'P200509124837673' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389092'
                WHERE ordernumber = 'P200509124922639' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '57696'
                WHERE ordernumber = 'P630509125229216' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389093'
                WHERE ordernumber = 'P200509125250135' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389095'
                WHERE ordernumber = 'P200509125800879' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389094'
                WHERE ordernumber = 'P630509125809536' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90618'
                WHERE ordernumber = 'P200509130655569' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385967'
                WHERE ordernumber = 'P630509131503853' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389097'
                WHERE ordernumber = 'P630509131632246' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336612'
                WHERE ordernumber = 'P200509131838555' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389098'
                WHERE ordernumber = 'P630509132033579' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301326'
                WHERE ordernumber = 'P200509132207311' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389100'
                WHERE ordernumber = 'P630509132320389' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389099'
                WHERE ordernumber = 'P630509132334545' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389101'
                WHERE ordernumber = 'P200509132343607' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389104'
                WHERE ordernumber = 'P630509133454490' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '75630'
                WHERE ordernumber = 'P200509133740750' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258889'
                WHERE ordernumber = 'P180509133831304' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295620'
                WHERE ordernumber = 'P200509134130769' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381992'
                WHERE ordernumber = 'P420509134427391' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93434'
                WHERE ordernumber = 'P790509134734367' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389106'
                WHERE ordernumber = 'P630509134759747' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '52467'
                WHERE ordernumber = 'P200509135029121' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276029'
                WHERE ordernumber = 'P180509135226354' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '256216'
                WHERE ordernumber = 'P180509135531310' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389107'
                WHERE ordernumber = 'P180509135930292' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389108'
                WHERE ordernumber = 'P420509140317136' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389109'
                WHERE ordernumber = 'P630509140547211' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296542'
                WHERE ordernumber = 'P180509141515806' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '318317'
                WHERE ordernumber = 'P420509141738146' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389111'
                WHERE ordernumber = 'P200509142045439' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '260383'
                WHERE ordernumber = 'P200509142149781' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389112'
                WHERE ordernumber = 'P200509142320193' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389112'
                WHERE ordernumber = 'P200509142406708' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389114'
                WHERE ordernumber = 'P180509142516735' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '291748'
                WHERE ordernumber = 'P200509142929920' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389115'
                WHERE ordernumber = 'P180509143035705' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222355'
                WHERE ordernumber = 'P180509143132917' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389117'
                WHERE ordernumber = 'P200509143311264' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389116'
                WHERE ordernumber = 'P180509143324183' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389119'
                WHERE ordernumber = 'P200509143706131' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302844'
                WHERE ordernumber = 'P200509144113221' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316128'
                WHERE ordernumber = 'P200509144343265' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389121'
                WHERE ordernumber = 'P180509144604432' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389122'
                WHERE ordernumber = 'P180509145008788' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389123'
                WHERE ordernumber = 'P200509145210691' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223476'
                WHERE ordernumber = 'P180509145549427' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283503'
                WHERE ordernumber = 'P630509150024587' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248874'
                WHERE ordernumber = 'P180509150107672' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389127'
                WHERE ordernumber = 'P200509151017312' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385060'
                WHERE ordernumber = 'P190509151138742' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389128'
                WHERE ordernumber = 'P190509151246796' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389129'
                WHERE ordernumber = 'P180509151605198' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298277'
                WHERE ordernumber = 'P190509151757436' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389131'
                WHERE ordernumber = 'P200509152226649' 
            
2024-05-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212352'
                WHERE ordernumber = 'P180509152231997' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351790'
                WHERE ordernumber = 'P630509152256495' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378577'
                WHERE ordernumber = 'P420509152528887' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389132'
                WHERE ordernumber = 'P190509152703115' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389133'
                WHERE ordernumber = 'P190509153110615' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64226'
                WHERE ordernumber = 'P420509153246338' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389134'
                WHERE ordernumber = 'P190509153407299' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384058'
                WHERE ordernumber = 'P590509153855442' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389135'
                WHERE ordernumber = 'P420509154059257' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389136'
                WHERE ordernumber = 'P190509154141887' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389137'
                WHERE ordernumber = 'P420509154206590' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389138'
                WHERE ordernumber = 'P190509154306339' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389139'
                WHERE ordernumber = 'P200509154324588' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389140'
                WHERE ordernumber = 'P630509154642950' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389142'
                WHERE ordernumber = 'P630509154752896' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389141'
                WHERE ordernumber = 'P200509154804667' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304589'
                WHERE ordernumber = 'P200509154909829' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217480'
                WHERE ordernumber = 'P190509155110427' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389143'
                WHERE ordernumber = 'P200509155601774' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389144'
                WHERE ordernumber = 'P420509155739830' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277595'
                WHERE ordernumber = 'P420509155904419' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237209'
                WHERE ordernumber = 'P180509160133281' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318257'
                WHERE ordernumber = 'P200509160215360' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342058'
                WHERE ordernumber = 'P420509160516272' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389145'
                WHERE ordernumber = 'P630509160558984' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377580'
                WHERE ordernumber = 'P420509160623476' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389146'
                WHERE ordernumber = 'P200509161056633' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '159621'
                WHERE ordernumber = 'P200509161133369' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364145'
                WHERE ordernumber = 'P190509161234149' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389147'
                WHERE ordernumber = 'P180509161443535' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '173552'
                WHERE ordernumber = 'P180509161809173' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346545'
                WHERE ordernumber = 'P180509161852474' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363024'
                WHERE ordernumber = 'P200509162038290' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389148'
                WHERE ordernumber = 'P180509162134433' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298036'
                WHERE ordernumber = 'P420509162206557' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290408'
                WHERE ordernumber = 'P180509162715247' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221996'
                WHERE ordernumber = 'P200509162719543' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P180509163019118' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348934'
                WHERE ordernumber = 'P200509163111160' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389149'
                WHERE ordernumber = 'P420509163120846' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389152'
                WHERE ordernumber = 'P630509163238300' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389153'
                WHERE ordernumber = 'P200509163337969' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389154'
                WHERE ordernumber = 'P180509163445679' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303586'
                WHERE ordernumber = 'P180509163548977' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389155'
                WHERE ordernumber = 'P630509163609445' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389157'
                WHERE ordernumber = 'P630509163819505' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389158'
                WHERE ordernumber = 'P200509163854736' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388814'
                WHERE ordernumber = 'P420509164648946' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251950'
                WHERE ordernumber = 'P200509164845154' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389160'
                WHERE ordernumber = 'P200509165027605' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389161'
                WHERE ordernumber = 'P180509165047155' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240198'
                WHERE ordernumber = 'P200509165117370' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389162'
                WHERE ordernumber = 'P190509165206871' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249541'
                WHERE ordernumber = 'P190509165410831' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389163'
                WHERE ordernumber = 'P180509165501188' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389165'
                WHERE ordernumber = 'P190509165548643' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389166'
                WHERE ordernumber = 'P200509165701911' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389164'
                WHERE ordernumber = 'P180509165701487' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389168'
                WHERE ordernumber = 'P180509170300572' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282647'
                WHERE ordernumber = 'P420509170307181' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389169'
                WHERE ordernumber = 'P190509170651699' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160309'
                WHERE ordernumber = 'P630509170846641' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386268'
                WHERE ordernumber = 'P180509171257941' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276720'
                WHERE ordernumber = 'P200509172153650' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389171'
                WHERE ordernumber = 'P200509173114783' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389172'
                WHERE ordernumber = 'P420509173315948' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118180'
                WHERE ordernumber = 'P180509173644581' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389173'
                WHERE ordernumber = 'P180509173833588' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389174'
                WHERE ordernumber = 'P420509173948162' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160627'
                WHERE ordernumber = 'P200509174323600' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287807'
                WHERE ordernumber = 'P420509174511260' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389175'
                WHERE ordernumber = 'P420509174733373' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375446'
                WHERE ordernumber = 'P630509174735826' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247445'
                WHERE ordernumber = 'P200509174843241' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250174'
                WHERE ordernumber = 'P200509175308397' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252231'
                WHERE ordernumber = 'P180509175347784' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389176'
                WHERE ordernumber = 'P420509175458534' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318780'
                WHERE ordernumber = 'P630509175500325' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389178'
                WHERE ordernumber = 'P180509175506935' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389177'
                WHERE ordernumber = 'P630509175522512' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389179'
                WHERE ordernumber = 'P200509175542422' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345943'
                WHERE ordernumber = 'P420509175705948' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389180'
                WHERE ordernumber = 'P180509175721752' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389181'
                WHERE ordernumber = 'P630509175911156' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352257'
                WHERE ordernumber = 'P200509180224368' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389183'
                WHERE ordernumber = 'P200509180251439' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101572'
                WHERE ordernumber = 'P200509180804628' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389184'
                WHERE ordernumber = 'P190509180933549' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354511'
                WHERE ordernumber = 'P790509181031754' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389185'
                WHERE ordernumber = 'P190509181151865' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '140649'
                WHERE ordernumber = 'P180509181207434' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348787'
                WHERE ordernumber = 'P200509181225454' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389187'
                WHERE ordernumber = 'P190509181331153' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '41841'
                WHERE ordernumber = 'P630509181443773' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389188'
                WHERE ordernumber = 'P420509181723399' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389189'
                WHERE ordernumber = 'P180509181745673' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389190'
                WHERE ordernumber = 'P180509181939295' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356414'
                WHERE ordernumber = 'P200509182017397' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389191'
                WHERE ordernumber = 'P180509182231800' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229200'
                WHERE ordernumber = 'P180509182415208' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389192'
                WHERE ordernumber = 'P180509182725355' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389193'
                WHERE ordernumber = 'P180509182823443' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347557'
                WHERE ordernumber = 'P200509182919200' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348464'
                WHERE ordernumber = 'P180509182945874' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297145'
                WHERE ordernumber = 'P420509183217723' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389194'
                WHERE ordernumber = 'P630509183302441' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253431'
                WHERE ordernumber = 'P200509183852216' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '6653'
                WHERE ordernumber = 'P180509184050652' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389195'
                WHERE ordernumber = 'P180509184352871' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119612'
                WHERE ordernumber = 'P180509184519308' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389196'
                WHERE ordernumber = 'P180509184652849' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138580'
                WHERE ordernumber = 'P180509184833672' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348265'
                WHERE ordernumber = 'P420509184952132' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369277'
                WHERE ordernumber = 'P180509185027591' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314728'
                WHERE ordernumber = 'P420509185034700' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389197'
                WHERE ordernumber = 'P200509185206535' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389198'
                WHERE ordernumber = 'P180509185354643' 
            
2024-05-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365315'
                WHERE ordernumber = 'P180509185423333' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236433'
                WHERE ordernumber = 'P420509185430845' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389196'
                WHERE ordernumber = 'P190509185931311' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389199'
                WHERE ordernumber = 'P200509190252355' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388909'
                WHERE ordernumber = 'P200509190341389' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '268619'
                WHERE ordernumber = 'P200509190539394' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328235'
                WHERE ordernumber = 'P420509190647396' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389200'
                WHERE ordernumber = 'P630509190719332' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389201'
                WHERE ordernumber = 'P190509191023653' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200509191203380' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97763'
                WHERE ordernumber = 'P190509191332318' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344320'
                WHERE ordernumber = 'P420509191431206' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389202'
                WHERE ordernumber = 'P200509191455520' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258546'
                WHERE ordernumber = 'P200509191732554' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389203'
                WHERE ordernumber = 'P200509191829727' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389205'
                WHERE ordernumber = 'P200509192042682' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389204'
                WHERE ordernumber = 'P630509192314858' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389206'
                WHERE ordernumber = 'P190509192547698' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389207'
                WHERE ordernumber = 'P200509192631884' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232492'
                WHERE ordernumber = 'P200509192759623' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389208'
                WHERE ordernumber = 'P190509192835785' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389209'
                WHERE ordernumber = 'P190509193038391' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287702'
                WHERE ordernumber = 'P190509193619420' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '293946'
                WHERE ordernumber = 'P190509193740240' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389212'
                WHERE ordernumber = 'P190509194433617' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389211'
                WHERE ordernumber = 'P200509194507521' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389211'
                WHERE ordernumber = 'P200509194538915' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383097'
                WHERE ordernumber = 'P420509194626266' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389213'
                WHERE ordernumber = 'P190509194659713' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389034'
                WHERE ordernumber = 'P630509194842229' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96428'
                WHERE ordernumber = 'P190509195143536' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346691'
                WHERE ordernumber = 'P200509195201983' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '71715'
                WHERE ordernumber = 'P190509195346510' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389214'
                WHERE ordernumber = 'P200509195422152' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301080'
                WHERE ordernumber = 'P200509195912811' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301080'
                WHERE ordernumber = 'P200509195929949' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389219'
                WHERE ordernumber = 'P630509204416303' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389220'
                WHERE ordernumber = 'P790509205452955' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312770'
                WHERE ordernumber = 'P790509210617745' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339782'
                WHERE ordernumber = 'P790509211154342' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389223'
                WHERE ordernumber = 'P790509212308650' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389224'
                WHERE ordernumber = 'P790509213549236' 
            
2024-05-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389225'
                WHERE ordernumber = 'P790509214603304'