4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Juventus

Enviar Datos
Información
  • Nombre del equipo Juventus
  • Nombre completo Juventus Football Club S.p.A.
  • Nombre corto JUV
  • País Italia
  • Ciudad Turín, Italia
  • Entrenador Massimiliano Allegri
  • URL del equipo en RF //m.resultados-futbol.com/Juventus-Fc
Otros Datos
  • Año de Fundación 1897
  • Presupuesto 88000000
  • Patrocinador Jeep
  • Marca de Ropa Adidas
  • Socios 56000
Internet

Información sobre el estadio

  • Nombre del estadio Juventus Stadium
  • Capacidad 41000
  • Dirección Strada Comunale di Altessano 131
  • Teléfono +39 (011) 656 31
  • Fax +39 (011) 511 9214
  • Año de construcción 2011
  • Tamaño 105x68 metros
Juventus Stadium

Histórico de participación

Coppa Italia
94 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1990, 1989, 1989, 1988, 1988, 1987, 1987, 1986, 1986, 1985, 1985, 1984, 1984, 1983, 1983, 1982, 1981, 1981, 1980, 1979, 1979, 1978, 1978, 1977, 1977, 1976, 1975, 1975, 1974, 1974, 1973, 1973, 1973, 1972, 1972, 1971, 1970, 1970, 1969, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1958, 1943, 1942, 1941, 1940, 1939, 1938, 1937)
Serie A
94 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1946, 1946, 1943, 1942, 1941, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929)
Champions League Grupo 8
57 veces
(2023, 2022, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2018, 2017, 2017, 2016, 2016, 2015, 2015, 2014, 2013, 2013, 2010, 2009, 2009, 2006, 2006, 2005, 2005, 2004, 2004, 2003, 2003, 2003, 2002, 2002, 2001, 1999, 1999, 1998, 1998, 1997, 1997, 1996, 1996, 1987, 1986, 1985, 1983, 1982, 1979, 1978, 1976, 1974, 1973, 1968, 1962, 1961, 1959)
Supercopa de Italia
17 veces
(2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2006, 2004, 2003, 1999, 1998, 1996, 1991)
Europa League Grupo 0
16 veces
(2023, 2014, 2011, 2010, 2000, 1995, 1994, 1993, 1992, 1990, 1989, 1988, 1981, 1977, 1975, 1972)
Partidos Amistosos
14 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)
Copa de Ferias
6 veces
(1971, 1970, 1969, 1967, 1965, 1964)
International Champions Cup
5 veces
(2020, 2019, 2018, 2017, 2014)
Recopa de Europa
4 veces
(1991, 1984, 1980, 1966)
Copa Intercontinental
3 veces
(1997, 1986, 1974)
Trofeo Joan Gamper
2 veces
(2022, 2006)
Fase Previa Champions League Grupo 3
2 veces
(2009, 2005)
Fase Previa Europa League Grupo 4
2 veces
(2011, 2011)
Peace Cup Grupo 0
2 veces
(2010, 2010)
Soccer Champions Tour
2 veces
(2024, 2023)
Supercopa Europa
2 veces
(1997, 1985)
Trofeo Armando Picchi
2 veces
(1971, 1971)
Trofeo Ramón de Carranza
1 vez
(1974)
Trofeo Ciudad de Zaragoza
1 vez
(2008)
Copa Latina
1 vez
(1952)
Copa Emirates
1 vez
(2008)
Copa Intertoto
1 vez
(2000)
MLS All-Star
1 vez
(2018)
Serie B
1 vez
(2007)
Serie A - Spareggio
1 vez
(1999)
Superliga Europea
1 vez
(2022)
Trofeo Teresa Herrera
1 vez
(1997)

Partidos del Juventus

Ir al LIVESCORE
Serie A Serie A »
13 May 12  Finalizado Juventus
3 - 1
 Atalanta 15
06 May 12  Finalizado Cagliari
0 - 2
 Juventus 20
02 May 12  Finalizado Juventus
1 - 1
 LecceTarjeta Roja 10
29 Abr 12  Finalizado Novara
0 - 4
 Juventus 9
25 Abr 12  Finalizado Cesena
0 - 1
 Juventus 11
22 Abr 12  Finalizado Juventus
4 - 0
 RomaTarjeta Roja 21
11 Abr 12  Finalizado Juventus
2 - 1
 LazioTarjeta Roja 14
07 Abr 12  Finalizado Palermo FC
0 - 2
 Juventus 9
01 Abr 12  Finalizado Juventus
3 - 0
 NapoliTarjeta Roja 22
