2024-10-27 01:00:01 -- 將會員中心id寫入data-lake
2024-10-27 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-10-26%';
        
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '170262'
                WHERE ordernumber = 'P631026102501250' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427629'
                WHERE ordernumber = 'P421026110448296' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427627'
                WHERE ordernumber = 'P421026110455130' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427630'
                WHERE ordernumber = 'P191026111209467' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426271'
                WHERE ordernumber = 'P201026111213414' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309527'
                WHERE ordernumber = 'P591026111248699' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427628'
                WHERE ordernumber = 'P181026111521196' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427632'
                WHERE ordernumber = 'P191026111615449' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288367'
                WHERE ordernumber = 'P201026111630644' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427631'
                WHERE ordernumber = 'P181026111716868' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159018'
                WHERE ordernumber = 'P181026111948355' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P201026112025231' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283963'
                WHERE ordernumber = 'P201026112119295' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427633'
                WHERE ordernumber = 'P191026112320119' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427634'
                WHERE ordernumber = 'P631026112816776' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235055'
                WHERE ordernumber = 'P201026112903160' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P181026113128159' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427637'
                WHERE ordernumber = 'P201026113245457' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427635'
                WHERE ordernumber = 'P191026113423169' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409975'
                WHERE ordernumber = 'P201026113604134' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '315065'
                WHERE ordernumber = 'P201026114217660' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381591'
                WHERE ordernumber = 'P421026114222173' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427639'
                WHERE ordernumber = 'P191026114620388' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '320241'
                WHERE ordernumber = 'P201026114758852' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '280958'
                WHERE ordernumber = 'P191026114843895' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242982'
                WHERE ordernumber = 'P201026115042437' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209239'
                WHERE ordernumber = 'P201026115149640' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427641'
                WHERE ordernumber = 'P421026115225275' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406903'
                WHERE ordernumber = 'P201026115512684' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '278210'
                WHERE ordernumber = 'P201026115658438' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '200006'
                WHERE ordernumber = 'P421026115659805' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427640'
                WHERE ordernumber = 'P181026115701598' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427647'
                WHERE ordernumber = 'P201026115814329' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427644'
                WHERE ordernumber = 'P181026115953411' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100515'
                WHERE ordernumber = 'P181026120053302' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427642'
                WHERE ordernumber = 'P181026120210943' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426581'
                WHERE ordernumber = 'P201026120219487' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427643'
                WHERE ordernumber = 'P181026120316611' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427646'
                WHERE ordernumber = 'P181026120421652' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '426842'
                WHERE ordernumber = 'P421026120509716' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '243635'
                WHERE ordernumber = 'P631026120932680' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220058'
                WHERE ordernumber = 'P201026120956192' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368596'
                WHERE ordernumber = 'P421026121049770' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427650'
                WHERE ordernumber = 'P731026122349201' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '415547'
                WHERE ordernumber = 'P181026122435293' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427651'
                WHERE ordernumber = 'P421026122626836' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427652'
                WHERE ordernumber = 'P421026122826581' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427653'
                WHERE ordernumber = 'P421026123104672' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261789'
                WHERE ordernumber = 'P421026123458780' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425679'
                WHERE ordernumber = 'P421026123647812' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427655'
                WHERE ordernumber = 'P181026124134999' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427656'
                WHERE ordernumber = 'P181026124701400' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427657'
                WHERE ordernumber = 'P421026124921839' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P711026125127359' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427658'
                WHERE ordernumber = 'P421026125139943' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427659'
                WHERE ordernumber = 'P771026125406806' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386309'
                WHERE ordernumber = 'P421026130553811' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230236'
                WHERE ordernumber = 'P181026130606497' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427660'
                WHERE ordernumber = 'P421026130849716' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251641'
                WHERE ordernumber = 'P771026131017905' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '124939'
                WHERE ordernumber = 'P711026131816779' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427661'
                WHERE ordernumber = 'P421026132007660' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427620'
                WHERE ordernumber = 'P181026133116737' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329391'
                WHERE ordernumber = 'P181026133727535' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427670'
                WHERE ordernumber = 'P201026133830591' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427662'
                WHERE ordernumber = 'P181026133925847' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300072'
                WHERE ordernumber = 'P201026133950461' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '18662'
                WHERE ordernumber = 'P731026134035128' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427665'
                WHERE ordernumber = 'P181026134155239' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427664'
                WHERE ordernumber = 'P181026134412186' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427672'
                WHERE ordernumber = 'P191026134652574' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207214'
                WHERE ordernumber = 'P191026134909424' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427673'
                WHERE ordernumber = 'P731026135004756' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427674'
                WHERE ordernumber = 'P201026135044473' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427666'
                WHERE ordernumber = 'P731026135110178' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427675'
                WHERE ordernumber = 'P201026135801953' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '376066'
                WHERE ordernumber = 'P181026135845886' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367291'
                WHERE ordernumber = 'P181026140046484' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427677'
                WHERE ordernumber = 'P421026140233193' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427447'
                WHERE ordernumber = 'P181026140340863' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427678'
                WHERE ordernumber = 'P421026140340480' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427447'
                WHERE ordernumber = 'P181026140449939' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427680'
                WHERE ordernumber = 'P421026140532878' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427447'
                WHERE ordernumber = 'P181026140612398' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427682'
                WHERE ordernumber = 'P421026140628296' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427681'
                WHERE ordernumber = 'P731026140632233' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395939'
                WHERE ordernumber = 'P421026140758121' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427679'
                WHERE ordernumber = 'P181026140805990' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248757'
                WHERE ordernumber = 'P201026140934986' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427684'
                WHERE ordernumber = 'P731026141000945' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427676'
                WHERE ordernumber = 'P181026141133838' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427683'
                WHERE ordernumber = 'P421026141231210' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101114'
                WHERE ordernumber = 'P201026141257554' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284521'
                WHERE ordernumber = 'P181026142022671' 
            
2024-10-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284521'
                WHERE ordernumber = 'P181026142043757' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427686'
                WHERE ordernumber = 'P421026142127268' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427687'
                WHERE ordernumber = 'P181026142312887' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160352'
                WHERE ordernumber = 'P191026142352203' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293984'
                WHERE ordernumber = 'P421026142413392' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '212739'
                WHERE ordernumber = 'P181026142530938' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '425835'
                WHERE ordernumber = 'P191026142741963' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427685'
                WHERE ordernumber = 'P181026142937821' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427689'
                WHERE ordernumber = 'P731026143103499' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427691'
                WHERE ordernumber = 'P201026143132314' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427690'
                WHERE ordernumber = 'P421026143213150' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427688'
                WHERE ordernumber = 'P181026143301530' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399573'
                WHERE ordernumber = 'P191026143314236' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '187994'
                WHERE ordernumber = 'P421026143319286' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427692'
                WHERE ordernumber = 'P181026143533517' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427693'
                WHERE ordernumber = 'P421026143620217' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424608'
                WHERE ordernumber = 'P421026143725170' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '222028'
                WHERE ordernumber = 'P191026144012462' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427694'
                WHERE ordernumber = 'P731026144109414' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427695'
                WHERE ordernumber = 'P201026144411648' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272255'
                WHERE ordernumber = 'P421026144801126' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427697'
                WHERE ordernumber = 'P201026145025809' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427698'
                WHERE ordernumber = 'P731026145137671' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '184093'
                WHERE ordernumber = 'P421026145236611' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427700'
                WHERE ordernumber = 'P421026145716431' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427699'
                WHERE ordernumber = 'P191026145752765' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427701'
                WHERE ordernumber = 'P421026145939133' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427702'
                WHERE ordernumber = 'P191026150538309' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427706'
                WHERE ordernumber = 'P201026150733692' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142268'
                WHERE ordernumber = 'P181026150904987' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427707'
                WHERE ordernumber = 'P201026150941305' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427704'
                WHERE ordernumber = 'P191026151101872' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427703'
                WHERE ordernumber = 'P191026151255678' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '79636'
                WHERE ordernumber = 'P181026151629231' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427709'
                WHERE ordernumber = 'P731026151653188' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427696'
                WHERE ordernumber = 'P181026151819732' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419682'
                WHERE ordernumber = 'P201026151826748' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427696'
                WHERE ordernumber = 'P181026151913914' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275229'
                WHERE ordernumber = 'P201026151945876' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295796'
                WHERE ordernumber = 'P181026152037329' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '389962'
                WHERE ordernumber = 'P421026152156969' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427711'
                WHERE ordernumber = 'P201026152355777' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114930'
                WHERE ordernumber = 'P181026152449504' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277039'
                WHERE ordernumber = 'P421026152544793' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427710'
                WHERE ordernumber = 'P201026152618289' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275229'
                WHERE ordernumber = 'P201026152826337' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381189'
                WHERE ordernumber = 'P181026153136585' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427712'
                WHERE ordernumber = 'P181026153552657' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '179907'
                WHERE ordernumber = 'P421026153554928' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427716'
                WHERE ordernumber = 'P201026154009415' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427715'
                WHERE ordernumber = 'P421026154109114' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308520'
                WHERE ordernumber = 'P201026154459278' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427713'
                WHERE ordernumber = 'P181026154551429' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102171'
                WHERE ordernumber = 'P191026154846656' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '221537'
                WHERE ordernumber = 'P711026154849431' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427719'
                WHERE ordernumber = 'P631026155141120' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '272147'
                WHERE ordernumber = 'P201026155218805' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427717'
                WHERE ordernumber = 'P711026155401286' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427619'
                WHERE ordernumber = 'P191026155428526' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422965'
                WHERE ordernumber = 'P201026155634458' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427718'
                WHERE ordernumber = 'P181026155855841' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427720'
                WHERE ordernumber = 'P191026155954194' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427721'
                WHERE ordernumber = 'P421026160218599' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427723'
                WHERE ordernumber = 'P191026160731473' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427722'
                WHERE ordernumber = 'P181026160846491' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '170389'
                WHERE ordernumber = 'P191026161000216' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426329'
                WHERE ordernumber = 'P201026161010966' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427724'
                WHERE ordernumber = 'P181026161153999' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385400'
                WHERE ordernumber = 'P181026161603236' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340385'
                WHERE ordernumber = 'P591026161746300' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340385'
                WHERE ordernumber = 'P591026161831266' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427725'
                WHERE ordernumber = 'P771026161831124' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359932'
                WHERE ordernumber = 'P421026161833515' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135585'
                WHERE ordernumber = 'P191026161935186' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427726'
                WHERE ordernumber = 'P771026162138503' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427728'
                WHERE ordernumber = 'P421026162235300' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291075'
                WHERE ordernumber = 'P181026162336570' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427727'
                WHERE ordernumber = 'P421026162417642' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115846'
                WHERE ordernumber = 'P711026162427542' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427732'
                WHERE ordernumber = 'P771026162441759' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427733'
                WHERE ordernumber = 'P771026162620310' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '116257'
                WHERE ordernumber = 'P181026162723355' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427735'
                WHERE ordernumber = 'P421026162753366' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291075'
                WHERE ordernumber = 'P181026162838265' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298359'
                WHERE ordernumber = 'P421026162958662' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141949'
                WHERE ordernumber = 'P191026163020933' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427731'
                WHERE ordernumber = 'P771026163033873' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427729'
                WHERE ordernumber = 'P421026163220127' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '421342'
                WHERE ordernumber = 'P771026163420161' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427734'
                WHERE ordernumber = 'P191026163503825' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427736'
                WHERE ordernumber = 'P181026163600166' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427738'
                WHERE ordernumber = 'P191026163850458' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427740'
                WHERE ordernumber = 'P771026163908765' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427734'
                WHERE ordernumber = 'P191026164000364' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427741'
                WHERE ordernumber = 'P181026164038144' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427742'
                WHERE ordernumber = 'P771026164204123' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427743'
                WHERE ordernumber = 'P771026164500460' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427746'
                WHERE ordernumber = 'P771026164725893' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '387912'
                WHERE ordernumber = 'P201026164812588' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427745'
                WHERE ordernumber = 'P771026165102388' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427744'
                WHERE ordernumber = 'P181026165142264' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427748'
                WHERE ordernumber = 'P421026165656945' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393695'
                WHERE ordernumber = 'P421026170024629' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427749'
                WHERE ordernumber = 'P191026170451316' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427750'
                WHERE ordernumber = 'P421026170539704' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99557'
                WHERE ordernumber = 'P181026170735466' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P201026171036682' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427751'
                WHERE ordernumber = 'P421026171217652' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181026171220162' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427752'
                WHERE ordernumber = 'P421026171643951' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403059'
                WHERE ordernumber = 'P191026171729962' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427754'
                WHERE ordernumber = 'P421026172355567' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426733'
                WHERE ordernumber = 'P771026172545924' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427753'
                WHERE ordernumber = 'P181026172612907' 
            
