4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Leganés
TEMPORADA 2023/2024
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Burela FS Burela FS 26 108 37 74
2 MSC Torreblanca FS Torreblanca 25 88 45 58
3 Futsi Atlético Futsi 25 109 66 57
4 Poio FS Poio FS 25 75 51 48
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 25 71 77 35
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 25 61 88 19
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
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 150 58 80
2 Burela FS Burela FS 30 108 32 74
3 Roldán FSF Roldán FSF 30 85 55 58
4 MSC Torreblanca FS Torreblanca 30 91 65 56
5 Poio FS Poio FS 30 91 58 55
6 AD Alcorcón Alcorcón 30 98 77 48
7 FSF Móstoles Móstoles 30 94 95 44
8 Marín Fútsal Marín 30 73 78 42
9 Ourense CF Ourense CF 30 81 70 40
10 Universidad de Alicante Universidad 30 62 73 38
11 CD Leganés CD Leganés 30 99 119 35
12 Rayo Majadahonda FS Rayo 30 68 102 33
13 AD Sala Zaragoza Sala 30 52 103 25
14 AE Penya Esplugues Penya 30 46 105 22
15 Nueces de Ronda Atl. Torcal Nueces Ronda 30 65 101 20
16 Joventut d'Elx FS Joventut 30 56 128 7
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
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 23 145 34 69
2 Burela FS Burela FS 23 97 32 62
3 Ourense CF Ourense CF 23 69 35 56
4 AD Alcorcón Alcorcón 23 95 47 53
5 Poio FS Poio FS 23 69 55 41
6 Universidad de Alicante Universidad 23 61 46 39
7 FSF Móstoles Móstoles 23 79 61 35
8 AE Penya Esplugues Penya 22 49 47 35
9 Roldán FSF Roldán FSF 23 47 58 31
10 UCAM Murcia FSF UCAM Murcia 22 70 73 29
11 AD Sala Zaragoza Sala 23 54 64 29
12 CD Leganés CD Leganés 23 56 82 18
13 Rayo Majadahonda FS Rayo 23 27 68 15
14 Cidade de As Burgas Cidade 23 29 85 11
15 Bilbo FS Bilbo FS 23 31 105 6
16 Xaloc Alacant Xaloc 23 20 106 3
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
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Roldán FSF Roldán FSF 30 116 50 73
2 Futsi Atlético Futsi 30 127 40 73
3 Burela FS Burela FS 30 127 73 72
4 Universidad de Alicante Universidad 30 106 40 70
5 AD Alcorcón Alcorcón 30 106 58 58
6 Ourense CF Ourense CF 30 81 51 56
7 Poio FS Poio FS 30 91 76 49
8 AE Penya Esplugues Penya 30 67 49 48
9 CD Leganés CD Leganés 30 71 80 38
10 UCAM Murcia FSF UCAM Murcia 30 77 86 38
11 FSF Móstoles Móstoles 30 76 75 38
12 Rayo Majadahonda FS Rayo 30 72 98 27
13 Guadalcacín Guadalcacín 30 57 126 24
14 CDVP Soto del Real CDVP Soto R. 30 58 117 17
15 Cádiz FSF Cádiz FSF 30 46 165 5
16 Cidade de As Burgas Cidade 30 47 141 5
TEMPORADA 2016/2017
PRIMERA DIVISIÓN FEMENINO FUTSAL
Equipo PJ GF GC Puntos
1 Futsi Atlético Futsi 30 126 28 85
2 Universidad de Alicante Universidad 30 115 48 71
3 AD Alcorcón Alcorcón 30 113 46 67
4 Burela FS Burela FS 30 86 58 59
5 Ourense CF Ourense CF 30 84 48 55
6 Poio FS Poio FS 30 75 55 54
7 Roldán FSF Roldán FSF 30 111 68 51
8 Rayo Majadahonda FS Rayo 30 83 98 40
9 Cidade de As Burgas Cidade 30 85 95 38
10 FSF Móstoles Móstoles 30 84 93 37
11 AE Penya Esplugues Penya 30 69 78 37
12 UCAM Murcia FSF UCAM Murcia 30 61 95 26
13 CD Leganés CD Leganés 30 60 110 20
14 FSF Rioja Diamante Rioja 30 39 116 15
15 UDC Txantrea KKE Txantrea 30 46 125 14
16 Rubí FS Rubí FS 30 48 124 13
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
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 CD Leganés CD Leganés 24 129 46 63
2 Valdetires Ferrol Valdetires 24 108 52 60
3 CDVP Soto del Real CDVP Soto R. 24 121 49 53
4 Unami CP Unami CP 24 80 50 46
5 AD Alcorcón B Alcorcón 24 76 56 42
6 Humanes Basket Humanes 24 77 65 40
7 CD Chiloeches Chiloeches 24 89 89 31
8 ADAE Simancas ADAE 24 67 88 30
9 At. Madrid Navalcarnero B Madrid 24 57 85 25
10 Mora FS Mora FS 24 51 110 21
11 FSF Alovera FSF Alovera 24 54 88 20
12 Leis Pontevedra FS Leis 24 51 104 11
13 Fisober Fsf Fisober Fsf 24 32 110 8
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 CD Leganés CD Leganés 24 92 37 59
2 Poio FS Poio FS 24 91 47 56
3 AD Teldeportivo Teldeportivo 24 85 43 53
4 Rayo Majadahonda FS Rayo 24 99 51 50
5 Leis Pontevedra FS Leis 24 69 49 42
6 At. Madrid Navalcarnero B Madrid 24 62 52 39
7 CD Chiloeches Chiloeches 24 90 69 35
8 Unami CP Unami CP 24 57 65 31
9 ADAE Simancas ADAE 24 67 70 26
10 Em De Alover Alover 24 52 106 22
11 AD Alcorcón B Alcorcón 24 56 79 20
12 Fs Chaboyme Fs Chaboyme 24 51 113 15
13 Universidad De Salamanca Fs Universidad 24 41 131 3
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 4
Equipo PJ GF GC Puntos
1 AD Alcorcón Alcorcón 25 143 30 70
2 Ad Collado Villalba Fs Collado 25 111 49 60
3 CD Leganés CD Leganés 25 108 58 52
4 Leis Pontevedra FS Leis 25 78 56 51
5 Ateneo Decombarro Fs Ateneo 25 79 56 48
6 At. Madrid Navalcarnero B Madrid 25 94 73 44
7 Unami CP Unami CP 25 61 61 39
8 ADAE Simancas ADAE 25 74 79 35
9 CD Chiloeches Chiloeches 25 85 81 34
10 Universidad De Salamanca Fs Universidad 25 47 81 27
11 Ad Samura Ad Samura 25 55 101 14
12 Cd Chozas De Abajo Fsf Chozas Abajo 25 66 129 14
13 Ciudade De Ourense Ciudade 25 50 119 13
14 Cd Monasterio Bembrive Fs Monasterio 25 43 121 4

  USO DE MEMORIA  
6,302,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1422
Total Execution Time  0.1434
  CADENA URL  
/historico/Leganes-Masdeporte
  GET DATOS  
$_GET['/historico/Leganes-Masdeporte']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0027  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 = 'Leganes-Masdeporte' 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.0019  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=8441 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=8441 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=8441 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 73236
0.0024  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 = 73405
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8441 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=157 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 157 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0048  SELECT /*53 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 (1114910,1060072,931766,909409,867439) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '8441' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '8441' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '8441' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73236 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 73405 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=8441 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73236 AND teamId = 8441
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73405 AND teamId = 8441
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '8441' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8441' and rp.type = 4
0.0020  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 = '8441' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 8441 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.0019  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 = 8441 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 8441 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 8441 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 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.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 `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 = 63429 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.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 `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.0021  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.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 `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 = 50512 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.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 `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.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 = 39790 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 `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 = 35498 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 `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.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 `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 = 7599 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 `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 = 2165 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 `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 = 1822 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC