2024-11-03 01:00:01 -- 將會員中心id寫入data-lake
2024-11-03 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-11-02%';
        
2024-11-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '428570'
                WHERE ordernumber = 'P201102110223405' 
            
2024-11-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '368494'
                WHERE ordernumber = 'P421102110311948' 
            
2024-11-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '307074'
                WHERE ordernumber = 'P201102110504264' 
            
2024-11-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '427938'
                WHERE ordernumber = 'P201102111028995' 
            
2024-11-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '348486'
                WHERE ordernumber = 'P201102111231750' 
            
2024-11-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '428571'
                WHERE ordernumber = 'P421102111238156' 
            
2024-11-03 01:00:01 -- 
                UPDATE `omo_order_list` SET userId = '406645'
                WHERE ordernumber = 'P201102111518257' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428572'
                WHERE ordernumber = 'P201102111640578' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428573'
                WHERE ordernumber = 'P421102111854478' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342564'
                WHERE ordernumber = 'P421102112025825' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '342564'
                WHERE ordernumber = 'P421102112130913' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379109'
                WHERE ordernumber = 'P181102112606236' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428575'
                WHERE ordernumber = 'P421102112938407' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428574'
                WHERE ordernumber = 'P181102113037645' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428576'
                WHERE ordernumber = 'P421102113120962' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98810'
                WHERE ordernumber = 'P201102113231873' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181102113247335' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '146074'
                WHERE ordernumber = 'P181102113410164' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428577'
                WHERE ordernumber = 'P421102113411482' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '241611'
                WHERE ordernumber = 'P201102113619306' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428578'
                WHERE ordernumber = 'P181102113859321' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428579'
                WHERE ordernumber = 'P421102114656732' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '139727'
                WHERE ordernumber = 'P201102115055790' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428582'
                WHERE ordernumber = 'P421102115229459' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428581'
                WHERE ordernumber = 'P421102115327951' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422474'
                WHERE ordernumber = 'P421102115406538' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417227'
                WHERE ordernumber = 'P201102115602286' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428583'
                WHERE ordernumber = 'P771102115726338' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396176'
                WHERE ordernumber = 'P181102120120326' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428585'
                WHERE ordernumber = 'P191102120930532' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428586'
                WHERE ordernumber = 'P201102121436981' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '107378'
                WHERE ordernumber = 'P181102121608138' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428587'
                WHERE ordernumber = 'P201102121626943' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '364742'
                WHERE ordernumber = 'P421102121951242' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428588'
                WHERE ordernumber = 'P421102122034974' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428584'
                WHERE ordernumber = 'P771102122312167' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304516'
                WHERE ordernumber = 'P591102122530283' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428590'
                WHERE ordernumber = 'P201102123442224' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '144269'
                WHERE ordernumber = 'P181102123742349' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403200'
                WHERE ordernumber = 'P421102124028345' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428589'
                WHERE ordernumber = 'P181102124222715' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '393661'
                WHERE ordernumber = 'P181102124414632' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428594'
                WHERE ordernumber = 'P771102125152664' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428593'
                WHERE ordernumber = 'P421102125226697' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428595'
                WHERE ordernumber = 'P181102125551891' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297429'
                WHERE ordernumber = 'P421102125644414' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428591'
                WHERE ordernumber = 'P191102125646961' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428592'
                WHERE ordernumber = 'P191102125755909' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '229100'
                WHERE ordernumber = 'P181102125958421' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428596'
                WHERE ordernumber = 'P181102130200628' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428599'
                WHERE ordernumber = 'P201102130229719' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97996'
                WHERE ordernumber = 'P201102130328426' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428598'
                WHERE ordernumber = 'P421102130329336' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428597'
                WHERE ordernumber = 'P181102130438409' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '400661'
                WHERE ordernumber = 'P421102130552547' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428183'
                WHERE ordernumber = 'P201102130559893' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428600'
                WHERE ordernumber = 'P421102130642292' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276050'
                WHERE ordernumber = 'P201102130957726' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428601'
                WHERE ordernumber = 'P631102131115613' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386294'
                WHERE ordernumber = 'P181102131441232' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428602'
                WHERE ordernumber = 'P421102131449510' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428603'
                WHERE ordernumber = 'P201102131457353' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380646'
                WHERE ordernumber = 'P201102131657757' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412987'
                WHERE ordernumber = 'P201102132024350' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377911'
                WHERE ordernumber = 'P191102132218983' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425540'
                WHERE ordernumber = 'P191102132419271' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428604'
                WHERE ordernumber = 'P201102132422514' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427581'
                WHERE ordernumber = 'P201102133118602' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '40868'
                WHERE ordernumber = 'P181102133318806' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428605'
                WHERE ordernumber = 'P181102133841470' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '288773'
                WHERE ordernumber = 'P181102134101302' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '216755'
                WHERE ordernumber = 'P181102134232941' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428608'
                WHERE ordernumber = 'P421102134459653' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '398019'
                WHERE ordernumber = 'P421102134547593' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137433'
                WHERE ordernumber = 'P201102134557217' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428610'
                WHERE ordernumber = 'P771102135150576' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428609'
                WHERE ordernumber = 'P181102135232709' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428611'
                WHERE ordernumber = 'P421102135333957' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234853'
                WHERE ordernumber = 'P201102135503465' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222971'
                WHERE ordernumber = 'P181102135616697' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428612'
                WHERE ordernumber = 'P181102135839553' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428613'
                WHERE ordernumber = 'P771102135845576' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428614'
                WHERE ordernumber = 'P421102140025496' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428160'
                WHERE ordernumber = 'P421102140120491' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384983'
                WHERE ordernumber = 'P201102140640344' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428615'
                WHERE ordernumber = 'P181102140700791' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428615'
                WHERE ordernumber = 'P181102140814804' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428618'
                WHERE ordernumber = 'P181102141001325' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428619'
                WHERE ordernumber = 'P201102141804854' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428616'
                WHERE ordernumber = 'P191102142304858' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416719'
                WHERE ordernumber = 'P191102142412367' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428058'
                WHERE ordernumber = 'P181102142751209' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428621'
                WHERE ordernumber = 'P191102142826552' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428622'
                WHERE ordernumber = 'P771102143020124' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428623'
                WHERE ordernumber = 'P771102143156628' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428625'
                WHERE ordernumber = 'P181102143247973' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428625'
                WHERE ordernumber = 'P181102143317545' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427113'
                WHERE ordernumber = 'P201102143356306' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '158833'
                WHERE ordernumber = 'P421102143439393' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428626'
                WHERE ordernumber = 'P421102143545937' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100682'
                WHERE ordernumber = 'P771102144135424' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428627'
                WHERE ordernumber = 'P771102144307909' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '399160'
                WHERE ordernumber = 'P421102144412457' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '222028'
                WHERE ordernumber = 'P181102144521863' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428629'
                WHERE ordernumber = 'P181102144649331' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '397188'
                WHERE ordernumber = 'P771102144807491' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428620'
                WHERE ordernumber = 'P181102145003296' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338630'
                WHERE ordernumber = 'P201102145023640' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428632'
                WHERE ordernumber = 'P771102145310316' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '325003'
                WHERE ordernumber = 'P181102145608673' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '402398'
                WHERE ordernumber = 'P421102150230554' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337540'
                WHERE ordernumber = 'P771102150551310' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428636'
                WHERE ordernumber = 'P421102150634268' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290595'
                WHERE ordernumber = 'P201102150815732' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428633'
                WHERE ordernumber = 'P631102150821795' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428637'
                WHERE ordernumber = 'P421102150856639' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428635'
                WHERE ordernumber = 'P181102150911975' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '202723'
                WHERE ordernumber = 'P631102150940825' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428638'
                WHERE ordernumber = 'P421102150953542' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328429'
                WHERE ordernumber = 'P771102151028126' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238232'
                WHERE ordernumber = 'P201102151128782' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428639'
                WHERE ordernumber = 'P421102151138536' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387229'
                WHERE ordernumber = 'P421102151256250' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428642'
                WHERE ordernumber = 'P421102151559198' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428641'
                WHERE ordernumber = 'P181102151649192' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '401001'
                WHERE ordernumber = 'P181102151911159' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428640'
                WHERE ordernumber = 'P181102152053975' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428643'
                WHERE ordernumber = 'P421102152224873' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301307'
                WHERE ordernumber = 'P181102152433315' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428645'
                WHERE ordernumber = 'P181102152639353' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '148413'
                WHERE ordernumber = 'P421102153020298' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428647'
                WHERE ordernumber = 'P181102153116460' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '234203'
                WHERE ordernumber = 'P201102153240555' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '381192'
                WHERE ordernumber = 'P421102153413864' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428648'
                WHERE ordernumber = 'P771102153447509' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '149802'
                WHERE ordernumber = 'P631102153623362' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428649'
                WHERE ordernumber = 'P421102153648959' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246718'
                WHERE ordernumber = 'P421102153724732' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428650'
                WHERE ordernumber = 'P421102154221926' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '43036'
                WHERE ordernumber = 'P631102154406324' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428652'
                WHERE ordernumber = 'P771102154847668' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301837'
                WHERE ordernumber = 'P421102154915758' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276231'
                WHERE ordernumber = 'P771102155046435' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428653'
                WHERE ordernumber = 'P421102155626281' 
            
