2024-05-03 01:00:02 -- 將會員中心id寫入data-lake
2024-05-03 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-02%';
        
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '128547'
                WHERE ordernumber = 'P180502110209527' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387896'
                WHERE ordernumber = 'P180502110340115' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387897'
                WHERE ordernumber = 'P200502110442661' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387898'
                WHERE ordernumber = 'P180502110520123' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387900'
                WHERE ordernumber = 'P180502110607118' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387901'
                WHERE ordernumber = 'P200502110743532' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387896'
                WHERE ordernumber = 'P190502110816779' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139459'
                WHERE ordernumber = 'P180502110850875' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367263'
                WHERE ordernumber = 'P180502111135576' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139459'
                WHERE ordernumber = 'P190502111145607' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387903'
                WHERE ordernumber = 'P790502111211967' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328853'
                WHERE ordernumber = 'P180502111354704' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284809'
                WHERE ordernumber = 'P420502111409121' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387904'
                WHERE ordernumber = 'P190502111411212' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80996'
                WHERE ordernumber = 'P180502111454676' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387906'
                WHERE ordernumber = 'P180502111852519' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230318'
                WHERE ordernumber = 'P180502111943759' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '162308'
                WHERE ordernumber = 'P180502112050874' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387907'
                WHERE ordernumber = 'P420502112157427' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386121'
                WHERE ordernumber = 'P180502112549818' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251367'
                WHERE ordernumber = 'P420502112731883' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387908'
                WHERE ordernumber = 'P420502112749560' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315203'
                WHERE ordernumber = 'P180502113021676' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384129'
                WHERE ordernumber = 'P180502113216386' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387910'
                WHERE ordernumber = 'P200502113459678' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387911'
                WHERE ordernumber = 'P180502113707581' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '167289'
                WHERE ordernumber = 'P200502113849305' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387893'
                WHERE ordernumber = 'P200502113922338' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387912'
                WHERE ordernumber = 'P200502114509762' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378098'
                WHERE ordernumber = 'P630502114707166' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387913'
                WHERE ordernumber = 'P180502115408828' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387916'
                WHERE ordernumber = 'P180502120152436' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387913'
                WHERE ordernumber = 'P180502120534865' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387917'
                WHERE ordernumber = 'P190502120534431' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387918'
                WHERE ordernumber = 'P420502120551904' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274687'
                WHERE ordernumber = 'P200502121044561' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P200502121408148' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385809'
                WHERE ordernumber = 'P200502121550536' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387919'
                WHERE ordernumber = 'P180502122010862' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345486'
                WHERE ordernumber = 'P190502122113286' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387920'
                WHERE ordernumber = 'P790502122439683' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385809'
                WHERE ordernumber = 'P200502122902385' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387922'
                WHERE ordernumber = 'P180502123228637' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '323640'
                WHERE ordernumber = 'P630502123438891' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286085'
                WHERE ordernumber = 'P180502123449645' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '270974'
                WHERE ordernumber = 'P200502123450195' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297787'
                WHERE ordernumber = 'P180502123642813' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329353'
                WHERE ordernumber = 'P180502124556875' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387928'
                WHERE ordernumber = 'P200502125504137' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329220'
                WHERE ordernumber = 'P180502125855620' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359391'
                WHERE ordernumber = 'P200502130043618' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387929'
                WHERE ordernumber = 'P790502130437990' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P420502130442337' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96862'
                WHERE ordernumber = 'P180502130537363' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242005'
                WHERE ordernumber = 'P200502130732484' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295010'
                WHERE ordernumber = 'P200502131146115' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387930'
                WHERE ordernumber = 'P180502131327472' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '66860'
                WHERE ordernumber = 'P180502131427965' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370568'
                WHERE ordernumber = 'P180502131525595' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370568'
                WHERE ordernumber = 'P180502131612828' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387931'
                WHERE ordernumber = 'P200502132217115' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '295437'
                WHERE ordernumber = 'P200502132603147' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387933'
                WHERE ordernumber = 'P180502133109254' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '233813'
                WHERE ordernumber = 'P200502133157925' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387932'
                WHERE ordernumber = 'P790502133224380' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387934'
                WHERE ordernumber = 'P180502133530262' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280878'
                WHERE ordernumber = 'P200502133710853' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387936'
                WHERE ordernumber = 'P420502134139988' 
            
2024-05-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387937'
                WHERE ordernumber = 'P180502134402130' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358757'
                WHERE ordernumber = 'P200502134419343' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276908'
                WHERE ordernumber = 'P200502135335846' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345587'
                WHERE ordernumber = 'P180502135806431' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387941'
                WHERE ordernumber = 'P200502135832273' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387942'
                WHERE ordernumber = 'P420502140538844' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279891'
                WHERE ordernumber = 'P190502140817901' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387943'
                WHERE ordernumber = 'P180502140824831' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387944'
                WHERE ordernumber = 'P200502141249695' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66007'
                WHERE ordernumber = 'P180502141522437' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279256'
                WHERE ordernumber = 'P630502141532900' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387946'
                WHERE ordernumber = 'P180502141916791' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387947'
                WHERE ordernumber = 'P420502141925900' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248642'
                WHERE ordernumber = 'P180502142659292' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387948'
                WHERE ordernumber = 'P790502143730837' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377965'
                WHERE ordernumber = 'P180502143822790' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368587'
                WHERE ordernumber = 'P190502143941686' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P180502143937701' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368587'
                WHERE ordernumber = 'P190502144041917' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387949'
                WHERE ordernumber = 'P790502144221238' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387950'
                WHERE ordernumber = 'P180502144357749' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387511'
                WHERE ordernumber = 'P420502144725859' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '318845'
                WHERE ordernumber = 'P180502145110855' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228556'
                WHERE ordernumber = 'P180502145311331' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387953'
                WHERE ordernumber = 'P420502145459918' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387954'
                WHERE ordernumber = 'P190502145650624' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387955'
                WHERE ordernumber = 'P790502145800469' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387956'
                WHERE ordernumber = 'P790502150100992' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387957'
                WHERE ordernumber = 'P180502150637226' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295073'
                WHERE ordernumber = 'P200502150925704' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387958'
                WHERE ordernumber = 'P790502151141692' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387960'
                WHERE ordernumber = 'P420502151348364' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '257126'
                WHERE ordernumber = 'P200502151549483' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '357592'
                WHERE ordernumber = 'P200502151743483' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '252058'
                WHERE ordernumber = 'P200502151912473' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387964'
                WHERE ordernumber = 'P180502152131795' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387963'
                WHERE ordernumber = 'P790502152330863' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387965'
                WHERE ordernumber = 'P180502152349880' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387966'
                WHERE ordernumber = 'P180502152557159' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345872'
                WHERE ordernumber = 'P190502152634491' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253344'
                WHERE ordernumber = 'P200502152858215' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '384178'
                WHERE ordernumber = 'P180502153002300' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387967'
                WHERE ordernumber = 'P190502153054277' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222506'
                WHERE ordernumber = 'P180502153532806' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387968'
                WHERE ordernumber = 'P200502154132470' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387969'
                WHERE ordernumber = 'P790502154225596' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387971'
                WHERE ordernumber = 'P180502155533294' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387971'
                WHERE ordernumber = 'P180502155829660' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387974'
                WHERE ordernumber = 'P180502160623411' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387973'
                WHERE ordernumber = 'P790502160904710' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213832'
                WHERE ordernumber = 'P200502161202576' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113421'
                WHERE ordernumber = 'P180502161334975' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387975'
                WHERE ordernumber = 'P200502161549364' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328419'
                WHERE ordernumber = 'P180502161818655' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165627'
                WHERE ordernumber = 'P200502161848337' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374206'
                WHERE ordernumber = 'P420502161918534' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215107'
                WHERE ordernumber = 'P200502162000731' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387977'
                WHERE ordernumber = 'P180502162006680' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387976'
                WHERE ordernumber = 'P190502162003594' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352011'
                WHERE ordernumber = 'P180502162201226' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387459'
                WHERE ordernumber = 'P200502162712674' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387020'
                WHERE ordernumber = 'P180502162745463' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387459'
                WHERE ordernumber = 'P200502162806882' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334915'
                WHERE ordernumber = 'P200502163008255' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387978'
                WHERE ordernumber = 'P420502163037325' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387981'
                WHERE ordernumber = 'P420502163720685' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387980'
                WHERE ordernumber = 'P790502163727735' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215525'
                WHERE ordernumber = 'P180502164752645' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '122420'
                WHERE ordernumber = 'P180502165035651' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221426'
                WHERE ordernumber = 'P180502165240631' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364000'
                WHERE ordernumber = 'P200502165434368' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387982'
                WHERE ordernumber = 'P200502165843719' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377898'
                WHERE ordernumber = 'P200502165947903' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385851'
                WHERE ordernumber = 'P200502170310895' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374299'
                WHERE ordernumber = 'P190502170900997' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283689'
                WHERE ordernumber = 'P200502170940278' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387983'
                WHERE ordernumber = 'P200502171331960' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387986'
                WHERE ordernumber = 'P180502171647754' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347676'
                WHERE ordernumber = 'P180502171816446' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273623'
                WHERE ordernumber = 'P200502171827588' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382774'
                WHERE ordernumber = 'P180502172412824' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387987'
                WHERE ordernumber = 'P200502172615365' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387988'
                WHERE ordernumber = 'P790502172854237' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289368'
                WHERE ordernumber = 'P420502173015282' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387989'
                WHERE ordernumber = 'P200502173114888' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383472'
                WHERE ordernumber = 'P420502173312164' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387991'
                WHERE ordernumber = 'P190502173511807' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383472'
                WHERE ordernumber = 'P420502173528732' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387990'
                WHERE ordernumber = 'P630502173554286' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103201'
                WHERE ordernumber = 'P190502173654116' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387992'
                WHERE ordernumber = 'P200502173747751' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P200502174006828' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387281'
                WHERE ordernumber = 'P200502174045459' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387993'
                WHERE ordernumber = 'P790502174433687' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387994'
                WHERE ordernumber = 'P630502174510620' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387995'
                WHERE ordernumber = 'P790502174706169' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387996'
                WHERE ordernumber = 'P790502174936720' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375446'
                WHERE ordernumber = 'P630502174951368' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143596'
                WHERE ordernumber = 'P200502175000172' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '104455'
                WHERE ordernumber = 'P180502175007544' 
            
2024-05-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387997'
                WHERE ordernumber = 'P790502175030793' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387997'
                WHERE ordernumber = 'P790502175105226' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95862'
                WHERE ordernumber = 'P180502175159521' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387998'
                WHERE ordernumber = 'P180502175421405' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314814'
                WHERE ordernumber = 'P200502175425481' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230288'
                WHERE ordernumber = 'P200502180125937' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358840'
                WHERE ordernumber = 'P200502180407247' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387999'
                WHERE ordernumber = 'P790502180554644' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306298'
                WHERE ordernumber = 'P180502180612249' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388000'
                WHERE ordernumber = 'P200502180830895' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388001'
                WHERE ordernumber = 'P200502180922752' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388002'
                WHERE ordernumber = 'P200502181333555' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287292'
                WHERE ordernumber = 'P180502181531669' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388004'
                WHERE ordernumber = 'P790502181804543' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '211888'
                WHERE ordernumber = 'P180502182046624' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388005'
                WHERE ordernumber = 'P420502182118501' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228192'
                WHERE ordernumber = 'P180502182711500' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630502182714494' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388006'
                WHERE ordernumber = 'P180502183130910' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269642'
                WHERE ordernumber = 'P200502183356376' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230557'
                WHERE ordernumber = 'P200502183650921' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384880'
                WHERE ordernumber = 'P200502184232233' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385492'
                WHERE ordernumber = 'P200502184518622' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388008'
                WHERE ordernumber = 'P190502184522932' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388009'
                WHERE ordernumber = 'P190502184932636' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387068'
                WHERE ordernumber = 'P190502185244485' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265381'
                WHERE ordernumber = 'P190502185406431' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388010'
                WHERE ordernumber = 'P200502190051664' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306109'
                WHERE ordernumber = 'P200502190145186' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '55673'
                WHERE ordernumber = 'P200502190434131' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '314207'
                WHERE ordernumber = 'P190502190522705' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385871'
                WHERE ordernumber = 'P190502190804942' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388011'
                WHERE ordernumber = 'P200502191014187' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123516'
                WHERE ordernumber = 'P590502191114264' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240871'
                WHERE ordernumber = 'P200502191128519' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277235'
                WHERE ordernumber = 'P190502191236407' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386309'
                WHERE ordernumber = 'P420502191237647' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277235'
                WHERE ordernumber = 'P190502191335416' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388012'
                WHERE ordernumber = 'P420502191715499' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '385489'
                WHERE ordernumber = 'P190502191735545' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P200502192048288' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371062'
                WHERE ordernumber = 'P190502192601439' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388013'
                WHERE ordernumber = 'P630502192736628' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '137009'
                WHERE ordernumber = 'P420502192900463' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388014'
                WHERE ordernumber = 'P200502193048377' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388016'
                WHERE ordernumber = 'P200502193600194' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388018'
                WHERE ordernumber = 'P420502193902384' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358349'
                WHERE ordernumber = 'P200502194057144' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '290405'
                WHERE ordernumber = 'P190502194338627' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388019'
                WHERE ordernumber = 'P200502194453690' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387244'
                WHERE ordernumber = 'P190502194714535' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388020'
                WHERE ordernumber = 'P200502194735256' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387720'
                WHERE ordernumber = 'P190502195027617' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104346'
                WHERE ordernumber = 'P200502195101270' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117187'
                WHERE ordernumber = 'P200502195453292' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388021'
                WHERE ordernumber = 'P200502195635759' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388022'
                WHERE ordernumber = 'P200502200111337' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388024'
                WHERE ordernumber = 'P630502211056186' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '387871'
                WHERE ordernumber = 'P790502211458939' 
            
2024-05-03 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388029'
                WHERE ordernumber = 'P630502212127337'