4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cabezuela
TEMPORADA 2023/2024
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Cabezuela Cabezuela 24 84 34 60
2 Piornal Piornal 24 80 23 59
3 Nuevo Caceres Nuevo San Fra Nuevo 24 61 22 52
4 UD Aceituna UD Aceituna 24 58 33 48
5 Brocense Brocense 24 64 41 43
6 CP Navaconcejo Navaconcejo 23 48 40 35
7 Las Hurdes CF Hurdes 24 61 49 34
8 CF Jerte CF Jerte 23 49 46 28
9 CD Coria B CD Coria B 24 49 52 26
10 CF Verato CF Verato 24 51 96 21
11 Norte de Extremadura Norte 24 43 80 17
12 Atletico Tietar Atletico 24 30 89 16
13 Cacereño Atlético Veracruz Cacereño 24 25 98 7
TEMPORADA 2022/2023
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Torreorgaz Torreorgaz 21 74 13 52
2 Torrejoncillo Torrejoncill 22 38 28 46
3 Piornal Piornal 22 54 29 44
4 Las Hurdes CF Hurdes 21 47 23 44
5 Cabezuela Cabezuela 22 47 28 40
6 CF Jerte CF Jerte 22 59 45 34
7 CD Coria B CD Coria B 22 40 34 33
8 Brocense Brocense 22 43 45 26
9 UD Aceituna UD Aceituna 22 33 42 19
10 CF Verato CF Verato 21 34 69 10
11 Atletico Tietar Atletico 22 18 66 10
12 Norte de Extremadura Norte 21 20 85 7
TEMPORADA 2021/2022
1ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Montehermoso Montehermoso 22 50 11 49
2 Moraleja Moraleja 22 56 19 45
3 CF Jaraíz CF Jaraíz 22 44 14 44
4 Amanecer Amanecer 22 39 25 42
5 Talayuela Talayuela 22 29 18 41
6 CF Caceres CF Caceres 22 34 24 31
7 Chinato Chinato 22 28 30 30
8 AD Valdefuentes Valdefuentes 22 35 40 26
9 Ciudad De Plasencia Ciudad 22 25 42 24
10 Malpartida Malpartida 22 22 40 17
11 Piornal Piornal 22 19 60 15
12 Cabezuela Cabezuela 22 15 73 8
TEMPORADA 2020/2021
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Cabezuela Cabezuela 14 34 17 33
2 CF Casar de Caceres Sotobos Casar 14 32 12 29
3 Navalmoral Navalmoral 14 18 25 22
4 CP Navaconcejo Navaconcejo 13 32 22 21
5 Torrejoncillo Torrejoncill 13 17 13 21
6 AD Puente San Francisco Puente 13 17 31 12
7 Cacereño Atlético Veracruz Cacereño 14 20 27 11
8 Cumbreño Cumbreño 13 11 34 7
TEMPORADA 2019/2020
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 CF Caceres CF Caceres 20 43 12 42
2 Cumbreño Cumbreño 20 40 41 39
3 Ciudad De Plasencia Ciudad 20 41 29 34
4 AD San Jorge Jorge 20 48 35 31
5 Cacereño Atlético Veracruz Cacereño 20 38 38 30
6 Navalmoral Navalmoral 20 34 27 28
7 Ad Casar De Cáceres Casar 20 40 37 28
8 CD Almoharín Almoharín 19 31 28 27
9 Cabezuela Cabezuela 20 40 38 27
10 Brocense Brocense 20 34 39 27
11 Torrejoncillo Torrejoncill 20 19 22 26
12 Hervas A Hervas A 19 28 32 23
13 Atletico Tietar Atletico 20 28 43 19
14 Nuevo Plasencia Nuevo 20 12 55 4
TEMPORADA 2018/2019
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 CF Caceres CF Caceres 24 61 23 53
2 CF Jaraíz CF Jaraíz 24 80 21 52
3 Hervas A Hervas A 24 53 29 46
4 Cabezuela Cabezuela 24 52 32 44
5 Atletico Tietar Atletico 24 49 41 40
6 Navalmoral Navalmoral 23 44 35 37
7 Imperio De Alcuescar A Imperio 24 38 50 31
8 Brocense Brocense 24 39 48 28
9 Ad Casar De Cáceres Casar 24 26 37 28
10 Nuevo Plasencia Nuevo 24 45 52 25
11 Cumbreño Cumbreño 23 32 53 24
12 CD Almoharín Almoharín 24 25 50 20
13 Valencia de Alcantara A Valencia 24 20 93 7
TEMPORADA 2017/2018
2ª REGIONAL EXTREMADURA GRUPO 1
Equipo PJ GF GC Puntos
1 Imperio De Alcuescar A Imperio 21 44 25 41
2 Brocense Brocense 22 39 34 39
3 CF Jaraíz CF Jaraíz 22 34 27 38
4 AD Valdefuentes Valdefuentes 22 47 35 36
5 Nuevo Plasencia Nuevo 22 43 29 35
6 Amanecer B Amanecer B 22 41 35 32
7 Cabezuela Cabezuela 22 40 32 31
8 CD Almoharín Almoharín 21 30 31 29
9 Cumbreño Cumbreño 22 38 44 25
10 Navalmoral Navalmoral 22 29 52 21
11 Atletico Tietar Atletico 20 23 46 19
12 Hervas A Hervas A 22 29 47 17
TEMPORADA 2016/2017
2ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 Malpartida Malpartida 22 68 29 48
2 Hervas A Hervas A 21 57 31 45
3 Piornal Piornal 22 66 25 44
4 AD Valdefuentes Valdefuentes 22 46 32 41
5 Cabezuela Cabezuela 22 45 47 35
6 CP Cumbreño A Cumbreño 22 45 40 32
7 Brocense Brocense 22 35 46 31
8 Imperio De Alcuescar A Imperio 21 43 33 30
9 CD Almoharín Almoharín 22 40 47 25
10 CD Ciconia Negra Ciconia 22 29 53 18
11 Peraleda de la Mata Peraleda 21 24 47 17
12 CD At. San José Obrero A José Obrero 21 17 85 6
TEMPORADA 2014/2015
1ª REGIONAL EXTREMADURA GRUPO 4
Equipo PJ GF GC Puntos
1 CF Jaraíz CF Jaraíz 20 48 18 41
2 Hervas A Hervas A 20 50 29 39
3 Las Hurdes CF Hurdes 20 46 29 38
4 Brocense Brocense 20 43 29 37
5 Piornal Piornal 20 43 26 33
6 Torreorgaz Torreorgaz 20 36 37 28
7 UDA A UDA A 20 44 49 26
8 AD Valdefuentes Valdefuentes 20 34 40 23
9 Losareño A Losareño A 20 43 71 20
10 Peraleda de la Mata Peraleda 20 25 52 16
11 Cabezuela Cabezuela 20 30 62 11
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Cd Burguillos Burguillos 38 81 26 85
2 Villafranca Villafranca 38 83 16 84
3 CD Don Benito Benito 38 76 18 83
4 Extremadura B Extremadura 38 61 28 71
5 Valdelacalzada Valdelacalza 38 63 35 71
6 Merida B Merida B 38 67 27 70
7 Diter Zafra Diter Zafra 38 52 25 68
8 CD Badajoz B Badajoz 38 59 37 66
9 CD Coria CD Coria 38 57 55 59
10 Monesterio Monesterio 38 39 36 55
11 Guareña Guareña 38 50 52 50
12 Villanovense Villanovense 37 38 46 49
13 Cacereño B Cacereño B 38 47 74 40
14 Olivenza Olivenza 38 47 68 39
15 UC La Estrella Estrella 38 36 60 38
16 Santa Amalia Santa Amalia 38 36 62 38
17 Castuera Castuera 38 39 69 36
18 Guadiana Guadiana 38 39 90 27
19 Valencia de Alcantara Valencia 38 24 83 20
20 Cabezuela Cabezuela 37 19 106 10
TEMPORADA 1991/1992
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Plasencia Plasencia 38 86 18 62
2 CP Cacereño Cacereño 38 89 21 58
3 Moralo Moralo 38 59 22 58
4 CD Don Benito Benito 38 84 17 58
5 Formación Cristiana Extrema Formación 38 73 43 47
6 Merida B Merida B 38 66 40 46
7 UD Montijo UD Montijo 38 55 34 44
8 AD Llerenense Llerenense 38 50 44 41
9 CD Badajoz Promesas Badajoz 38 59 48 39
10 Miajadas Miajadas 38 48 42 39
11 UC La Estrella Estrella 38 45 50 36
12 Castuera Castuera 38 45 65 36
13 Diter Zafra Diter Zafra 38 42 57 35
14 Villafranca Villafranca 38 42 56 33
15 CD Azuaga CD Azuaga 38 36 62 30
16 CD San Serván Serván 38 42 71 30
17 Talayuela Talayuela 38 41 64 28
18 Cabezuela Cabezuela 38 40 98 16
19 Orellana Orellana 38 26 82 15
20 Racing Valverdeño Racing 38 25 119 9
TEMPORADA 1988/1989
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 Mérida CP Mérida CP 80 244 42 142
2 CF Extremadura Extremadura 80 210 34 138
3 CP Cacereño Cacereño 80 178 42 124
4 Puebla Patria Puebla 80 140 90 96
5 Vasco Núñez Vasco 80 154 104 90
6 CD Villanovense Villanovense 80 106 92 88
7 Villafranca Villafranca 80 128 96 88
8 Diter Zafra Diter Zafra 80 112 94 86
9 Moralo Moralo 80 140 112 84
10 UC La Estrella Estrella 80 124 104 82
11 UD Montijo UD Montijo 80 140 122 82
12 CD Badajoz Promesas Badajoz 80 146 132 78
13 Sanvicenteño Sanvicenteñ 80 122 152 76
14 Orellana Orellana 80 102 118 76
15 Malpartida Malpartida 80 112 166 72
16 Peñarroya Pueblonuevo Peñarroya 80 102 134 68
17 Cabezuela Cabezuela 80 108 208 52
18 CD Coria CD Coria 80 72 136 50
19 Racing Valverdeño Racing 80 88 224 46
20 UD Fuente de Cantos Fuente 80 66 242 32
21 Monteresma Atalaya Monteresma 80 48 198 30
TEMPORADA 1987/1988
TERCERA DIVISIÓN GRUPO 14
Equipo PJ GF GC Puntos
1 CD Don Benito Benito 38 84 28 57
2 Mérida CP Mérida CP 38 73 17 57
3 CF Extremadura Extremadura 38 93 20 55
4 Moralo Moralo 38 61 37 52
5 Puebla Patria Puebla 38 66 36 47
6 UD Montijo UD Montijo 38 74 54 47
7 Vasco Núñez Vasco 38 69 53 46
8 CD Badajoz Promesas Badajoz 38 58 56 41
9 Diter Zafra Diter Zafra 38 53 53 41
10 UC La Estrella Estrella 38 54 38 41
11 CD Villanovense Villanovense 38 45 37 39
12 CD Coria CD Coria 38 47 67 35
13 Monteresma Atalaya Monteresma 38 48 69 34
14 Cabezuela Cabezuela 38 52 75 33
15 Sanvicenteño Sanvicenteñ 38 41 51 31
16 UD Fuente de Cantos Fuente 38 46 70 30
17 Peñarroya Pueblonuevo Peñarroya 38 48 82 23
18 Cd La Albuera Albuera 38 23 86 20
19 CD Azuaga CD Azuaga 38 38 93 18
20 EMD Aceuchal Aceuchal 38 18 69 13

  USO DE MEMORIA  
6,231,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5506
Total Execution Time  0.5518
  CADENA URL  
/historico/Cabezuela-Infantil
  GET DATOS  
$_GET['/historico/Cabezuela-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0134  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 = 'Cabezuela-Infantil' 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.0125  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=30062 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=30062 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30062 AND type_rel = 2
0.0129  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 = '30062' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '30062' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '30062' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73795 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=30062 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (73795) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73795 AND teamId = 30062
0.0127  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 = '30062' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30062' and rp.type = 4
0.0127  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 = '30062' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0135  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 = 73795 WHERE rp.league_id = 73795 AND rp.teamId = 30062 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.0135  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 = 73795 WHERE rp.league_id = 73795 AND rp.teamId = 30062 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 73795 WHERE rp.league_id = 73795 AND rp.teamId = 30062 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 30062 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 73795 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 69354 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.0130  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 = 63716 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.0127  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 = 59815 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.0129  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 = 51341 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 45372 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 39812 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 37079 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 5201 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0257  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 `tables1999` 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 = 22011 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0257  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 `tables1992` 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 = 21872 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0258  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 `tables1989` 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 = 21808 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0253  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 `tables1988` 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 = 21789 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC