2024-12-09 01:00:01 -- 將會員中心id寫入data-lake
2024-12-09 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-08%';
        
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433941'
                WHERE ordernumber = 'P2412080000185' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433942'
                WHERE ordernumber = 'P2412080000293' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433943'
                WHERE ordernumber = 'P2412080000340' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328134'
                WHERE ordernumber = 'P2412080000434' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433944'
                WHERE ordernumber = 'P2412080000643' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386167'
                WHERE ordernumber = 'P2412080000835' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433945'
                WHERE ordernumber = 'P2412080000984' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433946'
                WHERE ordernumber = 'P2412080001199' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '353126'
                WHERE ordernumber = 'P2412080001249' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '383452'
                WHERE ordernumber = 'P2412080001428' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433947'
                WHERE ordernumber = 'P2412080001744' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '279193'
                WHERE ordernumber = 'P2412080001832' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433950'
                WHERE ordernumber = 'P2412080002099' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280056'
                WHERE ordernumber = 'P2412080002239' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380886'
                WHERE ordernumber = 'P2412080002341' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433951'
                WHERE ordernumber = 'P2412080002569' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433952'
                WHERE ordernumber = 'P2412080002787' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433956'
                WHERE ordernumber = 'P2412080002864' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431510'
                WHERE ordernumber = 'P2412080003067' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431510'
                WHERE ordernumber = 'P2412080003199' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431599'
                WHERE ordernumber = 'P2412080003267' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433957'
                WHERE ordernumber = 'P2412080003343' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433958'
                WHERE ordernumber = 'P2412080003745' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433953'
                WHERE ordernumber = 'P2412080003967' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '419560'
                WHERE ordernumber = 'P2412080004075' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433959'
                WHERE ordernumber = 'P2412080004295' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '40142'
                WHERE ordernumber = 'P2412080004491' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '40142'
                WHERE ordernumber = 'P2412080004512' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433959'
                WHERE ordernumber = 'P2412080004663' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '40142'
                WHERE ordernumber = 'P2412080004928' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433961'
                WHERE ordernumber = 'P2412080005171' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433955'
                WHERE ordernumber = 'P2412080005386' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '271879'
                WHERE ordernumber = 'P2412080005436' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '332115'
                WHERE ordernumber = 'P2412080005664' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433963'
                WHERE ordernumber = 'P2412080005767' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433964'
                WHERE ordernumber = 'P2412080006196' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340041'
                WHERE ordernumber = 'P2412080006266' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433965'
                WHERE ordernumber = 'P2412080006367' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404696'
                WHERE ordernumber = 'P2412080006429' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433967'
                WHERE ordernumber = 'P2412080006568' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433966'
                WHERE ordernumber = 'P2412080006672' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433969'
                WHERE ordernumber = 'P2412080006984' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433968'
                WHERE ordernumber = 'P2412080007065' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163362'
                WHERE ordernumber = 'P2412080007164' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401999'
                WHERE ordernumber = 'P2412080007397' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433744'
                WHERE ordernumber = 'P2412080007412' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433972'
                WHERE ordernumber = 'P2412080007788' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433965'
                WHERE ordernumber = 'P2412080007870' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433973'
                WHERE ordernumber = 'P2412080007965' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '421658'
                WHERE ordernumber = 'P2412080008179' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433571'
                WHERE ordernumber = 'P2412080008254' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433976'
                WHERE ordernumber = 'P2412080008373' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433979'
                WHERE ordernumber = 'P2412080008537' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433982'
                WHERE ordernumber = 'P2412080008623' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433980'
                WHERE ordernumber = 'P2412080008789' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433978'
                WHERE ordernumber = 'P2412080009226' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433974'
                WHERE ordernumber = 'P2412080009348' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433983'
                WHERE ordernumber = 'P2412080009467' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433975'
                WHERE ordernumber = 'P2412080009578' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220135'
                WHERE ordernumber = 'P2412080009868' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433986'
                WHERE ordernumber = 'P2412080009957' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433977'
                WHERE ordernumber = 'P2412080010043' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433989'
                WHERE ordernumber = 'P2412080010154' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433991'
                WHERE ordernumber = 'P2412080010551' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433988'
                WHERE ordernumber = 'P2412080010698' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433992'
                WHERE ordernumber = 'P2412080010738' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397025'
                WHERE ordernumber = 'P2412080010847' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '259262'
                WHERE ordernumber = 'P2412080011088' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433993'
                WHERE ordernumber = 'P2412080011165' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433996'
                WHERE ordernumber = 'P2412080011361' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '325065'
                WHERE ordernumber = 'P2412080011466' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433997'
                WHERE ordernumber = 'P2412080011546' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433994'
                WHERE ordernumber = 'P2412080011646' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433995'
                WHERE ordernumber = 'P2412080011873' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433990'
                WHERE ordernumber = 'P2412080011976' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433997'
                WHERE ordernumber = 'P2412080012232' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433992'
                WHERE ordernumber = 'P2412080012345' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433721'
                WHERE ordernumber = 'P2412080012454' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433998'
                WHERE ordernumber = 'P2412080012759' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '433999'
                WHERE ordernumber = 'P2412080012835' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434000'
                WHERE ordernumber = 'P2412080013017' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '434001'
                WHERE ordernumber = 'P2412080013120' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '145565'
                WHERE ordernumber = 'P2412080013521' 
            
