2024-11-27 01:00:02 -- 將會員中心id寫入data-lake
2024-11-27 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-11-26%';
        
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '429804'
                WHERE ordernumber = 'P2411260000168' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '409163'
                WHERE ordernumber = 'P2411260000220' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431853'
                WHERE ordernumber = 'P2411260000432' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '412323'
                WHERE ordernumber = 'P2411260000529' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '367046'
                WHERE ordernumber = 'P2411260000615' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P2411260000839' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431854'
                WHERE ordernumber = 'P2411260001288' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431855'
                WHERE ordernumber = 'P2411260001391' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '209361'
                WHERE ordernumber = 'P2411260001748' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '387229'
                WHERE ordernumber = 'P2411260001829' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431528'
                WHERE ordernumber = 'P2411260002059' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431528'
                WHERE ordernumber = 'P2411260002195' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431856'
                WHERE ordernumber = 'P2411260002314' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '430876'
                WHERE ordernumber = 'P2411260002518' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287926'
                WHERE ordernumber = 'P2411260002638' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '307079'
                WHERE ordernumber = 'P2411260002796' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404139'
                WHERE ordernumber = 'P2411260002835' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P2411260002954' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431859'
                WHERE ordernumber = 'P2411260003119' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431860'
                WHERE ordernumber = 'P2411260003240' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '190999'
                WHERE ordernumber = 'P2411260003387' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '143149'
                WHERE ordernumber = 'P2411260003568' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '362346'
                WHERE ordernumber = 'P2411260003661' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431861'
                WHERE ordernumber = 'P2411260003841' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '301528'
                WHERE ordernumber = 'P2411260004043' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431862'
                WHERE ordernumber = 'P2411260004228' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385358'
                WHERE ordernumber = 'P2411260004694' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365200'
                WHERE ordernumber = 'P2411260004844' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '164381'
                WHERE ordernumber = 'P2411260005070' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380176'
                WHERE ordernumber = 'P2411260005123' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431865'
                WHERE ordernumber = 'P2411260005314' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341049'
                WHERE ordernumber = 'P2411260005475' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '294547'
                WHERE ordernumber = 'P2411260005724' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236620'
                WHERE ordernumber = 'P2411260005946' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431868'
                WHERE ordernumber = 'P2411260006195' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '236620'
                WHERE ordernumber = 'P2411260006342' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431870'
                WHERE ordernumber = 'P2411260006437' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431871'
                WHERE ordernumber = 'P2411260006637' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431869'
                WHERE ordernumber = 'P2411260006813' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431871'
                WHERE ordernumber = 'P2411260006953' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '396949'
                WHERE ordernumber = 'P2411260007193' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '365504'
                WHERE ordernumber = 'P2411260007282' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431873'
                WHERE ordernumber = 'P2411260007324' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277012'
                WHERE ordernumber = 'P2411260007492' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411465'
                WHERE ordernumber = 'P2411260007683' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431875'
                WHERE ordernumber = 'P2411260007797' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P2411260007890' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431877'
                WHERE ordernumber = 'P2411260008034' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '373803'
                WHERE ordernumber = 'P2411260008180' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221016'
                WHERE ordernumber = 'P2411260008282' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '248445'
                WHERE ordernumber = 'P2411260008482' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '99845'
                WHERE ordernumber = 'P2411260008537' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '431879'
                WHERE ordernumber = 'P2411260008676' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424526'
                WHERE ordernumber = 'P2411260008932' 
            
