2023-11-24 01:00:02 -- 將會員中心id寫入data-lake
2023-11-24 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2023-11-23%';
        
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '58213'
                WHERE ordernumber = 'P181123110152226' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283500'
                WHERE ordernumber = 'P201123110304973' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283500'
                WHERE ordernumber = 'P201123110322176' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229420'
                WHERE ordernumber = 'P181123110443663' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '106086'
                WHERE ordernumber = 'P181123110657722' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299721'
                WHERE ordernumber = 'P181123110803825' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348856'
                WHERE ordernumber = 'P201123110834723' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341339'
                WHERE ordernumber = 'P201123111002553' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348858'
                WHERE ordernumber = 'P421123111031926' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348859'
                WHERE ordernumber = 'P181123111109826' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '210514'
                WHERE ordernumber = 'P201123111201360' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '296416'
                WHERE ordernumber = 'P201123111634346' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348682'
                WHERE ordernumber = 'P201123111710933' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P201123111802635' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304743'
                WHERE ordernumber = 'P201123112341661' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348860'
                WHERE ordernumber = 'P421123112358799' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348862'
                WHERE ordernumber = 'P421123113011341' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '80905'
                WHERE ordernumber = 'P181123113435784' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348863'
                WHERE ordernumber = 'P421123113535868' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '258282'
                WHERE ordernumber = 'P181123114431630' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249763'
                WHERE ordernumber = 'P201123114516379' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348865'
                WHERE ordernumber = 'P181123115037730' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '268782'
                WHERE ordernumber = 'P181123115221415' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348866'
                WHERE ordernumber = 'P181123115449135' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348868'
                WHERE ordernumber = 'P181123115615123' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '334056'
                WHERE ordernumber = 'P201123115740948' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348870'
                WHERE ordernumber = 'P181123115801558' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348865'
                WHERE ordernumber = 'P181123115841327' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348408'
                WHERE ordernumber = 'P201123115854549' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39295'
                WHERE ordernumber = 'P201123115952287' 
            
2023-11-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '348871'
                WHERE ordernumber = 'P201123120103462' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137905'
                WHERE ordernumber = 'P201123120532216' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348873'
                WHERE ordernumber = 'P421123121224628' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348874'
                WHERE ordernumber = 'P181123121349675' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348875'
                WHERE ordernumber = 'P421123121516396' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220362'
                WHERE ordernumber = 'P181123122130782' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220362'
                WHERE ordernumber = 'P181123122304479' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279198'
                WHERE ordernumber = 'P421123122941449' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112388'
                WHERE ordernumber = 'P181123123240889' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348877'
                WHERE ordernumber = 'P181123123731738' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '287197'
                WHERE ordernumber = 'P181123124526951' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262350'
                WHERE ordernumber = 'P201123125013305' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '126005'
                WHERE ordernumber = 'P201123125442586' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '286180'
                WHERE ordernumber = 'P421123125531699' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348880'
                WHERE ordernumber = 'P181123125706314' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115842'
                WHERE ordernumber = 'P181123130133677' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348885'
                WHERE ordernumber = 'P181123131117445' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347465'
                WHERE ordernumber = 'P181123132403924' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302608'
                WHERE ordernumber = 'P201123132727765' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344591'
                WHERE ordernumber = 'P201123133045449' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348889'
                WHERE ordernumber = 'P201123133739300' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '243259'
                WHERE ordernumber = 'P201123133827238' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348891'
                WHERE ordernumber = 'P181123134559673' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P181123134830443' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348892'
                WHERE ordernumber = 'P201123135019207' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P181123135300559' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309980'
                WHERE ordernumber = 'P181123135323562' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '199081'
                WHERE ordernumber = 'P181123140034461' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343025'
                WHERE ordernumber = 'P181123140514405' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348893'
                WHERE ordernumber = 'P421123140559364' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348894'
                WHERE ordernumber = 'P421123140743360' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308743'
                WHERE ordernumber = 'P191123141026696' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P181123141419552' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348896'
                WHERE ordernumber = 'P201123141749485' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348897'
                WHERE ordernumber = 'P191123141934128' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215024'
                WHERE ordernumber = 'P201123142019662' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348898'
                WHERE ordernumber = 'P421123142037972' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348899'
                WHERE ordernumber = 'P191123142046156' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348900'
                WHERE ordernumber = 'P191123142238250' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348901'
                WHERE ordernumber = 'P421123142307667' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136084'
                WHERE ordernumber = 'P201123142311396' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348904'
                WHERE ordernumber = 'P201123142712540' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336748'
                WHERE ordernumber = 'P181123142903165' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348905'
                WHERE ordernumber = 'P201123143046976' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348906'
                WHERE ordernumber = 'P181123143101429' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302307'
                WHERE ordernumber = 'P201123143126261' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348907'
                WHERE ordernumber = 'P181123143405417' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348906'
                WHERE ordernumber = 'P181123143518509' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348908'
                WHERE ordernumber = 'P181123143654221' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348909'
                WHERE ordernumber = 'P201123143910214' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281602'
                WHERE ordernumber = 'P181123144424990' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348910'
                WHERE ordernumber = 'P181123145942160' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348911'
                WHERE ordernumber = 'P181123150052717' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348912'
                WHERE ordernumber = 'P181123150628488' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348914'
                WHERE ordernumber = 'P421123150638193' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100928'
                WHERE ordernumber = 'P201123150716719' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245310'
                WHERE ordernumber = 'P191123150810566' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348918'
                WHERE ordernumber = 'P181123151250670' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348919'
                WHERE ordernumber = 'P421123151439768' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322312'
                WHERE ordernumber = 'P201123151544272' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348920'
                WHERE ordernumber = 'P421123151803746' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135594'
                WHERE ordernumber = 'P201123151819267' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348922'
                WHERE ordernumber = 'P421123152407906' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '89926'
                WHERE ordernumber = 'P181123152748473' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181123153131790' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181123153336716' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '63318'
                WHERE ordernumber = 'P201123153429864' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181123153708272' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103972'
                WHERE ordernumber = 'P181123153855477' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348925'
                WHERE ordernumber = 'P191123153942427' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313744'
                WHERE ordernumber = 'P421123154251448' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348926'
                WHERE ordernumber = 'P201123154339973' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '160121'
                WHERE ordernumber = 'P201123154646317' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93266'
                WHERE ordernumber = 'P191123155225779' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348928'
                WHERE ordernumber = 'P191123155441730' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348929'
                WHERE ordernumber = 'P191123160003272' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348930'
                WHERE ordernumber = 'P201123160018190' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348931'
                WHERE ordernumber = 'P421123160105353' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348932'
                WHERE ordernumber = 'P191123160754917' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98126'
                WHERE ordernumber = 'P421123161017821' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348933'
                WHERE ordernumber = 'P201123161349481' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274812'
                WHERE ordernumber = 'P191123161502492' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348934'
                WHERE ordernumber = 'P201123162114112' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348935'
                WHERE ordernumber = 'P181123162947466' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '307010'
                WHERE ordernumber = 'P191123163035384' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241068'
                WHERE ordernumber = 'P201123163210707' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '38173'
                WHERE ordernumber = 'P181123163220564' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294892'
                WHERE ordernumber = 'P421123163254654' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108232'
                WHERE ordernumber = 'P191123163548845' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348936'
                WHERE ordernumber = 'P181123163622149' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348937'
                WHERE ordernumber = 'P181123163716394' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348938'
                WHERE ordernumber = 'P181123163840269' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348939'
                WHERE ordernumber = 'P421123163916340' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192108'
                WHERE ordernumber = 'P201123164000168' 
            