2024-11-03 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '160054'
                WHERE ordernumber = 'P201102155650975' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '416277'
                WHERE ordernumber = 'P181102160105157' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427097'
                WHERE ordernumber = 'P421102160423197' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428655'
                WHERE ordernumber = 'P421102160512580' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428656'
                WHERE ordernumber = 'P421102160629991' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428658'
                WHERE ordernumber = 'P771102161017433' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428659'
                WHERE ordernumber = 'P421102161111283' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428463'
                WHERE ordernumber = 'P421102161145398' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428463'
                WHERE ordernumber = 'P421102161408872' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428661'
                WHERE ordernumber = 'P771102161428680' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428662'
                WHERE ordernumber = 'P771102161456949' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428664'
                WHERE ordernumber = 'P771102161610649' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '229864'
                WHERE ordernumber = 'P181102161842327' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428667'
                WHERE ordernumber = 'P181102162516232' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428670'
                WHERE ordernumber = 'P201102162633995' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428668'
                WHERE ordernumber = 'P421102162739773' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346885'
                WHERE ordernumber = 'P771102162827251' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428672'
                WHERE ordernumber = 'P421102163054207' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '400905'
                WHERE ordernumber = 'P181102163121784' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428671'
                WHERE ordernumber = 'P771102163158275' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428665'
                WHERE ordernumber = 'P771102163414541' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428673'
                WHERE ordernumber = 'P181102163416376' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118993'
                WHERE ordernumber = 'P771102163641301' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428674'
                WHERE ordernumber = 'P421102163955193' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428675'
                WHERE ordernumber = 'P421102164145624' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '406303'
                WHERE ordernumber = 'P191102164200482' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428676'
                WHERE ordernumber = 'P181102164410177' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367046'
                WHERE ordernumber = 'P201102164528972' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '77445'
                WHERE ordernumber = 'P631102164712220' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125215'
                WHERE ordernumber = 'P201102164733266' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428677'
                WHERE ordernumber = 'P181102165114320' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348805'
                WHERE ordernumber = 'P421102165314896' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '303072'
                WHERE ordernumber = 'P181102165346642' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279570'
                WHERE ordernumber = 'P201102165408427' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279570'
                WHERE ordernumber = 'P201102165736951' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282147'
                WHERE ordernumber = 'P201102165835534' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428679'
                WHERE ordernumber = 'P771102170036286' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428681'
                WHERE ordernumber = 'P771102170220399' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49370'
                WHERE ordernumber = 'P201102170342224' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242008'
                WHERE ordernumber = 'P201102170952934' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428683'
                WHERE ordernumber = 'P421102171027386' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428684'
                WHERE ordernumber = 'P421102171134708' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '424860'
                WHERE ordernumber = 'P181102171153691' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428685'
                WHERE ordernumber = 'P201102171331997' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428682'
                WHERE ordernumber = 'P201102171458909' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428687'
                WHERE ordernumber = 'P421102171809459' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428686'
                WHERE ordernumber = 'P181102171855185' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312401'
                WHERE ordernumber = 'P181102172239337' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '419919'
                WHERE ordernumber = 'P201102172302635' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135847'
                WHERE ordernumber = 'P201102172421845' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428688'
                WHERE ordernumber = 'P181102173138674' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428691'
                WHERE ordernumber = 'P421102173200687' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428690'
                WHERE ordernumber = 'P191102173203772' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118201'
                WHERE ordernumber = 'P191102173439797' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428692'
                WHERE ordernumber = 'P421102174248602' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '255362'
                WHERE ordernumber = 'P181102174249118' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312843'
                WHERE ordernumber = 'P201102174345669' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428693'
                WHERE ordernumber = 'P191102174623354' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347034'
                WHERE ordernumber = 'P421102175557190' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428694'
                WHERE ordernumber = 'P421102175738592' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428697'
                WHERE ordernumber = 'P201102175743396' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428695'
                WHERE ordernumber = 'P421102175829910' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428700'
                WHERE ordernumber = 'P201102180009876' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428698'
                WHERE ordernumber = 'P421102180012537' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259520'
                WHERE ordernumber = 'P201102180202582' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428699'
                WHERE ordernumber = 'P421102180357577' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304060'
                WHERE ordernumber = 'P181102180422885' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428702'
                WHERE ordernumber = 'P771102180730781' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320939'
                WHERE ordernumber = 'P181102181035475' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428704'
                WHERE ordernumber = 'P181102181520856' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107559'
                WHERE ordernumber = 'P181102181724487' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138070'
                WHERE ordernumber = 'P181102182024312' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '405275'
                WHERE ordernumber = 'P201102182625202' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378401'
                WHERE ordernumber = 'P201102183007669' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94179'
                WHERE ordernumber = 'P201102183244701' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227589'
                WHERE ordernumber = 'P631102183638845' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428708'
                WHERE ordernumber = 'P201102184004828' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428710'
                WHERE ordernumber = 'P591102184312547' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428709'
                WHERE ordernumber = 'P201102184637856' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283615'
                WHERE ordernumber = 'P421102184709935' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428711'
                WHERE ordernumber = 'P421102184908195' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '273486'
                WHERE ordernumber = 'P181102184940783' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428712'
                WHERE ordernumber = 'P191102185106734' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378311'
                WHERE ordernumber = 'P191102185553470' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284478'
                WHERE ordernumber = 'P201102190043547' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428714'
                WHERE ordernumber = 'P191102190200845' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341428'
                WHERE ordernumber = 'P191102190252778' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114413'
                WHERE ordernumber = 'P191102190350935' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428715'
                WHERE ordernumber = 'P191102190939730' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365094'
                WHERE ordernumber = 'P201102191143149' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428716'
                WHERE ordernumber = 'P191102191456679' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '338812'
                WHERE ordernumber = 'P201102191815429' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428717'
                WHERE ordernumber = 'P191102191903254' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428716'
                WHERE ordernumber = 'P191102192032251' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428718'
                WHERE ordernumber = 'P771102192057227' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383130'
                WHERE ordernumber = 'P201102193512685' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277099'
                WHERE ordernumber = 'P191102193753979' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428722'
                WHERE ordernumber = 'P771102200757259' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428702'
                WHERE ordernumber = 'P771102202444138' 
            
2024-11-03 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '163753'
                WHERE ordernumber = 'P771102202749538'