2024-03-15 01:00:02 -- 將會員中心id寫入data-lake
2024-03-15 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-03-14%';
        
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100896'
                WHERE ordernumber = 'P190314110405633' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381422'
                WHERE ordernumber = 'P420314110656804' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381423'
                WHERE ordernumber = 'P180314110927404' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287768'
                WHERE ordernumber = 'P180314111338979' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381424'
                WHERE ordernumber = 'P180314111439522' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381421'
                WHERE ordernumber = 'P180314111540270' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381425'
                WHERE ordernumber = 'P420314111559593' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287768'
                WHERE ordernumber = 'P180314111603998' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381426'
                WHERE ordernumber = 'P180314111823612' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P180314111907895' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315094'
                WHERE ordernumber = 'P180314112142608' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381427'
                WHERE ordernumber = 'P420314112200464' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381428'
                WHERE ordernumber = 'P420314112308218' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381429'
                WHERE ordernumber = 'P180314112321570' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303028'
                WHERE ordernumber = 'P180314112350606' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253113'
                WHERE ordernumber = 'P180314113437287' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '8437'
                WHERE ordernumber = 'P180314114919576' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381380'
                WHERE ordernumber = 'P590314115252385' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381434'
                WHERE ordernumber = 'P420314115300749' 
            
2024-03-15 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381435'
                WHERE ordernumber = 'P180314115320774' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381436'
                WHERE ordernumber = 'P420314115650946' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381433'
                WHERE ordernumber = 'P590314115859576' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P200314120235574' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93028'
                WHERE ordernumber = 'P200314120400143' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315485'
                WHERE ordernumber = 'P200314120526954' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381438'
                WHERE ordernumber = 'P180314121102756' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381439'
                WHERE ordernumber = 'P180314121526664' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381440'
                WHERE ordernumber = 'P200314121648770' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '52478'
                WHERE ordernumber = 'P180314121739201' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135443'
                WHERE ordernumber = 'P180314121838756' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279353'
                WHERE ordernumber = 'P180314122156623' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381442'
                WHERE ordernumber = 'P200314122322653' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381443'
                WHERE ordernumber = 'P590314123723330' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289689'
                WHERE ordernumber = 'P180314123820609' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '265012'
                WHERE ordernumber = 'P420314124109238' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303679'
                WHERE ordernumber = 'P200314124249328' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282264'
                WHERE ordernumber = 'P200314124548833' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134240'
                WHERE ordernumber = 'P180314124556630' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180314125036996' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291605'
                WHERE ordernumber = 'P200314125340758' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288619'
                WHERE ordernumber = 'P180314131048605' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381445'
                WHERE ordernumber = 'P200314131140958' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340236'
                WHERE ordernumber = 'P420314131213592' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377241'
                WHERE ordernumber = 'P180314131356358' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365652'
                WHERE ordernumber = 'P180314131615746' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272754'
                WHERE ordernumber = 'P180314131835474' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321647'
                WHERE ordernumber = 'P180314131932490' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381448'
                WHERE ordernumber = 'P420314132348627' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381452'
                WHERE ordernumber = 'P420314134344785' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376950'
                WHERE ordernumber = 'P420314134553134' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381453'
                WHERE ordernumber = 'P200314134622675' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381455'
                WHERE ordernumber = 'P200314135343701' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288061'
                WHERE ordernumber = 'P190314135653769' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381456'
                WHERE ordernumber = 'P180314135711112' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P190314140729783' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345567'
                WHERE ordernumber = 'P180314140806660' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345567'
                WHERE ordernumber = 'P180314140850405' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283689'
                WHERE ordernumber = 'P200314141045497' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381461'
                WHERE ordernumber = 'P190314142056839' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381130'
                WHERE ordernumber = 'P180314142102454' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257894'
                WHERE ordernumber = 'P180314142551230' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381464'
                WHERE ordernumber = 'P590314143059593' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302881'
                WHERE ordernumber = 'P200314143142369' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381465'
                WHERE ordernumber = 'P420314143326366' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98143'
                WHERE ordernumber = 'P180314143341120' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155013'
                WHERE ordernumber = 'P420314143656178' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162230'
                WHERE ordernumber = 'P420314143951717' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381467'
                WHERE ordernumber = 'P190314144037180' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381468'
                WHERE ordernumber = 'P200314144229648' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247088'
                WHERE ordernumber = 'P420314144621897' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381470'
                WHERE ordernumber = 'P180314144946897' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302975'
                WHERE ordernumber = 'P200314144946270' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142209'
                WHERE ordernumber = 'P200314145135560' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381471'
                WHERE ordernumber = 'P180314145143310' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320692'
                WHERE ordernumber = 'P200314145225961' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381472'
                WHERE ordernumber = 'P180314145437400' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P190314145450545' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180314145857954' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286229'
                WHERE ordernumber = 'P200314150350226' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381473'
                WHERE ordernumber = 'P200314150603550' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281969'
                WHERE ordernumber = 'P200314150802730' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336241'
                WHERE ordernumber = 'P200314150941417' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381474'
                WHERE ordernumber = 'P200314151157884' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119052'
                WHERE ordernumber = 'P180314151619546' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381475'
                WHERE ordernumber = 'P190314151742640' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114332'
                WHERE ordernumber = 'P190314152051158' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243476'
                WHERE ordernumber = 'P180314152155262' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381476'
                WHERE ordernumber = 'P180314152313476' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302798'
                WHERE ordernumber = 'P420314152325536' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381477'
                WHERE ordernumber = 'P190314152339168' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381478'
                WHERE ordernumber = 'P420314152712964' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231735'
                WHERE ordernumber = 'P190314152805388' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380663'
                WHERE ordernumber = 'P420314153819338' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374685'
                WHERE ordernumber = 'P190314153928850' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381481'
                WHERE ordernumber = 'P200314154939606' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284155'
                WHERE ordernumber = 'P200314155033755' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305535'
                WHERE ordernumber = 'P200314155253779' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214088'
                WHERE ordernumber = 'P180314160554859' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381484'
                WHERE ordernumber = 'P200314161023796' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381485'
                WHERE ordernumber = 'P200314161149815' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304226'
                WHERE ordernumber = 'P180314161435372' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88154'
                WHERE ordernumber = 'P180314161633889' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '101737'
                WHERE ordernumber = 'P200314162237861' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381491'
                WHERE ordernumber = 'P200314163332896' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '290482'
                WHERE ordernumber = 'P200314163811514' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303279'
                WHERE ordernumber = 'P180314164047978' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308843'
                WHERE ordernumber = 'P420314165157203' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380348'
                WHERE ordernumber = 'P180314165814881' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312381'
                WHERE ordernumber = 'P200314165917630' 
            
