2024-05-19 01:00:02 -- 將會員中心id寫入data-lake
2024-05-19 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-05-18%';
        
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390534'
                WHERE ordernumber = 'P630518100912353' 
            
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '224004'
                WHERE ordernumber = 'P420518102320609' 
            
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390536'
                WHERE ordernumber = 'P420518104233857' 
            
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '351020'
                WHERE ordernumber = 'P190518110325805' 
            
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339016'
                WHERE ordernumber = 'P180518110401554' 
            
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227320'
                WHERE ordernumber = 'P630518110637657' 
            
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390539'
                WHERE ordernumber = 'P190518111640463' 
            
2024-05-19 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390540'
                WHERE ordernumber = 'P200518111835501' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249203'
                WHERE ordernumber = 'P180518111835314' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390541'
                WHERE ordernumber = 'P190518111902475' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386830'
                WHERE ordernumber = 'P190518112027800' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314146'
                WHERE ordernumber = 'P420518112251149' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '131880'
                WHERE ordernumber = 'P190518112255532' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142114'
                WHERE ordernumber = 'P200518112538197' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390542'
                WHERE ordernumber = 'P180518112615246' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390543'
                WHERE ordernumber = 'P200518112738158' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180518112753797' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214193'
                WHERE ordernumber = 'P190518112756631' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390544'
                WHERE ordernumber = 'P420518112807885' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280533'
                WHERE ordernumber = 'P200518113041679' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390546'
                WHERE ordernumber = 'P420518113419705' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387822'
                WHERE ordernumber = 'P420518113627943' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210229'
                WHERE ordernumber = 'P200518113719829' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390548'
                WHERE ordernumber = 'P200518113837134' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99126'
                WHERE ordernumber = 'P190518114813563' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390552'
                WHERE ordernumber = 'P180518114816310' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390553'
                WHERE ordernumber = 'P420518115000521' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307046'
                WHERE ordernumber = 'P180518115324335' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390549'
                WHERE ordernumber = 'P790518115347965' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390554'
                WHERE ordernumber = 'P420518115720667' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337863'
                WHERE ordernumber = 'P420518115916493' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390549'
                WHERE ordernumber = 'P790518115936440' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P420518120102590' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390555'
                WHERE ordernumber = 'P200518120244183' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390557'
                WHERE ordernumber = 'P420518120853548' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390558'
                WHERE ordernumber = 'P420518121027638' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82093'
                WHERE ordernumber = 'P180518121215404' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275764'
                WHERE ordernumber = 'P420518121256257' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82093'
                WHERE ordernumber = 'P180518121350403' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390559'
                WHERE ordernumber = 'P190518121358301' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366036'
                WHERE ordernumber = 'P420518121457334' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '43453'
                WHERE ordernumber = 'P200518122113452' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390561'
                WHERE ordernumber = 'P180518122348779' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390562'
                WHERE ordernumber = 'P200518122630169' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390560'
                WHERE ordernumber = 'P790518122940630' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111604'
                WHERE ordernumber = 'P200518123156909' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348622'
                WHERE ordernumber = 'P190518123239644' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390564'
                WHERE ordernumber = 'P200518123538601' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282087'
                WHERE ordernumber = 'P180518124417159' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390565'
                WHERE ordernumber = 'P420518124444928' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143180'
                WHERE ordernumber = 'P180518124604953' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390567'
                WHERE ordernumber = 'P790518124847541' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214148'
                WHERE ordernumber = 'P180518125036480' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379106'
                WHERE ordernumber = 'P180518125144975' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379106'
                WHERE ordernumber = 'P180518125318629' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98063'
                WHERE ordernumber = 'P200518125450410' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '258937'
                WHERE ordernumber = 'P180518125533339' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390568'
                WHERE ordernumber = 'P180518125705414' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122498'
                WHERE ordernumber = 'P180518125811967' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390569'
                WHERE ordernumber = 'P790518125843522' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390573'
                WHERE ordernumber = 'P420518125942746' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318049'
                WHERE ordernumber = 'P180518125951903' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390571'
                WHERE ordernumber = 'P790518130020644' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390574'
                WHERE ordernumber = 'P180518130233840' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221443'
                WHERE ordernumber = 'P200518130510615' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390577'
                WHERE ordernumber = 'P200518130724523' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264931'
                WHERE ordernumber = 'P200518130903608' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390579'
                WHERE ordernumber = 'P420518131053418' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390580'
                WHERE ordernumber = 'P200518131113515' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377791'
                WHERE ordernumber = 'P200518131152246' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390581'
                WHERE ordernumber = 'P790518131626681' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390582'
                WHERE ordernumber = 'P180518132024117' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286140'
                WHERE ordernumber = 'P180518132124354' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328733'
                WHERE ordernumber = 'P200518132423503' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390584'
                WHERE ordernumber = 'P420518132935929' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337356'
                WHERE ordernumber = 'P200518133139386' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245940'
                WHERE ordernumber = 'P200518133333358' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390587'
                WHERE ordernumber = 'P180518133936139' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '335401'
                WHERE ordernumber = 'P180518134148807' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390588'
                WHERE ordernumber = 'P420518134304143' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275770'
                WHERE ordernumber = 'P200518134323397' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167289'
                WHERE ordernumber = 'P200518134723785' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328314'
                WHERE ordernumber = 'P200518135108295' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390589'
                WHERE ordernumber = 'P200518135337149' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328314'
                WHERE ordernumber = 'P200518135459290' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390591'
                WHERE ordernumber = 'P630518135513646' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390590'
                WHERE ordernumber = 'P790518135547726' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118897'
                WHERE ordernumber = 'P180518135759430' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390592'
                WHERE ordernumber = 'P200518135822742' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '43704'
                WHERE ordernumber = 'P180518135837675' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390593'
                WHERE ordernumber = 'P180518140159497' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230607'
                WHERE ordernumber = 'P200518140425165' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390525'
                WHERE ordernumber = 'P180518140431114' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390594'
                WHERE ordernumber = 'P420518140543637' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382110'
                WHERE ordernumber = 'P200518140558901' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390594'
                WHERE ordernumber = 'P420518140709915' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390595'
                WHERE ordernumber = 'P180518140927491' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389628'
                WHERE ordernumber = 'P200518141140715' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390596'
                WHERE ordernumber = 'P420518141351928' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390597'
                WHERE ordernumber = 'P200518141436396' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390596'
                WHERE ordernumber = 'P420518141533291' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390599'
                WHERE ordernumber = 'P180518142348191' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390598'
                WHERE ordernumber = 'P790518142358730' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384635'
                WHERE ordernumber = 'P630518142554193' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337435'
                WHERE ordernumber = 'P180518142723847' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225215'
                WHERE ordernumber = 'P190518143358411' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213759'
                WHERE ordernumber = 'P180518143902392' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387738'
                WHERE ordernumber = 'P630518144237697' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390601'
                WHERE ordernumber = 'P420518144446577' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390602'
                WHERE ordernumber = 'P200518144520765' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268446'
                WHERE ordernumber = 'P200518144615960' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368550'
                WHERE ordernumber = 'P180518144653395' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390603'
                WHERE ordernumber = 'P420518144718287' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390604'
                WHERE ordernumber = 'P180518144812980' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328860'
                WHERE ordernumber = 'P420518145056229' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390608'
                WHERE ordernumber = 'P420518145526647' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345472'
                WHERE ordernumber = 'P790518145640265' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390610'
                WHERE ordernumber = 'P420518145825587' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390611'
                WHERE ordernumber = 'P180518145900275' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286388'
                WHERE ordernumber = 'P420518150028256' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322336'
                WHERE ordernumber = 'P420518150246332' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390612'
                WHERE ordernumber = 'P180518150412923' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390612'
                WHERE ordernumber = 'P180518150757350' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390613'
                WHERE ordernumber = 'P180518150941884' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390614'
                WHERE ordernumber = 'P180518151155417' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114533'
                WHERE ordernumber = 'P420518151201504' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390615'
                WHERE ordernumber = 'P420518151312691' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390617'
                WHERE ordernumber = 'P200518151848403' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388680'
                WHERE ordernumber = 'P420518151937601' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284117'
                WHERE ordernumber = 'P200518152432268' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390621'
                WHERE ordernumber = 'P790518152840520' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283028'
                WHERE ordernumber = 'P420518153020867' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281833'
                WHERE ordernumber = 'P190518153302140' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279146'
                WHERE ordernumber = 'P200518153635672' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390622'
                WHERE ordernumber = 'P420518153708188' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223917'
                WHERE ordernumber = 'P420518153939441' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390625'
                WHERE ordernumber = 'P420518154550827' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390620'
                WHERE ordernumber = 'P790518154648845' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '236420'
                WHERE ordernumber = 'P420518154727593' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390626'
                WHERE ordernumber = 'P420518154903333' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281763'
                WHERE ordernumber = 'P200518155057622' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293005'
                WHERE ordernumber = 'P180518155117713' 
            
