2024-03-22 01:00:02 -- 將會員中心id寫入data-lake
2024-03-22 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-21%';
        
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289031'
                WHERE ordernumber = 'P190321110139250' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259574'
                WHERE ordernumber = 'P200321110246422' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382400'
                WHERE ordernumber = 'P420321110433922' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126002'
                WHERE ordernumber = 'P190321110913401' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382401'
                WHERE ordernumber = 'P180321111205627' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382401'
                WHERE ordernumber = 'P180321111308257' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '126002'
                WHERE ordernumber = 'P180321111658790' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382403'
                WHERE ordernumber = 'P190321111708815' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382405'
                WHERE ordernumber = 'P180321111904437' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P200321111905440' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382403'
                WHERE ordernumber = 'P190321111904904' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382406'
                WHERE ordernumber = 'P180321112038654' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378938'
                WHERE ordernumber = 'P190321112106822' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '293210'
                WHERE ordernumber = 'P200321112209989' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107098'
                WHERE ordernumber = 'P190321112315130' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315189'
                WHERE ordernumber = 'P190321112520881' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P190321112752733' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258068'
                WHERE ordernumber = 'P420321112759225' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382408'
                WHERE ordernumber = 'P200321113335760' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96832'
                WHERE ordernumber = 'P590321113450492' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339238'
                WHERE ordernumber = 'P180321113453500' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336523'
                WHERE ordernumber = 'P200321113501954' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353461'
                WHERE ordernumber = 'P420321113626669' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382410'
                WHERE ordernumber = 'P200321113801381' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382409'
                WHERE ordernumber = 'P420321113833496' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382411'
                WHERE ordernumber = 'P200321114343571' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382412'
                WHERE ordernumber = 'P420321114415690' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382413'
                WHERE ordernumber = 'P420321114829785' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200321114859585' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P180321115322112' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '112578'
                WHERE ordernumber = 'P200321115649937' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342339'
                WHERE ordernumber = 'P420321115759804' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375005'
                WHERE ordernumber = 'P180321115955935' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382414'
                WHERE ordernumber = 'P180321120818164' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382415'
                WHERE ordernumber = 'P420321121237805' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382414'
                WHERE ordernumber = 'P180321121505231' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382416'
                WHERE ordernumber = 'P200321121832944' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281256'
                WHERE ordernumber = 'P180321122026122' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '154061'
                WHERE ordernumber = 'P180321122224438' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378164'
                WHERE ordernumber = 'P200321122355271' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382417'
                WHERE ordernumber = 'P180321122603250' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382419'
                WHERE ordernumber = 'P200321123331444' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '120750'
                WHERE ordernumber = 'P180321123358471' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238426'
                WHERE ordernumber = 'P200321123639112' 
            