25 Mar 12  Finalizado Juventus
2 - 0
 Inter 24
17 Mar 12  Finalizado Tarjeta RojaFiorentina
0 - 5
 Juventus 21
11 Mar 12  Finalizado Genoa
0 - 0
 Juventus 7
07 Mar 12  Finalizado Bologna
1 - 1
 JuventusTarjeta Roja 14
03 Mar 12  Finalizado Juventus
1 - 1
 Chievo 13
25 Feb 12  Finalizado Milan
1 - 1
 JuventusTarjeta Roja 73
18 Feb 12  Finalizado Juventus
3 - 1
 CataniaTarjeta Roja 27
15 Feb 12  Finalizado Parma
0 - 0
 Juventus 7
05 Feb 12  Finalizado Juventus
0 - 0
 Siena 7
28 Ene 12  Finalizado Juventus
2 - 1
 Udinese 11
21 Ene 12  Finalizado Atalanta
0 - 2
 Juventus 17
15 Ene 12  Finalizado Juventus
1 - 1
 Cagliari 11
08 Ene 12  Finalizado Lecce
0 - 1
 Juventus 7
21 Dic 11  Finalizado Udinese
0 - 0
 Juventus 20
18 Dic 11  Finalizado Juventus
2 - 0
 Novara 13
12 Dic 11  Finalizado Roma
1 - 1
 Juventus 96
04 Dic 11  Finalizado Juventus
2 - 0
 CesenaTarjeta Roja 9
29 Nov 11  Finalizado Napoli
3 - 3
 Juventus 31
26 Nov 11  Finalizado Lazio
0 - 1
 Juventus 28
20 Nov 11  Finalizado Juventus
3 - 0
 Palermo FC 43
29 Oct 11  Finalizado Inter
1 - 2
 Juventus 52
25 Oct 11  Finalizado Juventus
2 - 1
 Fiorentina 67
22 Oct 11  Finalizado Juventus
2 - 2
 Genoa 15
16 Oct 11  Finalizado Chievo
0 - 0
 Juventus 10
02 Oct 11  Finalizado Juventus
2 - 0
 MilanTarjeta Roja 32
25 Sep 11  Finalizado Catania
1 - 1
 Juventus 13
21 Sep 11  Finalizado Tarjeta RojaJuventus
1 - 1
 Bologna 13
18 Sep 11  Finalizado Siena
0 - 1
 Juventus 8
11 Sep 11  Finalizado Tarjeta RojaJuventus
4 - 1
 Parma 12
Coppa Italia Coppa Italia »
20 May 12  Finalizado Tarjeta RojaJuventus
0 - 2
 Napoli 0
20 Mar 12  Finalizado Juventus
2 - 2
 Milan 0
08 Feb 12  Finalizado Milan
1 - 2
 Juventus 0
24 Ene 12  Finalizado Juventus
3 - 0
 RomaTarjeta Roja 0
08 Dic 11  Finalizado Juventus
2 - 1
 Bologna 0
Partidos Amistosos Partidos Amistosos »
05 Ene 12  Finalizado Al Ahli Dubai
1 - 7
 Juventus 0
21 Ago 11  Finalizado Milan
2 - 1
 Juventus 0
13 Ago 11  Finalizado Juventus
0 - 0
 Real Betis 2
27 Jul 11  Finalizado Juventus
1 - 0
 America 1

Plantilla del Juventus Temporada 2011/2012

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
46 at 189 84 - - -
1 46 it 192 83 - - -
30 47 it 187 76 - - -
Defensa
15 42 it 186 79 1 - 3
6 46 it 190 82 - - -
32 dk 194 88 1 - 1
3 39 it 187 86 2 - 7
19 36 it 189 86 3 1 8
34 it 186 75 1 - -
37 uy 180 75 1 - -
11 37 it 184 75 1 1 3
26 40 ch 181 69 2 - 6
Centrocampista
21 44 it 177 68 3 - 5
22 36 cl 180 74 7 1 12
8 38 it 179 66 9 - 7
24 38 it 167 60 1 - 2
36 py 181 76 1 - -
27 39 rs 185 75 1 - -
41 it 175 75 1 - 3
7 40 it 178 77 6 - 6
40 it 179 74 1 - 5
Delantero
10 49 it 173 73 3 - -
32 39 it 183 80 10 - 4
17 37 nl 176 70 - - -
18 41 it 180 79 4 - 4
46 it 193 88 - - -
41 it 185 76 2 - 1
14 40 rs 186 76 8 1 3

Noticias del Juventus

Ver últimas noticias

