2024-07-17 01:00:03 -- 將會員中心id寫入data-lake
2024-07-17 01:00:03 -- 
            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-07-16%';
        
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '99549'
                WHERE ordernumber = 'P200716110346694' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '240859'
                WHERE ordernumber = 'P180716110533403' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401526'
                WHERE ordernumber = 'P420716110650944' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '329883'
                WHERE ordernumber = 'P180716111622648' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401527'
                WHERE ordernumber = 'P200716111703687' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '97842'
                WHERE ordernumber = 'P180716111705858' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '264650'
                WHERE ordernumber = 'P180716111925973' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '217062'
                WHERE ordernumber = 'P180716112043661' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401456'
                WHERE ordernumber = 'P180716112300657' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401530'
                WHERE ordernumber = 'P420716112447138' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '379682'
                WHERE ordernumber = 'P590716112723282' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '282932'
                WHERE ordernumber = 'P200716113044255' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '230656'
                WHERE ordernumber = 'P180716113119285' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401531'
                WHERE ordernumber = 'P200716113727421' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '239298'
                WHERE ordernumber = 'P180716113809289' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401532'
                WHERE ordernumber = 'P420716113841855' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '113466'
                WHERE ordernumber = 'P200716113907408' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '120182'
                WHERE ordernumber = 'P180716113955664' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '223290'
                WHERE ordernumber = 'P420716114051940' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401535'
                WHERE ordernumber = 'P630716115359368' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401538'
                WHERE ordernumber = 'P180716120139682' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401538'
                WHERE ordernumber = 'P180716120250670' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401537'
                WHERE ordernumber = 'P190716120656710' 
            
2024-07-17 01:00:03 -- 
                UPDATE `omo_order_list` SET userId = '401537'
                WHERE ordernumber = 'P190716120706390' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401536'
                WHERE ordernumber = 'P190716120712932' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390391'
                WHERE ordernumber = 'P630716121658792' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401541'
                WHERE ordernumber = 'P200716122433706' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401543'
                WHERE ordernumber = 'P200716122653123' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401544'
                WHERE ordernumber = 'P200716122828398' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396563'
                WHERE ordernumber = 'P180716123212185' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396573'
                WHERE ordernumber = 'P200716123338520' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392009'
                WHERE ordernumber = 'P180716123901219' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401547'
                WHERE ordernumber = 'P420716123914643' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '102055'
                WHERE ordernumber = 'P200716124931131' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '373857'
                WHERE ordernumber = 'P200716125322384' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '245511'
                WHERE ordernumber = 'P200716130343368' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401549'
                WHERE ordernumber = 'P180716130911141' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401550'
                WHERE ordernumber = 'P420716131749626' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '237954'
                WHERE ordernumber = 'P180716132049685' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '297135'
                WHERE ordernumber = 'P420716132454753' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '248574'
                WHERE ordernumber = 'P200716132747737' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401553'
                WHERE ordernumber = 'P630716133228164' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401556'
                WHERE ordernumber = 'P180716133257215' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401557'
                WHERE ordernumber = 'P180716133947237' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '302040'
                WHERE ordernumber = 'P180716134456370' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401557'
                WHERE ordernumber = 'P180716134621387' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401559'
                WHERE ordernumber = 'P180716134957500' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400599'
                WHERE ordernumber = 'P180716135102247' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401561'
                WHERE ordernumber = 'P180716135710550' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '390286'
                WHERE ordernumber = 'P630716140111180' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '66007'
                WHERE ordernumber = 'P180716140401941' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401564'
                WHERE ordernumber = 'P200716140555324' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '270609'
                WHERE ordernumber = 'P190716140839276' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '400133'
                WHERE ordernumber = 'P200716140844661' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '339680'
                WHERE ordernumber = 'P420716140928241' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401564'
                WHERE ordernumber = 'P200716141022488' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401565'
                WHERE ordernumber = 'P200716141257365' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401563'
                WHERE ordernumber = 'P190716141354926' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386603'
                WHERE ordernumber = 'P200716141853938' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '386603'
                WHERE ordernumber = 'P200716141938760' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401569'
                WHERE ordernumber = 'P180716142244549' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '357868'
                WHERE ordernumber = 'P180716142450352' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401570'
                WHERE ordernumber = 'P200716142512310' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401571'
                WHERE ordernumber = 'P180716142646881' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401572'
                WHERE ordernumber = 'P180716142827929' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401573'
                WHERE ordernumber = 'P180716143016390' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '142082'
                WHERE ordernumber = 'P200716143640930' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401577'
                WHERE ordernumber = 'P190716144545414' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '220482'
                WHERE ordernumber = 'P180716145000717' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '276826'
                WHERE ordernumber = 'P180716145325786' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401579'
                WHERE ordernumber = 'P200716145909401' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '380483'
                WHERE ordernumber = 'P420716152609887' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '371881'
                WHERE ordernumber = 'P180716152738483' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368838'
                WHERE ordernumber = 'P420716153016284' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '382354'
                WHERE ordernumber = 'P420716153141134' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '368331'
                WHERE ordernumber = 'P200716153547347' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '305270'
                WHERE ordernumber = 'P180716154519462' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '392812'
                WHERE ordernumber = 'P200716154743745' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '358258'
                WHERE ordernumber = 'P200716154855646' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '336721'
                WHERE ordernumber = 'P180716155558307' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '342834'
                WHERE ordernumber = 'P420716160300235' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '397603'
                WHERE ordernumber = 'P630716160912343' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401588'
                WHERE ordernumber = 'P200716161744155' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '88439'
                WHERE ordernumber = 'P180716163146766' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401590'
                WHERE ordernumber = 'P190716165004389' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401591'
                WHERE ordernumber = 'P180716165236197' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124407'
                WHERE ordernumber = 'P180716165416202' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401592'
                WHERE ordernumber = 'P200716165627922' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401593'
                WHERE ordernumber = 'P180716170155523' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401594'
                WHERE ordernumber = 'P200716170622510' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '132970'
                WHERE ordernumber = 'P180716170742627' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '289710'
                WHERE ordernumber = 'P200716170825513' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '393594'
                WHERE ordernumber = 'P200716171431365' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401597'
                WHERE ordernumber = 'P420716171441136' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401599'
                WHERE ordernumber = 'P420716171824546' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '271863'
                WHERE ordernumber = 'P420716172001359' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '190025'
                WHERE ordernumber = 'P180716172802220' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '198151'
                WHERE ordernumber = 'P200716173054605' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401602'
                WHERE ordernumber = 'P200716173142546' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401603'
                WHERE ordernumber = 'P200716173349279' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401604'
                WHERE ordernumber = 'P200716174134792' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '149491'
                WHERE ordernumber = 'P200716174543306' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '401605'
                WHERE ordernumber = 'P200716175312529' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '396552'
                WHERE ordernumber = 'P420716175339622' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '240937'
                WHERE ordernumber = 'P190716181037670' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '167164'
                WHERE ordernumber = 'P200716181100418' 
            
2024-07-17 01:00:04 -- 
                UPDATE `omo_order_list` SET userId = '124717'
                WHERE ordernumber = 'P190716181258365' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401607'
                WHERE ordernumber = 'P200716181418172' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401606'
                WHERE ordernumber = 'P180716181432963' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401608'
                WHERE ordernumber = 'P420716181601157' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401609'
                WHERE ordernumber = 'P200716181847776' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '72395'
                WHERE ordernumber = 'P180716182206124' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401583'
                WHERE ordernumber = 'P200716183029468' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401493'
                WHERE ordernumber = 'P420716183202826' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401616'
                WHERE ordernumber = 'P200716183956175' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306392'
                WHERE ordernumber = 'P200716184224278' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401617'
                WHERE ordernumber = 'P200716184726871' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '355283'
                WHERE ordernumber = 'P630716184926546' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '306867'
                WHERE ordernumber = 'P200716185532660' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401618'
                WHERE ordernumber = 'P190716185555537' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401621'
                WHERE ordernumber = 'P190716190938412' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '386117'
                WHERE ordernumber = 'P200716192052670' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '235539'
                WHERE ordernumber = 'P190716192450393' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401622'
                WHERE ordernumber = 'P190716192618856' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401623'
                WHERE ordernumber = 'P200716192629162' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '399775'
                WHERE ordernumber = 'P200716194442803' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '99718'
                WHERE ordernumber = 'P200716195226312' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '401626'
                WHERE ordernumber = 'P200716195448972' 
            
2024-07-17 01:00:05 -- 
                UPDATE `omo_order_list` SET userId = '343746'
                WHERE ordernumber = 'P590716201053964'