2023-11-28 01:00:02 -- 將會員中心id寫入data-lake
2023-11-28 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 '2023-11-27%';
        
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201127110119581' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '257880'
                WHERE ordernumber = 'P201127110300736' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '86113'
                WHERE ordernumber = 'P191127110320614' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '105100'
                WHERE ordernumber = 'P201127110349783' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '309380'
                WHERE ordernumber = 'P201127110429293' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349550'
                WHERE ordernumber = 'P191127110529717' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349551'
                WHERE ordernumber = 'P421127110558991' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '142919'
                WHERE ordernumber = 'P201127111904141' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '221427'
                WHERE ordernumber = 'P201127112240463' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349552'
                WHERE ordernumber = 'P421127112331729' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349553'
                WHERE ordernumber = 'P191127112533203' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '108588'
                WHERE ordernumber = 'P421127113212615' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349555'
                WHERE ordernumber = 'P201127113650884' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P191127113909349' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299101'
                WHERE ordernumber = 'P191127114418914' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '250177'
                WHERE ordernumber = 'P201127115036680' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '98527'
                WHERE ordernumber = 'P201127115128511' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '276777'
                WHERE ordernumber = 'P191127115544674' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349557'
                WHERE ordernumber = 'P191127120158999' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '214528'
                WHERE ordernumber = 'P181127121004415' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349559'
                WHERE ordernumber = 'P191127121013438' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349560'
                WHERE ordernumber = 'P201127121156665' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349561'
                WHERE ordernumber = 'P181127121216339' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349564'
                WHERE ordernumber = 'P201127122612808' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349554'
                WHERE ordernumber = 'P191127122800213' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349554'
                WHERE ordernumber = 'P191127122847650' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206554'
                WHERE ordernumber = 'P421127123100557' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '349567'
                WHERE ordernumber = 'P201127123434376' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '290955'
                WHERE ordernumber = 'P201127123529380' 
            
2023-11-28 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273931'
                WHERE ordernumber = 'P421127123605402' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336135'
                WHERE ordernumber = 'P421127124148606' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '344863'
                WHERE ordernumber = 'P421127124301715' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349568'
                WHERE ordernumber = 'P201127124640710' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247610'
                WHERE ordernumber = 'P201127124733930' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314099'
                WHERE ordernumber = 'P201127125249330' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240188'
                WHERE ordernumber = 'P201127125703839' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293262'
                WHERE ordernumber = 'P201127130509496' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349572'
                WHERE ordernumber = 'P201127130755755' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '336628'
                WHERE ordernumber = 'P421127130811302' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349573'
                WHERE ordernumber = 'P201127130917585' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349574'
                WHERE ordernumber = 'P191127131843987' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349575'
                WHERE ordernumber = 'P191127132749735' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349576'
                WHERE ordernumber = 'P201127132911753' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102595'
                WHERE ordernumber = 'P201127133044760' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349577'
                WHERE ordernumber = 'P201127133228543' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342860'
                WHERE ordernumber = 'P191127133759680' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289272'
                WHERE ordernumber = 'P201127133909649' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349578'
                WHERE ordernumber = 'P191127134114729' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349579'
                WHERE ordernumber = 'P191127134419277' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289124'
                WHERE ordernumber = 'P191127134624135' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102068'
                WHERE ordernumber = 'P181127135332669' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '345534'
                WHERE ordernumber = 'P201127135644799' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '145811'
                WHERE ordernumber = 'P191127135943141' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349582'
                WHERE ordernumber = 'P421127140320422' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343585'
                WHERE ordernumber = 'P191127140529846' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342876'
                WHERE ordernumber = 'P191127140807258' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342900'
                WHERE ordernumber = 'P191127140901609' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '328901'
                WHERE ordernumber = 'P201127141157877' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '235944'
                WHERE ordernumber = 'P191127141333164' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349585'
                WHERE ordernumber = 'P191127141749987' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '315941'
                WHERE ordernumber = 'P201127142025998' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349586'
                WHERE ordernumber = 'P191127142228307' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '114186'
                WHERE ordernumber = 'P201127142835880' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349588'
                WHERE ordernumber = 'P201127142944928' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99642'
                WHERE ordernumber = 'P191127143931245' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '280722'
                WHERE ordernumber = 'P201127144629343' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '94237'
                WHERE ordernumber = 'P201127145438288' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348642'
                WHERE ordernumber = 'P181127145632645' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '348642'
                WHERE ordernumber = 'P181127145733585' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '347386'
                WHERE ordernumber = 'P181127145810574' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '275450'
                WHERE ordernumber = 'P181127150012320' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349592'
                WHERE ordernumber = 'P421127150104117' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '343101'
                WHERE ordernumber = 'P421127151015998' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349594'
                WHERE ordernumber = 'P181127151040693' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349595'
                WHERE ordernumber = 'P421127151456996' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '121498'
                WHERE ordernumber = 'P421127152036966' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349604'
                WHERE ordernumber = 'P421127152550899' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349607'
                WHERE ordernumber = 'P191127154646483' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '215784'
                WHERE ordernumber = 'P191127154724379' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349609'
                WHERE ordernumber = 'P191127155043582' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '249754'
                WHERE ordernumber = 'P191127155342996' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349611'
                WHERE ordernumber = 'P191127155736919' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349613'
                WHERE ordernumber = 'P191127155917342' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349614'
                WHERE ordernumber = 'P201127160058610' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349615'
                WHERE ordernumber = 'P201127160407455' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349616'
                WHERE ordernumber = 'P191127160451831' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120871'
                WHERE ordernumber = 'P191127160639477' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349619'
                WHERE ordernumber = 'P191127161917534' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '102881'
                WHERE ordernumber = 'P201127161928608' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '214880'
                WHERE ordernumber = 'P191127162601337' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342097'
                WHERE ordernumber = 'P191127162927892' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282192'
                WHERE ordernumber = 'P201127162935122' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224865'
                WHERE ordernumber = 'P421127163204183' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '304282'
                WHERE ordernumber = 'P191127163315520' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '176036'
                WHERE ordernumber = 'P421127163750809' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '227972'
                WHERE ordernumber = 'P201127164215823' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349622'
                WHERE ordernumber = 'P191127164228143' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167845'
                WHERE ordernumber = 'P201127164922840' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349623'
                WHERE ordernumber = 'P191127165009921' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '306637'
                WHERE ordernumber = 'P201127165227144' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218546'
                WHERE ordernumber = 'P201127165322354' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289835'
                WHERE ordernumber = 'P181127165406167' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '268279'
                WHERE ordernumber = 'P201127165810222' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '96996'
                WHERE ordernumber = 'P181127170816217' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349625'
                WHERE ordernumber = 'P421127171219426' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349627'
                WHERE ordernumber = 'P421127172158630' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '228713'
                WHERE ordernumber = 'P201127172619531' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342690'
                WHERE ordernumber = 'P181127172650529' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '133686'
                WHERE ordernumber = 'P181127173726980' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349629'
                WHERE ordernumber = 'P201127173912450' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349630'
                WHERE ordernumber = 'P421127174254151' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '71667'
                WHERE ordernumber = 'P181127175710306' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '128436'
                WHERE ordernumber = 'P181127175909928' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '238659'
                WHERE ordernumber = 'P201127180219632' 
            
2023-11-28 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '349632'
                WHERE ordernumber = 'P181127180930374' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349634'
                WHERE ordernumber = 'P201127181443960' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349635'
                WHERE ordernumber = 'P181127181534116' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '288170'
                WHERE ordernumber = 'P181127181611843' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349637'
                WHERE ordernumber = 'P181127181810598' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349636'
                WHERE ordernumber = 'P421127181910476' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349638'
                WHERE ordernumber = 'P181127182027320' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349639'
                WHERE ordernumber = 'P181127182343937' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276190'
                WHERE ordernumber = 'P201127182436915' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '98721'
                WHERE ordernumber = 'P191127182446486' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349641'
                WHERE ordernumber = 'P181127182852193' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349643'
                WHERE ordernumber = 'P191127183836687' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349642'
                WHERE ordernumber = 'P201127183933851' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349645'
                WHERE ordernumber = 'P191127184308785' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '345600'
                WHERE ordernumber = 'P191127184358725' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349647'
                WHERE ordernumber = 'P191127184657232' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '227749'
                WHERE ordernumber = 'P201127184855812' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124068'
                WHERE ordernumber = 'P191127184914141' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '214728'
                WHERE ordernumber = 'P191127185459155' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '228942'
                WHERE ordernumber = 'P191127185702115' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349649'
                WHERE ordernumber = 'P201127185738882' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '348458'
                WHERE ordernumber = 'P421127185839666' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305740'
                WHERE ordernumber = 'P201127190251113' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '141010'
                WHERE ordernumber = 'P201127190449750' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '343608'
                WHERE ordernumber = 'P201127190653943' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '262228'
                WHERE ordernumber = 'P201127190758781' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '291734'
                WHERE ordernumber = 'P201127191844886' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '234333'
                WHERE ordernumber = 'P191127191957340' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349658'
                WHERE ordernumber = 'P201127193422341' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '230264'
                WHERE ordernumber = 'P191127193458343' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349660'
                WHERE ordernumber = 'P201127193715579' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '319273'
                WHERE ordernumber = 'P421127193743480' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349661'
                WHERE ordernumber = 'P201127193829367' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '99037'
                WHERE ordernumber = 'P191127194248402' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349663'
                WHERE ordernumber = 'P191127194832251' 
            
2023-11-28 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '349664'
                WHERE ordernumber = 'P191127195137647'