Juventus y Milan comparten los puntos y sus penas

BeSoccer - Sábado, 27 Abril 2024
0 2.264

En un duelo entre equipos en crisis, Juventus y Milan firmaron un empate a cero que no dejó contento a nadie. La 'Vecchia Signora' sigue de capa caída pese a su agónico pase a la final de Coppa, mientras que el cuadro lombardo no pudo reponerse con triunfo de la humillación de su última derrota ante el Inter. Eso sí, con las tablas, los de la Ciudad de la Moda dejaron más que encarrilado el subcampeonato a falta de cuatro jornadas.

"Me tomaron por loco cuando dije que el Inter era superior a los demás"

BeSoccer - Viernes, 26 Abril 2024
7 16.633

A Massimiliano Allegri no le ha extrañado nada que el Inter se haya proclamado campeón de la Serie A. Antes del Juventus-Milan valoró muy positivamente el esfuerzo de los 'nerazzurri', a los que consideró "claramente más fuertes que los demás".

"Siempre soñé con jugar en el Madrid y ganar la Champions"

BeSoccer - Jueves, 25 Abril 2024
4 21.036

El jugador Matías Soulé, cedido en el Frosinone por la Juventus de Turín, charló hace un par de semanas con 'ESPN' y habló sobre sus deseos como jugador. Aseguró que, de niño, siempre quiso jugar en el Real Madrid y aspira a conquistar la Champions League algún día.

Esto es la Juve

Juanma Velasco - Martes, 23 Abril 2024
0 9.226

La Juventus metió la cabeza en la gran final de la Coppa Italia pese a caer por 2-1 en el Olímpico de Roma ante la Lazio. Un gol de Milik en el 83' fue suficiente para una 'Vecchia Signora' que, pese a estar desaparecida en la Ciudad Eterna, aprovechó la mejor ocasión que tuvo para colarse en la batalla por el título.

"Sueño con ganar el Balón de Oro"

BeSoccer - Martes, 23 Abril 2024
4 3.429

El jugador de la Juventus Dusan Vlahovic concedió una entrevista al diario francés 'L'Équipe' en la que afirmó: "Obviamente, sueño con ganar el Balón de Oro". Además, el serbio habló sobre su técnico, Massimiliano Allegri, su club, su futuro y su rendimiento en la presente temporada. Por último, esbozó una lista de delanteros a los que considera como sus modelos de referencia.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,466,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.2785
Total Execution Time  0.2820
  CADENA URL  
/juventus-fc/2012
  GET DATOS  
$_GET['/juventus-fc/2012']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0062  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'juventus-fc' AND l.year = 2012 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0021  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1430 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1430 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1430 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1430 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1416
0.0023  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 14107
0.0036  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 1323
0.0024  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1430 AND type_rel = 2
0.0061  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1430 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1312859,1312701,1312542,1312313,1312198) ORDER BY n.cover_points DESC, update_date DESC
0.0042  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '1430' AND l.year = 2012 ORDER BY l.year DESC,cat.coefficient DESC
0.0042  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '1430' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 14107 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 1416 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2012 as c ON c.league_id = l.id WHERE (c.datateam1 = 1430 or c.datateam2 = 1430) AND l.year = 2012 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0028  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2012 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 1430 or c.datateam2 = 1430) AND l.year = 2012 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0035  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2012 as c ON c.league_id = l.id INNER JOIN events2012 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 1430 or c.datateam2 = 1430) AND l.year = 2012)
0.0040  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1430 AND l.year in (2011,2012,2013) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (42898,14108,2145,2081,1909,1906,1246) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 1909 AND teamId = 1430
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 2145 AND teamId = 1430
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 1246 AND teamId = 1430
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 14108 AND teamId = 1430
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 2081 AND teamId = 1430
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 42898 AND teamId = 1430
0.0093  SELECT count(id) as num_players from rel_players WHERE league_id = 1906 AND teamId = 1430
0.0052  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1416 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0197  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1416 WHERE rp.league_id = 1416 AND rp.teamId = 1430 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1416 WHERE rp.league_id = 1416 AND rp.teamId = 1430 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0091  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2012 e ON e.player_id = p.id AND e.league_id = 1416 WHERE rp.league_id = 1416 AND rp.teamId = 1430 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 1430 AND rp.league_id = 1416 AND l.year= 2012 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0028  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=30912 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0020  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=30912
0.0032  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=30912 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0036  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=30912 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0037  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=30912 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0039   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=30912 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0037  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=30912 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0021  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 1416 ORDER BY nameShow LIMIT 100