2024-12-09 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '133492'
                WHERE ordernumber = 'P2412080013822' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431991'
                WHERE ordernumber = 'P2412080013936' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434006'
                WHERE ordernumber = 'P2412080014119' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425176'
                WHERE ordernumber = 'P2412080014355' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434004'
                WHERE ordernumber = 'P2412080014459' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145565'
                WHERE ordernumber = 'P2412080014510' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434007'
                WHERE ordernumber = 'P2412080014784' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434009'
                WHERE ordernumber = 'P2412080014883' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434008'
                WHERE ordernumber = 'P2412080014986' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434010'
                WHERE ordernumber = 'P2412080015064' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324168'
                WHERE ordernumber = 'P2412080015168' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433842'
                WHERE ordernumber = 'P2412080015265' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382304'
                WHERE ordernumber = 'P2412080015426' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433111'
                WHERE ordernumber = 'P2412080015622' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434014'
                WHERE ordernumber = 'P2412080015739' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434015'
                WHERE ordernumber = 'P2412080015864' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434011'
                WHERE ordernumber = 'P2412080015934' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434012'
                WHERE ordernumber = 'P2412080016261' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386597'
                WHERE ordernumber = 'P2412080016391' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '373486'
                WHERE ordernumber = 'P2412080016533' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434017'
                WHERE ordernumber = 'P2412080016698' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434013'
                WHERE ordernumber = 'P2412080016828' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434018'
                WHERE ordernumber = 'P2412080016949' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434018'
                WHERE ordernumber = 'P2412080017188' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304694'
                WHERE ordernumber = 'P2412080017283' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434016'
                WHERE ordernumber = 'P2412080017350' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434021'
                WHERE ordernumber = 'P2412080017427' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409702'
                WHERE ordernumber = 'P2412080017554' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345037'
                WHERE ordernumber = 'P2412080017618' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345037'
                WHERE ordernumber = 'P2412080017720' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142518'
                WHERE ordernumber = 'P2412080017957' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379762'
                WHERE ordernumber = 'P2412080018053' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403387'
                WHERE ordernumber = 'P2412080018124' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434024'
                WHERE ordernumber = 'P2412080018711' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94072'
                WHERE ordernumber = 'P2412080019088' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434025'
                WHERE ordernumber = 'P2412080019123' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234324'
                WHERE ordernumber = 'P2412080019226' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427639'
                WHERE ordernumber = 'P2412080019381' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434023'
                WHERE ordernumber = 'P2412080019559' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234324'
                WHERE ordernumber = 'P2412080019824' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '351423'
                WHERE ordernumber = 'P2412080019960' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434028'
                WHERE ordernumber = 'P2412080020114' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425743'
                WHERE ordernumber = 'P2412080020277' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434029'
                WHERE ordernumber = 'P2412080020343' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434030'
                WHERE ordernumber = 'P2412080020531' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142635'
                WHERE ordernumber = 'P2412080020789' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434031'
                WHERE ordernumber = 'P2412080020892' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434032'
                WHERE ordernumber = 'P2412080021039' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434034'
                WHERE ordernumber = 'P2412080021449' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286571'
                WHERE ordernumber = 'P2412080021510' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434041'
                WHERE ordernumber = 'P2412080021747' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434042'
                WHERE ordernumber = 'P2412080021872' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434043'
                WHERE ordernumber = 'P2412080021979' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434039'
                WHERE ordernumber = 'P2412080022020' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434044'
                WHERE ordernumber = 'P2412080022125' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434045'
                WHERE ordernumber = 'P2412080022383' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434035'
                WHERE ordernumber = 'P2412080022465' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425119'
                WHERE ordernumber = 'P2412080022587' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434033'
                WHERE ordernumber = 'P2412080022642' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433904'
                WHERE ordernumber = 'P2412080022878' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434033'
                WHERE ordernumber = 'P2412080022933' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433335'
                WHERE ordernumber = 'P2412080023019' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434048'
                WHERE ordernumber = 'P2412080023255' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434049'
                WHERE ordernumber = 'P2412080023316' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433335'
                WHERE ordernumber = 'P2412080023442' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433949'
                WHERE ordernumber = 'P2412080023563' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433949'
                WHERE ordernumber = 'P2412080023630' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434050'
                WHERE ordernumber = 'P2412080023862' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434051'
                WHERE ordernumber = 'P2412080023969' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434052'
                WHERE ordernumber = 'P2412080024025' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '206307'
                WHERE ordernumber = 'P2412080024151' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '432547'
                WHERE ordernumber = 'P2412080024235' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '397143'
                WHERE ordernumber = 'P2412080024378' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434053'
                WHERE ordernumber = 'P2412080024689' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434054'
                WHERE ordernumber = 'P2412080024928' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434053'
                WHERE ordernumber = 'P2412080025037' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '433904'
                WHERE ordernumber = 'P2412080025189' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97170'
                WHERE ordernumber = 'P2412080025552' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434056'
                WHERE ordernumber = 'P2412080025781' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429735'
                WHERE ordernumber = 'P2412080025837' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337540'
                WHERE ordernumber = 'P2412080025986' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434058'
                WHERE ordernumber = 'P2412080026072' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117919'
                WHERE ordernumber = 'P2412080026358' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '319115'
                WHERE ordernumber = 'P2412080026471' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '117919'
                WHERE ordernumber = 'P2412080026524' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434065'
                WHERE ordernumber = 'P2412080027074' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '28872'
                WHERE ordernumber = 'P2412080027220' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238127'
                WHERE ordernumber = 'P2412080027573' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434068'
                WHERE ordernumber = 'P2412080027687' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434071'
                WHERE ordernumber = 'P2412080027852' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434070'
                WHERE ordernumber = 'P2412080028256' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434063'
                WHERE ordernumber = 'P2412080028329' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434064'
                WHERE ordernumber = 'P2412080028477' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434072'
                WHERE ordernumber = 'P2412080028510' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434073'
                WHERE ordernumber = 'P2412080028772' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '429643'
                WHERE ordernumber = 'P2412080028934' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434075'
                WHERE ordernumber = 'P2412080029046' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434077'
                WHERE ordernumber = 'P2412080029286' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434067'
                WHERE ordernumber = 'P2412080029365' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434074'
                WHERE ordernumber = 'P2412080029496' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434078'
                WHERE ordernumber = 'P2412080029514' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305818'
                WHERE ordernumber = 'P2412080029810' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434081'
                WHERE ordernumber = 'P2412080029964' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434083'
                WHERE ordernumber = 'P2412080030194' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '321442'
                WHERE ordernumber = 'P2412080030319' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434082'
                WHERE ordernumber = 'P2412080030467' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434084'
                WHERE ordernumber = 'P2412080030596' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '434085'
                WHERE ordernumber = 'P2412080030648' 
            