2024-05-19 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390624'
                WHERE ordernumber = 'P200518155203169' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390620'
                WHERE ordernumber = 'P790518155211465' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390628'
                WHERE ordernumber = 'P180518155409270' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390627'
                WHERE ordernumber = 'P200518155538956' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390630'
                WHERE ordernumber = 'P420518155749267' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390631'
                WHERE ordernumber = 'P180518155835974' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377694'
                WHERE ordernumber = 'P420518155836922' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386197'
                WHERE ordernumber = 'P420518155922112' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '154381'
                WHERE ordernumber = 'P420518160135511' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390633'
                WHERE ordernumber = 'P420518160305485' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390632'
                WHERE ordernumber = 'P200518160610309' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304185'
                WHERE ordernumber = 'P200518160910706' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390634'
                WHERE ordernumber = 'P180518160932880' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81316'
                WHERE ordernumber = 'P180518161023620' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '338028'
                WHERE ordernumber = 'P420518161300651' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390636'
                WHERE ordernumber = 'P180518161317557' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390637'
                WHERE ordernumber = 'P420518161451335' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390638'
                WHERE ordernumber = 'P180518161917169' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390639'
                WHERE ordernumber = 'P790518162154323' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390640'
                WHERE ordernumber = 'P180518162228171' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325846'
                WHERE ordernumber = 'P420518162441199' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390641'
                WHERE ordernumber = 'P180518162646862' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390642'
                WHERE ordernumber = 'P200518163024682' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390643'
                WHERE ordernumber = 'P420518163515783' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166913'
                WHERE ordernumber = 'P790518163710263' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390644'
                WHERE ordernumber = 'P190518164012206' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390645'
                WHERE ordernumber = 'P190518164157289' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388524'
                WHERE ordernumber = 'P590518164204736' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383338'
                WHERE ordernumber = 'P200518164246419' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390646'
                WHERE ordernumber = 'P420518164658946' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390647'
                WHERE ordernumber = 'P190518164808915' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389810'
                WHERE ordernumber = 'P190518165126871' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390649'
                WHERE ordernumber = 'P420518165135143' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389810'
                WHERE ordernumber = 'P190518165208748' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379311'
                WHERE ordernumber = 'P180518165419425' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390650'
                WHERE ordernumber = 'P190518165545474' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356322'
                WHERE ordernumber = 'P180518165800269' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390651'
                WHERE ordernumber = 'P180518170022416' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390606'
                WHERE ordernumber = 'P200518170115915' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390606'
                WHERE ordernumber = 'P200518170119638' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390652'
                WHERE ordernumber = 'P420518170129838' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390653'
                WHERE ordernumber = 'P190518170358364' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390654'
                WHERE ordernumber = 'P420518170619391' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379654'
                WHERE ordernumber = 'P200518170621836' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390655'
                WHERE ordernumber = 'P200518170732954' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390654'
                WHERE ordernumber = 'P420518170745718' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390656'
                WHERE ordernumber = 'P190518170817827' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390657'
                WHERE ordernumber = 'P420518170926870' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289271'
                WHERE ordernumber = 'P180518171322138' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316487'
                WHERE ordernumber = 'P790518171524160' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368536'
                WHERE ordernumber = 'P180518171618750' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390658'
                WHERE ordernumber = 'P200518171805185' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390659'
                WHERE ordernumber = 'P420518171913499' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124230'
                WHERE ordernumber = 'P180518171959710' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '72027'
                WHERE ordernumber = 'P180518172051418' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386335'
                WHERE ordernumber = 'P420518172130905' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390661'
                WHERE ordernumber = 'P180518172334878' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390660'
                WHERE ordernumber = 'P420518172442192' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390662'
                WHERE ordernumber = 'P180518172505687' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390663'
                WHERE ordernumber = 'P180518172626666' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376328'
                WHERE ordernumber = 'P190518172802858' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390664'
                WHERE ordernumber = 'P420518172844675' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390666'
                WHERE ordernumber = 'P200518172900990' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '361173'
                WHERE ordernumber = 'P190518172914600' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382783'
                WHERE ordernumber = 'P200518172954641' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373120'
                WHERE ordernumber = 'P190518173003890' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390668'
                WHERE ordernumber = 'P180518173021268' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390661'
                WHERE ordernumber = 'P190518173109172' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390670'
                WHERE ordernumber = 'P190518173250986' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159563'
                WHERE ordernumber = 'P190518173349376' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390671'
                WHERE ordernumber = 'P200518173407998' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390672'
                WHERE ordernumber = 'P180518173607611' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390674'
                WHERE ordernumber = 'P420518173751378' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390673'
                WHERE ordernumber = 'P180518173932167' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390667'
                WHERE ordernumber = 'P190518174023932' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390675'
                WHERE ordernumber = 'P790518174052991' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306806'
                WHERE ordernumber = 'P180518174109605' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81065'
                WHERE ordernumber = 'P200518174122129' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '17102'
                WHERE ordernumber = 'P200518174252822' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390676'
                WHERE ordernumber = 'P200518174511377' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390677'
                WHERE ordernumber = 'P420518174653211' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390678'
                WHERE ordernumber = 'P190518174742910' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '246328'
                WHERE ordernumber = 'P190518174917588' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390680'
                WHERE ordernumber = 'P190518175352333' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390682'
                WHERE ordernumber = 'P180518180040294' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390683'
                WHERE ordernumber = 'P200518180529680' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390684'
                WHERE ordernumber = 'P420518181101908' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390685'
                WHERE ordernumber = 'P180518181149300' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390686'
                WHERE ordernumber = 'P180518181408676' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390687'
                WHERE ordernumber = 'P790518181643546' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390689'
                WHERE ordernumber = 'P190518182245778' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390690'
                WHERE ordernumber = 'P180518182332498' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390691'
                WHERE ordernumber = 'P790518182537859' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390693'
                WHERE ordernumber = 'P190518182645131' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390694'
                WHERE ordernumber = 'P180518182741558' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291384'
                WHERE ordernumber = 'P190518182802386' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237814'
                WHERE ordernumber = 'P180518183046945' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390695'
                WHERE ordernumber = 'P200518183051351' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288868'
                WHERE ordernumber = 'P190518183107309' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390696'
                WHERE ordernumber = 'P790518183409475' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390698'
                WHERE ordernumber = 'P790518183715199' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390699'
                WHERE ordernumber = 'P180518184035115' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276353'
                WHERE ordernumber = 'P200518184537422' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390702'
                WHERE ordernumber = 'P190518184726163' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390703'
                WHERE ordernumber = 'P190518184942608' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100505'
                WHERE ordernumber = 'P200518185018788' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390704'
                WHERE ordernumber = 'P420518185019119' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390705'
                WHERE ordernumber = 'P420518185140683' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390708'
                WHERE ordernumber = 'P420518185648320' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390707'
                WHERE ordernumber = 'P790518185649250' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289367'
                WHERE ordernumber = 'P200518185825637' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390700'
                WHERE ordernumber = 'P790518185908373' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390709'
                WHERE ordernumber = 'P420518190030466' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358757'
                WHERE ordernumber = 'P200518190520359' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390710'
                WHERE ordernumber = 'P200518190728177' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390711'
                WHERE ordernumber = 'P420518190900754' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390712'
                WHERE ordernumber = 'P790518191246487' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '126295'
                WHERE ordernumber = 'P190518192236433' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240217'
                WHERE ordernumber = 'P200518192330758' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209172'
                WHERE ordernumber = 'P200518192541489' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384877'
                WHERE ordernumber = 'P190518192905605' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167325'
                WHERE ordernumber = 'P200518192917696' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390715'
                WHERE ordernumber = 'P420518193718600' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390716'
                WHERE ordernumber = 'P630518194124302' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283454'
                WHERE ordernumber = 'P190518194209517' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99859'
                WHERE ordernumber = 'P790518194450900' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390717'
                WHERE ordernumber = 'P200518194806597' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342504'
                WHERE ordernumber = 'P200518194923463' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390718'
                WHERE ordernumber = 'P790518195117207' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390719'
                WHERE ordernumber = 'P190518195150640' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390720'
                WHERE ordernumber = 'P630518195419555' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390721'
                WHERE ordernumber = 'P420518195721563' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298057'
                WHERE ordernumber = 'P630518200930870' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388375'
                WHERE ordernumber = 'P790518201357664' 
            
2024-05-19 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390723'
                WHERE ordernumber = 'P630518202159576' 
            
2024-05-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346362'
                WHERE ordernumber = 'P790518205721831' 
            
2024-05-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390726'
                WHERE ordernumber = 'P790518212122828' 
            
2024-05-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '298176'
                WHERE ordernumber = 'P590518212818978' 
            
2024-05-19 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '390728'
                WHERE ordernumber = 'P790518220654187'