2024-09-04 01:00:02 -- 將會員中心id寫入data-lake
2024-09-04 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-09-03%';
        
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375256'
                WHERE ordernumber = 'P180903110243215' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297211'
                WHERE ordernumber = 'P200903110251283' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418211'
                WHERE ordernumber = 'P420903110453161' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418185'
                WHERE ordernumber = 'P420903110939230' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397435'
                WHERE ordernumber = 'P420903111052150' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418196'
                WHERE ordernumber = 'P180903111101477' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418214'
                WHERE ordernumber = 'P200903111116328' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '267027'
                WHERE ordernumber = 'P200903111253199' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418218'
                WHERE ordernumber = 'P200903111454862' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418219'
                WHERE ordernumber = 'P420903111552307' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418219'
                WHERE ordernumber = 'P420903111619507' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '232071'
                WHERE ordernumber = 'P200903111621730' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418196'
                WHERE ordernumber = 'P180903111740691' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '408630'
                WHERE ordernumber = 'P420903111747620' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390505'
                WHERE ordernumber = 'P420903111828365' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220286'
                WHERE ordernumber = 'P180903111845137' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418222'
                WHERE ordernumber = 'P420903112221766' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404528'
                WHERE ordernumber = 'P200903112350229' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398350'
                WHERE ordernumber = 'P420903112415344' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '150628'
                WHERE ordernumber = 'P190903113308796' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236613'
                WHERE ordernumber = 'P180903113742465' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305464'
                WHERE ordernumber = 'P590903114302766' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418244'
                WHERE ordernumber = 'P420903114825643' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254415'
                WHERE ordernumber = 'P200903114833903' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418246'
                WHERE ordernumber = 'P420903115244606' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P200903115533270' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93887'
                WHERE ordernumber = 'P200903115615196' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333354'
                WHERE ordernumber = 'P180903115750895' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266731'
                WHERE ordernumber = 'P200903115907148' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '266731'
                WHERE ordernumber = 'P200903120032466' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '418251'
                WHERE ordernumber = 'P420903120138821' 
            
2024-09-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270523'
                WHERE ordernumber = 'P200903120201879' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394501'
                WHERE ordernumber = 'P420903120601471' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418255'
                WHERE ordernumber = 'P200903120809775' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327273'
                WHERE ordernumber = 'P190903120929438' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418256'
                WHERE ordernumber = 'P420903121012403' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418259'
                WHERE ordernumber = 'P420903121226239' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274742'
                WHERE ordernumber = 'P420903121324726' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '410967'
                WHERE ordernumber = 'P420903121623283' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418264'
                WHERE ordernumber = 'P420903121831894' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412273'
                WHERE ordernumber = 'P200903121901613' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418258'
                WHERE ordernumber = 'P180903122227302' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97359'
                WHERE ordernumber = 'P200903122348586' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418268'
                WHERE ordernumber = 'P420903122534631' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418270'
                WHERE ordernumber = 'P200903122626183' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418159'
                WHERE ordernumber = 'P200903122745215' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106604'
                WHERE ordernumber = 'P180903122950745' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418273'
                WHERE ordernumber = 'P420903123102531' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418277'
                WHERE ordernumber = 'P420903123239646' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291036'
                WHERE ordernumber = 'P200903123430892' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378409'
                WHERE ordernumber = 'P420903123507158' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416238'
                WHERE ordernumber = 'P200903123636539' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345580'
                WHERE ordernumber = 'P200903123727220' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180903123909268' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376911'
                WHERE ordernumber = 'P200903123954690' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418284'
                WHERE ordernumber = 'P420903124227301' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '232257'
                WHERE ordernumber = 'P200903124255966' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238127'
                WHERE ordernumber = 'P420903124424625' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '414562'
                WHERE ordernumber = 'P420903124610860' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271522'
                WHERE ordernumber = 'P200903124750687' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418288'
                WHERE ordernumber = 'P420903124841623' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296924'
                WHERE ordernumber = 'P420903124933970' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222163'
                WHERE ordernumber = 'P200903125013512' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343399'
                WHERE ordernumber = 'P420903125055572' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '72166'
                WHERE ordernumber = 'P420903125139774' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147635'
                WHERE ordernumber = 'P180903125220163' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418291'
                WHERE ordernumber = 'P420903125340167' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147635'
                WHERE ordernumber = 'P180903125507928' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418292'
                WHERE ordernumber = 'P420903125550550' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127992'
                WHERE ordernumber = 'P200903130326115' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338997'
                WHERE ordernumber = 'P200903130403168' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '88624'
                WHERE ordernumber = 'P180903130638853' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338601'
                WHERE ordernumber = 'P420903131149599' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314252'
                WHERE ordernumber = 'P190903131758363' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353508'
                WHERE ordernumber = 'P200903132438129' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418304'
                WHERE ordernumber = 'P420903132558307' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418307'
                WHERE ordernumber = 'P420903132839339' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418308'
                WHERE ordernumber = 'P420903133015570' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100376'
                WHERE ordernumber = 'P180903133254138' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418311'
                WHERE ordernumber = 'P420903133302655' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418312'
                WHERE ordernumber = 'P420903133527671' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418314'
                WHERE ordernumber = 'P200903133644617' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418316'
                WHERE ordernumber = 'P420903133740568' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418314'
                WHERE ordernumber = 'P200903133809674' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245369'
                WHERE ordernumber = 'P200903133903935' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316972'
                WHERE ordernumber = 'P420903133920670' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387638'
                WHERE ordernumber = 'P180903134435950' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418328'
                WHERE ordernumber = 'P420903135446557' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '261147'
                WHERE ordernumber = 'P200903140102197' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418333'
                WHERE ordernumber = 'P420903140152335' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416640'
                WHERE ordernumber = 'P420903140630124' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314967'
                WHERE ordernumber = 'P200903140646352' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401839'
                WHERE ordernumber = 'P420903140749622' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418337'
                WHERE ordernumber = 'P190903141124662' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219863'
                WHERE ordernumber = 'P200903141146559' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417686'
                WHERE ordernumber = 'P180903141259486' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364498'
                WHERE ordernumber = 'P190903141325312' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413026'
                WHERE ordernumber = 'P180903141755307' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418343'
                WHERE ordernumber = 'P420903141933351' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245513'
                WHERE ordernumber = 'P180903142001302' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237035'
                WHERE ordernumber = 'P200903142136179' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366074'
                WHERE ordernumber = 'P420903142924842' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270938'
                WHERE ordernumber = 'P200903143109949' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418349'
                WHERE ordernumber = 'P420903143110207' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '326775'
                WHERE ordernumber = 'P420903143350371' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '418351'
                WHERE ordernumber = 'P200903143436328' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283957'
                WHERE ordernumber = 'P180903143451776' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98533'
                WHERE ordernumber = 'P200903143508272' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385552'
                WHERE ordernumber = 'P200903143711947' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63274'
                WHERE ordernumber = 'P200903143923184' 
            
2024-09-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283957'
                WHERE ordernumber = 'P180903143924485' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418357'
                WHERE ordernumber = 'P420903144029216' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418356'
                WHERE ordernumber = 'P200903144034351' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414702'
                WHERE ordernumber = 'P420903144142825' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299335'
                WHERE ordernumber = 'P180903144409586' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '274959'
                WHERE ordernumber = 'P420903144412716' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418359'
                WHERE ordernumber = 'P200903144558326' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390391'
                WHERE ordernumber = 'P630903145044464' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418366'
                WHERE ordernumber = 'P420903145237964' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136379'
                WHERE ordernumber = 'P420903145402749' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418369'
                WHERE ordernumber = 'P420903145805163' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418371'
                WHERE ordernumber = 'P420903150038505' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387511'
                WHERE ordernumber = 'P420903150208821' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387511'
                WHERE ordernumber = 'P420903150255659' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418375'
                WHERE ordernumber = 'P420903150549649' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418378'
                WHERE ordernumber = 'P420903150647197' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '307696'
                WHERE ordernumber = 'P180903150711734' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '402765'
                WHERE ordernumber = 'P420903151446149' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416378'
                WHERE ordernumber = 'P200903151621492' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '407236'
                WHERE ordernumber = 'P200903151733192' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '82588'
                WHERE ordernumber = 'P200903152116488' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390083'
                WHERE ordernumber = 'P420903152147118' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209570'
                WHERE ordernumber = 'P190903152200621' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209570'
                WHERE ordernumber = 'P190903152319610' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418385'
                WHERE ordernumber = 'P420903152357399' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412103'
                WHERE ordernumber = 'P420903152438186' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418390'
                WHERE ordernumber = 'P420903152821190' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '340276'
                WHERE ordernumber = 'P420903153233160' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '255520'
                WHERE ordernumber = 'P180903154104214' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '202872'
                WHERE ordernumber = 'P420903154515811' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342846'
                WHERE ordernumber = 'P200903155111191' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342846'
                WHERE ordernumber = 'P200903155122114' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417532'
                WHERE ordernumber = 'P420903155143733' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417532'
                WHERE ordernumber = 'P420903155215478' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302586'
                WHERE ordernumber = 'P200903155252290' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392985'
                WHERE ordernumber = 'P200903155721800' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418411'
                WHERE ordernumber = 'P420903160423650' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230045'
                WHERE ordernumber = 'P420903160954503' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418416'
                WHERE ordernumber = 'P200903161310204' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418417'
                WHERE ordernumber = 'P420903161355266' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418230'
                WHERE ordernumber = 'P180903161646402' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418230'
                WHERE ordernumber = 'P180903161728863' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418422'
                WHERE ordernumber = 'P420903162417175' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418424'
                WHERE ordernumber = 'P420903162640883' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344743'
                WHERE ordernumber = 'P190903162754183' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302736'
                WHERE ordernumber = 'P420903162923950' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125914'
                WHERE ordernumber = 'P180903162943476' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289368'
                WHERE ordernumber = 'P420903163622911' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389272'
                WHERE ordernumber = 'P200903164348253' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401387'
                WHERE ordernumber = 'P200903165349221' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315906'
                WHERE ordernumber = 'P420903165408809' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '209646'
                WHERE ordernumber = 'P180903165936702' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '165203'
                WHERE ordernumber = 'P180903170402583' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P200903170507416' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '414813'
                WHERE ordernumber = 'P180903170621953' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418445'
                WHERE ordernumber = 'P420903171609433' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '399643'
                WHERE ordernumber = 'P180903171826321' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328319'
                WHERE ordernumber = 'P180903171918963' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '374118'
                WHERE ordernumber = 'P420903172021454' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334973'
                WHERE ordernumber = 'P420903172404291' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '219678'
                WHERE ordernumber = 'P200903172535165' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '24075'
                WHERE ordernumber = 'P200903174013487' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245603'
                WHERE ordernumber = 'P420903174024481' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393057'
                WHERE ordernumber = 'P200903174446563' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98567'
                WHERE ordernumber = 'P180903174822837' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334829'
                WHERE ordernumber = 'P190903174826607' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418469'
                WHERE ordernumber = 'P420903175150747' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418471'
                WHERE ordernumber = 'P200903175708895' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418472'
                WHERE ordernumber = 'P420903175727120' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263095'
                WHERE ordernumber = 'P200903175744747' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418472'
                WHERE ordernumber = 'P420903175943817' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297105'
                WHERE ordernumber = 'P420903180201772' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '395401'
                WHERE ordernumber = 'P420903180310563' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180903180734933' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357562'
                WHERE ordernumber = 'P180903181104297' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418478'
                WHERE ordernumber = 'P180903181422187' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '86284'
                WHERE ordernumber = 'P180903181457565' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418480'
                WHERE ordernumber = 'P200903181837975' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319102'
                WHERE ordernumber = 'P190903182321171' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '334955'
                WHERE ordernumber = 'P200903182530418' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418485'
                WHERE ordernumber = 'P420903182720897' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389538'
                WHERE ordernumber = 'P420903183013728' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396185'
                WHERE ordernumber = 'P420903183108491' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '105664'
                WHERE ordernumber = 'P180903183237191' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '418487'
                WHERE ordernumber = 'P420903183318312' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230241'
                WHERE ordernumber = 'P180903183535723' 
            
2024-09-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '416509'
                WHERE ordernumber = 'P420903183657586' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '109830'
                WHERE ordernumber = 'P180903184035506' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '392084'
                WHERE ordernumber = 'P200903184142685' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '95368'
                WHERE ordernumber = 'P180903184248731' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '176323'
                WHERE ordernumber = 'P180903184416169' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418493'
                WHERE ordernumber = 'P420903184908427' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418500'
                WHERE ordernumber = 'P200903185342727' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '245917'
                WHERE ordernumber = 'P180903185828692' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339605'
                WHERE ordernumber = 'P420903185936301' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '391255'
                WHERE ordernumber = 'P200903190326979' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '321217'
                WHERE ordernumber = 'P420903190506406' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339605'
                WHERE ordernumber = 'P420903190705485' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P420903190747890' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105913'
                WHERE ordernumber = 'P200903191106383' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '406463'
                WHERE ordernumber = 'P180903191115499' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '415960'
                WHERE ordernumber = 'P200903191207806' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '413423'
                WHERE ordernumber = 'P180903191324315' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '333038'
                WHERE ordernumber = 'P200903191614310' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '261976'
                WHERE ordernumber = 'P180903191700325' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '105183'
                WHERE ordernumber = 'P200903191754460' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401060'
                WHERE ordernumber = 'P180903192019585' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P180903192622884' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '45541'
                WHERE ordernumber = 'P200903192649791' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '292461'
                WHERE ordernumber = 'P180903192703932' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '45541'
                WHERE ordernumber = 'P200903192716272' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418478'
                WHERE ordernumber = 'P180903192751404' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418478'
                WHERE ordernumber = 'P180903193131545' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '232251'
                WHERE ordernumber = 'P180903193516112' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '220701'
                WHERE ordernumber = 'P180903193801989' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '414639'
                WHERE ordernumber = 'P200903193827480' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '409633'
                WHERE ordernumber = 'P200903193919230' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '418515'
                WHERE ordernumber = 'P200903194104461' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '411210'
                WHERE ordernumber = 'P200903194813720' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346756'
                WHERE ordernumber = 'P180903194851887' 
            
2024-09-04 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '346756'
                WHERE ordernumber = 'P180903195216571'