4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Viaxes Amarelle
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 26 108 37 74
2 Futsi Atlético Futsi 26 110 67 58
3 MSC Torreblanca FS Torreblanca 25 88 45 58
4 Poio FS Poio FS 26 76 52 49
5 AD Alcorcón Alcorcón 26 95 63 47
6 LBTL Alcantarilla LBTL 26 87 62 43
7 Roldán FSF Roldán FSF 26 69 61 42
8 Ourense CF Ourense CF 26 77 62 38
9 FSF Móstoles Móstoles 26 75 81 36
10 AE Les Corts Corts 25 61 78 31
11 Nueces de Ronda Atl. Torcal Nueces Ronda 26 87 81 29
12 FSF Castro FSF Castro 26 64 74 28
13 Viaxes Amarelle Viaxes 26 77 110 22
14 Marín Fútsal Marín 26 65 92 20
15 Rayo Majadahonda FS Rayo 26 60 129 10
16 CD Leganés CD Leganés 26 36 141 7
TEMPORADA 2022/2023
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 156 43 77
2 Poio FS Poio FS 30 95 34 75
3 Burela FS Burela FS 30 159 59 72
4 MSC Torreblanca FS Torreblanca 30 108 69 64
5 AD Alcorcón Alcorcón 30 102 78 53
6 Roldán FSF Roldán FSF 30 85 84 49
7 LBTL Alcantarilla LBTL 30 92 70 45
8 Ourense CF Ourense CF 30 84 69 43
9 FSF Móstoles Móstoles 30 87 84 43
10 Marín Fútsal Marín 30 74 89 36
11 CD Leganés CD Leganés 30 75 120 28
12 Viaxes Amarelle Viaxes 30 59 88 26
13 Rayo Majadahonda FS Rayo 30 50 139 25
14 AD Sala Zaragoza Sala 30 94 149 22
15 AD Teldeportivo Teldeportivo 30 68 102 15
16 Joventut d'Elx FS Joventut 30 43 154 9
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Viaxes Amarelle Viaxes 26 163 35 75
2 Cidade de As Burgas Cidade 26 110 38 67
3 Bembrive Bembrive 26 98 47 63
4 FSF Castro FSF Castro 26 95 55 59
5 Valdetires Ferrol Valdetires 26 88 58 44
6 UDC Txantrea KKE Txantrea 26 72 57 43
7 Rodiles FS Rodiles FS 26 86 71 40
8 CD Promesas EDF Promesas 26 63 57 35
9 Ourense CF B Ourense 26 82 100 29
10 AD Mioño AD Mioño 26 68 112 26
11 A Fervenza Fsf Fervenza 26 37 97 18
12 5 Coruña 5 Coruña 26 43 88 17
13 Gora Bilbao FS Gora Bilbao 26 38 107 14
14 Universidad de Salamanca Universidad 26 28 149 1
TEMPORADA 2020/2021
PRIMERA DIVISIÓN FEMENINO FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Universidad de Alicante Universidad 26 82 38 49
2 CD Leganés CD Leganés 25 89 87 40
3 AD Sala Zaragoza Sala 24 74 65 38
4 Rayo Majadahonda FS Rayo 23 58 62 28
5 AE Penya Esplugues Penya 23 40 52 25
6 Viaxes Amarelle Viaxes 23 35 63 23
7 Intersala Zaragoza Intersala 25 42 101 17
8 AD Teldeportivo Teldeportivo 25 45 92 14
9 Cidade de As Burgas Cidade 25 50 95 14
10 Xaloc Alacant Xaloc 26 26 135 5
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Viaxes Amarelle Viaxes 16 99 19 44
2 O Fisgón Futsal Fisgón 17 69 32 38
3 Valdetires Ferrol Valdetires 15 63 32 31
4 UDC Txantrea KKE Txantrea 17 41 29 30
5 FSF Castro FSF Castro 17 48 52 25
6 A Fervenza Fsf Fervenza 17 40 38 23
7 CDE Muslera CDE Muslera 17 37 68 23
8 Club Deportivo Orvina Club 17 42 45 22
9 Ourense Envialia Ourense 16 37 47 15
10 Rodiles FS Rodiles FS 17 36 50 14
11 Universidad de Valladolid Universidad 16 26 53 14
12 CD Promesas EDF Promesas 15 28 57 13
13 Ribamontan A Ribamontan 17 28 72 10
14 Stilo Kirol Kluba Stilo Kirol 0 0 0 0
TEMPORADA 2018/2019
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 150 43 84
2 Burela FS Burela FS 30 123 39 84
3 AD Alcorcón Alcorcón 30 113 71 58
4 Ourense CF Ourense CF 30 63 46 57
5 Roldán FSF Roldán FSF 30 96 58 53
6 Universidad de Alicante Universidad 30 92 62 53
7 Poio FS Poio FS 30 80 66 53
8 AE Penya Esplugues Penya 30 79 62 47
9 UCAM Murcia FSF UCAM Murcia 30 90 87 44
10 FSF Móstoles Móstoles 30 94 89 42
11 Rayo Majadahonda FS Rayo 30 64 99 31
12 CD Leganés CD Leganés 30 57 82 24
13 AD Sala Zaragoza Sala 30 65 118 24
14 Guadalcacín Guadalcacín 30 51 111 22
15 Viaxes Amarelle Viaxes 30 44 103 19
16 Femisport Palau Club Femisport 30 23 148 1
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 AD Alcorcón B Alcorcón 30 162 46 77
2 Colme Futsal Colme Futsal 30 114 45 72
3 Viaxes Amarelle Viaxes 30 93 32 72
4 Futsi Atletico Feminas II Futsi 30 97 63 55
5 O Fisgón Futsal Fisgón 30 92 70 51
6 FS San Fernando Fernando 30 72 66 51
7 Unami CP Unami CP 30 98 81 46
8 ADAE Simancas ADAE 30 94 87 45
9 CD Chiloeches Chiloeches 30 87 86 42
10 Mora FS Mora FS 30 54 64 37
11 Unión Tres Cantos FS A Fem Unión Tres 30 69 113 29
12 Universidad de Valladolid Universidad 30 84 114 28
13 Majadahonda FS Fem Majadahonda 30 78 117 28
14 CD EC Guadalajara Guadalajara 30 47 91 20
15 Cidade de Pontevedra Cidade 30 60 125 18
16 Fisober Fsf Fisober Fsf 30 40 141 11
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 Valdetires Ferrol Valdetires 30 148 74 69
2 CDVP Soto del Real CDVP Soto R. 30 118 55 69
3 Unami CP Unami CP 30 113 48 65
4 Colme Futsal Colme Futsal 30 97 53 55
5 Viaxes Amarelle Viaxes 30 76 63 55
6 AD Alcorcón B Alcorcón 30 92 79 45
7 Segovia Futsal Segovia 30 101 83 43
8 FS San Fernando Fernando 30 79 81 39
9 O Fisgón Futsal Fisgón 30 68 85 39
10 Artilleros Moratalaz Artilleros 30 88 91 37
11 Futsi Atletico Feminas II Futsi 30 96 107 34
12 CD Chiloeches Chiloeches 30 76 116 34
13 FSF Alovera FSF Alovera 30 68 93 33
14 Mora FS Mora FS 30 53 102 25
15 ADAE Simancas ADAE 30 66 145 24
16 Leis Pontevedra FS Leis 30 50 114 19
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 CD Leganés CD Leganés 24 104 39 56
2 Unami CP Unami CP 24 76 45 52
3 Viaxes Amarelle Viaxes 24 85 42 51
4 AD Alcorcón B Alcorcón 24 97 56 47
5 CDVP Soto del Real CDVP Soto R. 24 76 58 37
6 ADAE Simancas ADAE 24 71 83 35
7 FS San Fernando Fernando 24 63 59 34
8 FSF Alovera FSF Alovera 24 53 66 31
9 Humanes Basket Humanes 24 65 91 26
10 Leis Pontevedra FS Leis 24 61 84 23
11 CD Chiloeches Chiloeches 24 73 122 19
12 Futsi Atletico Feminas II Futsi 24 46 75 18
13 Mora FS Mora FS 24 44 94 10
TEMPORADA 2014/2015
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 135 52 81
2 Cidade de As Burgas Cidade 30 114 58 71
3 Burela FS Burela FS 30 101 59 70
4 Universidad de Alicante Universidad 30 98 55 60
5 AD Alcorcón Alcorcón 30 101 54 57
6 Ourense CF Ourense CF 30 80 75 51
7 FSF Rioja Diamante Rioja 30 79 91 46
8 Roldán FSF Roldán FSF 30 99 93 44
9 FSF Móstoles Móstoles 30 79 72 40
10 Poio FS Poio FS 30 70 79 36
11 FS Gironella Gironella 30 63 89 28
12 Rayo Majadahonda FS Rayo 30 73 99 25
13 Club Deportivo Orvina Club 30 52 96 23
14 Ordizia Ke Ordizia Ke 30 40 103 19
15 Bilbo FS Bilbo FS 30 50 96 18
16 Viaxes Amarelle Viaxes 30 47 110 18
TEMPORADA 2013/2014
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 159 54 81
2 Burela FS Burela FS 30 129 56 70
3 AD Alcorcón Alcorcón 30 108 73 68
4 Universidad de Alicante Universidad 30 131 73 59
5 Roldán FSF Roldán FSF 30 112 86 53
6 FSF Rioja Diamante Rioja 30 81 61 51
7 Ourense CF Ourense CF 30 91 75 46
8 FS Gironella Gironella 30 83 74 46
9 Poio FS Poio FS 30 87 97 37
10 Cidade de As Burgas Cidade 30 78 93 37
11 Club Deportivo Orvina Club 30 75 95 33
12 FSF Móstoles Móstoles 30 75 90 29
13 Viaxes Amarelle Viaxes 30 62 92 29
14 CDVP Soto del Real CDVP Soto R. 30 77 107 25
15 Valdetires Ferrol Valdetires 30 67 138 23
16 AE Vallirana Vallirana 30 43 194 3
TEMPORADA 2012/2013
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 28 114 40 70
2 Futsi Atlético Futsi 28 114 52 69
3 AD Alcorcón Alcorcón 28 101 76 55
4 Universidad de Alicante Universidad 28 115 83 53
5 Valladolid FSF Valladolid 28 92 77 52
6 Club Deportivo Orvina Club 28 105 87 47
7 FS Gironella Gironella 28 70 71 40
8 CDVP Soto del Real CDVP Soto R. 28 75 84 37
9 FSF Rioja Diamante Rioja 28 73 79 35
10 Ourense CF Ourense CF 28 90 96 34
11 FSF Móstoles Móstoles 28 94 95 33
12 Roldán FSF Roldán FSF 28 68 78 28
13 Cidade de As Burgas Cidade 28 51 70 21
14 Viaxes Amarelle Viaxes 28 60 124 17
15 Cfs Femeni Centelles Femeni 28 53 163 4
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 1
Equipo PJ GF GC Puntos
1 Viaxes Amarelle Viaxes 23 84 32 56
2 Ordizia Ke Ordizia Ke 23 55 34 54
3 Bilbo FS Bilbo FS 23 84 45 49
4 Valdetires Ferrol Valdetires 23 88 52 48
5 CD FS San Bernabé Bernabé 23 155 52 37
6 Club 4 Arcos Logroño Club Arcos. 23 70 71 31
7 Flaviobriga FS Flaviobriga 23 84 88 31
8 A Fervenza Fsf Fervenza 23 52 55 30
9 Fs Chaboyme Fs Chaboyme 23 62 79 25
10 UDC Txantrea KKE Txantrea 23 42 67 24
11 Guarnizo Fsf Guarnizo 24 71 177 24
12 CFS Calceatense Calceatense 23 61 85 19
13 Stilo Kirol Kluba Stilo Kirol 23 33 104 4

  USO DE MEMORIA  
6,357,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5059
Total Execution Time  0.5073
  CADENA URL  
/historico/Viaxes-Amarelle-Fs
  GET DATOS  
$_GET['/historico/Viaxes-Amarelle-Fs']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
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 = 'Viaxes-Amarelle-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=8411 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=8411 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=8411 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=8411 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8411 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 (760227) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '8411' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '8411' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=8411 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 (73405,73236) 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 = 73236 AND teamId = 8411
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73405 AND teamId = 8411
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 = 73236 WHERE rp.league_id = 73236 AND rp.teamId = 8411 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 = 73236 WHERE rp.league_id = 73236 AND rp.teamId = 8411 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 73236 WHERE rp.league_id = 73236 AND rp.teamId = 8411 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 8411 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73236 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.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 `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 = 68496 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.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 `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 = 63707 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 `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 = 58803 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.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 = 61993 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 = 50522 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 `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 = 44446 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 = 39800 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 = 35494 AND t.round = 30 ORDER BY team.conference 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 `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 = 64967 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 7573 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 64314 AND t.round = 30 ORDER BY team.conference 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 `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 = 2246 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 `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 = 1819 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC