4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ciudad de Móstoles
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Ciudad de Móstoles Ciudad 27 179 58 81
2 Cobisa FS Cobisa FS 26 132 70 59
3 Rivas Futsal Rivas Futsal 27 124 84 58
4 Bargas CD Bargas CD 26 97 82 44
5 CD El Valle CD El Valle 27 99 87 42
6 Grupo Lopez Bolaños A Grupo Lopez 27 94 86 41
7 Club Inter Movistar FS Club Inter. 27 106 92 39
8 Moral FS Moral FS 27 94 105 39
9 Ciudad de Torrejón Ciudad 27 107 123 39
10 Dehesa Villalba Dehesa 27 111 109 35
11 ED Brunete ED Brunete 27 73 100 30
12 Unión Tres Cantos Unión Tres 26 101 109 28
13 Simancas FS Simancas FS 26 76 95 25
14 Sierra San Vicente FS Sierra 27 82 125 24
15 Futsala Villaverde Futsala 27 81 139 23
16 Caceres Universidad Caceres 27 53 145 3
TEMPORADA 2022/2023
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Rivas Futsal Rivas Futsal 30 137 84 67
2 CD Albacete FS Albacete 30 133 93 61
3 Caceres Universidad Caceres 30 128 93 61
4 Unión Tres Cantos Unión Tres 30 127 100 58
5 Ciudad de Móstoles Ciudad 30 150 98 56
6 Cobisa FS Cobisa FS 30 138 104 49
7 Club Inter Movistar FS Club Inter. 30 139 99 47
8 Grupo Lopez Bolaños A Grupo Lopez 30 94 104 46
9 Moral FS Moral FS 30 111 112 43
10 Dehesa Villalba Dehesa 30 115 124 41
11 Simancas FS Simancas FS 30 120 136 39
12 Bargas CD Bargas CD 30 95 106 39
13 AD Alcorcón FS Alcorcón 30 87 111 28
14 Soliss FS Talavera Soliss 30 84 140 24
15 Asociación Jerez Futsal Asociación 30 76 146 24
16 Bambatan Rena FS Bambatan 30 64 148 2
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
SEGUNDA DIVISIÓN FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Alzira FS Alzira FS 24 78 67 36
2 Bisontes Castellón FS Bisontes 24 62 72 33
3 Full Energía Zaragoza Full 24 101 90 32
4 Ciudad de Móstoles Ciudad 24 71 69 32
5 CD Leganes FS Leganes 24 77 77 31
6 Elche CF Sala Elche Sala 24 84 89 31
7 ElPozo Ciudad de Murcia ElPozo 24 55 64 23
8 Rivas Futsal Rivas Futsal 24 56 97 21
9 Santiago Futsal Santiago 24 46 78 18
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
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Ciudad de Móstoles Ciudad 30 146 61 77
2 Nueva Elda Nueva Elda 30 125 70 67
3 CD Leganes FS Leganes 30 112 70 67
4 Zambu Pinatar Zambu 30 119 73 61
5 Torrejón Sala Five-Play Torrejón 30 110 90 58
6 Club Inter Movistar FS Club Inter. 30 120 85 51
7 Caceres Universidad Caceres 30 120 109 44
8 Silver Novanca FS Silver 30 112 114 44
9 CD El Valle CD El Valle 30 103 100 40
10 Navalmoral FS Navalmoral 30 125 152 39
11 Bargas CD Bargas CD 30 111 104 37
12 CDE Mejorada Mejorada 30 90 119 31
13 EFS Colmenar Viejo Colmenar 29 83 132 29
14 ED Abanilla-Abrisa Abanilla-Abr 30 87 137 21
15 Jumilla B. Carchelo Jumilla 29 78 136 19
16 Gelovision Ciudad de Toledo Gelovision 30 61 150 7
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Soliss FS Talavera Soliss 30 136 64 77
2 CD Leganes FS Leganes 30 130 75 68
3 Nueva Elda Nueva Elda 30 136 95 65
4 Ciudad de Móstoles Ciudad 30 143 88 62
5 Navalmoral FS Navalmoral 29 128 113 48
6 Club Inter Movistar FS Club Inter. 30 108 97 47
7 Zambu Pinatar Zambu 30 99 96 47
8 Torrejón Sala Five-Play Torrejón 30 92 94 40
9 Bargas CD Bargas CD 29 90 101 35
10 Silver Novanca FS Silver 30 91 101 33
11 Caceres Universidad Caceres 29 87 104 33
12 Jumilla B. Carchelo Jumilla 29 93 134 33
13 CDE Mejorada Mejorada 30 87 103 32
14 AA Pilaristas Flex Futsal Pilaristas 30 116 134 32
15 Simancas FS Simancas FS 30 80 135 14
16 CD Ciudad del Vino B Ciudad Vino 30 91 173 13
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Brihuega Fs Futsal Brihuega 30 163 86 75
2 Soliss FS Talavera Soliss 30 131 86 59
3 Massey Ferguson Valdepeñas Massey 30 116 83 59
4 Leganes Fs Futsal Leganes 30 162 106 55
5 Cde Velada Fs Futsal Velada 30 123 102 53
6 Ciudad de Móstoles Ciudad 30 116 93 49
7 Kelme Navalagamella Futsal Kelme 30 102 95 47
8 Silver Novanca FS Silver 30 99 116 36
9 Navalmoral Fs Futsal Navalmoral 30 115 136 35
10 AA Pilaristas Flex Futsal Pilaristas 30 138 142 34
11 Torres De La Alameda Fs Torres 30 109 130 34
12 Cuellar Cojalba Cuellar 30 104 129 34
13 San Clemente Futsal Clemente 30 97 125 34
14 Cfs Bargas Futsal Bargas 30 122 149 33
15 Albacete Fs Futsal Albacete 30 87 122 28
16 AD Calera FS Calera 30 79 163 14
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Kelme Navalagamella Futsal Kelme 30 120 76 69
2 Brihuega Fs Futsal Brihuega 30 134 88 60
3 Cd Fs Alamin Futsal Alamin 30 147 102 59
4 Leganes Fs Futsal Leganes 30 144 115 55
5 San Agustin Guadalix Futsal Agustin 30 137 106 54
6 Cde Velada Fs Futsal Velada 30 112 94 52
7 Ciudad de Móstoles Ciudad 30 124 108 46
8 AD Calera FS Calera 30 90 87 45
9 AA Pilaristas Flex Futsal Pilaristas 30 133 143 45
10 AD Almendralejo Almendralejo 30 135 129 43
11 Cfs Bargas Futsal Bargas 30 113 115 41
12 Ud Guadalajara Futsal Guadalajara 30 132 137 38
13 Ad Extremadura Futsal Extremadura 30 98 143 27
14 Sigüenza Fs Futsal Sigüenza 30 108 162 26
15 Cde Don Bosco Futsal Bosco Futsal 30 72 127 19
16 Hotel Gran Sol Futsal Hotel Gran. 30 88 155 9
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN B FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 El Escorial El Escorial 32 186 108 70
2 Burgos CFS Burgos CFS 32 174 126 64
3 CD Valverde CD Valverde 32 169 113 59
4 UDRB Mostoles UDRB 32 149 99 59
5 Loeches Loeches 32 135 108 59
6 Uni. Valladolid Uni. 32 167 147 54
7 Ciudad de Móstoles Ciudad 32 143 130 53
8 Simancas FS Simancas FS 32 123 120 50
9 Pilaristas Iberseguros Pilaristas 32 151 154 49
10 Ef Sala Arganda Sala Arganda 32 130 140 42
11 Collado Mediano Collado 32 137 159 40
12 Cd Albense Cd Albense 32 105 121 39
13 Admon. 300 Leganes Admon. 32 128 166 39
14 Humanes FS Humanes FS 32 153 170 36
15 Unión Tres Cantos Unión Tres 32 111 159 36
16 Los Palacios Palacios 32 109 125 30
17 Ad Tancitaro Tancitaro 32 104 229 2

  USO DE MEMORIA  
6,121,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5731
Total Execution Time  0.5743
  CADENA URL  
/historico/Ciudad-Mostoles-Fs-Futsal
  GET DATOS  
$_GET['/historico/Ciudad-Mostoles-Fs-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0171  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 = 'Ciudad-Mostoles-Fs-Futsal' 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.0131  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=8038 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=8038 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=8038 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0264  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 = 74088
0.0133  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=8038 AND type_rel = 2
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8038 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 (716966,782433,782113,1055812,1056232) ORDER BY n.cover_points DESC, update_date DESC
0.0154  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 = '8038' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 74088 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=8038 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 (74088,74080,71671) 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 = 74088 AND teamId = 8038
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 74080 AND teamId = 8038
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 71671 AND teamId = 8038
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 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 = 74088 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '8038' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8038' 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 = '8038' 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 = 74088 WHERE rp.league_id = 74088 AND rp.teamId = 8038 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.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 = 74088 WHERE rp.league_id = 74088 AND rp.teamId = 8038 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 = 74088 WHERE rp.league_id = 74088 AND rp.teamId = 8038 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 = 8038 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 74088 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.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 = 68840 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.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 `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 = 58755 AND t.round = 18 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 `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 = 61574 AND t.round = 10 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 = 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.0131  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 = 44515 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 `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 = 40227 AND t.round = 30 ORDER BY team.conference 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 `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 = 2499 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 `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 = 1793 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 739 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC