2024-10-29 01:00:01 -- 將會員中心id寫入data-lake
2024-10-29 01:00:01 -- 
            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-10-28%';
        
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '304155'
                WHERE ordernumber = 'P631028105137860' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428000'
                WHERE ordernumber = 'P201028110058619' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '300227'
                WHERE ordernumber = 'P191028110251119' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '249481'
                WHERE ordernumber = 'P201028111246524' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '101358'
                WHERE ordernumber = 'P421028111507812' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428004'
                WHERE ordernumber = 'P181028111713160' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '73683'
                WHERE ordernumber = 'P181028111834877' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428001'
                WHERE ordernumber = 'P421028111918670' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110695'
                WHERE ordernumber = 'P181028112242901' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287386'
                WHERE ordernumber = 'P181028112841467' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428006'
                WHERE ordernumber = 'P421028113643553' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '339238'
                WHERE ordernumber = 'P181028113937678' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '219407'
                WHERE ordernumber = 'P201028114209687' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428007'
                WHERE ordernumber = 'P631028114808680' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '113482'
                WHERE ordernumber = 'P181028114946507' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428008'
                WHERE ordernumber = 'P201028115451699' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '425855'
                WHERE ordernumber = 'P181028115526864' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '100438'
                WHERE ordernumber = 'P201028120157891' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '345773'
                WHERE ordernumber = 'P181028122015520' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '358094'
                WHERE ordernumber = 'P201028122112648' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '326727'
                WHERE ordernumber = 'P421028123033384' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428010'
                WHERE ordernumber = 'P201028123440145' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '274812'
                WHERE ordernumber = 'P181028123655279' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273696'
                WHERE ordernumber = 'P201028123759673' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '592'
                WHERE ordernumber = 'P181028124056296' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428013'
                WHERE ordernumber = 'P181028124727465' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '416401'
                WHERE ordernumber = 'P181028125155232' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428014'
                WHERE ordernumber = 'P181028125437688' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '352576'
                WHERE ordernumber = 'P181028130159205' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428015'
                WHERE ordernumber = 'P181028130428340' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '166122'
                WHERE ordernumber = 'P181028131601592' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '411522'
                WHERE ordernumber = 'P181028131750655' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428016'
                WHERE ordernumber = 'P181028132630492' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '110514'
                WHERE ordernumber = 'P711028132743667' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '338446'
                WHERE ordernumber = 'P181028132942638' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '137593'
                WHERE ordernumber = 'P181028133141315' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428017'
                WHERE ordernumber = 'P631028133213800' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275242'
                WHERE ordernumber = 'P631028133301327' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428018'
                WHERE ordernumber = 'P181028133303382' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '395651'
                WHERE ordernumber = 'P201028133722627' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '247930'
                WHERE ordernumber = 'P181028133821208' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428019'
                WHERE ordernumber = 'P201028133949219' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '403755'
                WHERE ordernumber = 'P201028134505488' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428021'
                WHERE ordernumber = 'P731028134709666' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96384'
                WHERE ordernumber = 'P201028135813991' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428024'
                WHERE ordernumber = 'P421028140242151' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '163342'
                WHERE ordernumber = 'P771028141922486' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428027'
                WHERE ordernumber = 'P181028142134574' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427747'
                WHERE ordernumber = 'P201028142157989' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428032'
                WHERE ordernumber = 'P421028142952605' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '324153'
                WHERE ordernumber = 'P191028144026792' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428031'
                WHERE ordernumber = 'P731028144056570' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428035'
                WHERE ordernumber = 'P201028145154547' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428035'
                WHERE ordernumber = 'P201028145646986' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '406820'
                WHERE ordernumber = 'P771028145902336' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428036'
                WHERE ordernumber = 'P181028150143379' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '424027'
                WHERE ordernumber = 'P181028150254212' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428037'
                WHERE ordernumber = 'P201028150437739' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '102047'
                WHERE ordernumber = 'P201028150559858' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '206570'
                WHERE ordernumber = 'P181028151027383' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '287298'
                WHERE ordernumber = 'P201028151039393' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428041'
                WHERE ordernumber = 'P771028151444363' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428041'
                WHERE ordernumber = 'P771028151755911' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428042'
                WHERE ordernumber = 'P421028152106540' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428043'
                WHERE ordernumber = 'P421028152156420' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428047'
                WHERE ordernumber = 'P201028152701359' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '385996'
                WHERE ordernumber = 'P201028153119966' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428045'
                WHERE ordernumber = 'P181028153852807' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428049'
                WHERE ordernumber = 'P711028153956152' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428052'
                WHERE ordernumber = 'P201028154212694' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '93317'
                WHERE ordernumber = 'P181028154433950' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428045'
                WHERE ordernumber = 'P181028154515981' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '310632'
                WHERE ordernumber = 'P181028154957656' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427097'
                WHERE ordernumber = 'P201028155533526' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428055'
                WHERE ordernumber = 'P201028155741831' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '273671'
                WHERE ordernumber = 'P181028155744847' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428056'
                WHERE ordernumber = 'P771028160306957' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423701'
                WHERE ordernumber = 'P421028160640707' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428057'
                WHERE ordernumber = 'P421028160720869' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '423701'
                WHERE ordernumber = 'P421028160810367' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '212111'
                WHERE ordernumber = 'P181028161230898' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428059'
                WHERE ordernumber = 'P421028161430413' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '404322'
                WHERE ordernumber = 'P421028161816129' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428060'
                WHERE ordernumber = 'P421028161917182' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428062'
                WHERE ordernumber = 'P421028162144224' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '95730'
                WHERE ordernumber = 'P771028162307948' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '427730'
                WHERE ordernumber = 'P771028162549788' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '329832'
                WHERE ordernumber = 'P421028162621722' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '230115'
                WHERE ordernumber = 'P181028162828343' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '64196'
                WHERE ordernumber = 'P181028163157210' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428064'
                WHERE ordernumber = 'P181028163257337' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328429'
                WHERE ordernumber = 'P201028163608704' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '359293'
                WHERE ordernumber = 'P771028163840807' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '357309'
                WHERE ordernumber = 'P421028164125689' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428065'
                WHERE ordernumber = 'P181028164301452' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '328429'
                WHERE ordernumber = 'P201028164326591' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '378221'
                WHERE ordernumber = 'P421028164532862' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428066'
                WHERE ordernumber = 'P201028164725253' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '380016'
                WHERE ordernumber = 'P201028164836324' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '261899'
                WHERE ordernumber = 'P181028165133483' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428067'
                WHERE ordernumber = 'P421028165308586' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '428068'
                WHERE ordernumber = 'P421028165434927' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '275164'
                WHERE ordernumber = 'P201028165519417' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '242234'
                WHERE ordernumber = 'P201028170814114' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '96748'
                WHERE ordernumber = 'P201028170903777' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '417284'
                WHERE ordernumber = 'P711028171101789' 
            
