4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Aluche B
TEMPORADA 2021/2022
1ª AUTO. MADRID JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Real Madrid Sub 19 C Real Madrid 34 129 20 93
2 ED Moratalaz Sub 19 Moratalaz 34 75 38 65
3 Complutense Alcalá Sub 19 Complutense 34 72 45 62
4 Fundacion Alcala Fundacion 34 63 53 58
5 Rayo Mjdh. Sub 19 C Rayo Mjdh. 34 64 51 55
6 Rayo Vallecano Sub 19 C Rayo 34 71 59 53
7 Santa Ana Sub 19 Santa 34 61 65 51
8 Villaviciosa de Odón A Villaviciosa 34 71 77 50
9 Chopera Alcobendas Sub 19 Chopera 34 61 49 48
10 San Fernando B Fernando 34 59 56 48
11 Villanueva del Pardillo A Villanueva 34 52 59 46
12 Nuevo Boadilla Sub 19 Nuevo 34 70 72 43
13 Canillas Sub 19 Canillas 34 57 80 38
14 UD Sanse Sub 19 Sanse 34 50 81 38
15 CD Móstoles C Móstoles 34 53 72 36
16 Unión Adarve C Unión 34 38 71 31
17 Alcobendas Sub 19 Alcobendas 34 30 67 24
18 Aluche B Aluche B 34 40 101 23
TEMPORADA 2020/2021
PREFERENTE MADRID JUVENIL GRUPO 4
Equipo PJ GF GC Puntos
1 Atlético de Madrid C Atlético 19 75 11 55
2 Aluche B Aluche B 19 53 22 45
3 Fuenlabrada Sub 19 C Fuenlabrada 19 44 19 41
4 Lugo Fuenlabrada A Lugo 19 50 26 38
5 Trival Valderas Alcorcón B Trival 19 39 20 38
6 Colonia Moscardo Sub 19 Colonia 19 52 31 34
7 Internacional de Mostoles Internaciona 19 36 24 33
8 AD Villaverde Bajo A Villaverde 19 35 33 33
9 Los Yébenes San Bruno B Yébenes 19 35 35 32
10 Fortuna Sub 19 Fortuna 19 37 29 27
11 Mostoles CF D Mostoles 19 34 32 24
12 Atlético Casarrubuelos B Atlético 19 38 48 24
13 Real Carabanchel B Real 19 32 35 22
14 Villaverde San Andrés Villaverde 19 27 39 22
15 La Avanzada A Avanzada 19 22 59 16
16 Municipal Arroyomolinos A Municipal 19 24 50 15
17 Libertad Alcorcón A Libertad 19 22 52 14
18 Griñon Griñon 19 25 48 10
19 Navalcarnero B Navalcarnero 19 22 57 10
20 El Álamo El Álamo 19 24 56 7
TEMPORADA 2019/2020
PREFERENTE MADRID JUVENIL GRUPO 4
Equipo PJ GF GC Puntos
1 Atlético de Pinto Atlético 22 72 27 51
2 Villaviciosa de Odón A Villaviciosa 23 66 43 45
3 CD Internacional Móstoles Internaciona 23 61 40 44
4 Lugo Fuenlabrada A Lugo 23 49 35 40
5 Atlético de Madrid C Atlético 23 68 47 38
6 Fortuna Sub 19 Fortuna 23 53 38 38
7 Ciudad de Getafe A Ciudad 23 56 48 37
8 Aluche B Aluche B 23 39 33 37
9 Fuenlabrada Sub 19 C Fuenlabrada 23 43 31 35
10 Municipal Arroyomolinos Municipal 23 55 46 33
11 Los Yébenes San Bruno B Yébenes 23 46 40 32
12 Real Carabanchel B Real 23 40 50 31
13 Trival Valderas Alcorcón B Trival 22 35 41 29
14 El Álamo El Álamo 23 37 45 27
15 La Avanzada A Avanzada 23 38 70 23
16 CD Móstoles Móstoles 23 28 51 18
17 Brunete A Brunete A 23 27 60 13
18 Atlético Casarrubuelos B Atlético 23 28 96 11
TEMPORADA 2018/2019
PREFERENTE MADRID JUVENIL GRUPO 4
Equipo PJ GF GC Puntos
1 Navalcarnero A Navalcarnero 34 106 49 73
2 Unión Carrascal A Unión 34 104 62 71
3 Villaviciosa de Odón A Villaviciosa 34 91 63 68
4 Fuenlabrada Sub 19 C Fuenlabrada 34 109 53 67
5 Escuela Futbol de Brunete Escuela 34 91 62 62
6 CD Móstoles C Móstoles 34 78 61 56
7 Atlético Pinto C Atlético 34 81 74 53
8 Lugo Fuenlabrada A Lugo 34 64 58 53
9 Municipal Arroyomolinos A Municipal 34 71 63 50
10 La Avanzada A Avanzada 34 67 64 47
11 Aluche B Aluche B 34 62 81 43
12 Trival Valderas Alcorcón C Trival 34 68 61 42
13 Libertad Alcorcón A Libertad 34 43 59 40
14 Real Carabanchel B Real 34 57 79 40
15 Fortuna Sub 19 Fortuna 34 53 82 37
16 Parla Escuela B Parla 34 42 99 31
17 Moraleja Enmedio A Moraleja 34 57 100 27
18 Colonia Moscardo B Colonia 34 42 116 13
TEMPORADA 2017/2018
1ª MADRID JUVENIL GRUPO 7
Equipo PJ GF GC Puntos
1 Nuevo Boadilla Sub 19 Nuevo 30 119 32 77
2 Aluche B Aluche B 30 86 34 70
3 Moratalaz E Moratalaz E 30 99 41 69
4 Pasillo Verde Arganzuela Pasillo 30 79 36 60
5 Móstoles D Móstoles D 30 79 51 55
6 Estudiantes Alcorcón A Estudiantes 30 75 80 44
7 E Amistad Alcorcon A Amistad 30 63 55 43
8 Carabanchel C Carabanchel 30 50 69 43
9 Los Yebenes-San Bruno C Yebenes-San 30 63 53 42
10 Boadilla B Boadilla B 30 71 66 40
11 Carabanchel EF Carabanchel 30 45 62 38
12 Atlético Cañada Atlético 30 57 58 36
13 Móstoles CF Móstoles 30 35 64 30
14 Villaviciosa de Odon B Villaviciosa 30 41 101 18
15 Libertad Alcorcón A Libertad 30 35 113 10
16 Puerta Bonita B Puerta 30 22 104 10
TEMPORADA 2016/2017
1ª MADRID JUVENIL GRUPO 7
Equipo PJ GF GC Puntos
1 Real Carabanchel B Real 30 130 26 80
2 Los Yébenes San Bruno B Yébenes 30 121 38 67
3 Atlético Cañada Atlético 30 125 50 61
4 Boadilla B Boadilla B 30 80 52 61
5 Aluche B Aluche B 30 72 44 56
6 Puerta Bonita C Puerta 30 103 59 55
7 E Amistad Alcorcon A Amistad 30 81 52 49
8 Nuevo Boadilla B Nuevo 30 90 60 45
9 Colonia Moscardo C Colonia 30 56 48 45
10 Carabanchel EF Carabanchel 30 75 70 40
11 Villaviciosa de Odon B Villaviciosa 30 80 84 39
12 Estudiantes Alcorcón A Estudiantes 30 59 71 37
13 Vicalvaro D Vicalvaro D 30 58 88 31
14 Prodet Pozuelo Liceo Soroll Prodet 30 47 168 11
15 La Dehesa La Dehesa 30 47 154 9
16 Adepo-Palomeras B Adepo-Palome 30 29 189 7
TEMPORADA 2015/2016
PREFERENTE MADRID JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Complutense Alcalá Sub 19 Complutense 34 119 42 79
2 Concepción A Concepción 34 93 39 78
3 San Blas A San Blas A 34 79 40 66
4 San Fernando C Fernando 34 92 55 66
5 San Roque EFF Roque 34 62 29 65
6 Alcalá C Alcalá C 34 103 49 64
7 Torrejon B Torrejon B 34 74 56 51
8 Esperanza A Esperanza A 34 69 63 47
9 La Chimenea B Chimenea 34 69 77 44
10 Rayo CI Alcobendas Sub 19 B Rayo 34 68 74 42
11 Villa Rosa A Villa Rosa 34 68 73 41
12 Canillas B Canillas B 34 43 45 40
13 Fuente el Saz A Fuente 34 44 56 38
14 Coslada Coslada 34 66 79 38
15 Aluche B Aluche B 34 47 85 32
16 Dosa A Dosa A 34 66 104 31
17 Naya A Naya A 34 46 126 22
18 Paracuellos A Paracuellos 34 30 146 13
TEMPORADA 2014/2015
1ª MADRID JUVENIL GRUPO 7
Equipo PJ GF GC Puntos
1 Nuevo Boadilla Sub 19 Nuevo 27 73 24 69
2 Aluche B Aluche B 27 75 26 59
3 Puerta Bonita B Puerta 27 83 41 57
4 Prodet Pozuelo Liceo Soroll Prodet 27 64 41 53
5 Boadilla B Boadilla B 27 61 43 49
6 San Viator San Viator 27 60 37 47
7 Los Yébenes San Bruno B Yébenes 27 74 63 43
8 Trival Valderas Alcorcón C Trival 27 54 48 38
9 Real Caravanchel C Real 27 47 54 33
10 Betis San Isidro Betis Isidro 27 60 76 29
11 Colonia Moscardo C Colonia 27 33 50 28
12 Ciempozuelos FB Ciempozuelos 27 43 66 26
13 Goya Goya 27 42 90 19
14 Parque Europa Parque 27 18 86 10
15 Atlético Leganés B Atlético 14 0 42 0

  USO DE MEMORIA  
5,652,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1472
Total Execution Time  0.1488
  CADENA URL  
/historico/Aluche-B-Juvenil
  GET DATOS  
$_GET['/historico/Aluche-B-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0044  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 = 'Aluche-B-Juvenil' 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.0040  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 = 'Aluche-B-Juvenil' 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.0020  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=22202 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=22202 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=22202 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=22202 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=22202 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=22202 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=22202 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=22202 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=22202 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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 = 64789
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22202 AND type_rel = 2
0.0024  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 = '22202' 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 = '22202' AND l.year = 2022 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 = '22202' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '22202' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 64789 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=22202 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0036  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 (64789,61293) 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.0021  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64789 AND teamId = 22202
0.0041  SELECT count(id) as num_players from rel_players_base WHERE league_id = 61293 AND teamId = 22202
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 64789 AND t.round = 34 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 = '22202' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '22202' and rp.type = 4
0.0021  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 = '22202' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 22202 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030  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_base` 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 = 64789 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.0033  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_base` 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 = 61293 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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_base` 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 = 52063 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.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 `tables2019_base` 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 = 45654 AND t.round = 34 ORDER BY team.conference 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 `tables2018_base` 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 = 39884 AND t.round = 30 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 `tables2017_base` 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 = 34198 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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_base` 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 = 16974 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 4607 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 64789 ORDER BY nameShow LIMIT 100