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 Sporting Braga

Enviar Datos
Información
  • Nombre del equipo Sporting Braga
  • Nombre completo Sporting Clube Braga
  • Nombre corto SPB
  • País Portugal
  • Ciudad Braga
  • Entrenador Rui Duarte
  • URL del equipo en RF //m.resultados-futbol.com/Sporting-Braga
Otros Datos
  • Año de Fundación 1921
  • Patrocinador Forum Braga.com
  • Equipo Filial Sporting Braga II
  • Marca de Ropa Lacatoni
Internet

Información sobre el estadio

  • Nombre del estadio Estádio Municipal de Braga
  • Capacidad 30286
  • Dirección Avenida do Estádio
  • Teléfono 253206860
  • Fax 253612929
  • Año de construcción 2003
Estádio Municipal de Braga

Histórico de participación

Liga Portuguesa
68 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, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1970, 1969, 1968, 1967, 1966, 1965, 1961, 1960, 1959, 1958, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948)
Taça de Portugal
60 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, 1998, 1997, 1995, 1993, 1992, 1991, 1989, 1988, 1986, 1985, 1983, 1982, 1981, 1979, 1978, 1977, 1975, 1970, 1968, 1967, 1966, 1965, 1961, 1960, 1959, 1958, 1956, 1955, 1954, 1953, 1952, 1951, 1949, 1948, 1943)
Europa League Grupo 0
27 veces
(2024, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2018, 2018, 2017, 2016, 2016, 2012, 2012, 2011, 2009, 2009, 2008, 2008, 2007, 2007, 2006, 2005, 1998, 1985, 1979)
Copa de la Liga Portugal Grupo 0
21 veces
(2024, 2024, 2023, 2023, 2022, 2021, 2020, 2020, 2019, 2019, 2018, 2017, 2017, 2016, 2016, 2015, 2014, 2013, 2012, 2010, 2008)
Partidos Amistosos
17 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2006, 2005, 2004)
Fase Previa Europa League Grupo 5
9 veces
(2020, 2020, 2019, 2018, 2018, 2014, 2012, 2010, 2009)
Fases Previas Copa de la Liga
7 veces
(2018, 2017, 2014, 2013, 2012, 2011, 2009)
Fase Previa Champions League Grupo 5
5 veces
(2024, 2024, 2013, 2011, 2011)
Supercopa Portugal
4 veces
(2022, 2017, 1999, 1983)
Champions League Grupo 3
3 veces
(2024, 2013, 2011)
Recopa de Europa
3 veces
(1999, 1983, 1967)
Trofeo Ramón de Carranza
1 vez
(2006)
Conference League Grupo 0
1 vez
(2023)
Copa Intertoto
1 vez
(2009)
Trofeo Teresa Herrera
1 vez
(2016)

Partidos del Sporting Braga

Ir al LIVESCORE
Europa League Europa League »
26 Feb 20  Finalizado Sporting Braga
0 - 1
 Rangers FC 370
20 Feb 20  Finalizado Rangers FC
3 - 2
 Sporting Braga 117
12 Dic 19  Finalizado Slovan Bratislava
2 - 4
 Sporting Braga 39
28 Nov 19  Finalizado Sporting Braga
3 - 3
 Wolves 58
07 Nov 19  Finalizado Sporting Braga
3 - 1
 BeşiktaşTarjeta Roja 23
24 Oct 19  Finalizado Beşiktaş
1 - 2
 Sporting Braga 52
03 Oct 19  Finalizado Sporting Braga
2 - 2
 Slovan Bratislava 37
19 Sep 19  Finalizado Wolves
0 - 1
 Sporting Braga 100
Liga Portuguesa Liga Portuguesa »
25 Jul 20  Finalizado Sporting Braga
2 - 1
 Porto 108
20 Jul 20  Finalizado Tarjeta RojaTondela
1 - 0
 Sporting Braga 64
15 Jul 20  Finalizado Sporting Braga
1 - 1
 Belenenses SAD 82
10 Jul 20  Finalizado Paços de Ferreira
1 - 5
 Sporting Braga 37
04 Jul 20  Finalizado Sporting Braga
4 - 0
 Desportivo Aves 43
30 Jun 20  Finalizado Rio Ave
4 - 3
 Sporting BragaTarjeta Roja 99
25 Jun 20  Finalizado Sporting Braga
3 - 2
 Vitória Guimarães 29
19 Jun 20  Finalizado Tarjeta RojaFamalicão
0 - 0
 Sporting Braga 27
13 Jun 20  Finalizado Sporting Braga
0 - 1
 Boavista 68
05 Jun 20  Finalizado CD Santa Clara
3 - 2
 Sporting BragaTarjeta Roja 50
06 Mar 20  Finalizado Sporting Braga
3 - 1
 Portimonense 29
01 Mar 20  Finalizado Marítimo
1 - 2
 Sporting Braga 23
