1 / 61

Liga ACB

Liga ACB. Liga ACB, known as Liga Endesa for sponsorship reasons, is the top professional basketball division of the Spanish basketball league system administrated by the Asociación de Clubes de Baloncesto (ACB) contested by 18 teams with two lowest-placed teams relegated to LEB Oro

ronaldj
Download Presentation

Liga ACB

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Liga ACB

  2. Liga ACB, known as Liga Endesa for sponsorship reasons, is the top professional basketball division of the Spanish basketball league system • administrated by the Asociación de Clubes de Baloncesto (ACB) • contested by 18 teams • with two lowest-placed teams relegated to LEB Oro • and replaced by top team in that division plus winner of playoffs

  3. Season

  4. SELECT MONTH(game.kickoff_time), COUNT(*) FROM game • GROUP BY MONTH(game.kickoff_time) • ORDER BY MONTH(game.kickoff_time)

  5. 1 1122 • 2 684 • 3 997 • 4 929 • 5 621 • 6 145 • 9 336 • 10 1019 • 11 839 • 12 1014

  6. we can conclude that season start in September and end in June

  7. Team Name Other then short team name and the name made for sponsorship reasons and variable during time

  8. SELECT * FROM team SELECT * FROM team JOIN teamName ON team.id = teamName.team_id • id acb_idfounded_year • 5 BAR 1926 • id acb_idfounded_year id team_id name season • 5 BAR 1926 469 5 F.C. BARCELONA BANCA CATALANA 1994 • 5 BAR 1926 401 5 F.C. BARCELONA 1998 • 5 BAR 1926 266 5 WINTERTHUR F.C. BARCELONA 2004 • 5 BAR 1926 207 5 AXA F.C. BARCELONA 2007 • 5 BAR 1926 195 5 REGAL F.C. BARCELONA 2008 • 5 BAR 1926 99 5 FC BARCELONA REGAL 2012 • 5 BAR 1926 68 5 FC BARCELONA 2013 • 5 BAR 1926 34 5 FC BARCELONA LASSA 2015

  9. Most popular names of teams • SELECT id, name FROM • (SELECT team.id, teamName.name, COUNT(*) AS Nums FROM team JOIN teamName ON team.id = teamName.team_id • GROUP BY team.id, teamName.name) tIN • WHERE tIN.Nums >= ALL • (SELECT tOUT.Nums FROM • (SELECT team.id, teamName.name, COUNT(*) AS Nums FROM team JOIN teamName ON team.id = teamName.team_id • GROUP BY team.id, teamName.name) tOUT • WHERE tIN.id = tOUT.id)

  10. in team we have 35 records … • in most popular team names we have 41 records … we must do some manual editing … • SELECT id, name InTonewTeams FROM … • ALTER TABEL team ADD team_nameNVarChar(50)

  11. Update query using joins • UPDATE team • SET team.team_name = newTeams.name • FROM team • JOIN newTeams ON team.id = newTeams.id • DROP TABLE newTeams

  12. Rooster

  13. view root1 • SELECT team.id as teamid, game.id as gameid, participant.id as participantid, actor.id as actorid, team.team_name, IIF(MONTH(game.kickoff_time) < 7, YEAR(game.kickoff_time)-1,YEAR(game.kickoff_time)) as season • FROM team • JOIN game ON team.id = home_team_id OR team.id = away_team_id • JOIN participant ON game.id = participant.game_id • AND team.id = participant.team_id • JOIN actor ON actor.id = participant.actor_id

  14. rooster • SELECT DISTINCT • team_name, season, • actor.display_name, actor.full_name, actor.position, actor.birthdate, actor.nationality, actor.license, actor.is_coach • FROM root1 JOIN actor ON actor.id = root1.actorid

  15. SELECT * FROM rooster WHERE team_name = 'REAL MADRID' and season = 2015ORDER BY is_coach, display_name • team_name season display_namefull_name position birthdate nationality license is_coach • REAL MADRID 2015 Ayón, Gustavo Gustavo Alfonso Ayón Aguirre P 1985-04-01 MEX EXT 0 • REAL MADRID 2015 Carroll, Jaycee Jaycee Don Carroll E 1983-04-16 AZE EUR 0 • REAL MADRID 2015 De la Rúa, Daniel Daniel de la Rúa de Agustín B 1997-01-30 ESP JFL 0 • REAL MADRID 2015 Doncic, Luka Luka Doncic B 1999-02-28 SVN JFL 0 • REAL MADRID 2015 Fernández, Rudy Rodolfo Fernández Farrés A 1985-04-04 ESP JFL 0 • REAL MADRID 2015 Hernangómez, W. Guillermo Gustavo HernangómezGeuer P 1994-05-27 ESP JFL 0 • REAL MADRID 2015 Lima, Augusto Augusto Cesar Lima Brito P 1991-09-17 ESP EUR 0 • REAL MADRID 2015 Llull, Sergio Sergio LlullMeliá B 1987-11-15 ESP JFL 0 • REAL MADRID 2015 Maciulis, Jonas Jonas Maciulis A 1985-02-10 LTU EUR 0 • REAL MADRID 2015 Ndour, Maurice Maurice Daly Ndour F 1992-06-18 SEN COT 0 • REAL MADRID 2015 Nocioni, Andrés Andrés Marcelo Nocioni F 1979-11-30 ITA EUR 0 • REAL MADRID 2015 Radoncic, Dino Dino Radoncic A 1999-01-08 SRB JFL 0 • REAL MADRID 2015 Reyes, Felipe Felipe Reyes Cabanas F 1980-03-16 ESP JFL 0 • REAL MADRID 2015 Rivers, K. C. Kelvin Creswell Rivers A 1987-03-01 USA EXT 0 • REAL MADRID 2015 Rodríguez, S. Sergio Rodríguez Gómez B 1986-06-12 ESP JFL 0 • REAL MADRID 2015 Taylor, Jeffery Jeffery Taylor A 1989-03-23 SWE EUR 0 • REAL MADRID 2015 Thiago, Samba Samba Thiago Ndiaye P 1998-04-19 SEN JFL 0 • REAL MADRID 2015 Thompkins, Trey Howard Samuel Thompkins III F 1990-05-29 USA EXT 0 • REAL MADRID 2015 Laso, Pablo Pablo LasoBiurrún 1967-10-13 ESP NULL 1

  16. SELECT * FROM rooster WHERE team_name = 'REAL MADRID' and season = 2015ORDER BY is_coach, display_name • REAL MADRID 2015 Fernández, Rudy Rodolfo Fernández Farrés A • REAL MADRID 2015 Llull, Sergio Sergio LlullMeliá B • REAL MADRID 2015 Maciulis, Jonas Jonas Maciulis A • REAL MADRID 2015 Ndour, Maurice Maurice Daly Ndour F • REAL MADRID 2015 Nocioni, Andrés Andrés Marcelo Nocioni F • REAL MADRID 2015 Reyes, Felipe Felipe Reyes Cabanas F • REAL MADRID 2015 Rivers, K. C. Kelvin Creswell Rivers A • REAL MADRID 2015 Rodríguez, S. Sergio Rodríguez Gómez B • REAL MADRID 2015 Laso, Pablo Pablo LasoBiurrún

  17. Depth Chart

  18. Depth Chart • SELECT root1.team_name, root1.season, actor.display_name, actor.position, SUM(participant.minutes)/60 as total_minutes • FROM root1 INNER JOIN actor ON actor.id = root1.actorid • INNER JOIN participant ON participant.id = root1.participantid • WHERE is_coach = 0 • GROUP BY root1.team_name, root1.season, actor.display_name, actor.position

  19. SELECT * FROM depthChart WHERE team_name = 'REAL MADRID' and season = 2015ORDER BY position, total_minutes DESC • team_name season display_name position total_minutes • REAL MADRID 2015 Maciulis, Jonas A 697 • REAL MADRID 2015 Taylor, Jeffery A 640 • REAL MADRID 2015 Fernández, Rudy A 542 • REAL MADRID 2015 Rivers, K. C. A 193 • REAL MADRID 2015 Radoncic, Dino A 7 • REAL MADRID 2015 Llull, Sergio B 1050 • REAL MADRID 2015 Rodríguez, S. B 1031 • REAL MADRID 2015 Doncic, Luka B 503 • REAL MADRID 2015 De la Rúa, Daniel B 4 • REAL MADRID 2015 Carroll, Jaycee E 885 • REAL MADRID 2015 Reyes, Felipe F 678 • REAL MADRID 2015 Thompkins, Trey F 620 • REAL MADRID 2015 Nocioni, Andrés F 529 • REAL MADRID 2015 Ndour, Maurice F 115 • REAL MADRID 2015 Ayón, Gustavo P 952 • REAL MADRID 2015 Hernangómez, W. P 384 • REAL MADRID 2015 Lima, Augusto P 211 • REAL MADRID 2015 Thiago, Samba P 1

  20. Standing

  21. Games (aka root2) • SELECT game.id, game.competition_phase, journey, • IIF(MONTH(game.kickoff_time) < 7, YEAR(game.kickoff_time) - 1, YEAR(game.kickoff_time)) AS season, • h.team_name AS home_team_name, game.score_home, • a.team_name AS away_team_name, game.score_away • FROM game JOIN • team h ON game.home_team_id = h.id JOIN • team a ON game.away_team_id = a.id

  22. Games (aka root2) • id competition_phase journey season home_team_namescore_homeaway_team_namescore_away • 1 regular 1 2016 HERBALIFE GRAN CANARIA 81 IBEROSTAR TENERIFE 92 • 2 regular 1 2016 ADECCO ESTUDIANTES 82 CAJA SAN FERNANDO 95 • 3 regular 1 2016 REAL MADRID 101 UNICAJA 90 • 4 regular 1 2016 RICOH MANRESA 50 F.C. BARCELONA 56 • 5 regular 1 2016 RIO NATURA MONBUS OBRADOIRO 76 TAU CERÁMICA 92 • 6 regular 1 2016 BALONCESTO FUENLABRADA 80 BILBAO BASKET 89 • 7 regular 1 2016 UCAM MURCIA CB 67 DKV JOVENTUT 65 • 8 regular 1 2016 CAI ZARAGOZA 68 PAMESA VALENCIA 80 • 9 regular 2 2016 MORABANC ANDORRA 97 HERBALIFE GRAN CANARIA 89 • 10 regular 2 2016 TAU CERÁMICA 87 UCAM MURCIA CB 75

  23. Points (aka root22) • SELECT root2.id, root2.competition_phase, root2.journey, root2.season, root2.home_team_name AS team_name, IIF(score_home > score_away, 1, 0) AS points • FROM root2 • UNION • SELECT root2.id, root2.competition_phase, root2.journey, root2.season, root2.away_team_name AS team_name, IIF(score_away > score_home, 1, 0) AS points • FROM root2

  24. Points (aka root22) • id competition_phase journey season team_name points • 1 regular 1 2016 HERBALIFE GRAN CANARIA 0 • 1 regular 1 2016 IBEROSTAR TENERIFE 1 • 2 regular 1 2016 ADECCO ESTUDIANTES 0 • 2 regular 1 2016 CAJA SAN FERNANDO 1 • 3 regular 1 2016 REAL MADRID 1 • 3 regular 1 2016 UNICAJA 0 • 4 regular 1 2016 F.C. BARCELONA 1 • 4 regular 1 2016 RICOH MANRESA 0 • 5 regular 1 2016 RIO NATURA MONBUS OBRADOIRO 0 • 5 regular 1 2016 TAU CERÁMICA 1

  25. Final Standing • SELECT competition_phase, season, team_name, • SUM(points) AS points • FROMroot22 • GROUP BY competition_phase, season, team_name

  26. SELECT TOP 8 * FROM finalStanding WHERE season = 2006 AND competition_phase = 'regular' ORDER BY points DESC • competition_phase season team_name points • regular 2006 TAU CERÁMICA 26 • regular 2006 REAL MADRID 25 • regular 2006 DKV JOVENTUT 23 • regular 2006 F.C. BARCELONA 23 • regular 2006 HERBALIFE GRAN CANARIA 21 • regular 2006 CASADEMONT GIRONA 21 • regular 2006 PAMESA VALENCIA 19 • regular 2006 UNICAJA 17

  27. SELECT * FROM finalStanding WHERE season = 2006 AND competition_phase = 'regular' ORDER BY points DESC • competition_phase season team_name points • regular 2006 TAU CERÁMICA 26 • regular 2006 REAL MADRID 25 • regular 2006 DKV JOVENTUT 23 • regular 2006 F.C. BARCELONA 23 • regular 2006 HERBALIFE GRAN CANARIA 21 • regular 2006 CASADEMONT GIRONA 21 • regular 2006 PAMESA VALENCIA 19 • regular 2006 UNICAJA 17 • regular 2006 ADECCO ESTUDIANTES 16 • regular 2006 BILBAO BASKET 15 • regular 2006 C.B. GRANADA 15 • regular 2006 CAJA SAN FERNANDO 14 • regular 2006 BALONCESTO FUENLABRADA 14 • regular 2006 UCAM MURCIA CB 13 • regular 2006 VIVEMENORCA 12 • regular 2006 FÓRUM VALLADOLID 12 • regular 2006 ETOSA ALICANTE 12 • regular 2006 LAGUN ARO GBC 8

  28. SELECT * FROM finalStanding WHERE season = 2006 AND competition_phase = 'playoff' ORDER BY points DESC • competition_phase season team_name points • playoff 2006 REAL MADRID 9 • playoff 2006 F.C. BARCELONA 7 • playoff 2006 DKV JOVENTUT 5 • playoff 2006 TAU CERÁMICA 5 • playoff 2006 HERBALIFE GRAN CANARIA 2 • playoff 2006 PAMESA VALENCIA 1 • playoff 2006 CASADEMONT GIRONA 1 • playoff 2006 UNICAJA 0

  29. MS SQL ServerTable-valued Functions • MS SQL Server • User’s Defined Functions which return int, char, … • User’s Defined Functions which return table • View with parameters • wherever you can use table you can use also views and table-valued functions • Database – Programmability – Functions – • Table-valued Function

  30. CREATE / ALTER • FUNCTION [dbo].[standing] • ( @season INTEGER, @journey INTEGER ) RETURNS TABLE AS RETURN • (SELECT team_name, SUM(points) AS points FROM ( • SELECT root2.id, root2.competition_phase, root2.journey, root2.season, root2.home_team_name AS team_name, IIF(score_home > score_away, 1, 0) AS points FROM root2 • WHERE competition_phase = 'regular' AND season = @season AND journey <= @journey • UNION • SELECT root2.id, root2.competition_phase, root2.journey, root2.season, root2.away_team_name AS team_name, IIF(score_away > score_home, 1, 0) AS points FROM root2 • WHERE competition_phase = 'regular' AND season = @season AND journey <= @journey) t • GROUP BY team_name • )

  31. SELECT * FROM standing(2006, 34) ORDER BY points DESC • TAU CERÁMICA 26 • REAL MADRID 25 • DKV JOVENTUT 23 • F.C. BARCELONA 23 • HERBALIFE GRAN CANARIA 21 • CASADEMONT GIRONA 21 • PAMESA VALENCIA 19 • UNICAJA 17 • ADECCO ESTUDIANTES 16 • BILBAO BASKET 15 • C.B. GRANADA 15 • CAJA SAN FERNANDO 14 • BALONCESTO FUENLABRADA 14 • UCAM MURCIA CB 13 • VIVEMENORCA 12 • FÓRUM VALLADOLID 12 • ETOSA ALICANTE 12 • LAGUN ARO GBC 8

  32. SELECT * FROM finalStanding WHERE season = 2006 AND competition_phase = 'regular' ORDER BY points DESC • competition_phase season team_name points • regular 2006 TAU CERÁMICA 26 • regular 2006 REAL MADRID 25 • regular 2006 DKV JOVENTUT 23 • regular 2006 F.C. BARCELONA 23 • regular 2006 HERBALIFE GRAN CANARIA 21 • regular 2006 CASADEMONT GIRONA 21 • regular 2006 PAMESA VALENCIA 19 • regular 2006 UNICAJA 17 • regular 2006 ADECCO ESTUDIANTES 16 • regular 2006 BILBAO BASKET 15 • regular 2006 C.B. GRANADA 15 • regular 2006 CAJA SAN FERNANDO 14 • regular 2006 BALONCESTO FUENLABRADA 14 • regular 2006 UCAM MURCIA CB 13 • regular 2006 VIVEMENORCA 12 • regular 2006 FÓRUM VALLADOLID 12 • regular 2006 ETOSA ALICANTE 12 • regular 2006 LAGUN ARO GBC 8

  33. SELECT * FROM standing(2006, 17) ORDER BY points DESC • team_name points • REAL MADRID 15 • TAU CERÁMICA 15 • CASADEMONT GIRONA 13 • DKV JOVENTUT 10 • UNICAJA 10 • CAJA SAN FERNANDO 10 • PAMESA VALENCIA 9 • HERBALIFE GRAN CANARIA 9 • F.C. BARCELONA 9 • BALONCESTO FUENLABRADA 8 • ADECCO ESTUDIANTES 7 • C.B. GRANADA 7 • UCAM MURCIA CB 7 • BILBAO BASKET 6 • ETOSA ALICANTE 6 • LAGUN ARO GBC 5 • FÓRUM VALLADOLID 4 • VIVEMENORCA 3

  34. Rivalries

  35. SELECT t1.team_name as team_name1, t2.team_name as team_name2 FROM team t1, team t2 • SELECT t1.team_name as team_name1, t2.team_name as team_name2 FROM team t1 CROSS JOIN team t2 • 35 * 35 = 1.225 rows

  36. JOIN

  37. SELECT home_team_name, away_team_name, COUNT(*) home_wins FROM root2 • WHERE score_home > score_away • GROUP BY home_team_name, away_team_name • SELECT home_team_name, away_team_name, COUNT(*) home_loss FROM root2 • WHERE score_home < score_away • GROUP BY home_team_name, away_team_name • SELECT home_team_name, away_team_name, COUNT(*) away_wins FROM root2 • WHERE score_away > score_home • GROUP BY home_team_name, away_team_name • SELECT home_team_name, away_team_name, COUNT(*) away_loss FROM root2 • WHERE score_away < score_home • GROUP BY home_team_name, away_team_name

  38. Scalar function wins / loss • ALTER FUNCTION [dbo].[wins] • ( @team1 NVarChar(50), @team2 NVarChar(50) ) RETURNS int AS • BEGIN • DECLARE @ResultVar INTEGER • DECLARE @TempVal INTEGER • SELECT @ResultVar = 0

  39. Scalar function wins / loss • SELECT @TempVal = COUNT(*) FROM root2 • WHERE score_home > score_away AND home_team_name = @team1 AND away_team_name = @team2 • SELECT @ResultVar = @ResultVar + @TempVal • SELECT @TempVal = COUNT(*) FROM root2 • WHERE score_away > score_home AND away_team_name = @team1 AND home_team_name = @team2 • SELECT @ResultVar = @ResultVar + @TempVal • RETURN @ResultVar • END

  40. SELECT • t1.team_name as team_name1, t2.team_name as team_name2, • dbo.wins(t1.team_name, t2.team_name) AS wins, • dbo.loss(t1.team_name, t2.team_name) AS loss • FROM team t1 CROSS JOIN team t2

  41. SELECT * FROM • (SELECT • t1.team_name as team_name1, t2.team_name as team_name2, • dbo.wins(t1.team_name, t2.team_name) AS wins, • dbo.loss(t1.team_name, t2.team_name) AS loss • FROM team t1 CROSS JOIN team t2) t • WHERE team_name1 = 'REAL MADRID' • ORDER BY wins + loss DESC

  42. team_name1 team_name2 wins loss • REAL MADRID F.C. BARCELONA 40 53 • REAL MADRID TAU CERÁMICA 36 33 • REAL MADRID PAMESA VALENCIA 43 22 • REAL MADRID ADECCO ESTUDIANTES 42 22 • REAL MADRID DKV JOVENTUT 48 13 • REAL MADRID CAJA SAN FERNANDO 38 19 • REAL MADRID UNICAJA 38 17 • … • REAL MADRID BALONCESTO SALAMANCA 2 2 • REAL MADRID UNELCO TENERIFE 4 0 • REAL MADRID C.B. CIUDAD DE HUELVA 1 1 • REAL MADRID REAL MADRID 0 0

  43. SELECT TOP 5 * FROM • (SELECT • t1.team_name as team_name1, t2.team_name as team_name2, • dbo.wins(t1.team_name, t2.team_name) AS wins, • dbo.loss(t1.team_name, t2.team_name) AS loss • FROM team t1 CROSS JOIN team t2) t • WHERE wins > loss • ORDER BY wins + loss DESC

  44. team_name1 team_name2 wins loss • F.C. BARCELONA REAL MADRID 53 40 • F.C. BARCELONA TAU CERÁMICA 46 41 • F.C. BARCELONA UNICAJA 55 25 • TAU CERÁMICA UNICAJA 39 33 • F.C. BARCELONA ADECCO ESTUDIANTES 48 23

  45. Game card

  46. root3 • SELECT game.id, • root2.home_team_name, root2.away_team_name, game.score_home, game.score_away, • IIF(MONTH(game.kickoff_time) < 7, YEAR(game.kickoff_time) - 1, YEAR(game.kickoff_time)) AS season, • game.competition_phase, game.journey, game.venue, game.attendance, game.kickoff_time • FROM game JOIN root2 ON game.id = root2.id

  47. SELECT * FROM root3WHERE season = 2006 AND home_team_name = 'REAL MADRID' AND away_team_name = 'F.C. Barcelona' • id home_team_nameaway_team_namescore_homescore_away season competition_phase journey venue attendance kickoff_time • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 • 3535 REAL MADRID F.C. BARCELONA 69 62 2006 playoff 45 Palacio Vistalegre 13780 2007-06-17 12:30:00.000 • 3536 REAL MADRID F.C. BARCELONA 83 80 2006 playoff 46 Palacio Vistalegre 13780 2007-06-19 21:30:00.000

  48. root33 • SELECT root1.gameid, root1.team_name, actor.display_name, actor.position, participant.number, participant.is_starter, participant.minutes, participant.points • FROM root1 INNER JOIN actor ON root1.actorid = actor.id • INNER JOIN participant ON root1.participantid = participant.id • WHERE (participant.minutes <> 0)

  49. SELECT root3.id, root3.home_team_name, root3.away_team_name, root3.score_home, root3.score_away, root3.season, root3.competition_phase, root3.journey, root3.venue,root3.attendance, root3.kickoff_time, • root33.team_name, root33.display_name, root33.position, root33.number, root33.is_starter, root33.minutes, root33.points • FROM root3 INNER JOINroot33 ON root3.id = root33.gameid

  50. SELECT * FROM gameCard WHERE id = 3291ORDER BY team_name, is_starter DESC, position,display_name • id home_team_nameaway_team_namescore_homescore_away season competition_phase journey venue attendance kickoff_timegameidteam_namedisplay_name position number is_starter minutes points • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA De la Fuente, R A 14 1 494 0 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Lakovic, Jaka B 10 1 1530 13 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Navarro, J.C. E 11 1 2319 21 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Trias, Jordi F 8 1 1196 11 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Marconato, D. P 9 1 1334 6 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Grimau, Roger B 44 0 1199 8 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Ukic, Roko B 21 0 870 6 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Basile, G. E 5 0 788 4 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Kakiouzis, M. F 20 0 1359 2 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Kasun, Mario P 41 0 471 2 • 3291 REAL MADRID F.C. BARCELONA 90 73 2006 regular 10 Palacio Vistalegre 13900 2006-11-25 19:00:00.000 3291 F.C. BARCELONA Vázquez, Fran P 17 0 440 0

More Related