2024-12-20 01:00:01 -- 將會員中心id寫入data-lake
2024-12-20 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-12-19%';
        
2024-12-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '219678'
                WHERE ordernumber = 'P2412190001089' 
            
2024-12-20 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P2412190001124' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437103'
                WHERE ordernumber = 'P2412190001266' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283089'
                WHERE ordernumber = 'P2412190001352' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437106'
                WHERE ordernumber = 'P2412190001435' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437106'
                WHERE ordernumber = 'P2412190001634' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302352'
                WHERE ordernumber = 'P2412190001732' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '322291'
                WHERE ordernumber = 'P2412190002076' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '390474'
                WHERE ordernumber = 'P2412190002292' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425424'
                WHERE ordernumber = 'P2412190002384' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437108'
                WHERE ordernumber = 'P2412190002436' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437107'
                WHERE ordernumber = 'P2412190002543' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130301'
                WHERE ordernumber = 'P2412190002685' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96536'
                WHERE ordernumber = 'P2412190002713' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437110'
                WHERE ordernumber = 'P2412190002978' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437110'
                WHERE ordernumber = 'P2412190003053' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386235'
                WHERE ordernumber = 'P2412190003188' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100658'
                WHERE ordernumber = 'P2412190003534' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435340'
                WHERE ordernumber = 'P2412190003696' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436896'
                WHERE ordernumber = 'P2412190003771' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '302354'
                WHERE ordernumber = 'P2412190003947' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437120'
                WHERE ordernumber = 'P2412190004036' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437121'
                WHERE ordernumber = 'P2412190004341' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274966'
                WHERE ordernumber = 'P2412190004443' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437120'
                WHERE ordernumber = 'P2412190004578' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101057'
                WHERE ordernumber = 'P2412190004942' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296924'
                WHERE ordernumber = 'P2412190005016' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437121'
                WHERE ordernumber = 'P2412190005163' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437121'
                WHERE ordernumber = 'P2412190005365' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277731'
                WHERE ordernumber = 'P2412190005433' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277731'
                WHERE ordernumber = 'P2412190005619' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '245088'
                WHERE ordernumber = 'P2412190006168' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437137'
                WHERE ordernumber = 'P2412190006345' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437137'
                WHERE ordernumber = 'P2412190006484' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P2412190006550' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '79034'
                WHERE ordernumber = 'P2412190006675' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437140'
                WHERE ordernumber = 'P2412190006722' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251911'
                WHERE ordernumber = 'P2412190007034' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '303132'
                WHERE ordernumber = 'P2412190007466' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432656'
                WHERE ordernumber = 'P2412190007710' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437121'
                WHERE ordernumber = 'P2412190007839' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '115637'
                WHERE ordernumber = 'P2412190008080' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P2412190008573' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2412190008697' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '263058'
                WHERE ordernumber = 'P2412190008872' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281733'
                WHERE ordernumber = 'P2412190008915' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '319052'
                WHERE ordernumber = 'P2412190009011' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98337'
                WHERE ordernumber = 'P2412190009281' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '435852'
                WHERE ordernumber = 'P2412190009389' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437165'
                WHERE ordernumber = 'P2412190009488' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '79034'
                WHERE ordernumber = 'P2412190009541' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341246'
                WHERE ordernumber = 'P2412190009618' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437166'
                WHERE ordernumber = 'P2412190009942' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '389101'
                WHERE ordernumber = 'P2412190010022' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284560'
                WHERE ordernumber = 'P2412190010144' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437164'
                WHERE ordernumber = 'P2412190010253' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437169'
                WHERE ordernumber = 'P2412190010379' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437156'
                WHERE ordernumber = 'P2412190010410' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426940'
                WHERE ordernumber = 'P2412190010568' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P2412190010712' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285220'
                WHERE ordernumber = 'P2412190010987' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437171'
                WHERE ordernumber = 'P2412190011036' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437173'
                WHERE ordernumber = 'P2412190011184' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437172'
                WHERE ordernumber = 'P2412190011444' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316333'
                WHERE ordernumber = 'P2412190011537' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437159'
                WHERE ordernumber = 'P2412190011671' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '281909'
                WHERE ordernumber = 'P2412190011964' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '308903'
                WHERE ordernumber = 'P2412190012014' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437178'
                WHERE ordernumber = 'P2412190012158' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309780'
                WHERE ordernumber = 'P2412190012242' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437180'
                WHERE ordernumber = 'P2412190012329' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437179'
                WHERE ordernumber = 'P2412190012483' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '407361'
                WHERE ordernumber = 'P2412190012579' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437182'
                WHERE ordernumber = 'P2412190012635' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '436444'
                WHERE ordernumber = 'P2412190012752' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437186'
                WHERE ordernumber = 'P2412190013113' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437185'
                WHERE ordernumber = 'P2412190013312' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432348'
                WHERE ordernumber = 'P2412190013669' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '254438'
                WHERE ordernumber = 'P2412190013846' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100500'
                WHERE ordernumber = 'P2412190013919' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437193'
                WHERE ordernumber = 'P2412190014043' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '88636'
                WHERE ordernumber = 'P2412190014249' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437196'
                WHERE ordernumber = 'P2412190014384' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437195'
                WHERE ordernumber = 'P2412190014460' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '119519'
                WHERE ordernumber = 'P2412190014715' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '432179'
                WHERE ordernumber = 'P2412190014842' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248668'
                WHERE ordernumber = 'P2412190014974' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437201'
                WHERE ordernumber = 'P2412190015089' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '130789'
                WHERE ordernumber = 'P2412190015449' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421953'
                WHERE ordernumber = 'P2412190015554' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422643'
                WHERE ordernumber = 'P2412190015878' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97952'
                WHERE ordernumber = 'P2412190015920' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437210'
                WHERE ordernumber = 'P2412190016491' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '223476'
                WHERE ordernumber = 'P2412190016898' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437211'
                WHERE ordernumber = 'P2412190016915' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437207'
                WHERE ordernumber = 'P2412190017058' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437212'
                WHERE ordernumber = 'P2412190017177' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437214'
                WHERE ordernumber = 'P2412190017236' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437206'
                WHERE ordernumber = 'P2412190017496' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437216'
                WHERE ordernumber = 'P2412190017648' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437218'
                WHERE ordernumber = 'P2412190017752' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286763'
                WHERE ordernumber = 'P2412190018059' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437219'
                WHERE ordernumber = 'P2412190018213' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402557'
                WHERE ordernumber = 'P2412190018383' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437215'
                WHERE ordernumber = 'P2412190018447' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277731'
                WHERE ordernumber = 'P2412190018516' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437220'
                WHERE ordernumber = 'P2412190018686' 
            
2024-12-20 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '437221'
                WHERE ordernumber = 'P2412190018892' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435073'
                WHERE ordernumber = 'P2412190018997' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437215'
                WHERE ordernumber = 'P2412190019118' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437224'
                WHERE ordernumber = 'P2412190019392' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437216'
                WHERE ordernumber = 'P2412190019485' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435073'
                WHERE ordernumber = 'P2412190019640' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348953'
                WHERE ordernumber = 'P2412190019758' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345014'
                WHERE ordernumber = 'P2412190019840' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437226'
                WHERE ordernumber = 'P2412190019938' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437207'
                WHERE ordernumber = 'P2412190020111' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127573'
                WHERE ordernumber = 'P2412190020284' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437228'
                WHERE ordernumber = 'P2412190020375' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310414'
                WHERE ordernumber = 'P2412190020596' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240953'
                WHERE ordernumber = 'P2412190020658' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '69094'
                WHERE ordernumber = 'P2412190020783' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277654'
                WHERE ordernumber = 'P2412190020955' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437137'
                WHERE ordernumber = 'P2412190021117' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215503'
                WHERE ordernumber = 'P2412190021292' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420013'
                WHERE ordernumber = 'P2412190021340' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239527'
                WHERE ordernumber = 'P2412190021569' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429146'
                WHERE ordernumber = 'P2412190021698' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315204'
                WHERE ordernumber = 'P2412190021746' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '297157'
                WHERE ordernumber = 'P2412190021815' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387976'
                WHERE ordernumber = 'P2412190021975' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436948'
                WHERE ordernumber = 'P2412190022197' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437229'
                WHERE ordernumber = 'P2412190022236' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219267'
                WHERE ordernumber = 'P2412190022491' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279433'
                WHERE ordernumber = 'P2412190022558' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435817'
                WHERE ordernumber = 'P2412190022671' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437232'
                WHERE ordernumber = 'P2412190023292' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437220'
                WHERE ordernumber = 'P2412190023330' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358703'
                WHERE ordernumber = 'P2412190023452' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282136'
                WHERE ordernumber = 'P2412190023634' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '47294'
                WHERE ordernumber = 'P2412190023720' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436954'
                WHERE ordernumber = 'P2412190024041' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437236'
                WHERE ordernumber = 'P2412190024187' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437237'
                WHERE ordernumber = 'P2412190024327' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119381'
                WHERE ordernumber = 'P2412190024664' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437238'
                WHERE ordernumber = 'P2412190024855' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '211568'
                WHERE ordernumber = 'P2412190024910' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437239'
                WHERE ordernumber = 'P2412190025282' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310147'
                WHERE ordernumber = 'P2412190025369' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114938'
                WHERE ordernumber = 'P2412190025426' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437140'
                WHERE ordernumber = 'P2412190025587' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432624'
                WHERE ordernumber = 'P2412190025610' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '435817'
                WHERE ordernumber = 'P2412190025813' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437241'
                WHERE ordernumber = 'P2412190025924' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116082'
                WHERE ordernumber = 'P2412190026123' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437146'
                WHERE ordernumber = 'P2412190026454' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437150'
                WHERE ordernumber = 'P2412190026652' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437151'
                WHERE ordernumber = 'P2412190026749' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437152'
                WHERE ordernumber = 'P2412190026854' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206631'
                WHERE ordernumber = 'P2412190026983' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437243'
                WHERE ordernumber = 'P2412190027149' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436929'
                WHERE ordernumber = 'P2412190027847' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437244'
                WHERE ordernumber = 'P2412190027989' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426487'
                WHERE ordernumber = 'P2412190028058' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436926'
                WHERE ordernumber = 'P2412190028142' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315224'
                WHERE ordernumber = 'P2412190028274' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436924'
                WHERE ordernumber = 'P2412190028383' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437247'
                WHERE ordernumber = 'P2412190028465' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '278444'
                WHERE ordernumber = 'P2412190028813' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '407358'
                WHERE ordernumber = 'P2412190028988' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '267984'
                WHERE ordernumber = 'P2412190029115' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '111289'
                WHERE ordernumber = 'P2412190029284' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436948'
                WHERE ordernumber = 'P2412190029596' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '148165'
                WHERE ordernumber = 'P2412190029750' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163294'
                WHERE ordernumber = 'P2412190030415' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421890'
                WHERE ordernumber = 'P2412190030697' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94455'
                WHERE ordernumber = 'P2412190030741' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106415'
                WHERE ordernumber = 'P2412190030898' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262027'
                WHERE ordernumber = 'P2412190031112' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219229'
                WHERE ordernumber = 'P2412190031264' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311192'
                WHERE ordernumber = 'P2412190031666' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284510'
                WHERE ordernumber = 'P2412190031770' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338215'
                WHERE ordernumber = 'P2412190031895' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382343'
                WHERE ordernumber = 'P2412190032089' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172861'
                WHERE ordernumber = 'P2412190032261' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280085'
                WHERE ordernumber = 'P2412190032349' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437256'
                WHERE ordernumber = 'P2412190032543' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '254652'
                WHERE ordernumber = 'P2412190032641' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404822'
                WHERE ordernumber = 'P2412190032794' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284927'
                WHERE ordernumber = 'P2412190032848' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430544'
                WHERE ordernumber = 'P2412190033031' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239396'
                WHERE ordernumber = 'P2412190033821' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399876'
                WHERE ordernumber = 'P2412190033946' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436916'
                WHERE ordernumber = 'P2412190034144' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '139551'
                WHERE ordernumber = 'P2412190034272' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '219229'
                WHERE ordernumber = 'P2412190034311' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240018'
                WHERE ordernumber = 'P2412190034496' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426672'
                WHERE ordernumber = 'P2412190034653' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437262'
                WHERE ordernumber = 'P2412190035348' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100952'
                WHERE ordernumber = 'P2412190035667' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229979'
                WHERE ordernumber = 'P2412190035838' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432453'
                WHERE ordernumber = 'P2412190035949' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303122'
                WHERE ordernumber = 'P2412190036092' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '76999'
                WHERE ordernumber = 'P2412190036145' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112805'
                WHERE ordernumber = 'P2412190036254' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381601'
                WHERE ordernumber = 'P2412190036598' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '412749'
                WHERE ordernumber = 'P2412190036824' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437266'
                WHERE ordernumber = 'P2412190036975' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430265'
                WHERE ordernumber = 'P2412190037194' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437268'
                WHERE ordernumber = 'P2412190037217' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365710'
                WHERE ordernumber = 'P2412190037320' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437270'
                WHERE ordernumber = 'P2412190037465' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365710'
                WHERE ordernumber = 'P2412190037565' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430125'
                WHERE ordernumber = 'P2412190037615' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217318'
                WHERE ordernumber = 'P2412190037767' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243564'
                WHERE ordernumber = 'P2412190037818' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241126'
                WHERE ordernumber = 'P2412190038110' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '105270'
                WHERE ordernumber = 'P2412190038281' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94254'
                WHERE ordernumber = 'P2412190038398' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '436412'
                WHERE ordernumber = 'P2412190038841' 
            
2024-12-20 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '437272'
                WHERE ordernumber = 'P2412190038973' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277899'
                WHERE ordernumber = 'P2412190039384' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436685'
                WHERE ordernumber = 'P2412190039450' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437275'
                WHERE ordernumber = 'P2412190039596' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2412190039670' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '96089'
                WHERE ordernumber = 'P2412190039748' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437276'
                WHERE ordernumber = 'P2412190039825' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161171'
                WHERE ordernumber = 'P2412190039929' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437279'
                WHERE ordernumber = 'P2412190040067' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436942'
                WHERE ordernumber = 'P2412190040156' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288433'
                WHERE ordernumber = 'P2412190040374' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '436942'
                WHERE ordernumber = 'P2412190040461' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '166284'
                WHERE ordernumber = 'P2412190040545' 
            
2024-12-20 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '437287'
                WHERE ordernumber = 'P2412190040663'