23 Feb 20  Finalizado Sporting Braga
3 - 1
 Vitória Setúbal 43
15 Feb 20  Finalizado Benfica
0 - 1
 Sporting BragaTarjeta Roja 65
08 Feb 20  Finalizado Tarjeta RojaSporting Braga
2 - 2
 Gil Vicente 15
02 Feb 20  Finalizado Sporting Braga
1 - 0
 Sporting CP 31
29 Ene 20  Finalizado Moreirense
1 - 2
 Sporting BragaTarjeta Roja 10
17 Ene 20  Finalizado Porto
1 - 2
 Sporting Braga 188
12 Ene 20  Finalizado Sporting Braga
2 - 1
 Tondela 86
04 Ene 20  Finalizado Tarjeta RojaBelenenses SAD
1 - 7
 Sporting Braga 15
15 Dic 19  Finalizado Sporting Braga
0 - 1
 Paços de Ferreira 77
07 Dic 19  Finalizado Desportivo Aves
1 - 0
 Sporting Braga 84
02 Dic 19  Finalizado Sporting Braga
2 - 0
 Rio Ave 68
10 Nov 19  Finalizado Vitória Guimarães
0 - 2
 Sporting Braga 6
03 Nov 19  Finalizado Sporting Braga
2 - 2
 Famalicão 85
31 Oct 19  Finalizado Boavista
2 - 0
 Sporting Braga 68
28 Oct 19  Finalizado Sporting Braga
2 - 0
 CD Santa Clara 126
29 Sep 19  Finalizado Portimonense
0 - 1
 Sporting Braga 18
23 Sep 19  Finalizado Sporting Braga
2 - 2
 MarítimoTarjeta Roja 163
13 Sep 19  Finalizado Vitória Setúbal
1 - 0
 Sporting BragaTarjeta Roja 36
01 Sep 19  Finalizado Sporting Braga
0 - 4
 Benfica 34
25 Ago 19  Finalizado Gil Vicente
1 - 1
 Sporting Braga 35
18 Ago 19  Finalizado Sporting CP
2 - 1
 Sporting Braga 32
11 Ago 19  Finalizado Sporting Braga
3 - 1
 Moreirense 24
Taça de Portugal Taça de Portugal »
18 Dic 19  Finalizado Benfica
2 - 1
 Sporting Braga 15
23 Nov 19  Finalizado Sporting Braga
1 - 0
 Gil Vicente 5
19 Oct 19  Finalizado Leça FC
1 - 3
 Sporting Braga 1
Partidos Amistosos Partidos Amistosos »
25 Jul 19  Finalizado Sporting Braga
2 - 2
 Tondela 5
24 Jul 19  Finalizado Sporting Braga
0 - 0
 Monaco 15
19 Jul 19  Finalizado Sporting Braga
0 - 2
 Lille 16
18 Jul 19  Finalizado Marítimo
0 - 0
 Sporting Braga 0
16 Jul 19  Finalizado Millwall
1 - 2
 Sporting Braga 3
16 Jul 19  Aplazado Sporting Braga
-
 Al-Duhail 0
13 Jul 19  Finalizado Portimonense
0 - 1
 Sporting Braga 12
09 Jul 19  Finalizado Sporting Braga
5 - 1
 Varzim 15
06 Jul 19  Finalizado Sporting Braga
4 - 1
 UD Oliveirense 0
Fase Previa Europa League Fase Previa Europa League »
29 Ago 19  Finalizado Spartak Moskva
1 - 2
 Sporting Braga 49
22 Ago 19  Finalizado Sporting Braga
1 - 0
 Spartak Moskva 42
15 Ago 19  Finalizado Sporting Braga
3 - 1
 Brøndby IF 28
08 Ago 19  Finalizado Brøndby IF
2 - 4
 Sporting Braga 107
Copa de la Liga Portugal Copa de la Liga Portugal »
25 Ene 20  Finalizado Sporting Braga
1 - 0
 Porto 50
21 Ene 20  Finalizado Sporting Braga
2 - 1
 Sporting CPTarjeta RojaTarjeta Roja 38
22 Dic 19  Finalizado Paços de Ferreira
1 - 4
 Sporting Braga 2
13 Oct 19  Finalizado Sporting Braga
2 - 1
 Marítimo 5
07 Oct 19  Finalizado Penafiel
1 - 3
 Sporting Braga 37

Plantilla del Sporting Braga Temporada 2019/2020

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
82 41 pt 187 84 - - -
1 32 br 190 84 - - 2
12 29 pt 186 76 - - -
Defensa
41 24 fr 185 72 - - -
36 29 br 186 85 - 1 4
4 27 pt 192 86 3 - 6
92 24 ao 196 82 - - 3
2 32 pt 171 62 - 1 5
70 24 br 175 70 - - -
4 27 br 186 80 - - -
81 25 pt 181 72 - - 1
47 30 pt 172 65 1 - 12
34 34 br 187 79 1 2 6
6 38 pt 189 77 - 1 -
5 33 pt 184 80 - - 4
3 28 br 192 84 - - 1
13 29 br 191 78 - - 3
Centrocampista
29 br 186 71 - - -
15 27 pt 174 62 - - 1
82 30 br 178 72 - - -
27 33 br 186 82 4 1 11
60 28 pt 190 82 2 - 9
17 30 pt 180 70 - 1 3
30 br 184 69 - - -
85 23 pt 185 75 - - -
Delantero
9 24 es 182 73 1 - -
32 br 190 73 - - -
11 34 pt 174 64 - - 1
89 24 gw 184 73 - - -
20 31 pt 187 88 17 - 4
21 29 pt 173 61 12 - 4
18 34 pt 180 73 4 - -
77 24 pt 184 70 8 - 1
90 26 br 179 72 6 - 6
7 33 ao 179 72 3 - 2

Noticias del Sporting Braga

Ver últimas noticias

El Olympiakos ficha a Felipe Pardo

BeSoccer - Domingo, 19 Julio 2015
0 447

Felipe Pardo (24), ya ex jugador del Sporting de Braga, acaba de firmar por el Olympiakos

Conceição, despedido por insultar al presidente

BeSoccer - Miércoles, 01 Julio 2015
0 160

El Sporting de Braga portugués anunció la rescisión del contrato de Sérgio Conceição por despido procedente, después de haberle abierto un proceso disciplinario por insultar y amenazar con agredir al presidente.

Joan Román, muy cerca del Sporting de Braga

BeSoccer - Lunes, 29 Junio 2015
0 148

En las próximas horas se podría hacer oficial el acuerdo entre el futbolista y el club portugués.

Juan Carlos Pérez, del Sporting de Braga, cedido al Málaga

BeSoccer - Martes, 23 Junio 2015
0 107

El centrocampista madrileño Juan Carlos Pérez, del Sporting de Braga portugués, se desplazó este martes a Málaga para cerrar su cesión por una temporada al equipo blanquiazul, tras el acuerdo al que llegaron hace unos días ambos clubes.

El extremo Juan Carlos llega cedido al Málaga por el Sporting de Braga

BeSoccer - Lunes, 22 Junio 2015
0 99

El extremo madrileño Juan Carlos Pérez jugará la próxima temporada en el Málaga CF cedido por el Sporting de Braga, club que tiene en propiedad su ficha y que en esta recién concluida campaña se lo cedió al Granada CF, ha informado hoy el club portugués.

Ver más noticias del equipo»



  USO DE MEMORIA  
7,042,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.2645
Total Execution Time  0.2669
  CADENA URL  
/sporting-braga/2020
  GET DATOS  
$_GET['/sporting-braga/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0018  SELECT type FROM routes WHERE alias = 'sporting-braga'
0.0049  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 = 'sporting-braga' AND l.year = 2020 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=2386 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=2386 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=2386 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=2386 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=2386 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=2386 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=2386 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=2386 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=2386 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=2386 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 = 49945
0.0026  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 = 51201
0.0029  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 = 51054
0.0026  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 = 51234
0.0026  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 = 53562
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 2
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2386 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (439,579,886,1200,3042) ORDER BY n.cover_points DESC, update_date DESC
0.0039  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 = '2386' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0036  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 = '2386' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 51054 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 51201 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 49945 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 53562 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  (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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 2386 or c.datateam2 = 2386) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0035  (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 calendars2020 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 = 2386 or c.datateam2 = 2386) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0035  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 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 = 2386 or c.datateam2 = 2386) AND l.year = 2020)
0.0042  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=2386 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (60338,60297,58721,57339,56547,51054) 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.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 57339 AND teamId = 2386
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 60338 AND teamId = 2386
0.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 58721 AND teamId = 2386
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 51054 AND teamId = 2386
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 60297 AND teamId = 2386
0.0190  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 2386
0.0024  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2386' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2386' and rp.type = 4
0.0023  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '2386' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0052  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 events2020 e ON e.player_id = p.id AND e.league_id = 49945 WHERE rp.league_id = 49945 AND rp.teamId = 2386 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.0042  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 events2020 e ON e.player_id = p.id AND e.league_id = 49945 WHERE rp.league_id = 49945 AND rp.teamId = 2386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 events2020 e ON e.player_id = p.id AND e.league_id = 49945 WHERE rp.league_id = 49945 AND rp.teamId = 2386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 2386 AND rp.league_id = 49945 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0046  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=6281692 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0021  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6281692
0.0085  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281692 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.0059  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281692 and (e.action = 4 or e.action = 5) 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281692 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0043   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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281692 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0065  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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6281692 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0020  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 = 49945 ORDER BY nameShow LIMIT 100