2024-03-04 01:00:02 -- 將會員中心id寫入data-lake
2024-03-04 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-03-03%';
        
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '340841'
                WHERE ordernumber = 'P420303102800540' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379834'
                WHERE ordernumber = 'P420303110303479' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379835'
                WHERE ordernumber = 'P200303110411498' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379836'
                WHERE ordernumber = 'P180303110429151' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379837'
                WHERE ordernumber = 'P420303110541438' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379838'
                WHERE ordernumber = 'P180303110651138' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310814'
                WHERE ordernumber = 'P190303110837570' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '336021'
                WHERE ordernumber = 'P200303110946444' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379841'
                WHERE ordernumber = 'P200303112325141' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349347'
                WHERE ordernumber = 'P200303112424594' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350966'
                WHERE ordernumber = 'P200303112547179' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379842'
                WHERE ordernumber = 'P590303112652738' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379844'
                WHERE ordernumber = 'P200303112847657' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379845'
                WHERE ordernumber = 'P190303112912602' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379843'
                WHERE ordernumber = 'P180303113012775' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379843'
                WHERE ordernumber = 'P180303113055336' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379847'
                WHERE ordernumber = 'P180303113410263' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '84735'
                WHERE ordernumber = 'P180303113655392' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '84735'
                WHERE ordernumber = 'P180303113739640' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379848'
                WHERE ordernumber = 'P190303113742365' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379846'
                WHERE ordernumber = 'P590303113850844' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379849'
                WHERE ordernumber = 'P180303114016806' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379850'
                WHERE ordernumber = 'P190303114035425' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '283493'
                WHERE ordernumber = 'P190303114212909' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379852'
                WHERE ordernumber = 'P420303114241459' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379853'
                WHERE ordernumber = 'P200303114307665' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309441'
                WHERE ordernumber = 'P180303114330812' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '282568'
                WHERE ordernumber = 'P200303114526159' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379854'
                WHERE ordernumber = 'P420303114804748' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304793'
                WHERE ordernumber = 'P180303115126439' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379855'
                WHERE ordernumber = 'P200303115300929' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '379856'
                WHERE ordernumber = 'P420303115728677' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '368121'
                WHERE ordernumber = 'P420303115954273' 
            
2024-03-04 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '316669'
                WHERE ordernumber = 'P190303120025426' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379857'
                WHERE ordernumber = 'P200303120550500' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95565'
                WHERE ordernumber = 'P190303120702360' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133740'
                WHERE ordernumber = 'P200303121319433' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379858'
                WHERE ordernumber = 'P200303121518673' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '339009'
                WHERE ordernumber = 'P200303121835888' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283388'
                WHERE ordernumber = 'P590303122123181' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379859'
                WHERE ordernumber = 'P420303122615421' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239634'
                WHERE ordernumber = 'P590303122751126' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379860'
                WHERE ordernumber = 'P590303123117579' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294471'
                WHERE ordernumber = 'P190303124631888' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379861'
                WHERE ordernumber = 'P420303124734933' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216899'
                WHERE ordernumber = 'P200303125259354' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298493'
                WHERE ordernumber = 'P200303125600444' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379862'
                WHERE ordernumber = 'P420303130208474' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '209723'
                WHERE ordernumber = 'P180303130547329' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379863'
                WHERE ordernumber = 'P420303130726593' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378910'
                WHERE ordernumber = 'P180303130932633' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379864'
                WHERE ordernumber = 'P180303131115664' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379865'
                WHERE ordernumber = 'P420303131729826' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379866'
                WHERE ordernumber = 'P200303132123585' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108952'
                WHERE ordernumber = 'P200303132355155' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217445'
                WHERE ordernumber = 'P190303132437232' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379867'
                WHERE ordernumber = 'P420303132502630' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379868'
                WHERE ordernumber = 'P200303132543734' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379840'
                WHERE ordernumber = 'P420303132657790' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379869'
                WHERE ordernumber = 'P420303132838782' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379870'
                WHERE ordernumber = 'P200303133340499' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '83318'
                WHERE ordernumber = 'P200303133416383' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379871'
                WHERE ordernumber = 'P180303133453523' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '288236'
                WHERE ordernumber = 'P200303133501863' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379872'
                WHERE ordernumber = 'P180303133619632' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379873'
                WHERE ordernumber = 'P420303133704655' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379874'
                WHERE ordernumber = 'P200303133731841' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379871'
                WHERE ordernumber = 'P180303133858538' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379876'
                WHERE ordernumber = 'P190303133921824' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379875'
                WHERE ordernumber = 'P420303133942640' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '226315'
                WHERE ordernumber = 'P180303134350780' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379877'
                WHERE ordernumber = 'P180303134708612' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '269565'
                WHERE ordernumber = 'P200303134737536' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358795'
                WHERE ordernumber = 'P180303135310479' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379878'
                WHERE ordernumber = 'P200303135400529' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364206'
                WHERE ordernumber = 'P200303135555887' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274867'
                WHERE ordernumber = 'P200303135715312' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '365002'
                WHERE ordernumber = 'P180303135721973' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379879'
                WHERE ordernumber = 'P180303140113655' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379880'
                WHERE ordernumber = 'P190303140116521' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379881'
                WHERE ordernumber = 'P180303140414817' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379883'
                WHERE ordernumber = 'P200303140553543' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379884'
                WHERE ordernumber = 'P420303140916602' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343942'
                WHERE ordernumber = 'P190303140951578' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379127'
                WHERE ordernumber = 'P420303141041506' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379885'
                WHERE ordernumber = 'P190303141454910' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '340771'
                WHERE ordernumber = 'P200303141639873' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283374'
                WHERE ordernumber = 'P190303141730645' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242490'
                WHERE ordernumber = 'P190303142019530' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379886'
                WHERE ordernumber = 'P180303142031389' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242490'
                WHERE ordernumber = 'P190303142303713' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379887'
                WHERE ordernumber = 'P420303142315905' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379886'
                WHERE ordernumber = 'P180303142328982' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379889'
                WHERE ordernumber = 'P420303142510739' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379891'
                WHERE ordernumber = 'P200303143350706' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379890'
                WHERE ordernumber = 'P190303143430537' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379893'
                WHERE ordernumber = 'P190303143659524' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '281677'
                WHERE ordernumber = 'P190303143759812' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '67684'
                WHERE ordernumber = 'P200303144124561' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379894'
                WHERE ordernumber = 'P180303144430663' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '244494'
                WHERE ordernumber = 'P200303144900329' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379896'
                WHERE ordernumber = 'P200303145607973' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379895'
                WHERE ordernumber = 'P420303145715942' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379897'
                WHERE ordernumber = 'P420303145818763' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379898'
                WHERE ordernumber = 'P420303150354934' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289202'
                WHERE ordernumber = 'P180303150356976' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377582'
                WHERE ordernumber = 'P200303150436445' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379899'
                WHERE ordernumber = 'P190303150822246' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379900'
                WHERE ordernumber = 'P200303150826993' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374191'
                WHERE ordernumber = 'P180303151503891' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379902'
                WHERE ordernumber = 'P420303151630130' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379892'
                WHERE ordernumber = 'P190303152055358' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379905'
                WHERE ordernumber = 'P590303152629246' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349347'
                WHERE ordernumber = 'P200303152944761' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379908'
                WHERE ordernumber = 'P180303153018549' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379907'
                WHERE ordernumber = 'P420303153122502' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '256869'
                WHERE ordernumber = 'P420303153850449' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379911'
                WHERE ordernumber = 'P590303154115931' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '90174'
                WHERE ordernumber = 'P200303154144624' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '378250'
                WHERE ordernumber = 'P190303154656779' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379913'
                WHERE ordernumber = 'P420303155044295' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379914'
                WHERE ordernumber = 'P200303155051642' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379915'
                WHERE ordernumber = 'P190303155154887' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379916'
                WHERE ordernumber = 'P420303155340666' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379917'
                WHERE ordernumber = 'P180303155458266' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '137631'
                WHERE ordernumber = 'P420303155459696' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '66218'
                WHERE ordernumber = 'P200303155514877' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379918'
                WHERE ordernumber = 'P190303155538984' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '363219'
                WHERE ordernumber = 'P420303155612996' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274265'
                WHERE ordernumber = 'P200303155756637' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164943'
                WHERE ordernumber = 'P200303155941572' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '346047'
                WHERE ordernumber = 'P420303160524945' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379921'
                WHERE ordernumber = 'P180303160754487' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379922'
                WHERE ordernumber = 'P180303160909534' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379919'
                WHERE ordernumber = 'P590303160947618' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379923'
                WHERE ordernumber = 'P180303160951265' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379925'
                WHERE ordernumber = 'P180303161142494' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379926'
                WHERE ordernumber = 'P180303161406460' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '352925'
                WHERE ordernumber = 'P190303161440540' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379927'
                WHERE ordernumber = 'P420303161652996' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '248308'
                WHERE ordernumber = 'P200303161702874' 
            
2024-03-04 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113039'
                WHERE ordernumber = 'P190303161809677' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379929'
                WHERE ordernumber = 'P190303162104851' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379924'
                WHERE ordernumber = 'P590303162233444' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379931'
                WHERE ordernumber = 'P420303162245630' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379930'
                WHERE ordernumber = 'P190303162359866' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379932'
                WHERE ordernumber = 'P180303162629730' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '128944'
                WHERE ordernumber = 'P200303163353648' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '353647'
                WHERE ordernumber = 'P190303164021583' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379935'
                WHERE ordernumber = 'P590303164238863' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379936'
                WHERE ordernumber = 'P420303164346268' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321717'
                WHERE ordernumber = 'P190303164807663' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '233233'
                WHERE ordernumber = 'P590303165504452' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379937'
                WHERE ordernumber = 'P420303170023999' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379940'
                WHERE ordernumber = 'P200303170532832' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379938'
                WHERE ordernumber = 'P590303170547973' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379943'
                WHERE ordernumber = 'P190303171539153' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '280487'
                WHERE ordernumber = 'P190303171906797' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '377969'
                WHERE ordernumber = 'P190303172250258' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379944'
                WHERE ordernumber = 'P420303172524908' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379945'
                WHERE ordernumber = 'P200303172547483' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346622'
                WHERE ordernumber = 'P420303173105198' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '281559'
                WHERE ordernumber = 'P180303173130996' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379946'
                WHERE ordernumber = 'P420303173237112' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379947'
                WHERE ordernumber = 'P180303173822497' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379948'
                WHERE ordernumber = 'P180303174145233' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '376111'
                WHERE ordernumber = 'P180303174812132' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379950'
                WHERE ordernumber = 'P420303175152919' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379952'
                WHERE ordernumber = 'P200303180058645' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379319'
                WHERE ordernumber = 'P200303180148563' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343770'
                WHERE ordernumber = 'P200303180245565' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379953'
                WHERE ordernumber = 'P420303180756552' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379951'
                WHERE ordernumber = 'P180303181038158' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '321217'
                WHERE ordernumber = 'P420303181302717' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379274'
                WHERE ordernumber = 'P180303181808421' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379954'
                WHERE ordernumber = 'P420303181953277' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379955'
                WHERE ordernumber = 'P200303182353740' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '346749'
                WHERE ordernumber = 'P190303183213143' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '269427'
                WHERE ordernumber = 'P190303183308231' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379956'
                WHERE ordernumber = 'P190303183409506' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379957'
                WHERE ordernumber = 'P420303183618831' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379958'
                WHERE ordernumber = 'P420303183918337' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '285730'
                WHERE ordernumber = 'P200303184226312' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379812'
                WHERE ordernumber = 'P200303184341404' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291868'
                WHERE ordernumber = 'P590303184418469' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379960'
                WHERE ordernumber = 'P590303184539688' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379959'
                WHERE ordernumber = 'P590303184940488' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379961'
                WHERE ordernumber = 'P190303185027278' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200303185335381' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '282426'
                WHERE ordernumber = 'P200303185414770' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '20905'
                WHERE ordernumber = 'P190303185537536' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '20905'
                WHERE ordernumber = 'P190303185630995' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '360394'
                WHERE ordernumber = 'P190303190908752' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '223482'
                WHERE ordernumber = 'P190303191226749' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '136516'
                WHERE ordernumber = 'P190303192152111' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379964'
                WHERE ordernumber = 'P420303192941431' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379965'
                WHERE ordernumber = 'P200303193157410' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379112'
                WHERE ordernumber = 'P420303194311446' 
            
2024-03-04 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '379970'
                WHERE ordernumber = 'P590303201718288'