2024-11-27 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422323'
                WHERE ordernumber = 'P2411260009023' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431882'
                WHERE ordernumber = 'P2411260009129' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431459'
                WHERE ordernumber = 'P2411260009539' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '324722'
                WHERE ordernumber = 'P2411260010477' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431838'
                WHERE ordernumber = 'P2411260010714' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '393066'
                WHERE ordernumber = 'P2411260010932' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431875'
                WHERE ordernumber = 'P2411260011078' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '234582'
                WHERE ordernumber = 'P2411260011277' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431885'
                WHERE ordernumber = 'P2411260011362' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334890'
                WHERE ordernumber = 'P2411260011758' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100490'
                WHERE ordernumber = 'P2411260011820' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328745'
                WHERE ordernumber = 'P2411260011925' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '296244'
                WHERE ordernumber = 'P2411260012059' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431889'
                WHERE ordernumber = 'P2411260012137' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431849'
                WHERE ordernumber = 'P2411260012212' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282896'
                WHERE ordernumber = 'P2411260012375' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '242448'
                WHERE ordernumber = 'P2411260012452' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P2411260012643' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329786'
                WHERE ordernumber = 'P2411260012710' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431894'
                WHERE ordernumber = 'P2411260012814' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314571'
                WHERE ordernumber = 'P2411260012919' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '143531'
                WHERE ordernumber = 'P2411260013118' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '178583'
                WHERE ordernumber = 'P2411260013974' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431896'
                WHERE ordernumber = 'P2411260014130' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431897'
                WHERE ordernumber = 'P2411260014361' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '334750'
                WHERE ordernumber = 'P2411260014410' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431897'
                WHERE ordernumber = 'P2411260014516' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '250721'
                WHERE ordernumber = 'P2411260014673' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '368838'
                WHERE ordernumber = 'P2411260015061' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431898'
                WHERE ordernumber = 'P2411260015128' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '107559'
                WHERE ordernumber = 'P2411260015339' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431900'
                WHERE ordernumber = 'P2411260015630' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '399308'
                WHERE ordernumber = 'P2411260015968' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '277896'
                WHERE ordernumber = 'P2411260016315' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431902'
                WHERE ordernumber = 'P2411260016474' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431904'
                WHERE ordernumber = 'P2411260016538' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96658'
                WHERE ordernumber = 'P2411260016848' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289030'
                WHERE ordernumber = 'P2411260016962' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428599'
                WHERE ordernumber = 'P2411260017411' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167013'
                WHERE ordernumber = 'P2411260017882' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431908'
                WHERE ordernumber = 'P2411260018086' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306214'
                WHERE ordernumber = 'P2411260018379' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431909'
                WHERE ordernumber = 'P2411260018429' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431911'
                WHERE ordernumber = 'P2411260018520' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431910'
                WHERE ordernumber = 'P2411260018653' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291605'
                WHERE ordernumber = 'P2411260019073' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431914'
                WHERE ordernumber = 'P2411260019112' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '108330'
                WHERE ordernumber = 'P2411260019278' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403368'
                WHERE ordernumber = 'P2411260019493' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '430800'
                WHERE ordernumber = 'P2411260019567' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P2411260019688' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329666'
                WHERE ordernumber = 'P2411260019837' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431916'
                WHERE ordernumber = 'P2411260020170' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215833'
                WHERE ordernumber = 'P2411260020216' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431917'
                WHERE ordernumber = 'P2411260020395' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431917'
                WHERE ordernumber = 'P2411260020773' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431919'
                WHERE ordernumber = 'P2411260020857' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '310479'
                WHERE ordernumber = 'P2411260021061' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '404544'
                WHERE ordernumber = 'P2411260021369' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431919'
                WHERE ordernumber = 'P2411260021421' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370519'
                WHERE ordernumber = 'P2411260021586' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348566'
                WHERE ordernumber = 'P2411260021770' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431920'
                WHERE ordernumber = 'P2411260021857' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '408006'
                WHERE ordernumber = 'P2411260021914' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347940'
                WHERE ordernumber = 'P2411260022079' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '283600'
                WHERE ordernumber = 'P2411260022131' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '322480'
                WHERE ordernumber = 'P2411260022478' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '49345'
                WHERE ordernumber = 'P2411260022584' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370568'
                WHERE ordernumber = 'P2411260022683' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '370568'
                WHERE ordernumber = 'P2411260022739' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '263357'
                WHERE ordernumber = 'P2411260022813' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '302561'
                WHERE ordernumber = 'P2411260023037' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431926'
                WHERE ordernumber = 'P2411260023146' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431925'
                WHERE ordernumber = 'P2411260023238' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431929'
                WHERE ordernumber = 'P2411260023891' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431929'
                WHERE ordernumber = 'P2411260023946' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '51876'
                WHERE ordernumber = 'P2411260024078' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431930'
                WHERE ordernumber = 'P2411260024233' 
            
2024-11-27 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '431932'
                WHERE ordernumber = 'P2411260024311'