2024-10-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370969'
                WHERE ordernumber = 'P421026172917897' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425170'
                WHERE ordernumber = 'P711026173253407' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427757'
                WHERE ordernumber = 'P201026173953833' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214008'
                WHERE ordernumber = 'P201026174258870' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277054'
                WHERE ordernumber = 'P181026174435534' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404307'
                WHERE ordernumber = 'P421026174520244' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427758'
                WHERE ordernumber = 'P181026174714437' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95433'
                WHERE ordernumber = 'P421026174805535' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427760'
                WHERE ordernumber = 'P421026174910810' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427761'
                WHERE ordernumber = 'P421026175104949' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427764'
                WHERE ordernumber = 'P201026175235878' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427759'
                WHERE ordernumber = 'P181026175311672' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '140799'
                WHERE ordernumber = 'P201026175411704' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427765'
                WHERE ordernumber = 'P181026175437158' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427766'
                WHERE ordernumber = 'P421026175501476' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424965'
                WHERE ordernumber = 'P421026175557860' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427767'
                WHERE ordernumber = 'P421026175737443' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '352793'
                WHERE ordernumber = 'P201026175740663' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427768'
                WHERE ordernumber = 'P191026175935294' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321276'
                WHERE ordernumber = 'P181026180131917' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167097'
                WHERE ordernumber = 'P201026180142985' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427106'
                WHERE ordernumber = 'P421026180402615' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427769'
                WHERE ordernumber = 'P201026180646346' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '232805'
                WHERE ordernumber = 'P181026180655519' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142405'
                WHERE ordernumber = 'P201026181042636' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427771'
                WHERE ordernumber = 'P181026181704712' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427770'
                WHERE ordernumber = 'P181026181830332' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427772'
                WHERE ordernumber = 'P181026182002960' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '300531'
                WHERE ordernumber = 'P181026182116260' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '421987'
                WHERE ordernumber = 'P731026182125798' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427775'
                WHERE ordernumber = 'P771026182221447' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427774'
                WHERE ordernumber = 'P181026182327397' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424310'
                WHERE ordernumber = 'P421026182344880' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427776'
                WHERE ordernumber = 'P711026182526313' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427773'
                WHERE ordernumber = 'P181026182655515' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '424310'
                WHERE ordernumber = 'P421026182809408' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423434'
                WHERE ordernumber = 'P181026182919966' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427777'
                WHERE ordernumber = 'P191026183716977' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427778'
                WHERE ordernumber = 'P181026183954146' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '425370'
                WHERE ordernumber = 'P191026184053818' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '404923'
                WHERE ordernumber = 'P181026184236658' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '344155'
                WHERE ordernumber = 'P191026184334648' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427779'
                WHERE ordernumber = 'P181026184531391' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '25'
                WHERE ordernumber = 'P191026184625135' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283493'
                WHERE ordernumber = 'P181026184713709' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '151394'
                WHERE ordernumber = 'P181026185452551' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427705'
                WHERE ordernumber = 'P631026185551624' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427781'
                WHERE ordernumber = 'P631026185754920' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427780'
                WHERE ordernumber = 'P181026185803521' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291414'
                WHERE ordernumber = 'P181026190224613' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427782'
                WHERE ordernumber = 'P771026190758136' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '27604'
                WHERE ordernumber = 'P201026190901115' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427784'
                WHERE ordernumber = 'P191026192723900' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299756'
                WHERE ordernumber = 'P191026193203844' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393538'
                WHERE ordernumber = 'P191026193421611' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427785'
                WHERE ordernumber = 'P711026193520932' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427789'
                WHERE ordernumber = 'P711026193652131' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '299756'
                WHERE ordernumber = 'P191026193811733' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '409262'
                WHERE ordernumber = 'P191026193941306' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '263528'
                WHERE ordernumber = 'P711026194157329' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427790'
                WHERE ordernumber = 'P191026194230843' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427790'
                WHERE ordernumber = 'P191026194358811' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '423520'
                WHERE ordernumber = 'P191026194833752' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427785'
                WHERE ordernumber = 'P711026195225623' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427785'
                WHERE ordernumber = 'P711026195406536' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347066'
                WHERE ordernumber = 'P191026200033214' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427792'
                WHERE ordernumber = 'P771026203011586' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427794'
                WHERE ordernumber = 'P771026203950671' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427796'
                WHERE ordernumber = 'P711026205107932' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427797'
                WHERE ordernumber = 'P771026210238949' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '104861'
                WHERE ordernumber = 'P771026212134918' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427798'
                WHERE ordernumber = 'P711026212253311' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228390'
                WHERE ordernumber = 'P771026213106752' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427799'
                WHERE ordernumber = 'P711026213233943' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427800'
                WHERE ordernumber = 'P771026214324168' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427801'
                WHERE ordernumber = 'P771026214928728' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427803'
                WHERE ordernumber = 'P771026215325846' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427806'
                WHERE ordernumber = 'P771026220755772' 
            
2024-10-27 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '427809'
                WHERE ordernumber = 'P711026221421882'