Baselight
SELECT p.name as player, t.name as team, s.season_label as season, c.name as competition, m.date as match_date, home_teams.name as home_team, away_teams.name as away_team, mps.*
FROM @blt.ultimate_soccer_dataset.match_player_stats mps
     INNER JOIN @blt.ultimate_soccer_dataset.matches m on (mps.match_id = m.match_id)
     INNER JOIN @blt.ultimate_soccer_dataset.players p on (mps.player_id = p.player_id)
     INNER JOIN @blt.ultimate_soccer_dataset.teams t on (mps.team_id = t.team_id)
     INNER JOIN @blt.ultimate_soccer_dataset.seasons s on (m.season_id = s.season_id)
     INNER JOIN @blt.ultimate_soccer_dataset.competitions c on (s.competition_id = c.competition_id)
     INNER JOIN @blt.ultimate_soccer_dataset.teams home_teams ON (m.home_team_id = home_teams.team_id)
     INNER JOIN @blt.ultimate_soccer_dataset.teams away_teams ON (m.away_team_id = away_teams.team_id)
WHERE p.player_id = '5b578ccf-496a-5afb-bea2-c7ece1b2c05b' -- Cristiano Ronaldo 
      and year(m.date) = 2017
      and mps.minutes_played > 0
order by m.DATE
playerteamseasoncompetitionmatch_datehome_teamaway_teammatch_idteam_idplayer_idplayer_numberis_captainis_substituteminutes_playedpositionratingshots_totalshots_on_targetgoals_scoredgoals_assistsgoals_concededsavespasses_totalpasses_keytackles_totaltackles_blockstackles_interceptionsduels_totalduels_wondribbles_attemptsdribbles_successdribbled_pastfouls_drawnfouls_committedyellow_cardsred_cardspenalties_wonpenalties_committedpenalties_scoredpenalties_missedpenalties_savedoffsides
Cristiano RonaldoReal Madrid2016/2017La Liga2017-01-07 00:00:00+00Real MadridGranada CFef7eb479-c4e8-5f54-b69d-4c2df8690a6d8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.5521nullnullnull290nullnull16210null2000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-01-15 00:00:00+00SevillaReal Madrida060a6be-5de2-5d27-9728-3e8796a2bb938c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.0531nullnullnull160nullnull19521null2200nullnull10nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-01-21 00:00:00+00Real MadridMalaga2e4936bc-ca47-5718-8072-128b0bcb05c28c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.843nullnullnullnull240nullnull010532null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-01-29 00:00:00+00Real MadridReal Sociedadf26f96cb-bbf5-5ed2-99fe-cd422a4d8c618c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.02111nullnull171nullnull04311null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-02-11 00:00:00+00OsasunaReal Madrida63fb373-0e26-593e-8eb7-6a3a052315db8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.7421nullnullnull202nullnull05310null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2016UEFA Champions League2017-02-15 00:00:00+00Real MadridNapoli29d6899e-c046-5a9f-b83d-52e2e631a7e48c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.030null1nullnull295nullnull117875null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-02-18 00:00:00+00Real MadridEspanyolac07f02f-68dc-5e57-b554-0670d309dc9a8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.430nullnullnullnull221nullnull012451null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-02-22 00:00:00+00ValenciaReal Madrid8fe41772-2455-5040-8531-a336cdf864518c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.6921nullnullnull181nullnull08321null1100nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-02-26 00:00:00+00VillarrealReal Madridfe7fc522-4c9f-59aa-bcdb-35a602dd13cd8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.6911nullnullnull180nullnull06400null3000nullnull10nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-03-01 00:00:00+00Real MadridLas Palmas78bbd439-7918-513f-ac7a-3ad304e452898c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.2822nullnullnull161nullnull0750012210nullnull10nullnull
Cristiano RonaldoReal Madrid2016UEFA Champions League2017-03-07 00:00:00+00NapoliReal Madridb3920a71-98ed-57c2-96cf-b1bfee3314a48c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.731nullnullnullnull170nullnull09611null3100nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-03-12 00:00:00+00Real MadridReal Betis69cde99f-0b2c-5b04-bf6c-5c3588103db48c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.4621nullnullnull171nullnull05220null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-03-18 00:00:00+00Athletic ClubReal Madrida93184bd-58f2-56b0-b4b5-336a972650418c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse79F8.221null2nullnull193nullnull011521null2200nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-04-02 00:00:00+00Real MadridAlavesed6f61d2-eb1e-5a8c-8c4e-c3849b6c31b48c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.771null1nullnull231nullnull013955null1100nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-04-08 00:00:00+00Real MadridAtletico Madrid30f2aecd-7614-5e33-932a-ab7310531b928c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.742nullnullnullnull272nullnull016560null0000nullnull00nullnull
Cristiano RonaldoReal Madrid2016UEFA Champions League2017-04-12 00:00:00+00Bayern MünchenReal Madride4705c1a-334e-5a3e-9ee5-b331e865efc18c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.5842nullnullnull292nullnull01161113000nullnull00nullnull
Cristiano RonaldoReal Madrid2016UEFA Champions League2017-04-18 00:00:00+00Real MadridBayern München518a3b41-b56d-5212-ba75-422285a47c4a8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse120F9.4953nullnullnull211nullnull28340null2100nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-04-23 00:00:00+00Real MadridBarcelonae931993f-18aa-59bc-b424-a61a61680f458c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.283nullnullnullnull142nullnull35210null2000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-04-29 00:00:00+00Real MadridValencia803b0f57-1a89-5da9-b47f-360acf109a308c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.5821nullnullnull161nullnull0813011100nullnull01nullnull
Cristiano RonaldoReal Madrid2016UEFA Champions League2017-05-02 00:00:00+00Real MadridAtletico Madrid9df5c86b-7f24-53ec-b0a4-04409d0307e98c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F9.7533nullnullnull242nullnull01796314100nullnull00nullnull
Cristiano RonaldoReal Madrid2016UEFA Champions League2017-05-10 00:00:00+00Atletico MadridReal Madriddbfcf9d7-6a65-5cd4-be74-2d763938ef7a8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.962nullnullnullnull231nullnull011410null3100nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-05-14 00:00:00+00Real MadridSevilla94f91e7e-5647-51d6-8683-0ffe3f985ec48c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.8432nullnullnull241nullnull17421null3000nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-05-17 00:00:00+00Celta VigoReal Madridbf8dab1b-40a1-5253-bec4-840bd47686cc8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse84F8.1322nullnullnull250nullnull01053211100nullnull00nullnull
Cristiano RonaldoReal Madrid2016/2017La Liga2017-05-21 00:00:00+00MalagaReal Madrida82f93d8-14c8-58fe-b2cc-2f7c9808a07f8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.2321nullnullnull252nullnull08121null0100nullnull00nullnull
Cristiano RonaldoReal Madrid2016UEFA Champions League2017-06-03 00:00:00+00JuventusReal Madrid90ff6015-c567-568f-a639-c5d91596d4788c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.4622nullnullnull180nullnull04100null1000nullnull00nullnull
Cristiano RonaldoPortugal2018World Cup - Qualification Europe2017-06-09 00:00:00+00LatviaPortugale42a9cb9-b7a8-50e7-926a-8cb370fb4947421512b8-7304-5373-ac02-70b4452113b05b578ccf-496a-5afb-bea2-c7ece1b2c05b7truefalse90F109721nullnull282nullnull09755null1100nullnull00nullnull
Cristiano RonaldoReal Madrid2017UEFA Super Cup2017-08-08 00:00:00+00Real MadridManchester United75a7ddd6-1c65-54c0-beaf-b0eb361e70a18c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsetrue7F6.810nullnullnullnull30nullnull05400null3000nullnull00nullnull
Cristiano RonaldoPortugal2018World Cup - Qualification Europe2017-08-31 00:00:00+00PortugalFaroe Islands0f3b0dfa-c668-5772-a7de-fc40c6102309421512b8-7304-5373-ac02-70b4452113b05b578ccf-496a-5afb-bea2-c7ece1b2c05b7truefalse90F106531nullnull613nullnull09421null2000nullnull10nullnull
Cristiano RonaldoPortugal2018World Cup - Qualification Europe2017-09-03 00:00:00+00HungaryPortugal9e9a0b53-b1ba-551a-b2c3-494752a19d39421512b8-7304-5373-ac02-70b4452113b05b578ccf-496a-5afb-bea2-c7ece1b2c05b7truefalse90F7.792null1nullnull493nullnull01057311010nullnull00nullnull
Cristiano RonaldoReal Madrid2017UEFA Champions League2017-09-13 00:00:00+00Real MadridApoel Nicosia06ac4d83-d5e5-572a-9764-6b5819dda7318c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.8932nullnullnull222nullnull07322null1100nullnull10nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-09-20 00:00:00+00Real MadridReal Betisf5ce6097-c167-5911-b2e2-50f7d8f727128c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.7122nullnullnullnull221nullnull010711null1300nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-09-23 00:00:00+00AlavesReal Madrided80c692-bf5b-5068-90cf-df5ea314e6158c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.761nullnullnullnull211nullnull05433null1100nullnull00nullnull
Cristiano RonaldoReal Madrid2017UEFA Champions League2017-09-26 00:00:00+00Borussia DortmundReal Madrid435e50cf-17f7-551f-8fe5-5f977d18e8928c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.4522nullnullnull290nullnull06100null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-10-01 00:00:00+00Real MadridEspanyolb0e2e1ea-84df-55b1-8e69-2d5d48ecd0b38c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.251null1nullnull175nullnull011532null1000nullnull00nullnull
Cristiano RonaldoPortugal2018World Cup - Qualification Europe2017-10-07 00:00:00+00AndorraPortugal97c26f7e-2aa0-5260-9d8f-8d069f29681c421512b8-7304-5373-ac02-70b4452113b05b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse45F8.0521nullnullnull152nullnull05300null3100nullnull00nullnull
Cristiano RonaldoPortugal2018World Cup - Qualification Europe2017-10-10 00:00:00+00PortugalSwitzerlandf3b1a766-5c5f-5b63-b46f-69926d3fb01a421512b8-7304-5373-ac02-70b4452113b05b578ccf-496a-5afb-bea2-c7ece1b2c05b7truefalse90F6.330nullnullnullnull340nullnull014672null3100nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-10-14 00:00:00+00GetafeReal Madrid108a6f4f-2ffc-5bd6-a777-feca5991f3ce8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.0531nullnullnull242nullnull04000null0000nullnull00nullnull
Cristiano RonaldoReal Madrid2017UEFA Champions League2017-10-17 00:00:00+00Real MadridTottenhame3f9d4c1-eb3c-59af-bbff-cb3084c4b6fd8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.1831nullnullnull171nullnull011543null0210nullnull10nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-10-22 00:00:00+00Real MadridEibar625c95ce-75c7-55da-8121-926feb100e7a8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.952nullnullnullnull181nullnull04210null0000nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-10-29 00:00:00+00GironaReal Madrid2255beeb-6aac-5fee-8d26-3fc752196a968c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.273nullnullnullnull181nullnull07121null0100nullnull00nullnull
Cristiano RonaldoReal Madrid2017UEFA Champions League2017-11-01 00:00:00+00TottenhamReal Madrid042a3b8f-6d20-56bc-bf76-8c684cdfd1b58c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.5751nullnullnull330nullnull04222null0000nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-11-05 00:00:00+00Real MadridLas Palmas6513b629-cb19-50bb-8a2a-ec76be27de4e8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.281null1nullnull323nullnull04200null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-11-18 00:00:00+00Atletico MadridReal Madrid510582bd-fb8c-5a6a-8169-b99a078d88e88c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.572nullnullnullnull222nullnull05410null3000nullnull00nullnull
Cristiano RonaldoReal Madrid2017UEFA Champions League2017-11-21 00:00:00+00Apoel NicosiaReal Madrid62501169-1812-5f5d-8661-a07d453561d78c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F9.78321nullnull171nullnull05411null2100nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-11-25 00:00:00+00Real MadridMalaga3003c6a3-0060-580a-b6a7-6cfa937bdae18c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F6.8741nullnullnull260nullnull17420null1000nullnull01nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-12-02 00:00:00+00Athletic ClubReal Madride90ec2a1-e768-5f90-8597-9bed37d60dd58c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F8.062nullnullnullnull172nullnull09733null1210nullnull00nullnull
Cristiano RonaldoReal Madrid2017UEFA Champions League2017-12-06 00:00:00+00Real MadridBorussia Dortmund7bd3f35a-a805-59d9-8bbf-7ef6080ddc1e8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.8851nullnullnull373nullnull08655null1000nullnull00nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-12-09 00:00:00+00Real MadridSevilla46cd4138-ea41-569b-b706-65391542ef6c8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse76F8.5532nullnullnull221nullnull1420010000nullnull10nullnull
Cristiano RonaldoReal Madrid2017/2018La Liga2017-12-23 00:00:00+00Real MadridBarcelona8a8ebd17-fe8c-5360-bd4d-d06adca2b12b8c71b852-7443-5b05-affd-2e9b77fc252d5b578ccf-496a-5afb-bea2-c7ece1b2c05b7falsefalse90F7.251nullnullnullnull221nullnull010610null2300nullnull00nullnull

Share link

Anyone who has the link will be able to view this.