2024-11-05 01:00:02 -- 將會員中心id寫入data-lake
2024-11-05 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-04%';
        
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428904'
                WHERE ordernumber = 'P421104110619251' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261980'
                WHERE ordernumber = 'P201104110703967' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428894'
                WHERE ordernumber = 'P191104111741745' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '39181'
                WHERE ordernumber = 'P181104112222874' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345365'
                WHERE ordernumber = 'P201104112619405' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428906'
                WHERE ordernumber = 'P421104112748889' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201104113054658' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '341339'
                WHERE ordernumber = 'P201104113520350' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427011'
                WHERE ordernumber = 'P201104113616253' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '140600'
                WHERE ordernumber = 'P181104113618240' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428908'
                WHERE ordernumber = 'P421104113842294' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '28872'
                WHERE ordernumber = 'P421104114325459' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '299811'
                WHERE ordernumber = 'P181104114756322' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '251558'
                WHERE ordernumber = 'P191104115308816' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P181104115641434' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428909'
                WHERE ordernumber = 'P421104120425800' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '231678'
                WHERE ordernumber = 'P191104120537247' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274566'
                WHERE ordernumber = 'P201104120914680' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '211038'
                WHERE ordernumber = 'P201104121006120' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428911'
                WHERE ordernumber = 'P181104121141910' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428913'
                WHERE ordernumber = 'P181104122459246' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428915'
                WHERE ordernumber = 'P421104122615449' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428914'
                WHERE ordernumber = 'P181104122636168' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '161316'
                WHERE ordernumber = 'P201104123430960' 
            
2024-11-05 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '277878'
                WHERE ordernumber = 'P181104123445563' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '161316'
                WHERE ordernumber = 'P201104123641185' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181104123906316' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428917'
                WHERE ordernumber = 'P201104124021914' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428919'
                WHERE ordernumber = 'P201104124432655' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385618'
                WHERE ordernumber = 'P421104125144684' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379470'
                WHERE ordernumber = 'P201104125255299' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '123569'
                WHERE ordernumber = 'P201104125648825' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428921'
                WHERE ordernumber = 'P421104130032430' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112637'
                WHERE ordernumber = 'P181104130409666' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '112637'
                WHERE ordernumber = 'P181104130601299' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428922'
                WHERE ordernumber = 'P181104130811204' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '311238'
                WHERE ordernumber = 'P181104131323303' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293988'
                WHERE ordernumber = 'P771104131539194' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282230'
                WHERE ordernumber = 'P201104132250222' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428924'
                WHERE ordernumber = 'P631104132330167' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '142209'
                WHERE ordernumber = 'P201104132543189' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428925'
                WHERE ordernumber = 'P201104132700436' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224732'
                WHERE ordernumber = 'P771104132948964' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428926'
                WHERE ordernumber = 'P421104133455652' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428173'
                WHERE ordernumber = 'P201104134038958' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '26344'
                WHERE ordernumber = 'P181104134141795' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428928'
                WHERE ordernumber = 'P591104135113365' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428910'
                WHERE ordernumber = 'P631104140125958' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426669'
                WHERE ordernumber = 'P421104141439447' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '313572'
                WHERE ordernumber = 'P201104142840225' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428932'
                WHERE ordernumber = 'P421104143042911' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428933'
                WHERE ordernumber = 'P201104143050980' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428009'
                WHERE ordernumber = 'P181104143140430' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428930'
                WHERE ordernumber = 'P181104143236221' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '241462'
                WHERE ordernumber = 'P181104143349407' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427310'
                WHERE ordernumber = 'P201104143707686' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '417811'
                WHERE ordernumber = 'P421104145149975' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '383468'
                WHERE ordernumber = 'P201104145242653' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428577'
                WHERE ordernumber = 'P421104145515282' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428936'
                WHERE ordernumber = 'P421104150600125' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426166'
                WHERE ordernumber = 'P181104150656818' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428937'
                WHERE ordernumber = 'P181104150929555' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428938'
                WHERE ordernumber = 'P191104151613261' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '377634'
                WHERE ordernumber = 'P191104152646532' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428940'
                WHERE ordernumber = 'P181104153857707' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428941'
                WHERE ordernumber = 'P181104155343752' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '403180'
                WHERE ordernumber = 'P201104155537887' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428942'
                WHERE ordernumber = 'P421104155922443' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428599'
                WHERE ordernumber = 'P201104155958171' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428943'
                WHERE ordernumber = 'P421104160159166' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '245453'
                WHERE ordernumber = 'P421104160757840' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428944'
                WHERE ordernumber = 'P181104162115282' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '409220'
                WHERE ordernumber = 'P201104162116382' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '358895'
                WHERE ordernumber = 'P201104162634820' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '413108'
                WHERE ordernumber = 'P201104163057414' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '374695'
                WHERE ordernumber = 'P181104163346938' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '224548'
                WHERE ordernumber = 'P201104163709157' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426487'
                WHERE ordernumber = 'P201104163848157' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428946'
                WHERE ordernumber = 'P181104164039348' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428945'
                WHERE ordernumber = 'P181104164229153' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428948'
                WHERE ordernumber = 'P421104164355952' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386314'
                WHERE ordernumber = 'P201104164452369' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428947'
                WHERE ordernumber = 'P181104164642762' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '274874'
                WHERE ordernumber = 'P181104165444406' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '162606'
                WHERE ordernumber = 'P181104165613991' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428949'
                WHERE ordernumber = 'P201104170221445' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '314886'
                WHERE ordernumber = 'P181104171315127' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426084'
                WHERE ordernumber = 'P181104172030209' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428952'
                WHERE ordernumber = 'P201104172128878' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '376066'
                WHERE ordernumber = 'P181104172251977' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '119608'
                WHERE ordernumber = 'P181104172355441' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428951'
                WHERE ordernumber = 'P181104173112791' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '154784'
                WHERE ordernumber = 'P181104173821647' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '247243'
                WHERE ordernumber = 'P181104174141873' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '164917'
                WHERE ordernumber = 'P181104174755155' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '342189'
                WHERE ordernumber = 'P181104175125406' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428956'
                WHERE ordernumber = 'P181104175343425' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '420658'
                WHERE ordernumber = 'P421104175350408' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '369737'
                WHERE ordernumber = 'P191104175517951' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '353666'
                WHERE ordernumber = 'P421104180124571' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '381339'
                WHERE ordernumber = 'P421104180704538' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220798'
                WHERE ordernumber = 'P201104181431353' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428958'
                WHERE ordernumber = 'P181104182047659' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '382813'
                WHERE ordernumber = 'P201104182624476' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '156496'
                WHERE ordernumber = 'P201104183027235' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '93645'
                WHERE ordernumber = 'P181104183313900' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '253624'
                WHERE ordernumber = 'P201104183410298' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428959'
                WHERE ordernumber = 'P181104184054766' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428961'
                WHERE ordernumber = 'P191104184352487' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428963'
                WHERE ordernumber = 'P191104185117900' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428964'
                WHERE ordernumber = 'P421104185306557' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428965'
                WHERE ordernumber = 'P191104190148862' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '81126'
                WHERE ordernumber = 'P201104190633953' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '422304'
                WHERE ordernumber = 'P191104191051878' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P191104191438425' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '385092'
                WHERE ordernumber = 'P191104191456407' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428967'
                WHERE ordernumber = 'P191104191700845' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '233156'
                WHERE ordernumber = 'P631104191720599' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '386600'
                WHERE ordernumber = 'P191104191917397' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99647'
                WHERE ordernumber = 'P191104192534417' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '356006'
                WHERE ordernumber = 'P191104192800849' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428969'
                WHERE ordernumber = 'P191104192904854' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428443'
                WHERE ordernumber = 'P191104193810317' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428970'
                WHERE ordernumber = 'P771104193817561' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428971'
                WHERE ordernumber = 'P201104193915648' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428968'
                WHERE ordernumber = 'P191104194126823' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428972'
                WHERE ordernumber = 'P201104194753979' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '91022'
                WHERE ordernumber = 'P201104195654378' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '100861'
                WHERE ordernumber = 'P201104195822551' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428975'
                WHERE ordernumber = 'P591104202958628' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428976'
                WHERE ordernumber = 'P771104203629845' 
            
2024-11-05 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '316376'
                WHERE ordernumber = 'P771104211436870'