4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Talleres Córdoba

Talleres Córdoba

Entrenador: Walter Ribonetto

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Argentinos Juniors Argentinos 0 0 0 0
2 Atl. Tucumán Atl. 0 0 0 0
3 Banfield Banfield 0 0 0 0
4 Barracas Central Barracas 0 0 0 0
5 Belgrano Belgrano 0 0 0 0
6 Boca Juniors Boca Juniors 0 0 0 0
7 CA Huracán CA Huracán 0 0 0 0
8 Central Córdoba Central 0 0 0 0
9 Defensa y Justicia Defensa 0 0 0 0
10 Dep. Riestra Dep. Riestra 0 0 0 0
11 Estudiantes La Plata Estudiantes 0 0 0 0
12 Gimnasia La Plata Gimnasia 0 0 0 0
13 Godoy Cruz Godoy Cruz 0 0 0 0
14 Indep. Rivadavia Indep. 0 0 0 0
15 Independiente Independient 0 0 0 0
16 Instituto Instituto 0 0 0 0
17 Lanús Lanús 0 0 0 0
18 Newell's Old Boys Newell's 0 0 0 0
19 Platense Platense 0 0 0 0
20 Racing Club Racing Club 0 0 0 0
21 River Plate River Plate 0 0 0 0
22 Rosario Central Rosario 0 0 0 0
23 San Lorenzo San Lorenzo 0 0 0 0
24 Sarmiento Sarmiento 0 0 0 0
25 Talleres Córdoba Talleres 0 0 0 0
26 Tigre Tigre 0 0 0 0
27 Unión Santa Fe Unión Santa 0 0 0 0
28 Vélez Sarsfield Vélez 0 0 0 0
TEMPORADA 2022/2023
COPA LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 CA Huracán CA Huracán 14 19 11 26
2 River Plate River Plate 14 24 16 24
3 Banfield Banfield 14 11 6 23
4 Rosario Central Rosario 14 17 13 23
5 Independiente Independient 14 15 11 23
6 Vélez Sarsfield Vélez 14 17 14 22
7 Instituto Instituto 14 11 7 20
8 Colón Colón 14 19 17 20
9 Talleres Córdoba Talleres 14 15 15 17
10 Atl. Tucumán Atl. 14 9 12 17
11 Gimnasia La Plata Gimnasia 14 13 21 15
12 Argentinos Juniors Argentinos 14 19 23 14
13 Barracas Central Barracas 14 10 21 14
14 Arsenal de Sarandí Arsenal 14 10 15 13
15 Racing Club Racing Club 14 22 16 24
16 Godoy Cruz Godoy Cruz 14 14 9 22
17 Belgrano Belgrano 14 20 18 21
18 Platense Platense 14 13 16 20
19 Central Córdoba Central 14 11 14 19
20 Newell's Old Boys Newell's 14 14 10 18
21 Boca Juniors Boca Juniors 14 17 16 18
22 San Lorenzo San Lorenzo 14 11 11 18
23 Estudiantes La Plata Estudiantes 14 11 13 17
24 Sarmiento Sarmiento 14 8 8 16
25 Unión Santa Fe Unión Santa 14 10 13 16
26 Defensa y Justicia Defensa 14 12 16 14
27 Tigre Tigre 14 8 13 13
28 Lanús Lanús 14 9 14 12
TEMPORADA 2021/2022
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 27 34 28 52
2 Racing Club Racing Club 27 41 24 50
3 River Plate River Plate 27 43 22 47
4 CA Huracán CA Huracán 27 35 21 47
5 Atl. Tucumán Atl. 27 32 22 46
6 San Lorenzo San Lorenzo 27 33 23 43
7 Tigre Tigre 27 41 32 43
8 Argentinos Juniors Argentinos 27 33 24 42
9 Gimnasia La Plata Gimnasia 27 26 18 41
10 Patronato Patronato 27 31 27 40
11 Newell's Old Boys Newell's 27 26 22 40
12 Defensa y Justicia Defensa 27 29 27 40
13 Talleres Córdoba Talleres 27 28 26 35
14 Independiente Independient 27 31 31 35
15 Godoy Cruz Godoy Cruz 27 25 29 35
16 Central Córdoba Central 27 34 37 34
17 Barracas Central Barracas 27 31 37 34
18 Estudiantes La Plata Estudiantes 27 28 40 33
19 Platense Platense 27 23 25 32
20 Rosario Central Rosario 27 24 28 32
21 Sarmiento Sarmiento 27 27 32 32
22 Unión Santa Fe Unión Santa 27 28 36 32
23 Arsenal de Sarandí Arsenal 27 28 29 30
24 Banfield Banfield 27 23 29 30
25 Colón Colón 27 24 36 29
26 Vélez Sarsfield Vélez 27 30 33 28
27 Lanús Lanús 27 22 40 21
28 Aldosivi Aldosivi 27 16 48 16
TEMPORADA 2020/2021
COPA LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Colón Colón 13 23 10 25
2 Estudiantes La Plata Estudiantes 13 16 10 22
3 River Plate River Plate 13 25 11 21
4 Racing Club Racing Club 13 14 12 21
5 San Lorenzo San Lorenzo 13 16 16 21
6 Banfield Banfield 13 14 12 20
7 Argentinos Juniors Argentinos 13 14 11 19
8 Rosario Central Rosario 13 16 18 18
9 Central Córdoba Central 13 14 17 17
10 Godoy Cruz Godoy Cruz 13 18 24 15
11 Platense Platense 13 12 19 14
12 Arsenal de Sarandí Arsenal 13 11 23 12
13 Aldosivi Aldosivi 13 15 21 11
14 Vélez Sarsfield Vélez 13 23 13 31
15 Boca Juniors Boca Juniors 13 22 12 22
16 Independiente Independient 13 16 10 20
17 Talleres Córdoba Talleres 13 19 16 20
18 Lanús Lanús 13 18 18 19
19 Unión Santa Fe Unión Santa 13 12 14 19
20 Atl. Tucumán Atl. 13 24 20 18
21 Gimnasia La Plata Gimnasia 13 15 20 15
22 CA Huracán CA Huracán 13 14 17 13
23 Patronato Patronato 13 12 17 12
24 Defensa y Justicia Defensa 13 15 21 12
25 Sarmiento Sarmiento 13 10 19 12
26 Newell's Old Boys Newell's 13 14 21 11
TEMPORADA 2019/2020
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 23 35 8 48
2 River Plate River Plate 23 41 18 47
3 Vélez Sarsfield Vélez 23 27 14 39
4 Racing Club Racing Club 23 28 23 39
5 Argentinos Juniors Argentinos 23 22 17 39
6 Defensa y Justicia Defensa 23 26 18 36
7 Lanús Lanús 23 32 29 36
8 San Lorenzo San Lorenzo 23 32 30 36
9 Rosario Central Rosario 23 31 29 36
10 Newell's Old Boys Newell's 23 33 25 35
11 Arsenal de Sarandí Arsenal 23 37 32 34
12 Talleres Córdoba Talleres 23 34 30 34
13 Estudiantes La Plata Estudiantes 23 23 22 30
14 Independiente Independient 23 27 25 29
15 Atl. Tucumán Atl. 23 22 25 29
16 Unión Santa Fe Unión Santa 23 21 30 27
17 Banfield Banfield 23 19 23 26
18 Central Córdoba Central 23 21 29 26
19 Gimnasia La Plata Gimnasia 23 22 23 23
20 Patronato Patronato 23 22 34 23
21 CA Huracán CA Huracán 23 17 27 22
22 Aldosivi Aldosivi 23 20 35 22
23 Colón Colón 23 17 39 18
24 Godoy Cruz Godoy Cruz 23 22 46 18
TEMPORADA 2018/2019
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Racing Club Racing Club 25 43 16 57
2 Defensa y Justicia Defensa 25 33 18 53
3 Boca Juniors Boca Juniors 25 42 18 51
4 River Plate River Plate 25 42 21 45
5 Atl. Tucumán Atl. 25 36 29 42
6 Vélez Sarsfield Vélez 25 34 25 40
7 Independiente Independient 25 35 28 38
8 Unión Santa Fe Unión Santa 25 29 24 36
9 Tigre Tigre 25 39 42 36
10 CA Huracán CA Huracán 25 28 28 35
11 Lanús Lanús 25 27 32 34
12 Talleres Córdoba Talleres 25 25 24 33
13 Aldosivi Aldosivi 25 21 24 33
14 Godoy Cruz Godoy Cruz 25 23 30 32
15 Newell's Old Boys Newell's 25 26 23 29
16 Banfield Banfield 25 27 31 29
17 Estudiantes La Plata Estudiantes 25 21 25 29
18 Gimnasia La Plata Gimnasia 25 21 32 29
19 Patronato Patronato 25 29 37 26
20 Rosario Central Rosario 25 16 26 26
21 San Martín San Juan Martín Juan 25 24 34 25
22 Belgrano Belgrano 25 16 23 24
23 San Lorenzo San Lorenzo 25 21 30 23
24 Colón Colón 25 21 33 23
25 San Martín Tucumán Martín 25 25 38 23
26 Argentinos Juniors Argentinos 25 15 28 22
TEMPORADA 2017/2018
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 27 50 22 58
2 Godoy Cruz Godoy Cruz 27 45 24 56
3 San Lorenzo San Lorenzo 27 31 20 50
4 CA Huracán CA Huracán 27 35 24 48
5 Talleres Córdoba Talleres 27 33 20 46
6 Independiente Independient 27 29 19 46
7 Racing Club Racing Club 27 46 32 45
8 River Plate River Plate 27 39 26 45
9 Defensa y Justicia Defensa 27 41 34 44
10 Unión Santa Fe Unión Santa 27 33 23 43
11 Colón Colón 27 32 22 41
12 Argentinos Juniors Argentinos 27 36 30 41
13 Belgrano Belgrano 27 29 28 40
14 Vélez Sarsfield Vélez 27 31 32 38
15 Atl. Tucumán Atl. 27 29 26 36
16 Estudiantes La Plata Estudiantes 27 25 26 36
17 Banfield Banfield 27 27 24 35
18 San Martín San Juan Martín Juan 27 30 36 33
19 Patronato Patronato 27 26 32 33
20 Rosario Central Rosario 27 30 41 32
21 Lanús Lanús 27 20 37 29
22 Newell's Old Boys Newell's 27 23 28 27
23 Gimnasia La Plata Gimnasia 27 28 43 27
24 Tigre Tigre 27 26 33 24
25 Temperley Temperley 27 22 46 23
26 Chacarita Juniors Chacarita 27 23 40 18
27 Arsenal de Sarandí Arsenal 27 19 36 17
28 Olimpo Olimpo 27 16 50 15
TEMPORADA 2016/2017
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 30 62 25 63
2 River Plate River Plate 30 51 28 56
3 Estudiantes La Plata Estudiantes 30 46 26 56
4 Racing Club Racing Club 30 51 40 55
5 Banfield Banfield 30 42 35 54
6 Independiente Independient 30 39 23 53
7 San Lorenzo San Lorenzo 30 46 35 53
8 Lanús Lanús 30 36 25 50
9 Newell's Old Boys Newell's 30 40 30 49
10 Defensa y Justicia Defensa 30 31 23 49
11 Colón Colón 30 32 25 49
12 Rosario Central Rosario 30 40 31 44
13 Gimnasia La Plata Gimnasia 30 26 24 43
14 Godoy Cruz Godoy Cruz 30 34 34 43
15 Talleres Córdoba Talleres 30 35 30 42
16 Olimpo Olimpo 30 37 32 38
17 Atletico Rafaela Atletico 30 31 30 37
18 Temperley Temperley 30 30 38 37
19 Vélez Sarsfield Vélez 30 31 40 37
20 Patronato Patronato 30 30 40 34
21 Atl. Tucumán Atl. 30 34 40 33
22 San Martín San Juan Martín Juan 30 27 40 33
23 Unión Santa Fe Unión Santa 30 25 39 32
24 Tigre Tigre 30 33 43 31
25 CA Huracán CA Huracán 30 23 30 29
26 Sarmiento Sarmiento 30 31 51 28
27 Arsenal de Sarandí Arsenal 30 27 50 27
28 Belgrano Belgrano 30 21 34 26
29 Quilmes Quilmes 30 18 43 25
30 Aldosivi Aldosivi 30 15 40 25
TEMPORADA 2015/2016
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 21 31 11 49
2 Chacarita Juniors Chacarita 21 30 12 43
3 Gimnasia Jujuy Gimnasia 21 26 16 38
4 Boca Unidos Boca Unidos 21 28 19 38
5 Villa Dálmine Villa 21 35 28 33
6 Crucero del Norte Crucero 21 26 25 32
7 Nueva Chicago Nueva 21 32 27 30
8 Guillermo Brown Guillermo 21 31 29 30
9 Los Andes Los Andes 21 21 22 30
10 Brown Adrogue Brown 21 27 26 28
11 JU Gualeguaychu Gualeguaychu 21 25 26 28
12 Almagro Almagro 21 23 25 28
13 Dep. Santamarina Dep. 21 16 19 27
14 All Boys All Boys 21 30 28 26
15 Ferro Carril Oeste Ferro Carril 21 21 27 26
16 Sportivo Estudiantes Sportivo 21 17 25 24
17 Juventud Universitario Juventud 21 20 23 22
18 Central Córdoba Central 21 23 27 21
19 Douglas Haig Douglas Haig 21 20 24 20
20 Indep. Rivadavia Indep. 21 14 26 20
21 Atlético Paraná Atlético 21 16 32 19
22 Instituto Instituto 21 18 33 16
TEMPORADA 2014/2015
TORNEO FEDERAL A TRANSICIÓN GRUPO 5
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 14 21 13 26
2 Unión Mar del Plata Unión Plata 14 21 13 26
3 Libertad Sunchales Libertad 14 22 16 23
4 Tiro Federal Rosario Tiro Federal 14 18 15 18
5 Defensores Belgrano VR Defensores 14 14 11 18
6 Independiente Chivilcoy Independient 14 11 18 16
7 Ferro General Pico Ferro 14 10 16 14
8 Alvarado Alvarado 14 7 22 5
TEMPORADA 2013/2014
PRIMERA NACIONAL
Equipo PJ GF GC Puntos
1 Banfield Banfield 42 71 40 78
2 Defensa y Justicia Defensa 42 67 45 75
3 Independiente Independient 42 49 37 67
4 CA Huracán CA Huracán 42 43 30 67
5 Atl. Tucumán Atl. 42 44 36 64
6 Instituto Instituto 42 54 46 62
7 Gimnasia Jujuy Gimnasia 42 41 35 61
8 Crucero del Norte Crucero 42 45 42 59
9 San Martín San Juan Martín Juan 42 49 52 57
10 Unión Santa Fe Unión Santa 42 48 48 55
11 Indep. Rivadavia Indep. 42 50 51 55
12 Sarmiento Sarmiento 42 45 47 55
13 Ferro Carril Oeste Ferro Carril 42 35 39 55
14 Boca Unidos Boca Unidos 42 43 46 54
15 Sportivo Belgrano Sportivo 42 39 40 53
16 Aldosivi Aldosivi 42 42 47 51
17 Douglas Haig Douglas Haig 42 35 44 51
18 Brown Adrogue Brown 42 45 50 50
19 Patronato Patronato 42 30 34 49
20 Talleres Córdoba Talleres 42 48 58 45
21 Almirante Brown Almirante 42 30 48 42
22 Villa San Carlos Villa Carlos 42 31 69 24
TEMPORADA 2012/2013
ARGENTINO A
Equipo PJ GF GC Puntos
1 Talleres Córdoba Talleres 24 42 23 46
2 Gimnasia y Tiro Gimnasia 24 36 26 42
3 San Martín Tucumán Martín 24 29 22 37
4 Sportivo Belgrano Sportivo 24 37 28 36
5 San Jorge Tucumán Jorge 24 25 35 36
6 Juventud Antoniana Juventud 24 20 18 35
7 Central Norte Central 24 33 29 33
8 Central Córdoba Central 24 32 28 33
9 Libertad Sunchales Libertad 24 22 28 29
10 Tiro Federal Rosario Tiro Federal 24 20 24 27
11 Guaraní A. Franco Guaraní 24 24 29 23
12 Alumni Villa Maria Alumni Villa 24 17 29 20
13 Racing Córdoba Racing 24 18 36 18
14 Dep. Santamarina Dep. 22 28 18 39
15 Juventud Universitario Juventud 22 28 23 35
16 Dep. Maipú Dep. Maipú 22 31 27 33
17 Racing Olavarría Racing 22 33 28 30
18 Gimnasia Conce… Gimnasia 22 26 27 30
19 Defensores Belgrano VR Defensores 22 19 22 30
20 Rivadavia Lincoln Rivadavia 22 32 36 29
21 Cipolletti Cipolletti 22 27 26 28
22 Alvarado Alvarado 22 20 21 28
23 Unión Mar del Plata Unión Plata 22 24 30 28
24 Guillermo Brown Guillermo 22 25 33 27
25 Sportivo Desamparados Sportivo 22 26 28 25
TEMPORADA 2011/2012
ARGENTINO A GRUPO 1
Equipo PJ GF GC Puntos
1 Crucero del Norte Crucero 24 31 21 41
2 San Martín Tucumán Martín 24 27 21 37
3 Sportivo Belgrano Sportivo 24 32 27 37
4 Talleres Córdoba Talleres 24 35 31 35
5 Racing Córdoba Racing 24 29 28 34
6 Central Córdoba Central 24 21 20 32
7 Tiro Federal Rosario Tiro Federal 24 26 28 32
8 Libertad Sunchales Libertad 24 30 25 31
9 Central Norte Central 24 24 25 31
10 Gimnasia y Tiro Gimnasia 24 27 30 31
11 Juventud Antoniana Juventud 24 28 27 30
12 Alumni Villa Maria Alumni Villa 24 23 32 21
13 Unión Sunchales Unión 24 16 34 20
14 Dep. Santamarina Dep. 22 37 20 38
15 Douglas Haig Douglas Haig 22 33 20 35
16 Racing Olavarría Racing 22 21 18 34
17 Unión Mar del Plata Unión Plata 22 27 26 32
18 Dep. Maipú Dep. Maipú 22 21 21 31
19 Huracán Tres Arroyos Huracán 22 22 27 28
20 Cipolletti Cipolletti 22 29 35 26
21 Gimnasia Conce… Gimnasia 22 20 27 25
22 Rivadavia Lincoln Rivadavia 22 25 31 24
23 Juventud Universitario Juventud 22 23 29 23
24 CAI CAI 22 22 37 21

  USO DE MEMORIA  
8,307,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2105
Total Execution Time  0.2117
  CADENA URL  
/historico/Talleres-Cordoba
  GET DATOS  
$_GET['/historico/Talleres-Cordoba']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (53)  
0.0130  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 = 'Talleres-Cordoba' AND l.year = 2024 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=6563 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6563 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=6563 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=6563 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=6563 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=6563 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=6563 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=6563 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 75395
0.0027  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6563 AND type_rel = 2
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6563 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (22574,33413,33997,35095,35271) ORDER BY n.cover_points DESC, update_date DESC
0.0049  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 = '6563' ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '6563' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 75640 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 = 75395 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=6563 AND l.year in (2023,2024,2025) 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 (75640,75395,75100,75056,74909,74880,71432) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 74880 AND teamId = 6563
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75056 AND teamId = 6563
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75640 AND teamId = 6563
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 74909 AND teamId = 6563
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75395 AND teamId = 6563
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6563
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75100 AND teamId = 6563
0.0022  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 = '6563' 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 = '6563' and rp.type = 4
0.0020  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 = '6563' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 75056 WHERE rp.league_id = 75056 AND rp.teamId = 6563 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.0019  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 events2024 e ON e.player_id = p.id AND e.league_id = 75056 WHERE rp.league_id = 75056 AND rp.teamId = 6563 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 75056 WHERE rp.league_id = 75056 AND rp.teamId = 6563 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 6563 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74880 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 75056 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 70411 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 70413 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66295 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 67703 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 61201 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 61219 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 49952 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 43555 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 38943 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 33424 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20209 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 16600 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 10882 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 3991 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 2501 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 2003 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 1655 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 1654 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC