2024-05-09 01:00:02 -- 將會員中心id寫入data-lake
2024-05-09 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-05-08%';
        
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388894'
                WHERE ordernumber = 'P180508110242739' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364588'
                WHERE ordernumber = 'P190508110249704' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214137'
                WHERE ordernumber = 'P180508110534969' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387054'
                WHERE ordernumber = 'P630508110746267' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '63111'
                WHERE ordernumber = 'P200508111011884' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388895'
                WHERE ordernumber = 'P200508111142263' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '131145'
                WHERE ordernumber = 'P180508111421466' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388897'
                WHERE ordernumber = 'P180508111601343' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287399'
                WHERE ordernumber = 'P200508111852880' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '227696'
                WHERE ordernumber = 'P180508112036259' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166122'
                WHERE ordernumber = 'P190508112145426' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388898'
                WHERE ordernumber = 'P420508112234161' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209570'
                WHERE ordernumber = 'P180508112317895' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388899'
                WHERE ordernumber = 'P420508112331705' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388901'
                WHERE ordernumber = 'P420508112613226' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '311243'
                WHERE ordernumber = 'P200508112629948' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388164'
                WHERE ordernumber = 'P200508112827646' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289705'
                WHERE ordernumber = 'P180508112909634' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378296'
                WHERE ordernumber = 'P180508113130557' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378213'
                WHERE ordernumber = 'P200508113237491' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388164'
                WHERE ordernumber = 'P200508113551661' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127781'
                WHERE ordernumber = 'P200508113901358' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254082'
                WHERE ordernumber = 'P180508114639578' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388904'
                WHERE ordernumber = 'P180508114924673' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383419'
                WHERE ordernumber = 'P200508115725701' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209274'
                WHERE ordernumber = 'P180508120918310' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269501'
                WHERE ordernumber = 'P200508120940148' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388906'
                WHERE ordernumber = 'P420508121339737' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388877'
                WHERE ordernumber = 'P180508121423994' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388905'
                WHERE ordernumber = 'P180508121540641' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388907'
                WHERE ordernumber = 'P180508121715430' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388908'
                WHERE ordernumber = 'P420508121952348' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388886'
                WHERE ordernumber = 'P790508122237531' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388886'
                WHERE ordernumber = 'P790508122421371' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254216'
                WHERE ordernumber = 'P180508122922362' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364080'
                WHERE ordernumber = 'P420508123014459' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386079'
                WHERE ordernumber = 'P200508123014349' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229245'
                WHERE ordernumber = 'P180508123617216' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228555'
                WHERE ordernumber = 'P190508123720623' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229245'
                WHERE ordernumber = 'P180508123729970' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '18038'
                WHERE ordernumber = 'P630508124315508' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388913'
                WHERE ordernumber = 'P420508124604923' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388914'
                WHERE ordernumber = 'P200508124834610' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388897'
                WHERE ordernumber = 'P180508124838273' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388911'
                WHERE ordernumber = 'P790508124936790' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355438'
                WHERE ordernumber = 'P200508125006367' 
            
2024-05-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388911'
                WHERE ordernumber = 'P790508125052462' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296904'
                WHERE ordernumber = 'P420508125132516' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388912'
                WHERE ordernumber = 'P790508125229907' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296904'
                WHERE ordernumber = 'P420508125132516' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388915'
                WHERE ordernumber = 'P630508125232603' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388879'
                WHERE ordernumber = 'P200508125404715' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388916'
                WHERE ordernumber = 'P420508125539697' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314470'
                WHERE ordernumber = 'P200508130756443' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95036'
                WHERE ordernumber = 'P180508130914917' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282560'
                WHERE ordernumber = 'P200508131230768' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279886'
                WHERE ordernumber = 'P180508131422598' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388921'
                WHERE ordernumber = 'P420508131938651' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388922'
                WHERE ordernumber = 'P200508132212186' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291788'
                WHERE ordernumber = 'P420508132555213' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200508132739785' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336135'
                WHERE ordernumber = 'P420508132932420' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352697'
                WHERE ordernumber = 'P180508133059997' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385705'
                WHERE ordernumber = 'P420508133438724' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388924'
                WHERE ordernumber = 'P180508133746879' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388924'
                WHERE ordernumber = 'P180508133825547' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388925'
                WHERE ordernumber = 'P190508133902274' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128659'
                WHERE ordernumber = 'P180508134022999' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388926'
                WHERE ordernumber = 'P190508134155674' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160114'
                WHERE ordernumber = 'P180508134232379' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384727'
                WHERE ordernumber = 'P200508134935212' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345453'
                WHERE ordernumber = 'P200508135208174' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342058'
                WHERE ordernumber = 'P200508135504235' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180508135514259' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222355'
                WHERE ordernumber = 'P180508135642719' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388928'
                WHERE ordernumber = 'P200508135648149' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388929'
                WHERE ordernumber = 'P630508135812764' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235779'
                WHERE ordernumber = 'P200508140254933' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388931'
                WHERE ordernumber = 'P630508140535292' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263162'
                WHERE ordernumber = 'P180508140647333' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384480'
                WHERE ordernumber = 'P180508140928696' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388932'
                WHERE ordernumber = 'P630508141108865' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388935'
                WHERE ordernumber = 'P630508141909365' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388938'
                WHERE ordernumber = 'P180508142156983' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388939'
                WHERE ordernumber = 'P180508142448891' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387893'
                WHERE ordernumber = 'P200508142455618' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388940'
                WHERE ordernumber = 'P630508142708656' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388942'
                WHERE ordernumber = 'P630508142849573' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388941'
                WHERE ordernumber = 'P180508142908492' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388943'
                WHERE ordernumber = 'P200508143132658' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342311'
                WHERE ordernumber = 'P180508143435605' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388942'
                WHERE ordernumber = 'P630508143610145' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388946'
                WHERE ordernumber = 'P200508143618508' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388945'
                WHERE ordernumber = 'P180508143921565' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388945'
                WHERE ordernumber = 'P180508144000940' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388948'
                WHERE ordernumber = 'P630508144424704' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388949'
                WHERE ordernumber = 'P630508144527230' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388950'
                WHERE ordernumber = 'P180508144801987' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141900'
                WHERE ordernumber = 'P590508144815173' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388951'
                WHERE ordernumber = 'P420508144917222' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '231746'
                WHERE ordernumber = 'P200508145054590' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388952'
                WHERE ordernumber = 'P630508145424725' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234950'
                WHERE ordernumber = 'P200508145606268' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388953'
                WHERE ordernumber = 'P180508145625812' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P420508150118989' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388955'
                WHERE ordernumber = 'P180508150227841' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238295'
                WHERE ordernumber = 'P630508150443700' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115668'
                WHERE ordernumber = 'P180508150836694' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338104'
                WHERE ordernumber = 'P200508151000911' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388958'
                WHERE ordernumber = 'P180508151313734' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388109'
                WHERE ordernumber = 'P630508151420735' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388959'
                WHERE ordernumber = 'P200508151449828' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346536'
                WHERE ordernumber = 'P180508151452369' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346536'
                WHERE ordernumber = 'P180508151535463' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381144'
                WHERE ordernumber = 'P180508151722382' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388957'
                WHERE ordernumber = 'P190508151757885' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328299'
                WHERE ordernumber = 'P180508151815390' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104613'
                WHERE ordernumber = 'P200508151818686' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328299'
                WHERE ordernumber = 'P180508151916913' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104613'
                WHERE ordernumber = 'P200508152139529' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388961'
                WHERE ordernumber = 'P630508152509358' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388960'
                WHERE ordernumber = 'P630508152601635' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385326'
                WHERE ordernumber = 'P420508152757958' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384966'
                WHERE ordernumber = 'P420508153930853' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267315'
                WHERE ordernumber = 'P180508154030141' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385492'
                WHERE ordernumber = 'P420508154054961' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388964'
                WHERE ordernumber = 'P200508154252491' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217542'
                WHERE ordernumber = 'P420508154721926' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388968'
                WHERE ordernumber = 'P180508155344797' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388969'
                WHERE ordernumber = 'P190508155356977' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374842'
                WHERE ordernumber = 'P200508155357787' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170740'
                WHERE ordernumber = 'P200508155444922' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104295'
                WHERE ordernumber = 'P420508155619172' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388970'
                WHERE ordernumber = 'P630508155711396' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '46268'
                WHERE ordernumber = 'P200508155805233' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242109'
                WHERE ordernumber = 'P630508160034742' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388965'
                WHERE ordernumber = 'P420508160107319' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388971'
                WHERE ordernumber = 'P180508160151987' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388973'
                WHERE ordernumber = 'P200508160331248' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294690'
                WHERE ordernumber = 'P420508160454133' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388976'
                WHERE ordernumber = 'P630508161003904' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388974'
                WHERE ordernumber = 'P790508161157212' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388979'
                WHERE ordernumber = 'P200508162153572' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314728'
                WHERE ordernumber = 'P420508162338942' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98337'
                WHERE ordernumber = 'P200508163228391' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P180508163445576' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367975'
                WHERE ordernumber = 'P200508163648816' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164789'
                WHERE ordernumber = 'P200508163900607' 
            
2024-05-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253874'
                WHERE ordernumber = 'P420508164319956' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102214'
                WHERE ordernumber = 'P180508164624584' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388981'
                WHERE ordernumber = 'P200508165108951' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266436'
                WHERE ordernumber = 'P200508165143268' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164789'
                WHERE ordernumber = 'P200508165224401' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215023'
                WHERE ordernumber = 'P180508165323790' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '208430'
                WHERE ordernumber = 'P200508165551272' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113282'
                WHERE ordernumber = 'P200508165724608' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290482'
                WHERE ordernumber = 'P200508165813285' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388983'
                WHERE ordernumber = 'P420508170316431' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388982'
                WHERE ordernumber = 'P790508170444686' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P200508170540739' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102068'
                WHERE ordernumber = 'P180508170541994' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349107'
                WHERE ordernumber = 'P420508171502795' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388985'
                WHERE ordernumber = 'P180508171622373' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '119752'
                WHERE ordernumber = 'P180508172126612' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388984'
                WHERE ordernumber = 'P190508172257829' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388987'
                WHERE ordernumber = 'P200508172326746' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388984'
                WHERE ordernumber = 'P190508172335553' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388988'
                WHERE ordernumber = 'P180508172401884' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388989'
                WHERE ordernumber = 'P200508172544257' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388990'
                WHERE ordernumber = 'P190508172620200' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388991'
                WHERE ordernumber = 'P420508172942498' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388992'
                WHERE ordernumber = 'P180508173029530' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '121146'
                WHERE ordernumber = 'P180508173704879' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388993'
                WHERE ordernumber = 'P420508173738118' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252221'
                WHERE ordernumber = 'P200508173941310' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388994'
                WHERE ordernumber = 'P180508174125907' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387945'
                WHERE ordernumber = 'P420508174252757' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388995'
                WHERE ordernumber = 'P180508174738261' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388996'
                WHERE ordernumber = 'P190508174844751' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239944'
                WHERE ordernumber = 'P190508175046113' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252494'
                WHERE ordernumber = 'P180508175121331' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '215833'
                WHERE ordernumber = 'P190508175255147' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388997'
                WHERE ordernumber = 'P200508175459501' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358866'
                WHERE ordernumber = 'P200508175605778' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '381382'
                WHERE ordernumber = 'P190508175632240' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388998'
                WHERE ordernumber = 'P630508175644389' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382008'
                WHERE ordernumber = 'P190508180751774' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389000'
                WHERE ordernumber = 'P630508181142359' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389001'
                WHERE ordernumber = 'P180508181225973' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '85805'
                WHERE ordernumber = 'P200508181421500' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220607'
                WHERE ordernumber = 'P200508181505630' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389003'
                WHERE ordernumber = 'P200508181623919' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389004'
                WHERE ordernumber = 'P180508181736165' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280616'
                WHERE ordernumber = 'P200508181800759' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347901'
                WHERE ordernumber = 'P180508181840607' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351822'
                WHERE ordernumber = 'P630508181855283' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '260501'
                WHERE ordernumber = 'P190508182003836' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282012'
                WHERE ordernumber = 'P630508182032157' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258574'
                WHERE ordernumber = 'P200508182209414' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389006'
                WHERE ordernumber = 'P180508182333123' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389007'
                WHERE ordernumber = 'P180508182436776' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '333134'
                WHERE ordernumber = 'P200508182801558' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389009'
                WHERE ordernumber = 'P790508183006842' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389010'
                WHERE ordernumber = 'P420508183423661' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389012'
                WHERE ordernumber = 'P790508183829840' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389013'
                WHERE ordernumber = 'P420508183910921' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355723'
                WHERE ordernumber = 'P630508183933964' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389014'
                WHERE ordernumber = 'P420508184017813' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117203'
                WHERE ordernumber = 'P790508184022594' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389015'
                WHERE ordernumber = 'P200508184058923' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389016'
                WHERE ordernumber = 'P200508184447436' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '383404'
                WHERE ordernumber = 'P190508184458504' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228942'
                WHERE ordernumber = 'P190508184557313' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '312880'
                WHERE ordernumber = 'P200508184726111' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389017'
                WHERE ordernumber = 'P190508185037614' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382008'
                WHERE ordernumber = 'P190508185420451' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '163494'
                WHERE ordernumber = 'P630508185807358' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389018'
                WHERE ordernumber = 'P630508190550674' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389001'
                WHERE ordernumber = 'P190508190606922' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '351778'
                WHERE ordernumber = 'P630508190734161' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387163'
                WHERE ordernumber = 'P190508191903190' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389019'
                WHERE ordernumber = 'P190508192242142' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389020'
                WHERE ordernumber = 'P190508192333302' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389021'
                WHERE ordernumber = 'P190508192450331' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '162419'
                WHERE ordernumber = 'P630508192554148' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389022'
                WHERE ordernumber = 'P790508192657700' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388816'
                WHERE ordernumber = 'P420508192748264' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389023'
                WHERE ordernumber = 'P420508193527725' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389024'
                WHERE ordernumber = 'P200508193604767' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389025'
                WHERE ordernumber = 'P420508193724369' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '107553'
                WHERE ordernumber = 'P190508194247159' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90138'
                WHERE ordernumber = 'P200508194819614' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389027'
                WHERE ordernumber = 'P630508194922886' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389028'
                WHERE ordernumber = 'P790508195015279' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389029'
                WHERE ordernumber = 'P200508195039301' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389027'
                WHERE ordernumber = 'P630508195143497' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389030'
                WHERE ordernumber = 'P190508195420298' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379440'
                WHERE ordernumber = 'P420508195459591' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371667'
                WHERE ordernumber = 'P630508195930803' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389031'
                WHERE ordernumber = 'P790508200300207' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '37483'
                WHERE ordernumber = 'P630508200530486' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347103'
                WHERE ordernumber = 'P630508200633434' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389032'
                WHERE ordernumber = 'P790508200747418' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389034'
                WHERE ordernumber = 'P630508202140291' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389027'
                WHERE ordernumber = 'P630508203335272' 
            
2024-05-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '389035'
                WHERE ordernumber = 'P790508210516369'