2024-01-23 01:00:02 -- 將會員中心id寫入data-lake
2024-01-23 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 '2024-01-22%';
        
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357542'
                WHERE ordernumber = 'P180122110155975' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '159073'
                WHERE ordernumber = 'P200122110330939' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370779'
                WHERE ordernumber = 'P190122110343737' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370779'
                WHERE ordernumber = 'P190122110417273' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370781'
                WHERE ordernumber = 'P180122110507596' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '213778'
                WHERE ordernumber = 'P200122110530212' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370781'
                WHERE ordernumber = 'P180122110534534' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '238643'
                WHERE ordernumber = 'P190122110543549' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '104624'
                WHERE ordernumber = 'P200122110858986' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273583'
                WHERE ordernumber = 'P200122110959986' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370788'
                WHERE ordernumber = 'P420122111045508' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370431'
                WHERE ordernumber = 'P420122111213743' 
            
2024-01-23 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '370790'
                WHERE ordernumber = 'P200122111247325' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353502'
                WHERE ordernumber = 'P190122111350368' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370431'
                WHERE ordernumber = 'P420122111609174' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370795'
                WHERE ordernumber = 'P200122111729461' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370796'
                WHERE ordernumber = 'P420122111818336' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346508'
                WHERE ordernumber = 'P200122111824377' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370799'
                WHERE ordernumber = 'P420122112006205' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284606'
                WHERE ordernumber = 'P200122112029912' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '86200'
                WHERE ordernumber = 'P190122112115640' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370801'
                WHERE ordernumber = 'P180122112153301' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '284606'
                WHERE ordernumber = 'P200122112308896' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370800'
                WHERE ordernumber = 'P180122112329719' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '361784'
                WHERE ordernumber = 'P420122112345451' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370805'
                WHERE ordernumber = 'P420122112737436' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '308639'
                WHERE ordernumber = 'P190122113509756' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370810'
                WHERE ordernumber = 'P420122113730622' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370810'
                WHERE ordernumber = 'P420122113902397' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365156'
                WHERE ordernumber = 'P190122113921646' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '54301'
                WHERE ordernumber = 'P190122114106118' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '118191'
                WHERE ordernumber = 'P200122114321634' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370813'
                WHERE ordernumber = 'P200122114451276' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '270921'
                WHERE ordernumber = 'P200122114713122' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96745'
                WHERE ordernumber = 'P190122114829510' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370816'
                WHERE ordernumber = 'P420122114945229' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '309299'
                WHERE ordernumber = 'P190122115026731' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370821'
                WHERE ordernumber = 'P190122115535986' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370823'
                WHERE ordernumber = 'P420122115800687' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363461'
                WHERE ordernumber = 'P200122115803888' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366791'
                WHERE ordernumber = 'P200122115848382' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '147682'
                WHERE ordernumber = 'P180122115908561' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370821'
                WHERE ordernumber = 'P190122115940432' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370826'
                WHERE ordernumber = 'P200122115958930' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368969'
                WHERE ordernumber = 'P420122120213484' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370832'
                WHERE ordernumber = 'P420122120505254' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '47535'
                WHERE ordernumber = 'P420122120638865' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337221'
                WHERE ordernumber = 'P200122120710935' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '366074'
                WHERE ordernumber = 'P420122120924490' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276041'
                WHERE ordernumber = 'P420122121607505' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296985'
                WHERE ordernumber = 'P200122122036398' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '165646'
                WHERE ordernumber = 'P200122122107204' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288772'
                WHERE ordernumber = 'P190122122154156' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279198'
                WHERE ordernumber = 'P420122122516349' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P190122122630439' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '80297'
                WHERE ordernumber = 'P420122122730757' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341210'
                WHERE ordernumber = 'P200122122941467' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370848'
                WHERE ordernumber = 'P200122123135682' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337061'
                WHERE ordernumber = 'P200122123325440' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102473'
                WHERE ordernumber = 'P190122123421634' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370851'
                WHERE ordernumber = 'P420122123653396' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364974'
                WHERE ordernumber = 'P190122123714235' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259538'
                WHERE ordernumber = 'P420122123935889' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342496'
                WHERE ordernumber = 'P420122124151847' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370854'
                WHERE ordernumber = 'P200122124314699' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370858'
                WHERE ordernumber = 'P200122124446999' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340163'
                WHERE ordernumber = 'P200122124525468' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '98509'
                WHERE ordernumber = 'P200122124612189' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370859'
                WHERE ordernumber = 'P200122124654817' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370812'
                WHERE ordernumber = 'P420122124742121' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370863'
                WHERE ordernumber = 'P200122125031141' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370864'
                WHERE ordernumber = 'P420122125101856' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '262399'
                WHERE ordernumber = 'P200122125117812' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370866'
                WHERE ordernumber = 'P200122125221458' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370867'
                WHERE ordernumber = 'P200122125302955' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370870'
                WHERE ordernumber = 'P420122125831407' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370868'
                WHERE ordernumber = 'P420122125839682' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370872'
                WHERE ordernumber = 'P200122130349773' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289954'
                WHERE ordernumber = 'P190122130429923' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '301501'
                WHERE ordernumber = 'P200122130550553' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370873'
                WHERE ordernumber = 'P420122130624536' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '192556'
                WHERE ordernumber = 'P180122130633979' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370876'
                WHERE ordernumber = 'P420122130720940' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125208'
                WHERE ordernumber = 'P420122130845969' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370878'
                WHERE ordernumber = 'P420122130932152' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370875'
                WHERE ordernumber = 'P190122130952950' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370880'
                WHERE ordernumber = 'P420122131134262' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237868'
                WHERE ordernumber = 'P190122131145309' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '125933'
                WHERE ordernumber = 'P200122131203838' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370882'
                WHERE ordernumber = 'P190122131412328' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '175605'
                WHERE ordernumber = 'P420122131515533' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365245'
                WHERE ordernumber = 'P420122131648739' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370887'
                WHERE ordernumber = 'P420122132031321' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370890'
                WHERE ordernumber = 'P200122132657976' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370593'
                WHERE ordernumber = 'P420122132747705' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370891'
                WHERE ordernumber = 'P420122132944726' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370894'
                WHERE ordernumber = 'P180122133346815' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '279074'
                WHERE ordernumber = 'P180122133522889' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347829'
                WHERE ordernumber = 'P200122133615747' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220269'
                WHERE ordernumber = 'P190122133652333' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368674'
                WHERE ordernumber = 'P190122133923569' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '266436'
                WHERE ordernumber = 'P200122134251665' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '17227'
                WHERE ordernumber = 'P420122134501214' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370898'
                WHERE ordernumber = 'P200122134530243' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368852'
                WHERE ordernumber = 'P420122134649612' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370244'
                WHERE ordernumber = 'P200122134834287' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '259436'
                WHERE ordernumber = 'P180122135025922' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '182156'
                WHERE ordernumber = 'P200122135133612' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370901'
                WHERE ordernumber = 'P190122135359318' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130773'
                WHERE ordernumber = 'P190122140432380' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311285'
                WHERE ordernumber = 'P190122140604437' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364746'
                WHERE ordernumber = 'P200122141005160' 
            