2024-12-09 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430824'
                WHERE ordernumber = 'P2412080030733' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434087'
                WHERE ordernumber = 'P2412080030841' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276807'
                WHERE ordernumber = 'P2412080030990' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434083'
                WHERE ordernumber = 'P2412080031039' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434089'
                WHERE ordernumber = 'P2412080031392' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434088'
                WHERE ordernumber = 'P2412080031419' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434090'
                WHERE ordernumber = 'P2412080031599' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434079'
                WHERE ordernumber = 'P2412080031663' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252730'
                WHERE ordernumber = 'P2412080031783' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434080'
                WHERE ordernumber = 'P2412080031832' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '417153'
                WHERE ordernumber = 'P2412080031975' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434092'
                WHERE ordernumber = 'P2412080032016' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434091'
                WHERE ordernumber = 'P2412080032166' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434096'
                WHERE ordernumber = 'P2412080032244' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434092'
                WHERE ordernumber = 'P2412080032371' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434095'
                WHERE ordernumber = 'P2412080032478' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434097'
                WHERE ordernumber = 'P2412080032547' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359445'
                WHERE ordernumber = 'P2412080032776' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434099'
                WHERE ordernumber = 'P2412080032879' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400622'
                WHERE ordernumber = 'P2412080032929' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434100'
                WHERE ordernumber = 'P2412080033071' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434093'
                WHERE ordernumber = 'P2412080033189' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434101'
                WHERE ordernumber = 'P2412080033227' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286174'
                WHERE ordernumber = 'P2412080033752' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434103'
                WHERE ordernumber = 'P2412080033827' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434102'
                WHERE ordernumber = 'P2412080033961' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132970'
                WHERE ordernumber = 'P2412080034018' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '388926'
                WHERE ordernumber = 'P2412080034372' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434104'
                WHERE ordernumber = 'P2412080034439' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434098'
                WHERE ordernumber = 'P2412080034689' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '369940'
                WHERE ordernumber = 'P2412080034796' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220649'
                WHERE ordernumber = 'P2412080034845' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434109'
                WHERE ordernumber = 'P2412080034913' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434110'
                WHERE ordernumber = 'P2412080035031' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434113'
                WHERE ordernumber = 'P2412080035225' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '309159'
                WHERE ordernumber = 'P2412080035428' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434112'
                WHERE ordernumber = 'P2412080035598' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278734'
                WHERE ordernumber = 'P2412080035671' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '236439'
                WHERE ordernumber = 'P2412080035750' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434116'
                WHERE ordernumber = 'P2412080035817' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '152506'
                WHERE ordernumber = 'P2412080035987' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434115'
                WHERE ordernumber = 'P2412080036044' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434117'
                WHERE ordernumber = 'P2412080036418' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434119'
                WHERE ordernumber = 'P2412080036795' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434114'
                WHERE ordernumber = 'P2412080036937' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '284630'
                WHERE ordernumber = 'P2412080037017' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434121'
                WHERE ordernumber = 'P2412080037275' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99142'
                WHERE ordernumber = 'P2412080037369' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384500'
                WHERE ordernumber = 'P2412080037547' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434122'
                WHERE ordernumber = 'P2412080037775' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434125'
                WHERE ordernumber = 'P2412080037962' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '426103'
                WHERE ordernumber = 'P2412080038099' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434123'
                WHERE ordernumber = 'P2412080038245' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434126'
                WHERE ordernumber = 'P2412080038337' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434124'
                WHERE ordernumber = 'P2412080038549' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434128'
                WHERE ordernumber = 'P2412080038793' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434129'
                WHERE ordernumber = 'P2412080039033' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '100188'
                WHERE ordernumber = 'P2412080039160' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434130'
                WHERE ordernumber = 'P2412080039211' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434131'
                WHERE ordernumber = 'P2412080039384' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434136'
                WHERE ordernumber = 'P2412080039416' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302233'
                WHERE ordernumber = 'P2412080039543' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '177312'
                WHERE ordernumber = 'P2412080039670' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434139'
                WHERE ordernumber = 'P2412080039860' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '113760'
                WHERE ordernumber = 'P2412080039982' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434140'
                WHERE ordernumber = 'P2412080040210' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434141'
                WHERE ordernumber = 'P2412080040381' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434142'
                WHERE ordernumber = 'P2412080040446' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '139619'
                WHERE ordernumber = 'P2412080040525' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '239180'
                WHERE ordernumber = 'P2412080040818' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '412118'
                WHERE ordernumber = 'P2412080041019' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '250791'
                WHERE ordernumber = 'P2412080041137' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341665'
                WHERE ordernumber = 'P2412080041373' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434145'
                WHERE ordernumber = 'P2412080041569' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434146'
                WHERE ordernumber = 'P2412080041891' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434144'
                WHERE ordernumber = 'P2412080042041' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '212355'
                WHERE ordernumber = 'P2412080042190' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269473'
                WHERE ordernumber = 'P2412080042269' 
            
2024-12-09 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '434152'
                WHERE ordernumber = 'P2412080042458'