2024-04-24 01:00:02 -- 將會員中心id寫入data-lake
2024-04-24 01:00:02 -- 
            SELECT u.id as userId,p.firm_service_id,p.order_code,p.created_at 
            FROM `purchases` p
            LEFT JOIN user_relations ur on p.user_relation_id = ur.id
            LEFT JOIN users u on ur.user_id = u.id
            WHERE p.order_code LIKE 'P%' 
            and p.created_at like '2024-04-23%';
        
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386709'
                WHERE ordernumber = 'P630423100552369' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386711'
                WHERE ordernumber = 'P630423101831470' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352545'
                WHERE ordernumber = 'P200423110218182' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '235519'
                WHERE ordernumber = 'P180423110404778' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143048'
                WHERE ordernumber = 'P200423110500655' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386714'
                WHERE ordernumber = 'P180423110815984' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386716'
                WHERE ordernumber = 'P200423110958553' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '81933'
                WHERE ordernumber = 'P200423111145646' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '246075'
                WHERE ordernumber = 'P180423111238786' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386717'
                WHERE ordernumber = 'P420423111625316' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294573'
                WHERE ordernumber = 'P200423111844319' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247672'
                WHERE ordernumber = 'P180423111904495' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386718'
                WHERE ordernumber = 'P180423112415957' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P200423112529741' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386719'
                WHERE ordernumber = 'P200423112851115' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386721'
                WHERE ordernumber = 'P190423113450478' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386722'
                WHERE ordernumber = 'P190423113654685' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386723'
                WHERE ordernumber = 'P180423113736489' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386725'
                WHERE ordernumber = 'P180423115107697' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248905'
                WHERE ordernumber = 'P200423124015798' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386726'
                WHERE ordernumber = 'P590423124415923' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '384011'
                WHERE ordernumber = 'P630423125249480' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386729'
                WHERE ordernumber = 'P180423125400798' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345484'
                WHERE ordernumber = 'P200423125738864' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '350313'
                WHERE ordernumber = 'P180423130034450' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '374458'
                WHERE ordernumber = 'P630423130408286' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386732'
                WHERE ordernumber = 'P180423131131313' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P180423131341810' 
            
2024-04-24 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '386733'
                WHERE ordernumber = 'P200423131433383' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93266'
                WHERE ordernumber = 'P180423132142879' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39039'
                WHERE ordernumber = 'P200423132214193' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385455'
                WHERE ordernumber = 'P420423132344674' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385455'
                WHERE ordernumber = 'P420423132413894' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '207972'
                WHERE ordernumber = 'P200423132747620' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P200423133237623' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386734'
                WHERE ordernumber = 'P200423133516199' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386736'
                WHERE ordernumber = 'P200423134301479' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242946'
                WHERE ordernumber = 'P180423134512949' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386738'
                WHERE ordernumber = 'P180423134639259' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242946'
                WHERE ordernumber = 'P180423134713128' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136217'
                WHERE ordernumber = 'P630423134730418' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '237169'
                WHERE ordernumber = 'P180423135126409' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276466'
                WHERE ordernumber = 'P200423135219916' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386740'
                WHERE ordernumber = 'P180423135422775' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386741'
                WHERE ordernumber = 'P200423140000784' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386742'
                WHERE ordernumber = 'P180423140128251' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '320424'
                WHERE ordernumber = 'P200423141018287' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386743'
                WHERE ordernumber = 'P420423141152842' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121148'
                WHERE ordernumber = 'P180423141739846' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302352'
                WHERE ordernumber = 'P420423141900553' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '295570'
                WHERE ordernumber = 'P200423142401157' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '380625'
                WHERE ordernumber = 'P180423143953665' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386179'
                WHERE ordernumber = 'P630423144907758' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334859'
                WHERE ordernumber = 'P180423151000240' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '364203'
                WHERE ordernumber = 'P180423151236679' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '216932'
                WHERE ordernumber = 'P420423152110366' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381089'
                WHERE ordernumber = 'P420423152818341' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '95592'
                WHERE ordernumber = 'P200423153121130' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386750'
                WHERE ordernumber = 'P180423153233261' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386751'
                WHERE ordernumber = 'P630423153252165' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386752'
                WHERE ordernumber = 'P200423153541494' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386753'
                WHERE ordernumber = 'P200423153648322' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386754'
                WHERE ordernumber = 'P190423153900217' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386755'
                WHERE ordernumber = 'P420423155740176' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143144'
                WHERE ordernumber = 'P200423160440547' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '141761'
                WHERE ordernumber = 'P180423160445640' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386759'
                WHERE ordernumber = 'P180423160949759' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386759'
                WHERE ordernumber = 'P180423161043570' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386760'
                WHERE ordernumber = 'P180423161208967' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386761'
                WHERE ordernumber = 'P420423161551467' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296163'
                WHERE ordernumber = 'P200423162240115' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386762'
                WHERE ordernumber = 'P420423163356977' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381774'
                WHERE ordernumber = 'P420423163653935' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386763'
                WHERE ordernumber = 'P630423163853578' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386764'
                WHERE ordernumber = 'P420423164046985' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386765'
                WHERE ordernumber = 'P200423164255830' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '350730'
                WHERE ordernumber = 'P190423164357866' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291788'
                WHERE ordernumber = 'P420423164602860' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '106911'
                WHERE ordernumber = 'P200423164929662' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379722'
                WHERE ordernumber = 'P420423165053870' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386768'
                WHERE ordernumber = 'P190423165613288' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313481'
                WHERE ordernumber = 'P180423165621703' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385187'
                WHERE ordernumber = 'P190423170956551' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386769'
                WHERE ordernumber = 'P420423171231683' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277935'
                WHERE ordernumber = 'P420423172400291' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341590'
                WHERE ordernumber = 'P190423172431755' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386773'
                WHERE ordernumber = 'P200423174039374' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '327132'
                WHERE ordernumber = 'P630423175034201' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102257'
                WHERE ordernumber = 'P180423175125475' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386774'
                WHERE ordernumber = 'P420423175616157' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '337116'
                WHERE ordernumber = 'P200423180120148' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386776'
                WHERE ordernumber = 'P180423180647902' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386777'
                WHERE ordernumber = 'P420423180703573' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386776'
                WHERE ordernumber = 'P180423180706960' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386778'
                WHERE ordernumber = 'P200423180818194' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283129'
                WHERE ordernumber = 'P180423180849713' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '294471'
                WHERE ordernumber = 'P190423181221756' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '166785'
                WHERE ordernumber = 'P180423181226519' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '285141'
                WHERE ordernumber = 'P200423181250161' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386779'
                WHERE ordernumber = 'P200423181751981' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386780'
                WHERE ordernumber = 'P180423181752249' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253624'
                WHERE ordernumber = 'P200423182134764' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386782'
                WHERE ordernumber = 'P200423182502189' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386784'
                WHERE ordernumber = 'P630423182911544' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386047'
                WHERE ordernumber = 'P200423183332981' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386785'
                WHERE ordernumber = 'P420423183925262' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '341314'
                WHERE ordernumber = 'P190423184228342' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382245'
                WHERE ordernumber = 'P200423184306842' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386786'
                WHERE ordernumber = 'P630423184525211' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386787'
                WHERE ordernumber = 'P190423184610986' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '276029'
                WHERE ordernumber = 'P190423185042634' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '312854'
                WHERE ordernumber = 'P200423185050132' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386788'
                WHERE ordernumber = 'P200423185619865' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334823'
                WHERE ordernumber = 'P190423190141304' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '298128'
                WHERE ordernumber = 'P200423190644706' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '271033'
                WHERE ordernumber = 'P200423190758745' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386789'
                WHERE ordernumber = 'P200423191109372' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386790'
                WHERE ordernumber = 'P190423191624285' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100154'
                WHERE ordernumber = 'P630423191730132' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '39674'
                WHERE ordernumber = 'P630423192251499' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '64079'
                WHERE ordernumber = 'P200423192304157' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385148'
                WHERE ordernumber = 'P590423193159944' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '355466'
                WHERE ordernumber = 'P200423193204768' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250334'
                WHERE ordernumber = 'P200423194601403' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386794'
                WHERE ordernumber = 'P200423194757256' 
            
2024-04-24 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386795'
                WHERE ordernumber = 'P630423201757859' 
            
2024-04-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386796'
                WHERE ordernumber = 'P630423203107475' 
            
2024-04-24 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '384207'
                WHERE ordernumber = 'P630423211641250'