2024-01-23 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370911'
                WHERE ordernumber = 'P420122141107689' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '143775'
                WHERE ordernumber = 'P420122141620550' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276443'
                WHERE ordernumber = 'P180122141652193' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285474'
                WHERE ordernumber = 'P180122141831461' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '364498'
                WHERE ordernumber = 'P180122142234945' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370921'
                WHERE ordernumber = 'P200122142308987' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370923'
                WHERE ordernumber = 'P420122142440857' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370924'
                WHERE ordernumber = 'P180122142520623' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '90938'
                WHERE ordernumber = 'P200122142642156' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370925'
                WHERE ordernumber = 'P180122142734130' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '125996'
                WHERE ordernumber = 'P420122142756954' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370926'
                WHERE ordernumber = 'P200122142809159' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128493'
                WHERE ordernumber = 'P420122143326309' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '156504'
                WHERE ordernumber = 'P200122143527270' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142353'
                WHERE ordernumber = 'P420122143543532' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '359025'
                WHERE ordernumber = 'P420122143917542' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '161937'
                WHERE ordernumber = 'P200122143955573' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '231253'
                WHERE ordernumber = 'P180122144013193' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '135376'
                WHERE ordernumber = 'P190122144049797' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370940'
                WHERE ordernumber = 'P200122144137815' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370940'
                WHERE ordernumber = 'P200122144258162' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245752'
                WHERE ordernumber = 'P180122144319961' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370945'
                WHERE ordernumber = 'P200122144514760' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370124'
                WHERE ordernumber = 'P420122144523436' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370953'
                WHERE ordernumber = 'P420122144959587' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345577'
                WHERE ordernumber = 'P190122145007996' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223304'
                WHERE ordernumber = 'P200122145459783' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368204'
                WHERE ordernumber = 'P420122145731196' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336285'
                WHERE ordernumber = 'P190122150059725' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '259990'
                WHERE ordernumber = 'P200122150336706' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '295273'
                WHERE ordernumber = 'P190122150339278' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370959'
                WHERE ordernumber = 'P190122150416663' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370961'
                WHERE ordernumber = 'P420122150513674' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '210801'
                WHERE ordernumber = 'P190122150542728' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '95592'
                WHERE ordernumber = 'P200122151240924' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248878'
                WHERE ordernumber = 'P200122151613904' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370966'
                WHERE ordernumber = 'P420122152026406' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281239'
                WHERE ordernumber = 'P190122152259804' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370969'
                WHERE ordernumber = 'P420122152446303' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370226'
                WHERE ordernumber = 'P190122152506319' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370971'
                WHERE ordernumber = 'P420122152717985' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '106023'
                WHERE ordernumber = 'P190122152723762' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370973'
                WHERE ordernumber = 'P420122152915301' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269120'
                WHERE ordernumber = 'P190122152937309' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '130063'
                WHERE ordernumber = 'P180122152941865' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370954'
                WHERE ordernumber = 'P420122153022146' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '315642'
                WHERE ordernumber = 'P180122153151419' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370980'
                WHERE ordernumber = 'P420122153913761' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '160121'
                WHERE ordernumber = 'P200122153953845' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342927'
                WHERE ordernumber = 'P420122154134279' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '151368'
                WHERE ordernumber = 'P200122154618987' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '164099'
                WHERE ordernumber = 'P200122155031319' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98313'
                WHERE ordernumber = 'P200122155203287' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '243649'
                WHERE ordernumber = 'P190122155339462' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '328546'
                WHERE ordernumber = 'P420122155809358' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370985'
                WHERE ordernumber = 'P200122155840689' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370986'
                WHERE ordernumber = 'P420122160026453' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370984'
                WHERE ordernumber = 'P200122160132156' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '52556'
                WHERE ordernumber = 'P180122160444655' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370989'
                WHERE ordernumber = 'P420122160617817' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '229194'
                WHERE ordernumber = 'P190122160641702' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123194'
                WHERE ordernumber = 'P180122160647643' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270662'
                WHERE ordernumber = 'P420122160730893' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '123194'
                WHERE ordernumber = 'P180122160746541' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '287179'
                WHERE ordernumber = 'P200122161010167' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '355693'
                WHERE ordernumber = 'P180122161049507' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347636'
                WHERE ordernumber = 'P200122161117142' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '157562'
                WHERE ordernumber = 'P180122161514265' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P180122161707637' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '296352'
                WHERE ordernumber = 'P200122161715470' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P180122161816192' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271305'
                WHERE ordernumber = 'P180122161919818' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '370996'
                WHERE ordernumber = 'P420122161923739' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '347715'
                WHERE ordernumber = 'P180122162012151' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '313349'
                WHERE ordernumber = 'P180122162144282' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '367983'
                WHERE ordernumber = 'P420122162238335' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358920'
                WHERE ordernumber = 'P180122162303180' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '252199'
                WHERE ordernumber = 'P430122162530690' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '366944'
                WHERE ordernumber = 'P200122162841846' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371002'
                WHERE ordernumber = 'P180122163134667' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371004'
                WHERE ordernumber = 'P180122163516421' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227076'
                WHERE ordernumber = 'P200122163758406' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371005'
                WHERE ordernumber = 'P420122163900124' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '93677'
                WHERE ordernumber = 'P200122163939551' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '304737'
                WHERE ordernumber = 'P200122164152711' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '221426'
                WHERE ordernumber = 'P180122164250147' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321877'
                WHERE ordernumber = 'P420122164324621' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346090'
                WHERE ordernumber = 'P200122165230751' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371010'
                WHERE ordernumber = 'P180122165318618' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276467'
                WHERE ordernumber = 'P200122165431965' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '325472'
                WHERE ordernumber = 'P180122165727497' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '127816'
                WHERE ordernumber = 'P180122165846494' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '286721'
                WHERE ordernumber = 'P180122170435971' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '159143'
                WHERE ordernumber = 'P200122170824411' 
            
