4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del LBTL Alcantarilla
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
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Roldán B Roldán B 24 97 33 57
2 LBTL Alcantarilla LBTL 24 87 25 56
3 MSC Torreblanca FS B Torreblanca 24 71 35 52
4 UD La Cruz UD La Cruz 24 87 55 44
5 Desguace París Algaida FS Desguace 24 76 47 44
6 Mabe CD El Ejido Futsal Mabe Ejido. 24 91 77 39
7 Deportivo Córdoba Deportivo 24 62 61 37
8 Martos FS Jaén Paraíso Int. Martos Jaén 24 73 60 35
9 CD Camoens CD Camoens 24 68 67 30
10 Guadalcacín Guadalcacín 24 49 78 24
11 Xaloc Alacant Xaloc 24 75 77 23
12 Cádiz FSF Cádiz FSF 24 24 108 4
13 UD Alhameña Alhameña 24 44 181 4
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 9
Equipo PJ GF GC Puntos
1 Deportivo Córdoba Deportivo 24 121 33 61
2 Nueces de Ronda Atl. Torcal Nueces Ronda 24 108 40 60
3 LBTL Alcantarilla LBTL 24 105 55 55
4 Desguace París Algaida FS Desguace 24 77 58 46
5 UD La Cruz UD La Cruz 24 100 73 43
6 Mabe CD El Ejido Futsal Mabe Ejido. 24 95 92 38
7 MSC Torreblanca FS B Torreblanca 24 75 71 34
8 Guadalcacín Guadalcacín 23 83 69 32
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 LBTL Alcantarilla LBTL 22 119 42 55
2 MSC Torreblanca FS Torreblanca 22 96 29 51
3 UD La Cruz UD La Cruz 22 74 39 48
4 Guadalcacín Guadalcacín 22 86 46 45
5 Deportivo Córdoba Deportivo 22 87 64 42
6 Nueces de Ronda Atl. Torcal Nueces Ronda 21 70 48 41
7 Desguace París Algaida FS Desguace 22 55 58 31
8 Roldán B Roldán B 22 49 50 29
9 Monachil 2013 CF Monachil 22 73 88 28
10 Mabe CD El Ejido Futsal Mabe Ejido. 22 56 78 28
11 Martos FS Jaén Paraíso Int. Martos Jaén 22 62 83 27
12 CD Camoens CD Camoens 22 51 70 24
13 Deportivo Loja Deportivo 22 44 92 15
14 SD Hispania SD Hispania 22 42 75 13
15 Sporting Garrovilla Sporting 21 40 105 12
16 Cádiz FSF Cádiz FSF 22 51 88 10
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Roldán B Roldán B 28 89 57 63
2 LBTL Alcantarilla LBTL 28 128 62 62
3 Nueces de Ronda Atl. Torcal Nueces Ronda 28 123 50 61
4 Deportivo Córdoba Deportivo 28 103 69 54
5 UD La Cruz UD La Cruz 28 108 66 50
6 MSC Torreblanca FS Torreblanca 28 122 74 49
7 Mabe CD El Ejido Futsal Mabe Ejido. 28 104 92 45
8 Cádiz FSF Cádiz FSF 28 90 69 42
9 Monachil 2013 CF Monachil 28 117 99 42
10 Deportivo Loja Deportivo 28 74 74 42
11 Desguace París Algaida FS Desguace 28 76 77 34
12 SD Hispania SD Hispania 28 80 93 32
13 Sporting Garrovilla Sporting 28 45 143 12
14 Playas de Málaga Playas 28 50 168 12
15 CD Hércules Ceuta Hércules 28 48 164 7
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Almagro FSF Almagro FSF 30 113 53 67
2 Monachil 2013 CF Monachil 30 157 106 61
3 LBTL Alcantarilla LBTL 30 122 74 58
4 Nueces de Ronda Atl. Torcal Nueces Ronda 30 114 68 58
5 MSC Torreblanca FS Torreblanca 30 137 92 56
6 SD Hispania SD Hispania 30 115 80 52
7 Deportivo Loja Deportivo 30 94 77 50
8 UD La Cruz UD La Cruz 30 110 92 49
9 Joventut d'Elx FS Joventut 30 110 67 48
10 Roldán B Roldán B 30 92 91 43
11 Deportivo Córdoba Deportivo 30 83 95 37
12 Mabe CD El Ejido Futsal Mabe Ejido. 30 115 125 34
13 CD Salesianos Salesianos 30 67 82 32
14 Martos FS Jaén Paraíso Int. Martos Jaén 30 66 99 31
15 CD Comarca de Níjar Comarca 30 57 165 16
16 Quijote Futsal Quijote 30 29 215 2
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 Guadalcacín Guadalcacín 30 151 58 73
2 Cádiz FSF Cádiz FSF 30 94 44 70
3 MSC Torreblanca FS Torreblanca 30 91 85 55
4 Almagro FSF Almagro FSF 30 76 68 50
5 Deportivo Loja Deportivo 30 91 69 48
6 LBTL Alcantarilla LBTL 30 95 79 47
7 Roldán B Roldán B 30 63 72 47
8 Nueces de Ronda Atl. Torcal Nueces Ronda 30 81 67 46
9 CD Salesianos Salesianos 30 69 78 43
10 Deportivo Córdoba Deportivo 30 75 71 41
11 SD Hispania SD Hispania 30 74 77 40
12 CD Vicar CD Vicar 30 76 75 39
13 Monachil 2013 CF Monachil 30 83 94 37
14 CD Estudiantes de Sevilla Estudiantes 30 63 89 27
15 Malagón FSF Malagón 30 51 126 16
16 Sporting Garrovilla Sporting 30 42 123 13
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN FEMENINO FUTSAL GRUPO 3
Equipo PJ GF GC Puntos
1 UCAM Murcia FSF UCAM Murcia 26 155 21 74
2 Almagro FSF Almagro FSF 26 92 45 60
3 Cádiz FSF Cádiz FSF 26 132 53 56
4 Deportivo Loja Deportivo 26 86 52 51
5 CD Vicar CD Vicar 26 98 68 50
6 Nueces de Ronda Atl. Torcal Nueces Ronda 26 84 58 46
7 CD Estudiantes de Sevilla Estudiantes 26 72 77 36
8 MSC Torreblanca FS Torreblanca 26 64 132 20
9 CD Salesianos Salesianos 26 36 89 16
10 UD La Cruz UD La Cruz 26 36 150 9
11 Albolote Futsal CD Albolote 26 34 146 4

  USO DE MEMORIA  
5,902,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.6061
Total Execution Time  0.6078
  CADENA URL  
/historico/La-Boca-Te-Lia-Futsal-Alcantarilla-Femenina-Futsal
  GET DATOS  
$_GET['/historico/La-Boca-Te-Lia-Futsal-Alcantarilla-Femenina-Futsal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0174  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 = 'La-Boca-Te-Lia-Futsal-Alcantarilla-Femenina-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.0128  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=95047 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=95047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=95047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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.0140  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.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=95047 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=157 AND type_rel = 3
0.0135  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.0138  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.0147  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 = '95047' ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '95047' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '95047' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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.0128  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.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=95047 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 = 95047
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73405 AND teamId = 95047
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 = 73236 AND t.round = 26 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 = '95047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '95047' 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 = '95047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 95047 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.0129  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 = 95047 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 95047 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 95047 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 = 63709 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 `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 = 58806 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 = 61759 AND t.round = 8 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 `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 = 50523 AND t.round = 22 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 = 44449 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 = 39795 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 `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 = 35493 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 7598 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 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 = 73236 ORDER BY nameShow LIMIT 100