4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Córdoba Patrimonio
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 28 105 70 55
2 Barça Barça 27 91 74 54
3 Jaén FS Jaén FS 28 89 66 51
4 Inter FS Inter FS 27 103 68 50
5 Palma Futsal Palma Futsal 28 101 91 47
6 Jimbee Cartagena Jimbee 27 81 73 45
7 Viña Albali Valdepeñas Viña Albali 28 94 84 42
8 Manzanares FS Manzanares 27 95 90 42
9 Industrias Santa Coloma Industrias 28 96 94 41
10 Peñíscola FS Peñíscola 27 100 95 32
11 Osasuna Magna Osasuna 27 71 83 31
12 Córdoba Patrimonio Córdoba 27 75 89 31
13 Noia Portus Apostoli Noia Portus 27 87 100 27
14 Ribera Navarra FS Ribera 28 73 90 24
15 Real Betis Futsal Real Betis. 28 73 122 24
16 Alzira FS Alzira FS 28 58 103 20
TEMPORADA 2022/2023
PRIMERA DIVISIÓN FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Palma Futsal Palma Futsal 30 120 81 65
2 Barça Barça 30 120 77 64
3 Jimbee Cartagena Jimbee 30 105 83 61
4 Jaén FS Jaén FS 30 110 68 60
5 ElPozo Murcia Costa Cálida ElPozo 30 92 70 52
6 Inter FS Inter FS 30 106 88 52
7 Viña Albali Valdepeñas Viña Albali 30 97 96 45
8 Noia Portus Apostoli Noia Portus 30 84 93 38
9 Industrias Santa Coloma Industrias 30 87 94 35
10 Manzanares FS Manzanares 30 80 98 34
11 Ribera Navarra FS Ribera 30 78 101 30
12 Real Betis Futsal Real Betis. 30 84 104 29
13 Córdoba Patrimonio Córdoba 30 87 111 29
14 Osasuna Magna Osasuna 30 59 82 29
15 CD UMA Antequera Antequera 30 74 100 29
16 Levante UD FS Levante 30 74 111 23
TEMPORADA 2021/2022
PRIMERA DIVISIÓN FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Barça Barça 30 122 63 68
2 Inter FS Inter FS 30 87 68 58
3 Palma Futsal Palma Futsal 30 78 55 58
4 Viña Albali Valdepeñas Viña Albali 30 91 81 56
5 Jimbee Cartagena Jimbee 30 99 70 55
6 Ribera Navarra FS Ribera 30 88 96 45
7 Jaén FS Jaén FS 30 85 73 44
8 ElPozo Murcia Costa Cálida ElPozo 30 87 72 43
9 Industrias Santa Coloma Industrias 30 90 78 42
10 Levante UD FS Levante 30 84 91 37
11 Córdoba Patrimonio Córdoba 30 90 91 36
12 Manzanares FS Manzanares 30 82 100 30
13 Osasuna Magna Osasuna 30 65 98 30
14 Real Betis Futsal Real Betis. 30 67 100 26
15 Sala 10 Zaragoza Sala 30 85 112 24
16 Burela FS Burela FS 30 62 114 14
TEMPORADA 2020/2021
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Murcia Costa Cálida ElPozo 34 108 79 68
2 Palma Futsal Palma Futsal 34 98 67 68
3 Barça Barça 34 109 63 66
4 Jimbee Cartagena Jimbee 34 134 93 64
5 Levante UD FS Levante 34 113 99 64
6 Inter FS Inter FS 34 121 84 57
7 Sala 10 Zaragoza Sala 34 108 104 48
8 Viña Albali Valdepeñas Viña Albali 34 107 91 47
9 Industrias Santa Coloma Industrias 34 95 89 47
10 Real Betis Futsal Real Betis. 34 86 101 46
11 Ribera Navarra FS Ribera 34 104 105 41
12 Osasuna Magna Osasuna 34 83 96 40
13 Córdoba Patrimonio Córdoba 34 80 90 40
14 Jaén FS Jaén FS 34 73 95 38
15 Burela FS Burela FS 34 102 120 38
16 Peñíscola FS Peñíscola 34 83 108 34
17 CD UMA Antequera Antequera 34 75 129 22
18 O Parrulo Ferrol Parrulo 34 80 146 20
TEMPORADA 2019/2020
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 23 96 51 56
2 Barça Barça 23 107 60 54
3 Viña Albali Valdepeñas Viña Albali 23 81 61 45
4 ElPozo Murcia Costa Cálida ElPozo 23 75 54 44
5 Palma Futsal Palma Futsal 23 64 38 43
6 Osasuna Magna Osasuna 23 83 67 39
7 Levante UD FS Levante 23 82 77 34
8 Jaén FS Jaén FS 23 66 70 33
9 Jimbee Cartagena Jimbee 23 67 74 27
10 O Parrulo Ferrol Parrulo 23 68 81 26
11 Peñíscola FS Peñíscola 23 70 72 26
12 Industrias Santa Coloma Industrias 23 61 83 25
13 Ribera Navarra FS Ribera 23 52 76 19
14 Córdoba Patrimonio Córdoba 23 51 89 17
15 Sala 10 Zaragoza Sala 23 63 86 15
16 Burela FS Burela FS 23 40 87 13
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 30 116 68 67
2 Real Betis Futsal Real Betis. 30 123 56 66
3 Atlético Mengíbar FS Atlético 30 109 65 62
4 Manzanares FS Manzanares 30 94 80 56
5 Barça Atlétic Barça 30 110 74 54
6 ElPozo Ciudad de Murcia ElPozo 30 111 73 53
7 Córdoba Patrimonio Córdoba 30 110 104 48
8 Santiago Futsal Santiago 30 99 88 45
9 Rivas Futsal Rivas Futsal 30 93 104 37
10 Noia Portus Apostoli Noia Portus 30 102 106 35
11 Bisontes Castellón FS Bisontes 30 66 98 33
12 Elche CF Sala Elche Sala 30 75 99 33
13 Full Energía Zaragoza Full 30 110 124 32
14 Soliss FS Talavera Soliss 30 93 129 29
15 Gran Canaria Gran Canaria 30 86 104 29
16 CD Salesianos Tenerife Salesianos 30 41 166 4
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 ElPozo Ciudad de Murcia ElPozo 30 131 84 61
2 Barça Atlétic Barça 30 122 70 60
3 Viña Albali Valdepeñas Viña Albali 30 114 72 60
4 Burela FS Burela FS 30 102 63 55
5 CD UMA Antequera Antequera 30 106 80 51
6 FSD Puertollano Puertollano 30 118 94 51
7 Real Betis Futsal Real Betis. 30 108 88 51
8 Rivas Futsal Rivas Futsal 30 110 91 48
9 Córdoba Patrimonio Córdoba 30 112 108 47
10 Bisontes Castellón FS Bisontes 30 82 99 40
11 Manzanares FS Manzanares 30 83 103 39
12 Atlético Mengíbar FS Atlético 30 81 90 38
13 Elche CF Sala Elche Sala 30 84 102 33
14 Noia Portus Apostoli Noia Portus 30 64 123 22
15 Prone Lugo FS Prone Lugo 30 64 125 18
16 Tenerife Iberia Toscal Tenerife 30 60 149 6
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Cerro de Reyes A Cerro Reyes 29 150 58 79
2 Córdoba Patrimonio Córdoba 29 160 92 73
3 Union África Ceutí Union 29 134 78 59
4 Xerez Deportivo Xerez 30 132 99 58
5 Peligros FS Peligros FS 30 153 105 52
6 Sporting Constitución FS Sporting 29 104 99 45
7 Villa del Río FS Villa Río 30 106 112 42
8 Victoria Kent Victoria 30 87 103 40
9 Coineña UDFS Coineña 30 138 122 39
10 CD Olimpic de Triana FS Olimpic 30 114 127 36
11 Real Betis Futsal B Real Betis. 30 99 120 34
12 CD Gador CD Gador 30 104 136 32
13 Infantes FS Infantes FS 29 92 127 31
14 Bujalance FS Bujalance 30 93 126 27
15 El Palo Pedregalejo Palo 30 79 144 16
16 Lucena FS Lucena FS 27 67 164 10
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B FUTSAL GRUPO 5
Equipo PJ GF GC Puntos
1 Atlético Mengíbar FS Atlético 24 105 42 68
2 Union África Ceutí Union 24 103 54 46
3 Córdoba Patrimonio Córdoba 23 103 83 42
4 Peligros FS Peligros FS 24 100 74 41
5 Lucena FS Lucena FS 23 82 66 41
6 Victoria Kent Victoria 24 69 82 34
7 Coineña UDFS Coineña 24 85 85 33
8 Caceres Malpartida FS Caceres 24 70 88 29
9 Villa del Río FS Villa Río 24 73 92 28
10 CD Olimpic de Triana FS Olimpic 25 86 115 23
11 Sporting Constitución FS Sporting 24 70 90 23
12 Bujalance FS Bujalance 25 79 94 23
13 Isleño San Fernando FS Isleño 24 30 90 13
TEMPORADA 2014/2015
TERCERA DIVISIÓN FUTSAL GRUPO 17
Equipo PJ GF GC Puntos
1 Córdoba Patrimonio Córdoba 26 166 73 61
2 Aquasierra Aquasierra 26 140 80 61
3 Fs Pozoblanco Futsal Pozoblanco 26 123 107 43
4 Social Energy Alcalá FS Social 26 93 92 43
5 CD Villalba FS Villalba 26 109 106 40
6 Isleño Isleño 26 105 98 38
7 Puebla Infantes Puebla 26 108 125 36
8 UD Alchoyano FS Alchoyano 26 100 112 34
9 La Muralla La Muralla 26 78 102 33
10 Nazareno Dos Hermanas FS Nazareno 26 91 91 30
11 La Palma La Palma 26 76 98 30
12 Ciudad De Ceuta Ciudad Ceuta 26 92 125 29
13 Portuense Portuense 26 88 111 25
14 Tres Calles Tres Calles 26 90 139 18

  USO DE MEMORIA  
6,192,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5748
Total Execution Time  0.5762
  CADENA URL  
/historico/Itea-Automatismos-Fs
  GET DATOS  
$_GET['/historico/Itea-Automatismos-Fs']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0135  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 = 'Itea-Automatismos-Fs' 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=83478 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=83478 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=83478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 73234
0.0130  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 = 74080
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83478 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 83478 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (473606,523532,528931,553308,583801) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '83478' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '83478' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '83478' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = 74080 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 73234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=83478 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74080,73234) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73234 AND teamId = 83478
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 83478
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 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 = 73234 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '83478' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '83478' and rp.type = 4
0.0126  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 = '83478' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 83478 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.0127  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 83478 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73234 WHERE rp.league_id = 73234 AND rp.teamId = 83478 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 83478 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73234 AND t.round = 28 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 `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 = 68486 AND t.round = 30 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 `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 = 58753 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.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 `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 = 50469 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.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 `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 = 44362 AND t.round = 30 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 = 39113 AND t.round = 30 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 = 35142 AND t.round = 30 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 `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 = 20046 AND t.round = 26 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 = 5419 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 73234 ORDER BY nameShow LIMIT 100