4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Complutense Alcala A
TEMPORADA 2021/2022
PREFERENTE MADRID ALEVÍN F7 GRUPO 3
Equipo PJ GF GC Puntos
1 Atletico Madrileño B Atletico 26 232 55 69
2 Cfd Futuro San Francisco Futuro 26 135 49 60
3 Complutense Alcala A Complutense 26 136 67 59
4 Club Atletico de Madrid G Club 26 140 63 55
5 Alcala C Alcala C 26 95 55 53
6 Escfut El Olivo de Coslada Escfut Olivo 26 92 56 53
7 Atoledo Olivos A Atoledo 25 132 62 47
8 Gredos San Diego Alcala A Gredos Diego 26 96 88 37
9 Colegio San Gabriel A Colegio 26 59 79 27
10 Naya A Naya A 26 58 157 18
11 Mun Villarejo Villarejo 25 33 118 17
12 Cobeña B Cobeña B 26 41 135 16
13 San Fernando B Fernando 26 37 179 13
14 Coslada A Coslada A 26 5 128 3
TEMPORADA 2020/2021
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Madrileño A Atlético 17 59 19 42
2 Real Madrid C Real Madrid 17 53 18 38
3 San Sebastian Reyes A Sebastian 17 46 20 36
4 San Fernando A Fernando 17 38 14 34
5 R. Ciudad Alcobendas Sub 12 Ciudad 17 38 18 33
6 SAD Fundacion Rayo Vallecan Fundacion 17 40 23 30
7 Colegio Miramadrid Colegio 17 29 19 30
8 At. Chpr. Alcobendas Sub 12 Chpr. 17 35 21 29
9 Complutense Alcala A Complutense 17 26 23 26
10 Siete Picos Colmenar A Siete Picos 17 24 23 26
11 Getafe C Getafe C 17 26 25 24
12 Sanse A Sanse A 17 23 25 23
13 Fundacion RSD Alcala A Fundacion 17 31 28 19
14 AD Torrejon CF A Torrejon 17 23 34 17
15 Club Atletico de Madrid D Club 17 18 41 10
16 San Agustin de Guadalix A Agustin 17 20 61 10
17 Chamartin Vergara Alcobenda Chamartin 17 16 46 6
18 Escfut El Olivo de Coslada Escfut Olivo 17 10 97 4
TEMPORADA 2019/2020
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Real Madrid C Real Madrid 19 44 4 52
2 Rayo C. Alcobendas Sub 12 Rayo 19 49 13 45
3 Atletico Chopera Alcobendas Atletico 19 32 15 35
4 Getafe C Getafe C 19 26 13 35
5 San Fernando A Fernando 19 28 21 32
6 Complutense Alcala A Complutense 19 36 18 31
7 RSD Alcalá SAD Sub 12 Alcalá 19 34 31 28
8 San Sebastian Reyes A Sebastian 19 31 31 28
9 Fundacion Rayo Vallecano Fundacion 19 27 21 25
10 Sanse A Sanse A 19 27 41 20
11 Chamartin Vergara Alcobenda Chamartin 19 19 38 20
12 AD Torrejon CF Torrejon 19 32 54 16
13 At. Tharsis At. Tharsis 19 18 48 9
14 Escfut El Olivo de Coslada Escfut Olivo 19 11 66 2
TEMPORADA 2018/2019
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 R. Ciudad Alcobendas Sub 12 Ciudad 26 85 12 67
2 Real Madrid C Real Madrid 26 79 19 67
3 Complutense Alcala A Complutense 26 69 33 56
4 San Fernando A Fernando 26 60 28 50
5 Club Atletico de Madrid D Club 26 57 30 49
6 RSD Alcalá SAD Sub 12 Alcalá 26 74 36 45
7 San Sebastian Reyes A Sebastian 26 80 62 44
8 Union Deportiva La Poveda A Union 26 56 57 33
9 At. Chpr. Alcobendas Sub 12 Chpr. 26 52 53 30
10 Getafe C Getafe C 26 31 68 24
11 Paracuellos A Paracuellos 26 41 59 22
12 Atlético Madrileño A Atlético 26 36 70 20
13 Espartales Sur A Espartales 26 19 93 11
14 Avance A Avance A 26 15 134 5
TEMPORADA 2017/2018
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Real Madrid Sub 12 B Real Madrid 26 227 5 78
2 Rayo Vallecano B Rayo 26 83 37 55
3 RSD Alcalá SAD Sub 12 Alcalá 26 64 25 54
4 Complutense Alcala A Complutense 26 68 44 51
5 San Blas A San Blas A 26 70 42 50
6 San Roque A San Roque A 26 56 46 47
7 Club Atletico de Madrid D Club 26 69 43 43
8 Paracuellos A Paracuellos 26 51 72 33
9 EF Concepcion Sub 12 Concepcion 26 34 46 31
10 AD Torrejon CF A Torrejon 26 43 58 25
11 Espartales Sur A Espartales 26 38 76 25
12 Atletico Madrileño B Atletico 26 46 63 24
13 Parque Granada A Parque 26 21 144 5
14 Coslada A Coslada A 26 12 181 4
TEMPORADA 2016/2017
1ª MADRID ALEVÍN GRUPO 10
Equipo PJ GF GC Puntos
1 Atletico Alcala Atletico 24 184 36 70
2 Avance B Avance B 24 87 47 54
3 Gredos San Diego Alcala A Gredos Diego 24 127 48 52
4 Complutense Alcala A Complutense 24 113 50 49
5 Avance A Avance A 24 102 52 47
6 Gredos San Diego Alcala G Gredos Diego 24 86 75 37
7 Complutense Alcala B Complutense 24 92 100 31
8 San Gabriel A Gabriel 24 78 85 26
9 Rayo Velilla Rayo Velilla 24 70 90 25
10 Atletico Alcala B Atletico 24 109 130 23
11 CA Villalbilla Villalbilla 24 45 94 23
12 Club Ciudad Henares Club Ciudad 24 66 104 19
13 Atletico La Garena Atletico 24 33 255 0
TEMPORADA 2015/2016
1ª MADRID ALEVÍN GRUPO 9
Equipo PJ GF GC Puntos
1 Gredos San Diego Alcala A Gredos Diego 19 110 11 55
2 Chorrillo Distrito Viii Chorrillo 18 74 41 43
3 Complutense Alcala A Complutense 18 60 41 36
4 Complutense Alcala B Complutense 19 61 58 29
5 Avance Avance 18 60 50 29
6 Garena B Garena B 18 65 50 27
7 Garena A Garena A 18 52 58 23
8 Cfd Futuro San Francisco Futuro 18 51 81 13
9 Nuevo Baztan Nuevo Baztan 18 30 103 10
10 Atletico Alcala Atletico 19 22 83 7
11 Colegio Montfort Colegio 3 0 9 0
TEMPORADA 2014/2015
1ª AUTO. MADRID ALEVÍN F7 GRUPO 2
Equipo PJ GF GC Puntos
1 Alcala A Alcala A 26 89 16 61
2 Atlético C Atlético C 26 66 30 55
3 Real Madrid C Real Madrid 26 86 16 54
4 Coslada A Coslada A 26 57 24 47
5 Canillas Canillas 26 71 33 46
6 Getafe C Getafe C 26 65 30 42
7 Sporting Hortaleza A Sporting 26 47 37 42
8 Vicalvaro A Vicalvaro A 26 54 44 40
9 Club Fundacion Rayo Valleca Club 26 44 34 37
10 Complutense Alcala A Complutense 26 61 60 34
11 San Blas A San Blas A 26 36 47 27
12 EF Concepcion Sub 12 Concepcion 26 30 83 12
13 Parque Granada A Parque 26 16 110 7
14 Atletico Torrejon Ardoz A Atletico 26 17 175 4

  USO DE MEMORIA  
5,529,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1351
Total Execution Time  0.1371
  CADENA URL  
/historico/Ad-Complutense-Alcala-A-Alevin
  GET DATOS  
$_GET['/historico/Ad-Complutense-Alcala-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0028  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 = 'Ad-Complutense-Alcala-A-Alevin' 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.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 = 'Ad-Complutense-Alcala-A-Alevin' 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=38921 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=38921 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=38921 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=38921 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=38921 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=38921 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=38921 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=38921 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=38921 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=38921 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=38921 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=38921 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 = 64881
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=38921 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2505 AND type_rel = 3
0.0029  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 = '38921' ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '38921' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '38921' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = 64881 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 = 64893 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  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=38921 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (64893,64881,61491) 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_base WHERE league_id = 64881 AND teamId = 38921
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64893 AND teamId = 38921
0.0021  SELECT count(id) as num_players from rel_players_base WHERE league_id = 61491 AND teamId = 38921
0.0019  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 = 64881 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '38921' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '38921' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 = 38921 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 64881 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.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 `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 = 61491 AND t.round = 17 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 `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 = 52473 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.0025  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 = 45482 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 `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 = 41620 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 34514 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 36346 AND t.round = 26 ORDER BY team.conference 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 `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 = 17996 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 18936 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 6529 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 64881 ORDER BY nameShow LIMIT 100