2024-03-22 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '382421'
                WHERE ordernumber = 'P420321124338747' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382422'
                WHERE ordernumber = 'P200321124627897' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381303'
                WHERE ordernumber = 'P420321124827948' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382425'
                WHERE ordernumber = 'P180321124849370' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135178'
                WHERE ordernumber = 'P200321125227176' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382422'
                WHERE ordernumber = 'P200321125333986' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382358'
                WHERE ordernumber = 'P420321125735809' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382281'
                WHERE ordernumber = 'P180321130133529' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122935'
                WHERE ordernumber = 'P200321130602335' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94344'
                WHERE ordernumber = 'P180321130738568' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380002'
                WHERE ordernumber = 'P180321130933581' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '330824'
                WHERE ordernumber = 'P180321131047608' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382427'
                WHERE ordernumber = 'P200321131143818' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382427'
                WHERE ordernumber = 'P200321131312861' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382428'
                WHERE ordernumber = 'P200321131932337' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104444'
                WHERE ordernumber = 'P180321132041337' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155149'
                WHERE ordernumber = 'P200321132110510' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294580'
                WHERE ordernumber = 'P200321132248571' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381215'
                WHERE ordernumber = 'P200321132451740' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155149'
                WHERE ordernumber = 'P200321132622389' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382385'
                WHERE ordernumber = 'P180321132822589' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382429'
                WHERE ordernumber = 'P200321132833598' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382431'
                WHERE ordernumber = 'P180321133108895' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '155149'
                WHERE ordernumber = 'P200321133159977' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382430'
                WHERE ordernumber = 'P590321133416801' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99796'
                WHERE ordernumber = 'P200321133423716' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382432'
                WHERE ordernumber = 'P180321133432845' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99109'
                WHERE ordernumber = 'P200321133934191' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355605'
                WHERE ordernumber = 'P420321134058560' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341653'
                WHERE ordernumber = 'P200321134827301' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382435'
                WHERE ordernumber = 'P420321135449548' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382437'
                WHERE ordernumber = 'P180321135533687' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '74563'
                WHERE ordernumber = 'P420321135844735' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80885'
                WHERE ordernumber = 'P180321135905374' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355511'
                WHERE ordernumber = 'P200321140141703' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382438'
                WHERE ordernumber = 'P200321140346491' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367839'
                WHERE ordernumber = 'P420321140549790' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279660'
                WHERE ordernumber = 'P190321140738582' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245286'
                WHERE ordernumber = 'P200321141033828' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120336'
                WHERE ordernumber = 'P190321141515568' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309225'
                WHERE ordernumber = 'P200321141837585' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382439'
                WHERE ordernumber = 'P420321142105858' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382440'
                WHERE ordernumber = 'P180321142408839' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '208559'
                WHERE ordernumber = 'P190321142421970' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382441'
                WHERE ordernumber = 'P180321142559490' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382442'
                WHERE ordernumber = 'P190321142726687' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382443'
                WHERE ordernumber = 'P180321143010236' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382444'
                WHERE ordernumber = 'P180321143145252' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382445'
                WHERE ordernumber = 'P190321143156334' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377262'
                WHERE ordernumber = 'P420321143306757' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353938'
                WHERE ordernumber = 'P420321143444300' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382446'
                WHERE ordernumber = 'P190321143450902' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289031'
                WHERE ordernumber = 'P190321143710485' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '260400'
                WHERE ordernumber = 'P180321143735983' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382447'
                WHERE ordernumber = 'P420321143818827' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341479'
                WHERE ordernumber = 'P180321144013533' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276052'
                WHERE ordernumber = 'P180321144443211' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382448'
                WHERE ordernumber = 'P200321145023136' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354232'
                WHERE ordernumber = 'P420321145056463' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382449'
                WHERE ordernumber = 'P180321145114953' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382450'
                WHERE ordernumber = 'P420321145216633' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249460'
                WHERE ordernumber = 'P420321145450408' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235847'
                WHERE ordernumber = 'P420321145554905' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P420321145753128' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378054'
                WHERE ordernumber = 'P200321150045803' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382451'
                WHERE ordernumber = 'P420321150048589' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382452'
                WHERE ordernumber = 'P420321150612306' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382453'
                WHERE ordernumber = 'P190321151011871' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382454'
                WHERE ordernumber = 'P200321151109824' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366074'
                WHERE ordernumber = 'P420321151146291' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382455'
                WHERE ordernumber = 'P420321151533288' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382457'
                WHERE ordernumber = 'P200321151621538' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P180321152445673' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '251499'
                WHERE ordernumber = 'P420321152505962' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382460'
                WHERE ordernumber = 'P420321152849954' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376813'
                WHERE ordernumber = 'P200321152925733' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166417'
                WHERE ordernumber = 'P180321153201427' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382320'
                WHERE ordernumber = 'P200321154400711' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382462'
                WHERE ordernumber = 'P180321154724397' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '246109'
                WHERE ordernumber = 'P180321154852650' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382463'
                WHERE ordernumber = 'P180321155110363' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382464'
                WHERE ordernumber = 'P200321155223386' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374079'
                WHERE ordernumber = 'P180321155813194' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366326'
                WHERE ordernumber = 'P180321160110310' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382466'
                WHERE ordernumber = 'P420321160418960' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339068'
                WHERE ordernumber = 'P420321160723808' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305688'
                WHERE ordernumber = 'P180321160953780' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382469'
                WHERE ordernumber = 'P180321161331187' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382471'
                WHERE ordernumber = 'P190321162357582' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382472'
                WHERE ordernumber = 'P200321162550119' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382470'
                WHERE ordernumber = 'P180321162733788' 
            
2024-03-22 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259119'
                WHERE ordernumber = 'P200321162816559' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342695'
                WHERE ordernumber = 'P190321162905500' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352011'
                WHERE ordernumber = 'P180321163021903' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302780'
                WHERE ordernumber = 'P200321163950848' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382475'
                WHERE ordernumber = 'P420321164404317' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382473'
                WHERE ordernumber = 'P590321164547528' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382477'
                WHERE ordernumber = 'P420321165237725' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382478'
                WHERE ordernumber = 'P180321165657814' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382479'
                WHERE ordernumber = 'P190321165832758' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382480'
                WHERE ordernumber = 'P200321165907324' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263960'
                WHERE ordernumber = 'P200321170123402' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221426'
                WHERE ordernumber = 'P190321170235358' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382481'
                WHERE ordernumber = 'P180321171042153' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382481'
                WHERE ordernumber = 'P180321171220604' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132468'
                WHERE ordernumber = 'P180321171612123' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382483'
                WHERE ordernumber = 'P180321172046725' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382482'
                WHERE ordernumber = 'P190321172144823' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382486'
                WHERE ordernumber = 'P200321172500867' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352410'
                WHERE ordernumber = 'P180321172545905' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258844'
                WHERE ordernumber = 'P180321172825651' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382487'
                WHERE ordernumber = 'P200321172903396' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382488'
                WHERE ordernumber = 'P420321173437752' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378510'
                WHERE ordernumber = 'P180321173445275' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382489'
                WHERE ordernumber = 'P200321173549785' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382491'
                WHERE ordernumber = 'P200321173750634' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382492'
                WHERE ordernumber = 'P200321174429875' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250471'
                WHERE ordernumber = 'P180321175326525' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347910'
                WHERE ordernumber = 'P420321180122252' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382495'
                WHERE ordernumber = 'P420321181222777' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382496'
                WHERE ordernumber = 'P200321181322230' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229471'
                WHERE ordernumber = 'P200321181751935' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382498'
                WHERE ordernumber = 'P420321182159967' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382499'
                WHERE ordernumber = 'P190321182447195' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101769'
                WHERE ordernumber = 'P420321182608328' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353667'
                WHERE ordernumber = 'P420321182809685' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381580'
                WHERE ordernumber = 'P180321183138714' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211888'
                WHERE ordernumber = 'P180321183325305' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379900'
                WHERE ordernumber = 'P190321184110783' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377840'
                WHERE ordernumber = 'P200321185350683' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '225907'
                WHERE ordernumber = 'P200321185626587' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373625'
                WHERE ordernumber = 'P420321185924954' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244286'
                WHERE ordernumber = 'P200321190015807' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382501'
                WHERE ordernumber = 'P190321190350750' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221131'
                WHERE ordernumber = 'P190321190428403' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '131519'
                WHERE ordernumber = 'P190321190458979' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382014'
                WHERE ordernumber = 'P190321190544914' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382502'
                WHERE ordernumber = 'P200321190941178' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '318464'
                WHERE ordernumber = 'P190321190942677' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '292914'
                WHERE ordernumber = 'P200321191009149' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382503'
                WHERE ordernumber = 'P190321191135345' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359921'
                WHERE ordernumber = 'P190321191222845' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215593'
                WHERE ordernumber = 'P190321191345719' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382504'
                WHERE ordernumber = 'P190321192043387' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382506'
                WHERE ordernumber = 'P190321192313526' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342409'
                WHERE ordernumber = 'P190321192703908' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '241297'
                WHERE ordernumber = 'P190321193112376' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382508'
                WHERE ordernumber = 'P190321193345742' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382509'
                WHERE ordernumber = 'P190321193500308' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382510'
                WHERE ordernumber = 'P200321193638503' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382510'
                WHERE ordernumber = 'P200321193726744' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231344'
                WHERE ordernumber = 'P190321194037866' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382512'
                WHERE ordernumber = 'P200321194340309' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346488'
                WHERE ordernumber = 'P200321194455376' 
            
2024-03-22 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190321194607988'