2024-05-14 01:00:01 -- 將會員中心id寫入data-lake 2024-05-14 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-05-13%'; 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '229115' WHERE ordernumber = 'P180513110120159' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389779' WHERE ordernumber = 'P190513110401123' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '111805' WHERE ordernumber = 'P190513110519268' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389781' WHERE ordernumber = 'P180513110547226' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '161924' WHERE ordernumber = 'P200513110733733' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389782' WHERE ordernumber = 'P190513110735564' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389783' WHERE ordernumber = 'P790513111443461' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '244651' WHERE ordernumber = 'P190513111546409' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389775' WHERE ordernumber = 'P180513112415946' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389785' WHERE ordernumber = 'P180513112553786' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '311238' WHERE ordernumber = 'P180513112931155' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '137430' WHERE ordernumber = 'P200513113339385' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '137430' WHERE ordernumber = 'P200513113353314' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '384125' WHERE ordernumber = 'P420513113446910' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '289846' WHERE ordernumber = 'P200513114122722' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '228749' WHERE ordernumber = 'P190513114254965' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389788' WHERE ordernumber = 'P420513114354504' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '247665' WHERE ordernumber = 'P190513114711748' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '303263' WHERE ordernumber = 'P180513114831901' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '383652' WHERE ordernumber = 'P190513114917692' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389790' WHERE ordernumber = 'P180513115009972' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '387858' WHERE ordernumber = 'P200513115209435' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '289319' WHERE ordernumber = 'P420513115853246' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '242509' WHERE ordernumber = 'P180513120043634' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389791' WHERE ordernumber = 'P420513121439511' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '242026' WHERE ordernumber = 'P200513121543370' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '373709' WHERE ordernumber = 'P200513121617143' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '306059' WHERE ordernumber = 'P200513122212238' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389795' WHERE ordernumber = 'P180513122746206' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389796' WHERE ordernumber = 'P420513123024943' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389794' WHERE ordernumber = 'P420513123558822' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389797' WHERE ordernumber = 'P420513123849480' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '231406' WHERE ordernumber = 'P180513124236149' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389798' WHERE ordernumber = 'P630513124354287' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '387511' WHERE ordernumber = 'P420513124413773' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '354220' WHERE ordernumber = 'P180513124632476' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389799' WHERE ordernumber = 'P200513124822548' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389800' WHERE ordernumber = 'P200513124918394' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '245514' WHERE ordernumber = 'P200513125456328' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389802' WHERE ordernumber = 'P180513130638167' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '248675' WHERE ordernumber = 'P420513131039208' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389801' WHERE ordernumber = 'P200513131346817' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389804' WHERE ordernumber = 'P420513131509111' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389805' WHERE ordernumber = 'P180513132251711' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '302881' WHERE ordernumber = 'P200513132500412' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389806' WHERE ordernumber = 'P190513132745844' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '387520' WHERE ordernumber = 'P180513133422822' 2024-05-14 01:00:02 -- UPDATE `omo_order_list` SET userId = '389807' WHERE ordernumber = 'P420513133725548' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '286550' WHERE ordernumber = 'P180513135003405' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389809' WHERE ordernumber = 'P190513135124121' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389810' WHERE ordernumber = 'P180513135534152' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '376301' WHERE ordernumber = 'P200513135551113' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '351842' WHERE ordernumber = 'P200513140635325' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '247930' WHERE ordernumber = 'P180513140724232' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '86200' WHERE ordernumber = 'P180513141137660' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '320225' WHERE ordernumber = 'P180513141542247' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389811' WHERE ordernumber = 'P420513141543924' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389812' WHERE ordernumber = 'P180513142053467' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389256' WHERE ordernumber = 'P630513142712971' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389815' WHERE ordernumber = 'P200513142842612' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389814' WHERE ordernumber = 'P180513142923721' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '296858' WHERE ordernumber = 'P420513143123171' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '43704' WHERE ordernumber = 'P180513144422513' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '378451' WHERE ordernumber = 'P180513144900659' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389817' WHERE ordernumber = 'P630513145402583' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '305148' WHERE ordernumber = 'P200513150245402' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389819' WHERE ordernumber = 'P200513150248867' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '291211' WHERE ordernumber = 'P200513150303418' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '379752' WHERE ordernumber = 'P180513151230646' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '315335' WHERE ordernumber = 'P420513151240691' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '286332' WHERE ordernumber = 'P200513151500346' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '129091' WHERE ordernumber = 'P180513151531713' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '165024' WHERE ordernumber = 'P200513151650439' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '282532' WHERE ordernumber = 'P180513151744156' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '388897' WHERE ordernumber = 'P190513152233690' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '349574' WHERE ordernumber = 'P180513152241151' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '318228' WHERE ordernumber = 'P180513153343323' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389044' WHERE ordernumber = 'P180513154701155' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389044' WHERE ordernumber = 'P180513154955816' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '128554' WHERE ordernumber = 'P200513155856240' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389825' WHERE ordernumber = 'P180513155919383' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389824' WHERE ordernumber = 'P180513160216745' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389826' WHERE ordernumber = 'P200513160456533' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '386312' WHERE ordernumber = 'P200513161046404' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '388947' WHERE ordernumber = 'P630513161253992' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389830' WHERE ordernumber = 'P180513161316649' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389830' WHERE ordernumber = 'P180513161423516' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '208509' WHERE ordernumber = 'P180513162057696' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389833' WHERE ordernumber = 'P180513162318681' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '351381' WHERE ordernumber = 'P200513162349753' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '94949' WHERE ordernumber = 'P180513162409984' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389832' WHERE ordernumber = 'P630513162412855' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389834' WHERE ordernumber = 'P630513162609852' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '358895' WHERE ordernumber = 'P200513162623161' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '160936' WHERE ordernumber = 'P200513162751608' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '271320' WHERE ordernumber = 'P180513164239578' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '8776' WHERE ordernumber = 'P180513164807332' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '366205' WHERE ordernumber = 'P630513164823437' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389836' WHERE ordernumber = 'P420513165128306' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '358349' WHERE ordernumber = 'P200513165239575' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389840' WHERE ordernumber = 'P200513170339373' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '217198' WHERE ordernumber = 'P180513170851975' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '136379' WHERE ordernumber = 'P420513171032874' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '263416' WHERE ordernumber = 'P200513171133924' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '385350' WHERE ordernumber = 'P200513171500393' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389842' WHERE ordernumber = 'P420513172009726' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389844' WHERE ordernumber = 'P180513172134215' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389845' WHERE ordernumber = 'P790513172413356' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '342437' WHERE ordernumber = 'P180513172643454' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '102998' WHERE ordernumber = 'P180513172802135' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '304706' WHERE ordernumber = 'P180513173020795' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '265992' WHERE ordernumber = 'P200513173047396' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '388121' WHERE ordernumber = 'P180513173141977' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '384015' WHERE ordernumber = 'P420513173804362' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '291072' WHERE ordernumber = 'P180513174011160' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389849' WHERE ordernumber = 'P180513174159709' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '363474' WHERE ordernumber = 'P420513174202768' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389848' WHERE ordernumber = 'P190513174225746' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389850' WHERE ordernumber = 'P200513174228176' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389851' WHERE ordernumber = 'P420513175312670' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389853' WHERE ordernumber = 'P200513175630885' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '98317' WHERE ordernumber = 'P180513180320484' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389843' WHERE ordernumber = 'P200513180411897' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389855' WHERE ordernumber = 'P200513180717640' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389856' WHERE ordernumber = 'P420513180933797' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '278186' WHERE ordernumber = 'P180513181915357' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '355096' WHERE ordernumber = 'P200513182137504' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '99647' WHERE ordernumber = 'P180513182447727' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389858' WHERE ordernumber = 'P420513182840288' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '355096' WHERE ordernumber = 'P200513182934704' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '169372' WHERE ordernumber = 'P180513183556917' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '161831' WHERE ordernumber = 'P630513183805437' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '278019' WHERE ordernumber = 'P180513183842781' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389860' WHERE ordernumber = 'P200513184203313' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '306969' WHERE ordernumber = 'P180513184348970' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389861' WHERE ordernumber = 'P630513190329655' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389862' WHERE ordernumber = 'P190513190549189' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389863' WHERE ordernumber = 'P200513190941974' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389864' WHERE ordernumber = 'P420513191113700' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389866' WHERE ordernumber = 'P190513191909912' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '354500' WHERE ordernumber = 'P190513192212899' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389867' WHERE ordernumber = 'P200513192302510' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '337561' WHERE ordernumber = 'P190513192315519' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '342558' WHERE ordernumber = 'P190513192611355' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '336194' WHERE ordernumber = 'P190513192724402' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389869' WHERE ordernumber = 'P200513192954971' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389870' WHERE ordernumber = 'P190513193248992' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389871' WHERE ordernumber = 'P190513193709777' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389872' WHERE ordernumber = 'P420513193835666' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389873' WHERE ordernumber = 'P190513194006998' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389874' WHERE ordernumber = 'P190513194346951' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389876' WHERE ordernumber = 'P190513194810481' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '92942' WHERE ordernumber = 'P790513195932395' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '219855' WHERE ordernumber = 'P200513200302869' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389878' WHERE ordernumber = 'P630513200854597' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '389882' WHERE ordernumber = 'P790513202845715' 2024-05-14 01:00:03 -- UPDATE `omo_order_list` SET userId = '380422' WHERE ordernumber = 'P630513210238517'