2024-03-10 01:00:02 -- 將會員中心id寫入data-lake
2024-03-10 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-03-09%';
        
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297186'
                WHERE ordernumber = 'P420309102852919' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '262466'
                WHERE ordernumber = 'P420309104858941' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298816'
                WHERE ordernumber = 'P190309110135809' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380721'
                WHERE ordernumber = 'P190309110350807' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380722'
                WHERE ordernumber = 'P190309110453887' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380723'
                WHERE ordernumber = 'P180309110549632' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378296'
                WHERE ordernumber = 'P180309111153206' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364955'
                WHERE ordernumber = 'P180309111703954' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '252840'
                WHERE ordernumber = 'P200309111851816' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '118704'
                WHERE ordernumber = 'P180309112137820' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380726'
                WHERE ordernumber = 'P420309112301132' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '82089'
                WHERE ordernumber = 'P180309112357736' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '369186'
                WHERE ordernumber = 'P200309112401631' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '253616'
                WHERE ordernumber = 'P180309112457718' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380724'
                WHERE ordernumber = 'P180309112716637' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348002'
                WHERE ordernumber = 'P420309112913286' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '372416'
                WHERE ordernumber = 'P180309113421352' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '343632'
                WHERE ordernumber = 'P420309114119188' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380727'
                WHERE ordernumber = 'P420309114741584' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288749'
                WHERE ordernumber = 'P200309115055129' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380728'
                WHERE ordernumber = 'P420309115114628' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339611'
                WHERE ordernumber = 'P420309115406649' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380730'
                WHERE ordernumber = 'P420309115521666' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380729'
                WHERE ordernumber = 'P200309115549155' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380729'
                WHERE ordernumber = 'P200309115623503' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284943'
                WHERE ordernumber = 'P190309120855170' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272754'
                WHERE ordernumber = 'P180309120949279' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159425'
                WHERE ordernumber = 'P200309122259395' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380732'
                WHERE ordernumber = 'P180309122355922' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '272928'
                WHERE ordernumber = 'P200309122520638' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212515'
                WHERE ordernumber = 'P190309122619685' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380733'
                WHERE ordernumber = 'P190309123005152' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380735'
                WHERE ordernumber = 'P180309123100327' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357748'
                WHERE ordernumber = 'P180309123658291' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377834'
                WHERE ordernumber = 'P420309124041145' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380736'
                WHERE ordernumber = 'P180309124232227' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380737'
                WHERE ordernumber = 'P180309124411212' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234843'
                WHERE ordernumber = 'P190309125139598' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380738'
                WHERE ordernumber = 'P180309125216145' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380739'
                WHERE ordernumber = 'P420309125502475' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380741'
                WHERE ordernumber = 'P180309125718435' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283418'
                WHERE ordernumber = 'P200309125805709' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380742'
                WHERE ordernumber = 'P420309125954142' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380743'
                WHERE ordernumber = 'P180309130123376' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380744'
                WHERE ordernumber = 'P590309130728636' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352826'
                WHERE ordernumber = 'P420309131339709' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339611'
                WHERE ordernumber = 'P420309132424241' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290497'
                WHERE ordernumber = 'P200309132611712' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '360096'
                WHERE ordernumber = 'P420309133205777' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380747'
                WHERE ordernumber = 'P180309133952987' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '347352'
                WHERE ordernumber = 'P180309134113501' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377820'
                WHERE ordernumber = 'P420309134119235' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380748'
                WHERE ordernumber = 'P200309134228782' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '264756'
                WHERE ordernumber = 'P200309134403993' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380608'
                WHERE ordernumber = 'P200309134533869' 
            
2024-03-10 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '375353'
                WHERE ordernumber = 'P420309134617387' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289933'
                WHERE ordernumber = 'P200309134654630' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380750'
                WHERE ordernumber = 'P420309134834514' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380751'
                WHERE ordernumber = 'P200309135729856' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128677'
                WHERE ordernumber = 'P180309140356934' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380754'
                WHERE ordernumber = 'P200309140809841' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380755'
                WHERE ordernumber = 'P200309141032598' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301477'
                WHERE ordernumber = 'P190309141136498' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262414'
                WHERE ordernumber = 'P190309141422396' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379390'
                WHERE ordernumber = 'P200309142118336' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95844'
                WHERE ordernumber = 'P200309142224835' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '354723'
                WHERE ordernumber = 'P420309142547404' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380756'
                WHERE ordernumber = 'P190309142801806' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233407'
                WHERE ordernumber = 'P200309143143660' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380757'
                WHERE ordernumber = 'P420309143303242' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380758'
                WHERE ordernumber = 'P420309143549398' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380759'
                WHERE ordernumber = 'P200309143820369' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321461'
                WHERE ordernumber = 'P190309143835997' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380760'
                WHERE ordernumber = 'P200309143938460' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306952'
                WHERE ordernumber = 'P190309144129130' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380746'
                WHERE ordernumber = 'P180309144142390' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376618'
                WHERE ordernumber = 'P180309144213268' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281882'
                WHERE ordernumber = 'P420309144310375' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380761'
                WHERE ordernumber = 'P420309144401816' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380762'
                WHERE ordernumber = 'P190309144705111' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380762'
                WHERE ordernumber = 'P190309144737920' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380763'
                WHERE ordernumber = 'P590309144927391' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '200378'
                WHERE ordernumber = 'P180309145226162' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380764'
                WHERE ordernumber = 'P190309145653742' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380765'
                WHERE ordernumber = 'P420309145842603' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259735'
                WHERE ordernumber = 'P180309150038622' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380766'
                WHERE ordernumber = 'P420309150059241' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373111'
                WHERE ordernumber = 'P180309150316308' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '213832'
                WHERE ordernumber = 'P200309151537959' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380769'
                WHERE ordernumber = 'P590309151649981' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380770'
                WHERE ordernumber = 'P420309151930740' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380768'
                WHERE ordernumber = 'P590309151945680' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380771'
                WHERE ordernumber = 'P420309152301993' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380773'
                WHERE ordernumber = 'P200309152526654' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380774'
                WHERE ordernumber = 'P420309152554121' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380775'
                WHERE ordernumber = 'P420309152650593' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271305'
                WHERE ordernumber = 'P180309152717702' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278936'
                WHERE ordernumber = 'P420309153653696' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380776'
                WHERE ordernumber = 'P200309153736660' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380779'
                WHERE ordernumber = 'P420309153945402' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289642'
                WHERE ordernumber = 'P420309154135778' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233952'
                WHERE ordernumber = 'P200309154444147' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380781'
                WHERE ordernumber = 'P420309154536394' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380778'
                WHERE ordernumber = 'P590309154614352' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380777'
                WHERE ordernumber = 'P590309154716998' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380782'
                WHERE ordernumber = 'P420309154717717' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380783'
                WHERE ordernumber = 'P190309154822356' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380784'
                WHERE ordernumber = 'P420309154926328' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380781'
                WHERE ordernumber = 'P420309155227934' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380785'
                WHERE ordernumber = 'P420309155322776' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380786'
                WHERE ordernumber = 'P180309155355704' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377386'
                WHERE ordernumber = 'P420309155428755' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '362474'
                WHERE ordernumber = 'P180309155659177' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380788'
                WHERE ordernumber = 'P420309155708998' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380789'
                WHERE ordernumber = 'P420309155833708' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230102'
                WHERE ordernumber = 'P180309160158253' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380790'
                WHERE ordernumber = 'P420309160442648' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380787'
                WHERE ordernumber = 'P200309160812739' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272726'
                WHERE ordernumber = 'P200309160911520' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380792'
                WHERE ordernumber = 'P200309161016996' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211355'
                WHERE ordernumber = 'P200309161310186' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380795'
                WHERE ordernumber = 'P200309161446909' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380797'
                WHERE ordernumber = 'P200309161801167' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380794'
                WHERE ordernumber = 'P590309161806145' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380796'
                WHERE ordernumber = 'P190309161818825' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380798'
                WHERE ordernumber = 'P200309161947616' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380799'
                WHERE ordernumber = 'P180309162236452' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380800'
                WHERE ordernumber = 'P180309162327770' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346028'
                WHERE ordernumber = 'P420309162508145' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380801'
                WHERE ordernumber = 'P200309162649142' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380802'
                WHERE ordernumber = 'P200309162819181' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380804'
                WHERE ordernumber = 'P190309162925172' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310551'
                WHERE ordernumber = 'P200309163101553' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380807'
                WHERE ordernumber = 'P420309163220953' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380808'
                WHERE ordernumber = 'P180309163427556' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294327'
                WHERE ordernumber = 'P420309163528573' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380809'
                WHERE ordernumber = 'P180309163824329' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380810'
                WHERE ordernumber = 'P180309164114890' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '65589'
                WHERE ordernumber = 'P200309164117897' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346343'
                WHERE ordernumber = 'P420309164203595' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380812'
                WHERE ordernumber = 'P200309164222951' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P190309164531468' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380814'
                WHERE ordernumber = 'P420309164728202' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216410'
                WHERE ordernumber = 'P200309164743975' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219239'
                WHERE ordernumber = 'P180309164950867' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P190309165509656' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380816'
                WHERE ordernumber = 'P200309170017377' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '109535'
                WHERE ordernumber = 'P180309170124976' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380815'
                WHERE ordernumber = 'P200309170153402' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63111'
                WHERE ordernumber = 'P200309170320846' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380817'
                WHERE ordernumber = 'P420309170505362' 
            
2024-03-10 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380818'
                WHERE ordernumber = 'P200309170517891' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380819'
                WHERE ordernumber = 'P420309170558403' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380820'
                WHERE ordernumber = 'P200309170659178' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380821'
                WHERE ordernumber = 'P420309170702800' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380822'
                WHERE ordernumber = 'P190309170709771' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '109535'
                WHERE ordernumber = 'P180309170713987' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '331098'
                WHERE ordernumber = 'P200309170754946' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380823'
                WHERE ordernumber = 'P180309171054961' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '94814'
                WHERE ordernumber = 'P180309172106590' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '378446'
                WHERE ordernumber = 'P180309172328895' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304025'
                WHERE ordernumber = 'P180309172522763' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230932'
                WHERE ordernumber = 'P200309172708546' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149333'
                WHERE ordernumber = 'P200309172855518' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304025'
                WHERE ordernumber = 'P180309173159794' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380826'
                WHERE ordernumber = 'P420309173343646' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128983'
                WHERE ordernumber = 'P420309173451419' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380827'
                WHERE ordernumber = 'P200309173451848' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '213930'
                WHERE ordernumber = 'P180309173653384' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380828'
                WHERE ordernumber = 'P200309173659147' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281945'
                WHERE ordernumber = 'P200309173918501' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380829'
                WHERE ordernumber = 'P200309174149123' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380830'
                WHERE ordernumber = 'P200309174318542' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380831'
                WHERE ordernumber = 'P200309174418502' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '108179'
                WHERE ordernumber = 'P190309174524532' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265591'
                WHERE ordernumber = 'P200309174602532' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '235023'
                WHERE ordernumber = 'P200309175443216' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276802'
                WHERE ordernumber = 'P200309175855804' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '74302'
                WHERE ordernumber = 'P200309180436446' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320317'
                WHERE ordernumber = 'P200309180551858' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380832'
                WHERE ordernumber = 'P180309180709928' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379753'
                WHERE ordernumber = 'P180309181038756' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380834'
                WHERE ordernumber = 'P180309181243981' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380299'
                WHERE ordernumber = 'P200309181408795' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380835'
                WHERE ordernumber = 'P590309182834260' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380837'
                WHERE ordernumber = 'P420309183105634' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380838'
                WHERE ordernumber = 'P190309183247162' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '147075'
                WHERE ordernumber = 'P200309183402681' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '147075'
                WHERE ordernumber = 'P200309183610421' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380839'
                WHERE ordernumber = 'P200309183819960' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380840'
                WHERE ordernumber = 'P200309184013699' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380841'
                WHERE ordernumber = 'P190309184125567' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '301428'
                WHERE ordernumber = 'P190309184433136' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380842'
                WHERE ordernumber = 'P190309184606620' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380843'
                WHERE ordernumber = 'P200309184746949' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373915'
                WHERE ordernumber = 'P420309185252473' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380844'
                WHERE ordernumber = 'P200309185404779' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380845'
                WHERE ordernumber = 'P190309185409942' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380845'
                WHERE ordernumber = 'P190309185445616' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93668'
                WHERE ordernumber = 'P190309185609232' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380846'
                WHERE ordernumber = 'P200309185946153' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380848'
                WHERE ordernumber = 'P190309190830668' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304431'
                WHERE ordernumber = 'P190309191013269' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380849'
                WHERE ordernumber = 'P200309191326425' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380850'
                WHERE ordernumber = 'P200309191632662' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136306'
                WHERE ordernumber = 'P420309191959783' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380852'
                WHERE ordernumber = 'P200309194606570' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380853'
                WHERE ordernumber = 'P200309194730254' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379377'
                WHERE ordernumber = 'P200309195006309' 
            
2024-03-10 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380855'
                WHERE ordernumber = 'P200309195245532'