4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD UMA Antequera
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Sala 10 Zaragoza Sala 28 129 59 70
2 CD UMA Antequera Antequera 28 103 65 61
3 Burela FS Burela FS 28 93 59 56
4 Union África Ceutí Union 28 88 69 50
5 Full Energía Zaragoza Full 28 100 94 49
6 Inagroup El Ejido Inagroup 28 88 76 43
7 O Parrulo Ferrol Parrulo 28 99 88 40
8 Sala 5 Martorell Sala 28 83 90 40
9 Levante UD FS Levante 28 80 91 38
10 Ibiza Gasifred Ibiza 28 90 91 31
11 Melistar Futsal Melistar 28 67 88 30
12 Barça Atlétic Barça 28 68 80 27
13 CD Leganes FS Leganes 28 61 87 25
14 Real Betis Futsal B Real Betis. 28 59 97 23
15 Atlético Mengíbar FS Atlético 28 66 99 21
16 Bisontes Castellón FS Bisontes 28 50 91 21
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
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Noia Portus Apostoli Noia Portus 34 149 69 82
2 Peñíscola FS Peñíscola 34 122 82 64
3 CD UMA Antequera Antequera 34 123 100 62
4 Alzira FS Alzira FS 34 99 93 57
5 Atletico Benavente FS Atletico 34 152 146 54
6 Barça Atlétic Barça 34 148 120 52
7 Inagroup El Ejido Inagroup 34 95 87 52
8 Union África Ceutí Union 34 100 102 50
9 Full Energía Zaragoza Full 34 111 128 46
10 O Parrulo Ferrol Parrulo 34 106 119 45
11 Bisontes Castellón FS Bisontes 34 88 104 45
12 Real Betis Futsal B Real Betis. 34 122 118 44
13 CD Leganes FS Leganes 34 107 109 44
14 Atlético Mengíbar FS Atlético 34 109 115 42
15 Soliss FS Talavera Soliss 34 95 104 42
16 ETB Calvia - Palma Futsal Calvia Palma 34 112 126 35
17 Ciudad de Móstoles Ciudad 34 93 129 32
18 Club Inter Movistar FS Club Inter. 34 76 156 15
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
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Real Betis Futsal Real Betis. 23 83 47 50
2 CD UMA Antequera Antequera 23 82 43 45
3 Soliss FS Talavera Soliss 23 74 52 43
4 Manzanares FS Manzanares 23 67 56 43
5 Elche CF Sala Elche Sala 23 78 78 40
6 Ciudad de Móstoles Ciudad 23 73 63 33
7 ElPozo Ciudad de Murcia ElPozo 23 61 55 31
8 Noia Portus Apostoli Noia Portus 23 63 69 31
9 Atlético Mengíbar FS Atlético 23 60 61 30
10 Alzira FS Alzira FS 23 70 78 30
11 Barça Atlétic Barça 23 67 71 28
12 Union África Ceutí Union 23 58 65 26
13 Bisontes Castellón FS Bisontes 23 47 66 25
14 Santiago Futsal Santiago 23 42 59 22
15 Full Energía Zaragoza Full 23 82 103 22
16 Rivas Futsal Rivas Futsal 23 59 100 13
TEMPORADA 2018/2019
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Barça Barça 30 134 65 67
2 ElPozo Murcia Costa Cálida ElPozo 30 122 78 62
3 Osasuna Magna Osasuna 30 104 75 59
4 Inter FS Inter FS 30 125 66 57
5 Palma Futsal Palma Futsal 30 102 70 55
6 Jaén FS Jaén FS 30 94 81 49
7 Ribera Navarra FS Ribera 30 108 92 46
8 Levante UD FS Levante 30 105 99 45
9 Peñíscola FS Peñíscola 30 77 79 44
10 Jimbee Cartagena Jimbee 30 104 109 40
11 Sala 10 Zaragoza Sala 30 82 117 33
12 Industrias Santa Coloma Industrias 30 79 98 32
13 O Parrulo Ferrol Parrulo 30 80 116 27
14 Viña Albali Valdepeñas Viña Albali 30 83 136 22
15 Naturpellet Segovia Naturpellet 30 59 115 18
16 CD UMA Antequera Antequera 30 67 129 14
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 FUTSAL
Equipo PJ GF GC Puntos
1 Barça Atlétic Barça 26 122 65 59
2 Naturpellet Segovia Naturpellet 26 97 60 58
3 CD UMA Antequera Antequera 26 91 63 56
4 ElPozo Ciudad de Murcia ElPozo 26 99 73 51
5 Elche CF Sala Elche Sala 26 88 61 47
6 Viña Albali Valdepeñas Viña Albali 26 80 64 45
7 O Parrulo Ferrol Parrulo 26 83 73 43
8 Atlético Mengíbar FS Atlético 26 83 80 34
9 Real Betis Futsal Real Betis. 26 79 90 29
10 FSD Puertollano Puertollano 26 74 78 27
11 Rivas Futsal Rivas Futsal 26 89 103 26
12 Tenerife Iberia Toscal Tenerife 26 95 127 23
13 Prone Lugo FS Prone Lugo 26 49 116 8
14 Cidade De Narón Cidade 26 51 127 6
TEMPORADA 2015/2016
PRIMERA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Inter FS Inter FS 30 158 57 83
2 Barça Barça 30 157 78 74
3 ElPozo Murcia Costa Cálida ElPozo 30 130 81 63
4 Palma Futsal Palma Futsal 30 107 80 57
5 Ribera Navarra FS Ribera 30 91 75 52
6 Osasuna Magna Osasuna 30 111 85 48
7 Industrias Santa Coloma Industrias 30 129 125 44
8 Peñíscola FS Peñíscola 30 117 116 41
9 Burela FS Burela FS 30 92 108 40
10 Santiago Futsal Santiago 30 99 117 31
11 Sala 10 Zaragoza Sala 30 109 125 31
12 Jaén FS Jaén FS 30 86 111 28
13 Levante UD FS Levante 30 72 128 23
14 Jumilla B. Carchelo Jumilla 30 85 135 21
15 Elche CF Sala Elche Sala 30 75 156 17
16 CD UMA Antequera Antequera 30 97 138 17
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 CD UMA Antequera Antequera 26 135 84 54
2 Elche CF Sala Elche Sala 26 101 67 53
3 Barça Atlétic Barça 26 112 68 52
4 Brihuega F.S. Brihuega 26 96 72 50
5 Viña Albali Valdepeñas Viña Albali 26 93 75 45
6 C.D. La Escuela C.D. Escuela 26 92 85 41
7 Jimbee Cartagena Jimbee 26 100 81 39
8 Melilla FS Melilla FS 26 88 75 39
9 Gran Canaria Gran Canaria 26 95 91 39
10 ElPozo Ciudad de Murcia ElPozo 26 102 93 37
11 O Parrulo Ferrol Parrulo 26 74 104 25
12 Hércules San Vicente Hércules 26 65 77 23
13 FS Zamora Futsal Zamora 26 45 92 20
14 Sierra de Salinas Sierra 26 37 171 0
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Levante UD FS Levante 24 97 61 55
2 Uruguay Tenerife Uruguay 24 121 79 49
3 Elche CF Sala Elche Sala 24 100 65 48
4 FC Barcelona Barcelona 24 94 68 45
5 Jimbee Cartagena Jimbee 24 100 89 39
6 ElPozo Ciudad de Murcia ElPozo 24 86 83 35
7 Brihuega F.S. Brihuega 24 91 79 35
8 Melilla F.S Melilla F.S 24 73 72 33
9 Hospitalet Bellsport Hospitalet 24 79 83 29
10 C.D. La Escuela C.D. Escuela 24 78 91 28
11 CD UMA Antequera Antequera 24 65 86 26
12 Hércules San Vicente Hércules 24 68 83 20
13 O Parrulo Ferrol Parrulo 24 45 158 1
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Peñíscola FS Peñíscola 26 115 74 54
2 Jumilla B. Carchelo Jumilla 26 96 63 54
3 Carnicer Torrejón Carnicer 26 117 84 48
4 ElPozo Ciudad de Murcia ElPozo 26 99 81 46
5 Fuconsa Jaén Fuconsa 26 93 69 45
6 Playas de Castellón FS Playas 26 114 99 41
7 Bp Andorra Bp Andorra 26 96 98 40
8 Barça Atlétic Barça 26 120 100 38
9 Cd Dominicos Futsal Dominicos 26 79 80 35
10 Melilla FS Melilla FS 26 81 114 30
11 CD UMA Antequera Antequera 26 71 94 28
12 FS Cartagena Cartagena 26 99 125 24
13 Maristas UPV FS Maristas 26 82 109 24
14 Uruguay Peruanos Futsal Uruguay 26 82 154 12
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 Oxipharma FS Oxipharma 30 141 91 59
2 Manzanares FS Manzanares 30 111 99 56
3 ElPozo Ciudad de Murcia ElPozo 30 114 98 49
4 Fuconsa Jaén Fuconsa 30 82 85 48
5 C. A Gran Canaria Gran Canaria 30 123 112 47
6 Barça Atlétic Barça 30 118 113 46
7 CD UMA Antequera Antequera 30 104 91 45
8 Sala 5 Martorell Sala 30 130 110 44
9 Burela FS Burela FS 30 94 85 44
10 Union África Ceutí Union 30 118 128 42
11 Bp Andorra Bp Andorra 30 105 103 41
12 Maristas UPV FS Maristas 30 110 112 34
13 Hospitalet Bellsport Hospitalet 30 109 126 31
14 Melilla FS Melilla FS 30 87 108 31
15 Ibiza Gasifred Ibiza 30 105 128 30
16 Playas de Castellón FS Playas 30 91 153 25
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN FUTSAL
Equipo PJ GF GC Puntos
1 FSD Puertollano Puertollano 36 125 58 90
2 Ribera Navarra FS Ribera 36 158 88 81
3 Maristas UPV FS Maristas 36 144 111 65
4 C. A Gran Canaria Gran Canaria 36 130 115 62
5 Burela FS Burela FS 36 108 82 60
6 Arcebansa Chint Zamora Arcebansa 36 111 99 60
7 Bp Andorra Bp Andorra 36 141 116 59
8 Lanzarote Lanzarote 36 152 143 52
9 El Pozo Murcia B Pozo Murcia 36 129 123 51
10 CD UMA Antequera Antequera 36 138 140 50
11 Barça Atlétic Barça 36 102 103 49
12 Ulejos Y Pavimentos Brihueg Ulejos 36 112 115 46
13 Union África Ceutí Union 36 101 107 46
14 Jaén FS Jaén FS 36 88 102 40
15 Ibiza Gasifred Ibiza 36 119 134 37
16 Melilla FS Melilla FS 36 92 144 32
17 Cáceres 2016 Cáceres 36 104 150 31
18 Albacete FS Albacete FS 36 99 143 26
19 Tobarra FS Tobarra FS 36 74 154 18
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 Palma Futsal Palma Futsal 27 152 64 74
2 FSD Puertollano Puertollano 26 121 68 58
3 Maristas UPV FS Maristas 26 125 71 52
4 CD UMA Antequera Antequera 28 103 103 45
5 Ibiza Gasifred Ibiza 26 106 86 42
6 Jumilla FS Jumilla FS 26 94 94 39
7 El Pozo Murcia B Pozo Murcia 26 81 81 35
8 Union África Ceutí Union 27 83 91 33
9 Bujalance FS Bujalance 26 80 92 30
10 Albacete FS Albacete FS 24 67 89 27
11 Tobarra FS Tobarra FS 26 72 106 26
12 CFS Playas Salou Playas Salou 26 86 123 22
13 Caravaca FS Caravaca FS 19 77 79 21
14 Melilla FS Melilla FS 13 42 46 19
15 FS Nazareno FS Nazareno 26 54 150 4
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN FUTSAL GRUPO 2
Equipo PJ GF GC Puntos
1 CD UMA Antequera Antequera 20 95 68 40
2 Mm Pérez Bujalance Pérez 20 57 51 37
3 Maristas UPV FS Maristas 20 70 61 31
4 ElPozo Ciudad de Murcia ElPozo 20 60 58 31
5 Lanzarote Lanzarote 20 67 70 30
6 Intersa Ibi Intersa Ibi 20 65 62 28
7 Albacete FS Albacete FS 20 67 67 26
8 FS Nazareno FS Nazareno 20 63 69 26
9 Cd Puertollano Puertollano 20 55 53 25
10 C. A Gran Canaria Gran Canaria 20 69 82 21
11 Jumilla FS Jumilla FS 20 55 82 16

  USO DE MEMORIA  
6,999,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1183
Total Execution Time  0.1199
  CADENA URL  
/historico/Uma-Antequera
  GET DATOS  
$_GET['/historico/Uma-Antequera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5174 AND type_rel = 2
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5174 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0031  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 (428692,449929,455169,455716,459484) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '5174' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=5174 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0034  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,73235,70783,70771,68486) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 68486 AND teamId = 5174
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73235 AND teamId = 5174
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 5174
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 70771 AND teamId = 5174
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 70783 AND teamId = 5174
0.0026  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 = 5174 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  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 = 73235 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.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 = 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.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 `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 = 63428 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.0072  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.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 `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 = 50516 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.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 `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 = 44361 AND t.round = 30 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 `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.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 `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 = 33894 AND t.round = 26 ORDER BY team.conference 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 `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 = 16598 AND t.round = 30 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 = 4457 AND t.round = 26 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 `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 = 3020 AND t.round = 26 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 `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 = 1936 AND t.round = 26 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 `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 = 1787 AND t.round = 30 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 `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 = 1215 AND t.round = 38 ORDER BY team.conference 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 `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 = 925 AND t.round = 30 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 `tables2009` 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 = 736 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC