2024-05-23 01:00:01 -- 將會員中心id寫入data-lake
2024-05-23 01:00:01 -- 
            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-22%';
        
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391261'
                WHERE ordernumber = 'P190522110623570' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254478'
                WHERE ordernumber = 'P180522110704986' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391260'
                WHERE ordernumber = 'P790522110709392' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '244494'
                WHERE ordernumber = 'P200522110718434' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391262'
                WHERE ordernumber = 'P180522110916186' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247282'
                WHERE ordernumber = 'P200522110932152' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377525'
                WHERE ordernumber = 'P420522110932830' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282647'
                WHERE ordernumber = 'P420522111108817' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247282'
                WHERE ordernumber = 'P200522111419916' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142572'
                WHERE ordernumber = 'P180522111515526' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276404'
                WHERE ordernumber = 'P180522111714177' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391266'
                WHERE ordernumber = 'P180522112041898' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391268'
                WHERE ordernumber = 'P420522112237759' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '89996'
                WHERE ordernumber = 'P180522112252599' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391267'
                WHERE ordernumber = 'P790522112353955' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '199262'
                WHERE ordernumber = 'P200522113046226' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391269'
                WHERE ordernumber = 'P630522113335593' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385074'
                WHERE ordernumber = 'P180522113422697' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377373'
                WHERE ordernumber = 'P630522113624153' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '354159'
                WHERE ordernumber = 'P190522113738223' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '305084'
                WHERE ordernumber = 'P420522113823880' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391270'
                WHERE ordernumber = 'P630522113847405' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391271'
                WHERE ordernumber = 'P200522114717328' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391271'
                WHERE ordernumber = 'P200522114913415' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139358'
                WHERE ordernumber = 'P180522114951695' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P200522115451746' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336241'
                WHERE ordernumber = 'P200522115901764' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386830'
                WHERE ordernumber = 'P180522121334386' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367890'
                WHERE ordernumber = 'P180522121609972' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391278'
                WHERE ordernumber = 'P790522121630563' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '388950'
                WHERE ordernumber = 'P180522122223697' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158688'
                WHERE ordernumber = 'P420522124214564' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245523'
                WHERE ordernumber = 'P200522124325667' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359469'
                WHERE ordernumber = 'P200522124451655' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391279'
                WHERE ordernumber = 'P190522124500296' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287538'
                WHERE ordernumber = 'P200522124652117' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391281'
                WHERE ordernumber = 'P630522124737703' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236623'
                WHERE ordernumber = 'P180522124756778' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242432'
                WHERE ordernumber = 'P200522125025930' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357888'
                WHERE ordernumber = 'P420522125102277' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391279'
                WHERE ordernumber = 'P190522125103952' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289795'
                WHERE ordernumber = 'P200522125206866' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296648'
                WHERE ordernumber = 'P420522125352465' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381303'
                WHERE ordernumber = 'P420522130526620' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391285'
                WHERE ordernumber = 'P180522131454209' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364047'
                WHERE ordernumber = 'P180522131545853' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391286'
                WHERE ordernumber = 'P630522131800495' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336671'
                WHERE ordernumber = 'P630522132406621' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223179'
                WHERE ordernumber = 'P200522132646301' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391291'
                WHERE ordernumber = 'P180522132759418' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391293'
                WHERE ordernumber = 'P790522133504875' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284049'
                WHERE ordernumber = 'P180522134235964' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139604'
                WHERE ordernumber = 'P200522134809677' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386690'
                WHERE ordernumber = 'P180522134818122' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326586'
                WHERE ordernumber = 'P420522134829663' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386690'
                WHERE ordernumber = 'P180522134942962' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391296'
                WHERE ordernumber = 'P790522135051713' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '92779'
                WHERE ordernumber = 'P790522140145854' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391300'
                WHERE ordernumber = 'P180522140145763' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391299'
                WHERE ordernumber = 'P710522140501469' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389340'
                WHERE ordernumber = 'P180522140545187' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357873'
                WHERE ordernumber = 'P420522140614424' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '155149'
                WHERE ordernumber = 'P200522141007827' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '228228'
                WHERE ordernumber = 'P180522141539945' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391303'
                WHERE ordernumber = 'P200522141842855' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P180522141855523' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391304'
                WHERE ordernumber = 'P790522142012927' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391307'
                WHERE ordernumber = 'P420522142329719' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257348'
                WHERE ordernumber = 'P180522142744410' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391308'
                WHERE ordernumber = 'P200522142804974' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391309'
                WHERE ordernumber = 'P790522142849879' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391312'
                WHERE ordernumber = 'P190522143004352' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391311'
                WHERE ordernumber = 'P200522143017189' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391313'
                WHERE ordernumber = 'P790522143214702' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231270'
                WHERE ordernumber = 'P200522143220230' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389337'
                WHERE ordernumber = 'P180522143513870' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '193074'
                WHERE ordernumber = 'P180522143647580' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391316'
                WHERE ordernumber = 'P420522143903453' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391316'
                WHERE ordernumber = 'P420522144035308' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391318'
                WHERE ordernumber = 'P790522144832988' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383208'
                WHERE ordernumber = 'P420522144935978' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391255'
                WHERE ordernumber = 'P200522145437994' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253739'
                WHERE ordernumber = 'P180522150019686' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391322'
                WHERE ordernumber = 'P710522150146884' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391324'
                WHERE ordernumber = 'P180522150333659' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391324'
                WHERE ordernumber = 'P180522150503142' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342870'
                WHERE ordernumber = 'P200522150503745' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391326'
                WHERE ordernumber = 'P200522150910496' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391327'
                WHERE ordernumber = 'P420522150938618' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391328'
                WHERE ordernumber = 'P200522151054412' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391329'
                WHERE ordernumber = 'P180522151128357' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '41673'
                WHERE ordernumber = 'P180522151227668' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384961'
                WHERE ordernumber = 'P180522152006441' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336542'
                WHERE ordernumber = 'P200522152057183' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242847'
                WHERE ordernumber = 'P180522152151742' 
            
2024-05-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '331099'
                WHERE ordernumber = 'P200522152217713' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391248'
                WHERE ordernumber = 'P710522152232490' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249754'
                WHERE ordernumber = 'P180522152526347' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391332'
                WHERE ordernumber = 'P200522153302611' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132875'
                WHERE ordernumber = 'P190522154444192' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391333'
                WHERE ordernumber = 'P180522154454131' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381220'
                WHERE ordernumber = 'P420522154736601' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391335'
                WHERE ordernumber = 'P420522155958163' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388209'
                WHERE ordernumber = 'P180522160211684' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391336'
                WHERE ordernumber = 'P420522160223378' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P200522160243171' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378784'
                WHERE ordernumber = 'P200522160317908' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391337'
                WHERE ordernumber = 'P420522160333588' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391338'
                WHERE ordernumber = 'P180522160625289' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352187'
                WHERE ordernumber = 'P200522160931850' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391339'
                WHERE ordernumber = 'P790522161130148' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391340'
                WHERE ordernumber = 'P190522161230418' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387069'
                WHERE ordernumber = 'P420522161344526' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275107'
                WHERE ordernumber = 'P200522161346801' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384125'
                WHERE ordernumber = 'P420522161516697' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391342'
                WHERE ordernumber = 'P180522161647596' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391343'
                WHERE ordernumber = 'P200522161651360' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275107'
                WHERE ordernumber = 'P200522161807870' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P180522162352321' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '169204'
                WHERE ordernumber = 'P180522162915683' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391346'
                WHERE ordernumber = 'P200522162930524' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93638'
                WHERE ordernumber = 'P630522163037582' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '59647'
                WHERE ordernumber = 'P420522163109738' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391347'
                WHERE ordernumber = 'P790522163320457' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391348'
                WHERE ordernumber = 'P190522163439535' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '134812'
                WHERE ordernumber = 'P190522163543837' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391349'
                WHERE ordernumber = 'P710522164017668' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391350'
                WHERE ordernumber = 'P200522164405824' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391352'
                WHERE ordernumber = 'P630522164910928' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378942'
                WHERE ordernumber = 'P180522165433481' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223482'
                WHERE ordernumber = 'P190522165603636' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391353'
                WHERE ordernumber = 'P190522170116649' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325590'
                WHERE ordernumber = 'P790522170315438' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99654'
                WHERE ordernumber = 'P200522170457627' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284478'
                WHERE ordernumber = 'P200522170654866' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391356'
                WHERE ordernumber = 'P790522170900992' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378485'
                WHERE ordernumber = 'P710522171100866' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391355'
                WHERE ordernumber = 'P420522171153120' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391066'
                WHERE ordernumber = 'P200522171947771' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356340'
                WHERE ordernumber = 'P200522174019604' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391360'
                WHERE ordernumber = 'P200522174256454' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391361'
                WHERE ordernumber = 'P180522174335456' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266880'
                WHERE ordernumber = 'P190522174431867' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264172'
                WHERE ordernumber = 'P200522174816577' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391364'
                WHERE ordernumber = 'P200522174901638' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391365'
                WHERE ordernumber = 'P190522174916489' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '360167'
                WHERE ordernumber = 'P420522175109550' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '42973'
                WHERE ordernumber = 'P180522175337839' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137117'
                WHERE ordernumber = 'P190522175352227' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137117'
                WHERE ordernumber = 'P190522175434536' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391367'
                WHERE ordernumber = 'P190522175658374' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390047'
                WHERE ordernumber = 'P200522175849423' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391370'
                WHERE ordernumber = 'P790522180105941' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '225398'
                WHERE ordernumber = 'P180522180144785' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391369'
                WHERE ordernumber = 'P790522180330692' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287551'
                WHERE ordernumber = 'P190522180802853' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391372'
                WHERE ordernumber = 'P180522180820879' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391373'
                WHERE ordernumber = 'P200522180824558' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391374'
                WHERE ordernumber = 'P420522180850211' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391375'
                WHERE ordernumber = 'P190522181113349' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391376'
                WHERE ordernumber = 'P190522181455788' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391375'
                WHERE ordernumber = 'P190522181626599' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391378'
                WHERE ordernumber = 'P630522181826297' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391379'
                WHERE ordernumber = 'P180522181931396' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273486'
                WHERE ordernumber = 'P180522182031575' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391380'
                WHERE ordernumber = 'P180522182353192' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391381'
                WHERE ordernumber = 'P180522183014608' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '325219'
                WHERE ordernumber = 'P180522183121965' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391382'
                WHERE ordernumber = 'P180522183413246' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '390164'
                WHERE ordernumber = 'P420522183423534' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391383'
                WHERE ordernumber = 'P420522183824190' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391384'
                WHERE ordernumber = 'P190522184252929' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281300'
                WHERE ordernumber = 'P190522184338945' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391385'
                WHERE ordernumber = 'P200522184443498' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312392'
                WHERE ordernumber = 'P420522184857931' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307752'
                WHERE ordernumber = 'P200522185136915' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220368'
                WHERE ordernumber = 'P190522185319507' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391387'
                WHERE ordernumber = 'P190522190606131' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391388'
                WHERE ordernumber = 'P190522190736967' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391391'
                WHERE ordernumber = 'P200522191434948' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391392'
                WHERE ordernumber = 'P200522191733345' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391393'
                WHERE ordernumber = 'P190522191845317' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384178'
                WHERE ordernumber = 'P190522192004774' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391394'
                WHERE ordernumber = 'P190522192208419' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391395'
                WHERE ordernumber = 'P190522192322693' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '391396'
                WHERE ordernumber = 'P190522192551263' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380463'
                WHERE ordernumber = 'P200522193238672' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132907'
                WHERE ordernumber = 'P200522193754266' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132907'
                WHERE ordernumber = 'P200522193902897' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271900'
                WHERE ordernumber = 'P190522193951210' 
            
2024-05-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '132907'
                WHERE ordernumber = 'P200522194009119' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385853'
                WHERE ordernumber = 'P190522194349436' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391399'
                WHERE ordernumber = 'P710522194403623' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319132'
                WHERE ordernumber = 'P190522194725680' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391402'
                WHERE ordernumber = 'P190522195640918' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391403'
                WHERE ordernumber = 'P790522201232891' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391404'
                WHERE ordernumber = 'P790522202838569' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391407'
                WHERE ordernumber = 'P790522203904131' 
            
2024-05-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '391417'
                WHERE ordernumber = 'P710522213635861'