2024-03-15 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381493'
                WHERE ordernumber = 'P200314170425430' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342029'
                WHERE ordernumber = 'P420314170830698' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328235'
                WHERE ordernumber = 'P420314171029873' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290308'
                WHERE ordernumber = 'P200314171222318' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381495'
                WHERE ordernumber = 'P190314171308961' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P590314171326932' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366017'
                WHERE ordernumber = 'P180314171514812' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381497'
                WHERE ordernumber = 'P180314171738537' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381498'
                WHERE ordernumber = 'P180314171909192' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380174'
                WHERE ordernumber = 'P590314172005509' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381499'
                WHERE ordernumber = 'P190314172230847' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381502'
                WHERE ordernumber = 'P200314172433341' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '81433'
                WHERE ordernumber = 'P200314172614587' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381504'
                WHERE ordernumber = 'P200314172759516' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141605'
                WHERE ordernumber = 'P200314172915343' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381505'
                WHERE ordernumber = 'P180314173209718' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282963'
                WHERE ordernumber = 'P180314173648316' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '267614'
                WHERE ordernumber = 'P420314174201450' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381506'
                WHERE ordernumber = 'P200314174324237' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340551'
                WHERE ordernumber = 'P420314174531900' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378069'
                WHERE ordernumber = 'P180314175101305' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381507'
                WHERE ordernumber = 'P200314175247175' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379126'
                WHERE ordernumber = 'P200314175404573' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '261398'
                WHERE ordernumber = 'P420314175611813' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381460'
                WHERE ordernumber = 'P200314175809458' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381460'
                WHERE ordernumber = 'P200314175812207' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317159'
                WHERE ordernumber = 'P190314175928243' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297239'
                WHERE ordernumber = 'P200314180010919' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '316212'
                WHERE ordernumber = 'P420314180116407' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381508'
                WHERE ordernumber = 'P180314180256497' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '350848'
                WHERE ordernumber = 'P200314180423971' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381509'
                WHERE ordernumber = 'P420314180725534' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319998'
                WHERE ordernumber = 'P180314180903568' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381510'
                WHERE ordernumber = 'P180314181009964' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137205'
                WHERE ordernumber = 'P200314181018756' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381511'
                WHERE ordernumber = 'P200314181231441' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381512'
                WHERE ordernumber = 'P190314181409158' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '111669'
                WHERE ordernumber = 'P200314181524947' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381513'
                WHERE ordernumber = 'P200314181658728' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104611'
                WHERE ordernumber = 'P180314181836147' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381415'
                WHERE ordernumber = 'P420314182353564' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249083'
                WHERE ordernumber = 'P180314182356207' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '118192'
                WHERE ordernumber = 'P200314182410523' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221618'
                WHERE ordernumber = 'P180314182622609' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381515'
                WHERE ordernumber = 'P200314182921151' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381516'
                WHERE ordernumber = 'P190314182949213' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379868'
                WHERE ordernumber = 'P200314183105973' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345521'
                WHERE ordernumber = 'P200314183214887' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93414'
                WHERE ordernumber = 'P200314183619311' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279451'
                WHERE ordernumber = 'P200314183855955' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381517'
                WHERE ordernumber = 'P190314183905664' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121902'
                WHERE ordernumber = 'P190314184034812' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135178'
                WHERE ordernumber = 'P200314184050484' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121902'
                WHERE ordernumber = 'P190314184102830' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283747'
                WHERE ordernumber = 'P200314184504668' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379940'
                WHERE ordernumber = 'P200314184601361' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381518'
                WHERE ordernumber = 'P190314184620199' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297428'
                WHERE ordernumber = 'P420314185023467' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229153'
                WHERE ordernumber = 'P190314185044909' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376484'
                WHERE ordernumber = 'P200314185101832' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381519'
                WHERE ordernumber = 'P200314185319511' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292050'
                WHERE ordernumber = 'P200314185539257' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97764'
                WHERE ordernumber = 'P190314185915760' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239897'
                WHERE ordernumber = 'P200314190104571' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381521'
                WHERE ordernumber = 'P190314190259119' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381120'
                WHERE ordernumber = 'P190314190348353' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381520'
                WHERE ordernumber = 'P200314190509864' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '356227'
                WHERE ordernumber = 'P190314190806185' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381522'
                WHERE ordernumber = 'P200314191645125' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381523'
                WHERE ordernumber = 'P200314192254513' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366944'
                WHERE ordernumber = 'P420314192308821' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255091'
                WHERE ordernumber = 'P200314192612609' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98387'
                WHERE ordernumber = 'P200314192814860' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '129990'
                WHERE ordernumber = 'P420314193151909' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381526'
                WHERE ordernumber = 'P420314194020391' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381527'
                WHERE ordernumber = 'P420314194107194' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88468'
                WHERE ordernumber = 'P200314194253616' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100347'
                WHERE ordernumber = 'P200314194336178' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289851'
                WHERE ordernumber = 'P200314194557324' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381529'
                WHERE ordernumber = 'P420314194607173' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P190314194647915' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237280'
                WHERE ordernumber = 'P200314194658903' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P190314194812897' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381530'
                WHERE ordernumber = 'P420314194818118' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P190314194947854' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281482'
                WHERE ordernumber = 'P190314195156153' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '317356'
                WHERE ordernumber = 'P420314195602580' 
            
2024-03-15 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381535'
                WHERE ordernumber = 'P590314205144966'