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

Calamocha

Entrenador: Sergio Lagunas

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 Ejea Ejea 32 45 24 63
2 CD Ebro CD Ebro 32 45 22 60
3 CD Cuarte CD Cuarte 32 42 22 59
4 Caspe Caspe 32 41 31 58
5 CF Epila CF Epila 32 46 30 53
6 Calamocha Calamocha 32 36 26 49
7 Almudévar Almudévar 32 34 27 49
8 Fraga Fraga 32 48 37 47
9 CD Utrillas CD Utrillas 32 41 38 46
10 Huesca B Huesca B 32 38 33 45
11 Atlético Monzón Atlético 32 25 22 45
12 CDJ Tamarite Tamarite 32 48 51 40
13 CD Binéfar CD Binéfar 32 35 48 35
14 Fuentes Fuentes 32 33 44 34
15 CD Belchite 97 Belchite 32 31 47 29
16 Illueca Illueca 32 24 49 24
17 SD Borja SD Borja 32 14 39 22
18 CD Cariñena Cariñena 32 32 68 19
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 Robres Robres 30 48 29 60
2 Barbastro Barbastro 30 45 25 53
3 Huesca B Huesca B 30 54 33 51
4 Ejea Ejea 30 47 33 48
5 CDJ Tamarite Tamarite 30 44 41 48
6 Almudévar Almudévar 30 36 28 47
7 Illueca Illueca 30 37 38 47
8 CF Epila CF Epila 30 35 29 41
9 CD Utrillas CD Utrillas 30 33 38 39
10 Calamocha Calamocha 30 23 26 38
11 CD Binéfar CD Binéfar 30 42 38 37
12 Caspe Caspe 30 30 39 36
13 CD Cuarte CD Cuarte 30 27 34 35
14 Atlético Monzón Atlético 30 24 33 28
15 CD Cariñena Cariñena 30 34 65 24
16 CD La Almunia Almunia 30 34 64 22
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 Deportivo Aragón Deportivo 32 65 29 67
2 Utebo Utebo 32 63 28 66
3 Illueca Illueca 32 47 31 65
4 CD Binéfar CD Binéfar 32 54 30 56
5 Robres Robres 32 45 32 53
6 CD Cuarte CD Cuarte 32 46 27 52
7 Atlético Monzón Atlético 32 40 23 49
8 Barbastro Barbastro 32 36 29 48
9 Caspe Caspe 32 46 37 48
10 CF Epila CF Epila 32 39 37 48
11 CD Cariñena Cariñena 32 36 45 45
12 Calamocha Calamocha 32 36 40 36
13 CD Belchite 97 Belchite 32 35 43 33
14 Santa Anastasia CF Santa 32 31 40 33
15 SD Borja SD Borja 32 31 48 29
16 Giner Torrero Giner 32 23 97 18
17 Biescas Biescas 32 10 67 10
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 CD Teruel CD Teruel 22 34 11 49
2 Huesca B Huesca B 22 36 18 45
3 CD Belchite 97 Belchite 22 22 9 35
4 Deportivo Aragón Deportivo 22 32 14 34
5 Illueca Illueca 22 23 16 34
6 CD Binéfar CD Binéfar 22 29 17 32
7 Atlético Monzón Atlético 22 26 19 31
8 CD Cariñena Cariñena 22 21 23 27
9 CDJ Tamarite Tamarite 22 19 29 25
10 Valdefierro Valdefierro 22 20 36 22
11 Fraga Fraga 22 17 21 22
12 AD San Juan AD San Juan 22 0 66 0
13 Brea Brea 22 34 12 42
14 CD Cuarte CD Cuarte 22 32 21 39
15 Utebo Utebo 22 21 15 37
16 Barbastro Barbastro 22 27 18 36
17 SD Borja SD Borja 22 29 23 31
18 Calamocha Calamocha 22 24 19 30
19 Sariñena Sariñena 22 36 36 29
20 CF Epila CF Epila 22 23 23 26
21 Robres Robres 22 23 31 26
22 Almudévar Almudévar 22 17 32 22
23 Villanueva CF Villanueva 22 16 39 18
24 Sabiñánigo Sabiñánigo 22 24 37 14
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 SD Tarazona SD Tarazona 28 58 20 65
2 CD Teruel CD Teruel 29 53 19 63
3 Brea Brea 29 41 23 54
4 Deportivo Aragón Deportivo 28 51 23 51
5 CD Cuarte CD Cuarte 28 39 32 50
6 AD San Juan AD San Juan 28 38 30 46
7 SD Borja SD Borja 28 37 29 45
8 Illueca Illueca 28 42 37 43
9 Sariñena Sariñena 29 36 32 43
10 CD Binéfar CD Binéfar 29 34 30 41
11 Barbastro Barbastro 29 35 33 39
12 Fraga Fraga 29 35 33 37
13 Utebo Utebo 29 37 41 32
14 Atlético Monzón Atlético 29 24 34 32
15 Robres Robres 29 31 39 28
16 CDJ Tamarite Tamarite 29 27 45 28
17 Calamocha Calamocha 28 32 48 27
18 CD Belchite 97 Belchite 29 21 35 26
19 Villanueva CF Villanueva 29 23 48 24
20 Valdefierro Valdefierro 28 22 56 22
21 Almudévar Almudévar 28 18 47 19
TEMPORADA 2018/2019
TERCERA DIVISIÓN GRUPO 17
Equipo PJ GF GC Puntos
1 SD Tarazona SD Tarazona 38 72 17 80
2 Illueca Illueca 38 60 34 72
3 Deportivo Aragón Deportivo 38 58 19 72
4 Sariñena Sariñena 38 51 30 71
5 SD Borja SD Borja 38 54 30 70
6 Utebo Utebo 38 50 31 67
7 Brea Brea 38 48 34 61
8 AD San Juan AD San Juan 38 44 30 58
9 Atlético Monzón Atlético 38 41 35 57
10 Almudévar Almudévar 38 42 42 50
11 CD Binéfar CD Binéfar 38 45 50 47
12 Calamocha Calamocha 38 41 55 46
13 Villanueva CF Villanueva 38 37 56 44
14 Robres Robres 38 38 46 43
15 CDJ Tamarite Tamarite 38 36 59 43
16 CD Belchite 97 Belchite 38 32 42 38
17 San Lorenzo Flumen Lorenzo 38 32 69 33
18 Sabiñánigo Sabiñánigo 38 33 55 32
19 CD La Almunia Almunia 38 38 71 31
20 Casetas Casetas 38 20 67 23
TEMPORADA 2017/2018
PREFERENTE ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 AD San Juan AD San Juan 34 69 26 74
2 Calamocha Calamocha 34 66 31 69
3 CD Mequinenza Mequinenza 34 64 34 62
4 Fuentes Fuentes 33 45 31 56
5 At. Calatayud Calatayud 34 59 48 56
6 CF Epila CF Epila 34 48 34 54
7 CD Cuarte CD Cuarte 34 59 40 52
8 Alcañiz Alcañiz 34 51 40 51
9 Andorra Andorra 34 51 44 49
10 Actur Pablo Iglesias Actur Pablo 34 56 47 48
11 Cella Cella 34 45 41 48
12 UD San José José 34 57 52 47
13 CD Utrillas CD Utrillas 34 46 54 42
14 Mores CD Mores CD 34 22 34 34
15 Teruel Teruel 33 24 74 25
16 Alfindén A.D Alfindén 34 32 65 24
17 Morata CD Morata CD 34 29 70 23
18 Atlético Escalerillas Atlético 34 24 82 21
TEMPORADA 2016/2017
PREFERENTE ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD La Almunia Almunia 34 74 29 75
2 Valdefierro Valdefierro 34 78 31 73
3 CD Utrillas CD Utrillas 34 61 36 56
4 At. Calatayud Calatayud 34 64 41 56
5 CF Villa De Alagón Villa 34 46 33 54
6 Calamocha Calamocha 34 51 34 53
7 Fuentes Fuentes 34 54 45 53
8 Casetas Casetas 34 65 46 49
9 Mallén Mallén 34 51 55 48
10 Morata CD Morata CD 34 56 58 43
11 Cella Cella 34 32 40 43
12 Gallur CD Gallur CD 34 34 42 42
13 Hernán Cortés Junquera Hernán 34 43 55 41
14 Zaragoza 2014 Zaragoza 34 58 74 41
15 Quinto Quinto 34 30 38 40
16 Fuensport Fuensport 34 37 67 35
17 Sadabense CD Sadabense 34 33 85 23
18 Alcorisa Alcorisa 34 35 93 17
TEMPORADA 2015/2016
PREFERENTE ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CF Epila CF Epila 34 78 28 75
2 Brea Brea 34 73 33 74
3 UD San José José 34 62 41 59
4 Casetas Casetas 34 51 35 58
5 Fuentes Fuentes 34 54 44 58
6 UD Montecarlo Montecarlo 34 58 36 55
7 Cella Cella 34 50 37 55
8 CD Utrillas CD Utrillas 34 57 43 55
9 Calamocha Calamocha 34 53 38 55
10 Morata CD Morata CD 34 48 37 50
11 Mallén Mallén 34 57 47 50
12 CD La Almunia Almunia 34 53 48 45
13 Gallur CD Gallur CD 34 43 58 41
14 Quinto Quinto 34 38 43 39
15 Tauste CD Tauste CD 34 37 71 28
16 Villanueva B Villanueva 34 40 88 20
17 Pedrola Pedrola 34 20 93 16
18 San Gregorio Arrabal Gregorio 34 44 96 12
TEMPORADA 2014/2015
PREFERENTE ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Cariñena Cariñena 34 82 33 73
2 CD Belchite 97 Belchite 34 57 22 71
3 CD La Almunia Almunia 34 61 32 67
4 Brea Brea 34 59 44 56
5 Cella Cella 34 50 33 55
6 CD Utrillas CD Utrillas 34 53 46 55
7 CF Epila CF Epila 34 51 42 50
8 Casetas Casetas 34 56 45 48
9 Calamocha Calamocha 34 42 48 46
10 Giner Torrero Giner 34 49 48 44
11 Alcañiz Alcañiz 34 51 53 43
12 Morata CD Morata CD 34 43 56 43
13 Fuentes Fuentes 34 51 47 42
14 At. Calatayud Calatayud 34 48 50 41
15 Actur Pablo Iglesias Actur Pablo 34 45 55 41
16 AD Magallon AD Magallon 34 43 77 30
17 Atlético Albalate Atlético 34 32 71 21
18 CD Calanda CD Calanda 34 28 99 19
TEMPORADA 2013/2014
PREFERENTE ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 RSD Santa Isabel Santa Isabel 34 69 16 74
2 Caspe Caspe 34 75 22 72
3 CD La Almunia Almunia 34 53 27 72
4 Cella Cella 34 54 32 61
5 CD Belchite 97 Belchite 34 52 27 61
6 Calamocha Calamocha 34 52 44 58
7 CD Utrillas CD Utrillas 34 53 35 52
8 Fuentes Fuentes 34 48 45 50
9 UD San José José 34 51 49 47
10 Casetas Casetas 34 50 44 47
11 CD Cariñena Cariñena 34 50 44 45
12 Alcañiz Alcañiz 34 43 49 44
13 Giner Torrero Giner 34 38 47 40
14 Atlético Albalate Atlético 34 36 49 38
15 Quinto Quinto 34 37 54 32
16 CD A Mesa Puesta Mesa Puesta 34 41 76 31
17 CF Lécera 2022 Lécera 2022 34 27 92 14
18 CD Calatorao Calatorao 34 19 96 6
TEMPORADA 2011/2012
PREFERENTE ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SD Borja SD Borja 34 76 22 84
2 CD La Almunia Almunia 34 70 31 74
3 Mallén Mallén 34 60 34 71
4 Cella Cella 34 60 40 56
5 Illueca Illueca 34 62 39 54
6 CF Villa De Alagón Villa 34 61 41 53
7 Brea Brea 34 55 57 52
8 CD Belchite 97 Belchite 34 57 45 50
9 Calamocha Calamocha 34 35 50 42
10 San Gregorio Gregorio 34 45 65 39
11 CF Hernán Cortés Hernán 34 46 53 38
12 CD Utrillas CD Utrillas 34 46 57 38
13 Morata CD Morata CD 34 33 50 38
14 UD Valdefuentes Fs Valdefuentes 34 51 46 37
15 Actur Pablo Iglesias Actur Pablo 34 37 62 36
16 La Muela La Muela 34 50 69 32
17 Cd Daroca Cd Daroca 34 33 79 26
18 Cd Azuara Cd Azuara 34 31 68 21
TEMPORADA 2010/2011
PREFERENTE ARAGÓN GRUPO 2
Equipo PJ GF GC Puntos
1 CD Cuarte CD Cuarte 34 91 41 76
2 UD San José José 34 74 40 64
3 Atlético Escalerillas Atlético 34 63 40 64
4 Quinto Quinto 34 56 31 63
5 CD Belchite 97 Belchite 34 59 49 57
6 Illueca Illueca 34 49 39 57
7 CD La Almunia Almunia 34 44 32 56
8 Brea Brea 34 48 51 56
9 Alcañiz Alcañiz 34 61 53 52
10 Cd Daroca Cd Daroca 34 43 46 44
11 Fuentes Fuentes 34 49 55 43
12 CD Utrillas CD Utrillas 34 49 53 42
13 Peñas Oscenses Peñas 34 37 51 35
14 Calamocha Calamocha 34 52 71 35
15 Teruel B Teruel B 34 30 44 34
16 Cd Movera Cd Movera 34 34 69 28
17 Alcorisa Alcorisa 34 36 73 27
18 Monzalbarba Monzalbarba 34 33 70 19
TEMPORADA 2009/2010
PREFERENTE ARAGÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Ebro CD Ebro 34 78 22 84
2 Universidad de Zaragoza Universidad 34 83 17 81
3 SD Tarazona SD Tarazona 34 72 35 72
4 Oliver Oliver 34 49 49 57
5 Brea Brea 33 60 50 56
6 UD San José José 34 45 41 52
7 Calamocha Calamocha 34 56 55 51
8 Pedrola Pedrola 34 53 45 48
9 Teruel B Teruel B 34 42 52 46
10 Casetas Casetas 33 47 52 44
11 Illueca Illueca 34 45 56 44
12 CD La Almunia Almunia 34 42 50 43
13 Monzalbarba Monzalbarba 34 49 59 36
14 Alfindén A.D Alfindén 34 51 69 35
15 UD Montecarlo Montecarlo 34 41 57 32
16 Garrapinillos Garrapinillo 34 42 64 31
17 Cella Cella 34 38 82 24
18 Santa Anastasia CF Santa 34 47 85 21

  USO DE MEMORIA  
7,020,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1404
Total Execution Time  0.1416
  CADENA URL  
/historico/Calamocha
  GET DATOS  
$_GET['/historico/Calamocha']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0027  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 = 'Calamocha' 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.0018  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=3961 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=3961 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=3961 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3961 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3961 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (737351,822157,886617,978130,987209) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '3961' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '3961' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '3961' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72277 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=3961 AND l.year in (2023,2024,2025) 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 (72277,71432,68447) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72277 AND teamId = 3961
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68447 AND teamId = 3961
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3961
0.0038  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72277 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '3961' 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 = '3961' 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 = '3961' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033  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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 3961 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.0031  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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 3961 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 72277 WHERE rp.league_id = 72277 AND rp.teamId = 3961 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 3961 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72277 AND t.round = 32 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 `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 = 62401 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 58596 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 50285 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 44405 AND t.round = 38 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 `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 = 39350 AND t.round = 34 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 `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 = 33994 AND t.round = 34 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 = 16721 AND t.round = 34 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 = 4083 AND t.round = 34 ORDER BY team.conference 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 `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 = 2696 AND t.round = 34 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 `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 = 1478 AND t.round = 34 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 `tables2011` 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 = 1142 AND t.round = 34 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 `tables2010` 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 = 861 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 72277 ORDER BY nameShow LIMIT 100