2024-06-12 01:00:01 -- 將會員中心id寫入data-lake
2024-06-12 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-06-11%';
        
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395513'
                WHERE ordernumber = 'P200611110203339' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '355007'
                WHERE ordernumber = 'P190611110235833' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395514'
                WHERE ordernumber = 'P180611111054715' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '207267'
                WHERE ordernumber = 'P190611111327879' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394858'
                WHERE ordernumber = 'P190611111532705' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394858'
                WHERE ordernumber = 'P190611111544554' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395515'
                WHERE ordernumber = 'P180611111748189' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '946'
                WHERE ordernumber = 'P180611111939569' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '366369'
                WHERE ordernumber = 'P200611112355303' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395516'
                WHERE ordernumber = 'P200611113117588' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395517'
                WHERE ordernumber = 'P200611113449898' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395509'
                WHERE ordernumber = 'P420611113608483' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304157'
                WHERE ordernumber = 'P180611113630939' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '284262'
                WHERE ordernumber = 'P180611114545471' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339254'
                WHERE ordernumber = 'P420611114933661' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395522'
                WHERE ordernumber = 'P200611115758227' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P180611121231275' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275910'
                WHERE ordernumber = 'P180611121604304' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '297110'
                WHERE ordernumber = 'P420611122147147' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395523'
                WHERE ordernumber = 'P180611122215239' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '377400'
                WHERE ordernumber = 'P180611123414737' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277983'
                WHERE ordernumber = 'P190611123452565' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180611124752649' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395526'
                WHERE ordernumber = 'P180611125636976' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395527'
                WHERE ordernumber = 'P200611130114225' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395527'
                WHERE ordernumber = 'P200611130226831' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304870'
                WHERE ordernumber = 'P180611131028657' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282292'
                WHERE ordernumber = 'P200611132025736' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96157'
                WHERE ordernumber = 'P180611132028742' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395528'
                WHERE ordernumber = 'P420611132503602' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '391274'
                WHERE ordernumber = 'P200611132925800' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336569'
                WHERE ordernumber = 'P420611133639973' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '97446'
                WHERE ordernumber = 'P190611134627811' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '36056'
                WHERE ordernumber = 'P200611135753749' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298853'
                WHERE ordernumber = 'P180611135853122' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '337679'
                WHERE ordernumber = 'P710611140145973' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395534'
                WHERE ordernumber = 'P190611140230640' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '122945'
                WHERE ordernumber = 'P200611140525346' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384943'
                WHERE ordernumber = 'P630611141704547' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384943'
                WHERE ordernumber = 'P630611142044731' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395539'
                WHERE ordernumber = 'P710611142102247' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395541'
                WHERE ordernumber = 'P200611142508432' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '306163'
                WHERE ordernumber = 'P710611142653996' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395540'
                WHERE ordernumber = 'P780611142805210' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395545'
                WHERE ordernumber = 'P420611143804717' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395543'
                WHERE ordernumber = 'P180611143815939' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101722'
                WHERE ordernumber = 'P180611144211323' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395548'
                WHERE ordernumber = 'P420611144949959' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395549'
                WHERE ordernumber = 'P200611145055808' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '87269'
                WHERE ordernumber = 'P630611145218950' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395550'
                WHERE ordernumber = 'P780611145218612' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '392638'
                WHERE ordernumber = 'P180611145915658' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395551'
                WHERE ordernumber = 'P200611150132686' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395552'
                WHERE ordernumber = 'P180611150355281' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '333919'
                WHERE ordernumber = 'P180611151101900' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328279'
                WHERE ordernumber = 'P190611151145729' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395553'
                WHERE ordernumber = 'P420611151747753' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395554'
                WHERE ordernumber = 'P200611152001286' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395555'
                WHERE ordernumber = 'P420611152104543' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '394270'
                WHERE ordernumber = 'P200611152238960' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395556'
                WHERE ordernumber = 'P180611152421803' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395557'
                WHERE ordernumber = 'P180611153401839' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '127551'
                WHERE ordernumber = 'P200611153607901' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '344831'
                WHERE ordernumber = 'P180611154646205' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '298067'
                WHERE ordernumber = 'P180611155036938' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395560'
                WHERE ordernumber = 'P200611155106133' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143618'
                WHERE ordernumber = 'P420611155140191' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '285180'
                WHERE ordernumber = 'P200611155320708' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395561'
                WHERE ordernumber = 'P780611155341821' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385427'
                WHERE ordernumber = 'P200611160124765' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '220537'
                WHERE ordernumber = 'P710611160400779' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385156'
                WHERE ordernumber = 'P180611160508320' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '289385'
                WHERE ordernumber = 'P180611160646942' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395563'
                WHERE ordernumber = 'P420611161214200' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395564'
                WHERE ordernumber = 'P180611161536227' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395565'
                WHERE ordernumber = 'P180611162303116' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378702'
                WHERE ordernumber = 'P190611162428755' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P180611162522157' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395566'
                WHERE ordernumber = 'P200611162535364' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309439'
                WHERE ordernumber = 'P180611162553152' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374215'
                WHERE ordernumber = 'P200611162633654' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395568'
                WHERE ordernumber = 'P420611162821159' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384727'
                WHERE ordernumber = 'P630611163021346' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395570'
                WHERE ordernumber = 'P180611163336850' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '286011'
                WHERE ordernumber = 'P200611163616332' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395571'
                WHERE ordernumber = 'P190611163754978' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102300'
                WHERE ordernumber = 'P200611163951215' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395572'
                WHERE ordernumber = 'P420611164234621' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214245'
                WHERE ordernumber = 'P190611164546183' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '20544'
                WHERE ordernumber = 'P180611164801478' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '269062'
                WHERE ordernumber = 'P420611164838166' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395573'
                WHERE ordernumber = 'P200611165015420' 
            
2024-06-12 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395574'
                WHERE ordernumber = 'P200611165301870' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395575'
                WHERE ordernumber = 'P180611165603592' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209052'
                WHERE ordernumber = 'P200611165932412' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388164'
                WHERE ordernumber = 'P200611170338652' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395576'
                WHERE ordernumber = 'P180611170516225' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395577'
                WHERE ordernumber = 'P420611170947919' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395578'
                WHERE ordernumber = 'P420611171106884' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395581'
                WHERE ordernumber = 'P190611171621613' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395582'
                WHERE ordernumber = 'P420611171649590' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249469'
                WHERE ordernumber = 'P200611171947655' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395583'
                WHERE ordernumber = 'P180611172143609' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315127'
                WHERE ordernumber = 'P200611172219215' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293808'
                WHERE ordernumber = 'P200611173155358' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392504'
                WHERE ordernumber = 'P200611173742903' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128470'
                WHERE ordernumber = 'P200611174114950' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304163'
                WHERE ordernumber = 'P200611174314174' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395585'
                WHERE ordernumber = 'P780611174328455' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395586'
                WHERE ordernumber = 'P180611174618610' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112057'
                WHERE ordernumber = 'P180611174802747' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395589'
                WHERE ordernumber = 'P780611174854637' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395590'
                WHERE ordernumber = 'P190611175014259' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395588'
                WHERE ordernumber = 'P200611175114395' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340966'
                WHERE ordernumber = 'P420611175136524' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395591'
                WHERE ordernumber = 'P710611175301756' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '371964'
                WHERE ordernumber = 'P420611175516616' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '394414'
                WHERE ordernumber = 'P200611175555193' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395569'
                WHERE ordernumber = 'P420611175617995' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215228'
                WHERE ordernumber = 'P420611175757821' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230248'
                WHERE ordernumber = 'P200611180144227' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '388675'
                WHERE ordernumber = 'P180611180428642' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395594'
                WHERE ordernumber = 'P200611181655878' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395593'
                WHERE ordernumber = 'P710611181726656' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281899'
                WHERE ordernumber = 'P420611181844958' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '82089'
                WHERE ordernumber = 'P180611182155788' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395595'
                WHERE ordernumber = 'P190611182858281' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '115824'
                WHERE ordernumber = 'P180611182917939' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '305586'
                WHERE ordernumber = 'P190611182958779' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395596'
                WHERE ordernumber = 'P180611183031150' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '210370'
                WHERE ordernumber = 'P180611183203875' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395597'
                WHERE ordernumber = 'P180611183349648' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395598'
                WHERE ordernumber = 'P190611183415541' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377152'
                WHERE ordernumber = 'P200611183604282' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '127964'
                WHERE ordernumber = 'P200611183703752' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395442'
                WHERE ordernumber = 'P420611183743356' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395599'
                WHERE ordernumber = 'P180611184329197' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395600'
                WHERE ordernumber = 'P200611184352625' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '135579'
                WHERE ordernumber = 'P190611184454502' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395601'
                WHERE ordernumber = 'P200611184654583' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395602'
                WHERE ordernumber = 'P190611184838782' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51025'
                WHERE ordernumber = 'P190611185012731' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369507'
                WHERE ordernumber = 'P420611190005441' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67948'
                WHERE ordernumber = 'P200611190028560' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '138914'
                WHERE ordernumber = 'P190611190516285' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316111'
                WHERE ordernumber = 'P200611190545637' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395604'
                WHERE ordernumber = 'P190611192015175' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281627'
                WHERE ordernumber = 'P200611192654657' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395605'
                WHERE ordernumber = 'P190611192732129' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395606'
                WHERE ordernumber = 'P200611192916255' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395607'
                WHERE ordernumber = 'P200611193503297' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395608'
                WHERE ordernumber = 'P190611194222998' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130397'
                WHERE ordernumber = 'P710611194243202' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395610'
                WHERE ordernumber = 'P200611194955157' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395611'
                WHERE ordernumber = 'P200611195132715' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395612'
                WHERE ordernumber = 'P190611195437589' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395612'
                WHERE ordernumber = 'P190611195541217' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395614'
                WHERE ordernumber = 'P780611200636174' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294573'
                WHERE ordernumber = 'P630611203232903' 
            
2024-06-12 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336290'
                WHERE ordernumber = 'P710611220045119'