2024-04-17 01:00:02 -- 將會員中心id寫入data-lake 2024-04-17 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-04-16%'; 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '343521' WHERE ordernumber = 'P630416105251369' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '300706' WHERE ordernumber = 'P200416110439161' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '339620' WHERE ordernumber = 'P420416110528553' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385690' WHERE ordernumber = 'P190416110547285' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '338590' WHERE ordernumber = 'P420416110731198' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '306337' WHERE ordernumber = 'P190416110804459' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385681' WHERE ordernumber = 'P180416110901265' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '153743' WHERE ordernumber = 'P200416110916962' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '293293' WHERE ordernumber = 'P180416111140574' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '347462' WHERE ordernumber = 'P190416111208301' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385691' WHERE ordernumber = 'P180416112440463' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '96884' WHERE ordernumber = 'P200416113437214' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385692' WHERE ordernumber = 'P420416113603676' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385693' WHERE ordernumber = 'P420416114101474' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '302357' WHERE ordernumber = 'P420416114402899' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385695' WHERE ordernumber = 'P630416114809739' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385696' WHERE ordernumber = 'P630416114939700' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385697' WHERE ordernumber = 'P200416115812366' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '167252' WHERE ordernumber = 'P190416120045641' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385698' WHERE ordernumber = 'P200416120122828' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '104252' WHERE ordernumber = 'P420416120418795' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385700' WHERE ordernumber = 'P190416120830417' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '329135' WHERE ordernumber = 'P190416121437536' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '298067' WHERE ordernumber = 'P190416121938277' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '54623' WHERE ordernumber = 'P200416122025403' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '384036' WHERE ordernumber = 'P190416122425876' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '56458' WHERE ordernumber = 'P200416122537836' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385701' WHERE ordernumber = 'P190416122718621' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385702' WHERE ordernumber = 'P190416123724282' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '310087' WHERE ordernumber = 'P420416124822820' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '245336' WHERE ordernumber = 'P190416125106830' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385703' WHERE ordernumber = 'P190416125457729' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385704' WHERE ordernumber = 'P190416125632930' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385705' WHERE ordernumber = 'P420416130303586' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385706' WHERE ordernumber = 'P420416130357125' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385707' WHERE ordernumber = 'P180416131310200' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '97403' WHERE ordernumber = 'P200416132242793' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385709' WHERE ordernumber = 'P180416132850756' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385710' WHERE ordernumber = 'P200416132914424' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '167318' WHERE ordernumber = 'P200416133213580' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '287116' WHERE ordernumber = 'P200416133316353' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '265910' WHERE ordernumber = 'P200416133609456' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '84930' WHERE ordernumber = 'P420416133941353' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '378465' WHERE ordernumber = 'P200416134443152' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '208833' WHERE ordernumber = 'P180416134903170' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '59575' WHERE ordernumber = 'P200416135830789' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '94987' WHERE ordernumber = 'P180416135856220' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '101722' WHERE ordernumber = 'P180416141923901' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '312031' WHERE ordernumber = 'P420416142250431' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '163085' WHERE ordernumber = 'P420416142929137' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '382414' WHERE ordernumber = 'P180416143528163' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '98582' WHERE ordernumber = 'P200416143616466' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385715' WHERE ordernumber = 'P190416144950985' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '105793' WHERE ordernumber = 'P180416145054809' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '323618' WHERE ordernumber = 'P180416145245466' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385716' WHERE ordernumber = 'P630416150411499' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385717' WHERE ordernumber = 'P180416150544827' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '380173' WHERE ordernumber = 'P420416150605350' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '233900' WHERE ordernumber = 'P420416150724561' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '102085' WHERE ordernumber = 'P180416151316158' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '383315' WHERE ordernumber = 'P200416151411753' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385719' WHERE ordernumber = 'P180416151436690' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385721' WHERE ordernumber = 'P180416151621439' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '271189' WHERE ordernumber = 'P180416152113965' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '265161' WHERE ordernumber = 'P180416152214210' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '271189' WHERE ordernumber = 'P190416152228702' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '301524' WHERE ordernumber = 'P420416152328608' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '271189' WHERE ordernumber = 'P190416152423982' 2024-04-17 01:00:03 -- UPDATE `omo_order_list` SET userId = '385723' WHERE ordernumber = 'P180416152658412' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385724' WHERE ordernumber = 'P420416152805316' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '220938' WHERE ordernumber = 'P200416153202868' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385719' WHERE ordernumber = 'P180416153215176' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '343888' WHERE ordernumber = 'P190416153228566' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '97110' WHERE ordernumber = 'P630416154726752' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385727' WHERE ordernumber = 'P190416154842590' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '378376' WHERE ordernumber = 'P420416154939326' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385727' WHERE ordernumber = 'P190416154950865' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385730' WHERE ordernumber = 'P190416155057652' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '349767' WHERE ordernumber = 'P420416155125649' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385729' WHERE ordernumber = 'P180416155127248' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '111126' WHERE ordernumber = 'P190416155145941' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385731' WHERE ordernumber = 'P630416155237984' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '352030' WHERE ordernumber = 'P190416155431203' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '384779' WHERE ordernumber = 'P630416155839121' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '291723' WHERE ordernumber = 'P630416155849710' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '311777' WHERE ordernumber = 'P190416155901638' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385732' WHERE ordernumber = 'P420416160053500' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385733' WHERE ordernumber = 'P190416160430646' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385734' WHERE ordernumber = 'P420416161017314' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '290301' WHERE ordernumber = 'P200416161533846' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385736' WHERE ordernumber = 'P180416161636269' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '162647' WHERE ordernumber = 'P180416161727855' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385680' WHERE ordernumber = 'P420416161754605' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385680' WHERE ordernumber = 'P420416161809493' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '53712' WHERE ordernumber = 'P180416161854454' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385737' WHERE ordernumber = 'P180416162059365' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '378491' WHERE ordernumber = 'P420416162716834' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '100745' WHERE ordernumber = 'P180416162824666' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385738' WHERE ordernumber = 'P200416163304739' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385735' WHERE ordernumber = 'P180416163849192' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '366089' WHERE ordernumber = 'P630416164332994' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '261174' WHERE ordernumber = 'P200416165418906' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '286027' WHERE ordernumber = 'P200416165545131' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385740' WHERE ordernumber = 'P180416165805677' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385741' WHERE ordernumber = 'P420416165849716' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '43247' WHERE ordernumber = 'P420416165945992' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '261174' WHERE ordernumber = 'P200416165957498' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385742' WHERE ordernumber = 'P180416170422365' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385743' WHERE ordernumber = 'P200416170517492' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385744' WHERE ordernumber = 'P630416170608408' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '101456' WHERE ordernumber = 'P420416170640774' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '293485' WHERE ordernumber = 'P200416170735319' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '183915' WHERE ordernumber = 'P180416170947948' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385745' WHERE ordernumber = 'P180416171119475' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385746' WHERE ordernumber = 'P180416171303672' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385748' WHERE ordernumber = 'P420416172317964' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '238188' WHERE ordernumber = 'P200416172749880' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385749' WHERE ordernumber = 'P190416173058249' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '248954' WHERE ordernumber = 'P180416173150902' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '377552' WHERE ordernumber = 'P420416174542731' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385751' WHERE ordernumber = 'P180416174822544' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385752' WHERE ordernumber = 'P180416174955931' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '117899' WHERE ordernumber = 'P180416175643508' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '99647' WHERE ordernumber = 'P180416175856145' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385754' WHERE ordernumber = 'P190416180305351' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385755' WHERE ordernumber = 'P420416181646448' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '346725' WHERE ordernumber = 'P190416182310670' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385757' WHERE ordernumber = 'P630416182421846' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '218840' WHERE ordernumber = 'P190416182711999' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385758' WHERE ordernumber = 'P420416182735431' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385759' WHERE ordernumber = 'P420416182852559' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '275752' WHERE ordernumber = 'P190416182950229' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '363326' WHERE ordernumber = 'P200416183320851' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '368818' WHERE ordernumber = 'P420416183328355' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '296980' WHERE ordernumber = 'P420416183922450' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385761' WHERE ordernumber = 'P420416184345662' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '105423' WHERE ordernumber = 'P190416184815126' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '38099' WHERE ordernumber = 'P420416185701609' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385762' WHERE ordernumber = 'P420416190411928' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385763' WHERE ordernumber = 'P190416190509266' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385764' WHERE ordernumber = 'P420416190654599' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385765' WHERE ordernumber = 'P630416191313934' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385766' WHERE ordernumber = 'P630416191438401' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385767' WHERE ordernumber = 'P190416191450642' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385768' WHERE ordernumber = 'P200416191754163' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '275210' WHERE ordernumber = 'P200416192315155' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '318416' WHERE ordernumber = 'P190416192800397' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385770' WHERE ordernumber = 'P420416193122228' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '380263' WHERE ordernumber = 'P420416193253141' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385771' WHERE ordernumber = 'P200416193325973' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '142462' WHERE ordernumber = 'P190416193454341' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '380683' WHERE ordernumber = 'P630416193625803' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '206345' WHERE ordernumber = 'P190416193654829' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '81933' WHERE ordernumber = 'P200416194010831' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385677' WHERE ordernumber = 'P190416194038180' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '380339' WHERE ordernumber = 'P190416194248567' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '377502' WHERE ordernumber = 'P590416201703690' 2024-04-17 01:00:04 -- UPDATE `omo_order_list` SET userId = '385777' WHERE ordernumber = 'P630416210143339'