2024-01-23 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371016'
                WHERE ordernumber = 'P200122171304999' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304743'
                WHERE ordernumber = 'P200122171636425' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '217519'
                WHERE ordernumber = 'P200122171726273' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371018'
                WHERE ordernumber = 'P420122172138582' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371020'
                WHERE ordernumber = 'P420122172329780' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371023'
                WHERE ordernumber = 'P420122172504543' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272568'
                WHERE ordernumber = 'P420122172633875' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '222161'
                WHERE ordernumber = 'P200122172850682' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371018'
                WHERE ordernumber = 'P420122173142265' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '286120'
                WHERE ordernumber = 'P180122173536808' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '354453'
                WHERE ordernumber = 'P180122173652575' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '299292'
                WHERE ordernumber = 'P420122173652886' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '360788'
                WHERE ordernumber = 'P420122173830133' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '368814'
                WHERE ordernumber = 'P200122174033126' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '218840'
                WHERE ordernumber = 'P180122174233799' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '276697'
                WHERE ordernumber = 'P200122174334502' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371035'
                WHERE ordernumber = 'P420122174547216' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '344127'
                WHERE ordernumber = 'P420122174658452' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371036'
                WHERE ordernumber = 'P180122175232312' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '304026'
                WHERE ordernumber = 'P200122175238627' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '212202'
                WHERE ordernumber = 'P180122175322917' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '359084'
                WHERE ordernumber = 'P420122175509569' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371039'
                WHERE ordernumber = 'P200122175626369' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371040'
                WHERE ordernumber = 'P200122175715750' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '353810'
                WHERE ordernumber = 'P180122175720352' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '96007'
                WHERE ordernumber = 'P180122175847543' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '93510'
                WHERE ordernumber = 'P180122180008973' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371043'
                WHERE ordernumber = 'P420122180158117' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '229589'
                WHERE ordernumber = 'P180122180242396' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371047'
                WHERE ordernumber = 'P200122180330194' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371049'
                WHERE ordernumber = 'P200122180509790' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99415'
                WHERE ordernumber = 'P200122180756174' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '272980'
                WHERE ordernumber = 'P180122180901142' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371051'
                WHERE ordernumber = 'P420122180920597' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371052'
                WHERE ordernumber = 'P420122181105646' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '256105'
                WHERE ordernumber = 'P200122181133417' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371053'
                WHERE ordernumber = 'P420122181145933' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '196711'
                WHERE ordernumber = 'P420122181414256' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '320749'
                WHERE ordernumber = 'P420122181535463' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337447'
                WHERE ordernumber = 'P200122181916972' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '337447'
                WHERE ordernumber = 'P200122182046830' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371056'
                WHERE ordernumber = 'P200122182323532' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '215272'
                WHERE ordernumber = 'P180122182530563' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371052'
                WHERE ordernumber = 'P420122182606520' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371058'
                WHERE ordernumber = 'P420122182811785' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '309779'
                WHERE ordernumber = 'P180122182952492' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '318562'
                WHERE ordernumber = 'P420122183005439' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371062'
                WHERE ordernumber = 'P180122183445921' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '250259'
                WHERE ordernumber = 'P180122183629208' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282773'
                WHERE ordernumber = 'P200122183947163' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '282773'
                WHERE ordernumber = 'P200122184059879' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '193625'
                WHERE ordernumber = 'P180122184225375' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371066'
                WHERE ordernumber = 'P200122184307308' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371067'
                WHERE ordernumber = 'P200122184513670' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371033'
                WHERE ordernumber = 'P180122184651373' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371069'
                WHERE ordernumber = 'P420122185039397' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '103924'
                WHERE ordernumber = 'P200122185202862' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371072'
                WHERE ordernumber = 'P420122185207621' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371074'
                WHERE ordernumber = 'P420122185442788' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371075'
                WHERE ordernumber = 'P200122185458650' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371072'
                WHERE ordernumber = 'P420122185530336' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '145965'
                WHERE ordernumber = 'P180122185532197' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371077'
                WHERE ordernumber = 'P200122185631822' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '366883'
                WHERE ordernumber = 'P200122185728716' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371078'
                WHERE ordernumber = 'P420122190012643' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '271153'
                WHERE ordernumber = 'P200122190251904' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '365174'
                WHERE ordernumber = 'P200122190437794' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '233922'
                WHERE ordernumber = 'P420122190810856' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '101523'
                WHERE ordernumber = 'P180122191044760' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '370935'
                WHERE ordernumber = 'P180122191430700' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '329340'
                WHERE ordernumber = 'P200122192131210' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371088'
                WHERE ordernumber = 'P420122192211393' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '146920'
                WHERE ordernumber = 'P420122192544771' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371092'
                WHERE ordernumber = 'P420122192927555' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '161497'
                WHERE ordernumber = 'P420122193228487' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371096'
                WHERE ordernumber = 'P200122193320376' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '242137'
                WHERE ordernumber = 'P200122193432765' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '46600'
                WHERE ordernumber = 'P200122193711532' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '44719'
                WHERE ordernumber = 'P190122193731382' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '268883'
                WHERE ordernumber = 'P420122193804484' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371100'
                WHERE ordernumber = 'P200122193927516' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371097'
                WHERE ordernumber = 'P190122193937536' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '283475'
                WHERE ordernumber = 'P190122194124255' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '46600'
                WHERE ordernumber = 'P200122194314234' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371097'
                WHERE ordernumber = 'P190122194535409' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '267171'
                WHERE ordernumber = 'P420122194744255' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '24164'
                WHERE ordernumber = 'P200122195157890' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '339929'
                WHERE ordernumber = 'P420122195500208' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371107'
                WHERE ordernumber = 'P190122195753831' 
            
2024-01-23 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '371107'
                WHERE ordernumber = 'P190122195827520'