2023-11-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322937'
                WHERE ordernumber = 'P421123164335717' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '320679'
                WHERE ordernumber = 'P181123164519535' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '322937'
                WHERE ordernumber = 'P421123164726882' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348940'
                WHERE ordernumber = 'P201123170248414' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348941'
                WHERE ordernumber = 'P181123170607546' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '298817'
                WHERE ordernumber = 'P421123170712196' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348943'
                WHERE ordernumber = 'P181123171022874' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348944'
                WHERE ordernumber = 'P181123171110345' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348945'
                WHERE ordernumber = 'P201123171212389' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130469'
                WHERE ordernumber = 'P181123171323444' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348946'
                WHERE ordernumber = 'P201123171444877' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '283536'
                WHERE ordernumber = 'P201123171548829' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '279655'
                WHERE ordernumber = 'P181123171615740' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348949'
                WHERE ordernumber = 'P201123172113810' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348945'
                WHERE ordernumber = 'P201123172217891' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '172291'
                WHERE ordernumber = 'P181123172651264' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348950'
                WHERE ordernumber = 'P201123172712275' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295896'
                WHERE ordernumber = 'P201123172942754' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252077'
                WHERE ordernumber = 'P181123173304735' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348951'
                WHERE ordernumber = 'P201123173341424' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252077'
                WHERE ordernumber = 'P181123173408265' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348952'
                WHERE ordernumber = 'P201123173425737' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252077'
                WHERE ordernumber = 'P181123173650860' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348953'
                WHERE ordernumber = 'P201123173846436' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348954'
                WHERE ordernumber = 'P181123173929534' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348955'
                WHERE ordernumber = 'P421123174251520' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348946'
                WHERE ordernumber = 'P201123174441646' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348956'
                WHERE ordernumber = 'P181123174631688' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348957'
                WHERE ordernumber = 'P201123174646198' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '326783'
                WHERE ordernumber = 'P201123175327554' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348958'
                WHERE ordernumber = 'P181123175809740' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160938'
                WHERE ordernumber = 'P201123175845621' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245878'
                WHERE ordernumber = 'P181123180232754' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289224'
                WHERE ordernumber = 'P421123180353458' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '258497'
                WHERE ordernumber = 'P201123180454868' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348959'
                WHERE ordernumber = 'P191123180528288' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345301'
                WHERE ordernumber = 'P201123180545166' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348960'
                WHERE ordernumber = 'P421123181112193' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '306648'
                WHERE ordernumber = 'P181123181315351' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '273668'
                WHERE ordernumber = 'P201123181537352' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '278994'
                WHERE ordernumber = 'P181123181730346' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348961'
                WHERE ordernumber = 'P201123181947805' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348962'
                WHERE ordernumber = 'P191123182024577' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348962'
                WHERE ordernumber = 'P191123182709849' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '277459'
                WHERE ordernumber = 'P201123182722650' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348964'
                WHERE ordernumber = 'P181123183103378' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '148994'
                WHERE ordernumber = 'P191123183229908' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348966'
                WHERE ordernumber = 'P191123183503959' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245887'
                WHERE ordernumber = 'P181123183553667' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '97248'
                WHERE ordernumber = 'P201123183727701' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '244403'
                WHERE ordernumber = 'P201123183853986' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '266403'
                WHERE ordernumber = 'P201123183948573' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348965'
                WHERE ordernumber = 'P191123184107697' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348968'
                WHERE ordernumber = 'P421123184335711' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229200'
                WHERE ordernumber = 'P191123184415180' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '158224'
                WHERE ordernumber = 'P181123184517517' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93543'
                WHERE ordernumber = 'P201123184654281' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337744'
                WHERE ordernumber = 'P421123185316612' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '265381'
                WHERE ordernumber = 'P191123185557367' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '117532'
                WHERE ordernumber = 'P191123185714835' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '101826'
                WHERE ordernumber = 'P201123185717502' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348970'
                WHERE ordernumber = 'P201123190209541' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348969'
                WHERE ordernumber = 'P201123190400809' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343787'
                WHERE ordernumber = 'P191123190701643' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348971'
                WHERE ordernumber = 'P201123191050331' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227972'
                WHERE ordernumber = 'P201123191801385' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348878'
                WHERE ordernumber = 'P191123191837488' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '341740'
                WHERE ordernumber = 'P191123192301456' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345628'
                WHERE ordernumber = 'P201123193229275' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348972'
                WHERE ordernumber = 'P191123193552458' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347890'
                WHERE ordernumber = 'P191123193717966' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348974'
                WHERE ordernumber = 'P191123193900118' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348976'
                WHERE ordernumber = 'P421123194432406' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348977'
                WHERE ordernumber = 'P191123195044411' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348977'
                WHERE ordernumber = 'P191123195509851' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348978'
                WHERE ordernumber = 'P421123195559820' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '184428'
                WHERE ordernumber = 'P201123195743738' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '337894'
                WHERE ordernumber = 'P201123200115698' 
            
2023-11-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '103160'
                WHERE ordernumber = 'P201123200244148'