2024-10-29 01:00:02 -- 
                UPDATE `omo_order_list` SET userId = '422540'
                WHERE ordernumber = 'P771028174111751' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428072'
                WHERE ordernumber = 'P181028174226699' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '372907'
                WHERE ordernumber = 'P631028175100283' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '130397'
                WHERE ordernumber = 'P711028175227272' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '167129'
                WHERE ordernumber = 'P181028175259710' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '426695'
                WHERE ordernumber = 'P771028175343181' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '427021'
                WHERE ordernumber = 'P201028175648539' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '359122'
                WHERE ordernumber = 'P181028180025675' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428074'
                WHERE ordernumber = 'P181028180147969' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '367339'
                WHERE ordernumber = 'P421028180238943' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428075'
                WHERE ordernumber = 'P181028180423909' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '300239'
                WHERE ordernumber = 'P421028180446418' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '293456'
                WHERE ordernumber = 'P201028180555664' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428076'
                WHERE ordernumber = 'P421028180953462' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428077'
                WHERE ordernumber = 'P201028181144344' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '218548'
                WHERE ordernumber = 'P201028181325580' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '375452'
                WHERE ordernumber = 'P421028182726965' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428078'
                WHERE ordernumber = 'P201028184143921' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428080'
                WHERE ordernumber = 'P771028184932140' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '395401'
                WHERE ordernumber = 'P421028185342783' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428081'
                WHERE ordernumber = 'P771028185653265' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428083'
                WHERE ordernumber = 'P201028190714542' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428082'
                WHERE ordernumber = 'P771028190801581' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392727'
                WHERE ordernumber = 'P711028191119635' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '392410'
                WHERE ordernumber = 'P771028191816729' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428086'
                WHERE ordernumber = 'P771028192358118' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428087'
                WHERE ordernumber = 'P711028192845256' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '172954'
                WHERE ordernumber = 'P711028195139806' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '136526'
                WHERE ordernumber = 'P771028195300347' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428089'
                WHERE ordernumber = 'P771028195506958' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428079'
                WHERE ordernumber = 'P711028195541902' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '103010'
                WHERE ordernumber = 'P631028195852567' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '289391'
                WHERE ordernumber = 'P191028195933594' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '15226'
                WHERE ordernumber = 'P771028200107531' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428091'
                WHERE ordernumber = 'P771028201234847' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291258'
                WHERE ordernumber = 'P711028201930384' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291258'
                WHERE ordernumber = 'P711028202340576' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '291258'
                WHERE ordernumber = 'P711028202711637' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '428092'
                WHERE ordernumber = 'P631028205313670' 
            
2024-10-29 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '220197'
                WHERE ordernumber = 'P771028212354990'