4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Loreto Sub 8
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla Sub 8 Sevilla 28 244 16 84
2 Real Betis Balompie Sub 8 Real Betis. 28 184 47 72
3 UD Tomares Sub 8 Tomares 28 153 57 71
4 San Roque Balompie Sub 8 Roque 28 120 67 56
5 AAVV Centro Histórico Sub 8 AAVV Centro 27 107 79 55
6 Castilleja Sub 8 Castilleja 28 80 81 45
7 Coria CF Sub 8 Coria 28 92 109 45
8 Umbrete Sub 8 Umbrete 28 82 96 41
9 Camas Sub 8 Camas Sub 8 27 71 86 33
10 AD Dani Triana Sub 8 Dani Triana 28 79 116 30
11 Lora CF Sub 8 Lora 28 75 129 23
12 Calavera CF Sub 8 Calavera 28 53 107 22
13 Loreto Sub 8 Loreto 28 54 143 20
14 Atlético Algabeño Sub 8 Atlético 28 44 121 16
15 Colegio Claret Sub 8 Colegio 28 71 173 16
16 Juventud Dva. Gines Sub 8 Juventud 28 40 122 12
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 255 11 90
2 UD Tomares Sub 8 Tomares 29 156 80 70
3 Sevilla Sub 8 B Sevilla 30 136 74 63
4 San Roque Balompie Sub 8 Roque 30 143 69 57
5 Umbrete Sub 8 Umbrete 30 107 82 57
6 Camas Sub 8 Camas Sub 8 30 114 77 55
7 Loreto Sub 8 Loreto 30 92 70 51
8 Coria CF Sub 8 Coria 30 137 102 49
9 David Castedo 3 (DC 3) David 30 110 128 43
10 Lora CF Sub 8 Lora 30 89 128 37
11 Montequinto Sub 8 Montequinto 30 98 104 36
12 Castilleja Sub 8 Castilleja 30 82 128 28
13 SAM-CAM Dos Hermanas Sub 8 SAM-CAM 30 84 145 26
14 Cud Santiponce Sub 10 Santiponce 29 69 182 13
15 Municipal de Gerena Sub 10 Municipal 30 49 230 9
16 CD Esfubasa Sub 10 Esfubasa 30 52 203 7
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 32 234 9 96
2 Real Betis Balompie Sub 8 Real Betis. 32 226 35 85
3 San Roque Balompie Sub 8 Roque 32 159 47 80
4 Loreto Sub 8 Loreto 32 139 75 70
5 Tomares A Tomares A 32 115 76 61
6 Camas Sub 8 Camas Sub 8 32 146 102 56
7 Castilleja Sub 8 Castilleja 32 107 113 48
8 David Castedo 3 (DC 3) David 32 96 105 44
9 Coria CF Sub 8 Coria 32 92 122 42
10 Sededos Sub 8 Sededos 32 92 132 40
11 San Alberto Magno Alberto 32 93 117 39
12 Montequinto Sub 8 Montequinto 32 92 135 38
13 Club Polideportivo Bormujos Club 32 54 95 33
14 Lora CF Sub 8 Lora 32 71 150 33
15 Salteras A Salteras A 32 76 142 24
16 La Liara Balompie Liara 32 36 216 6
17 Mairena del Aljarafe Sub 10 Mairena 32 31 188 4
TEMPORADA 2020/2021
4ª ANDALUZA SEVILLA BENJAMIN GRUPO 11
Equipo PJ GF GC Puntos
1 Loreto Sub 8 Loreto 12 74 24 31
2 Tomares A Tomares A 12 74 26 29
3 Montequinto B Montequinto 12 64 20 29
4 Club Polideportivo Bormujos Club 13 52 43 24
5 El Regate El Regate 11 58 32 21
6 Nueva Sevilla A Nueva 13 46 49 18
7 CD David Castedo 3 (dc 3) David 12 54 41 17
8 San Alberto Magno B Alberto 12 38 46 9
9 Atlético Algabeño B Atlético 10 19 49 6
10 Juventud Dva. Gines Sub 8 Juventud 12 15 81 5
11 Castilleja Sub 8 Castilleja 13 21 104 1
TEMPORADA 2019/2020
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Mairena del Aljarafe A Mairena 21 129 42 56
2 Sevilla A Sevilla A 21 125 43 52
3 CD Salteras CD Salteras 21 113 52 44
4 Benacazon Benacazon 22 101 66 41
5 Umbrete Sub 8 Umbrete 22 81 58 37
6 Juventud Gines Juventud 22 78 70 34
7 Castilleja A Castilleja 21 62 72 34
8 Loreto Sub 8 Loreto 22 84 85 32
9 Guillena Sub 10 Guillena 21 84 90 32
10 CD FB Juventud Deportiva Juventud 21 94 72 31
11 Tor del Rey de Pilas Pilas 21 79 92 29
12 Camas Sub 10 B Camas 22 78 80 26
13 Camino Viejo Camino Viejo 22 63 120 12
14 UD Manantial Manantial 21 39 125 8
15 Villafranco Villafranco 22 36 179 3
TEMPORADA 2018/2019
4ª ANDALUZA SEVILLA BENJAMIN GRUPO 9
Equipo PJ GF GC Puntos
1 Mairena del Aljarafe A Mairena 28 255 31 84
2 Huevar Huevar 28 188 32 78
3 Club Atletico Aznalcazar Club 28 142 55 66
4 El Regate El Regate 28 149 76 66
5 Atletico Sanlucar A Atletico 28 182 67 61
6 Academia Ugena Academia 28 75 79 40
7 San Martin B Martin 28 99 123 37
8 Benacazon Benacazon 28 77 121 35
9 Loreto Sub 8 Loreto 28 77 135 28
10 Camino Viejo A Camino Viejo 28 69 118 26
11 Tor del Rey de Pilas Pilas 28 78 141 26
12 Almensilla Almensilla 28 69 121 25
13 Villafranco Villafranco 28 57 134 24
14 Gelves Gelves 28 54 147 22
15 Cmd San Juan Juan 28 30 222 2
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 7
Equipo PJ GF GC Puntos
1 Ciudad de Moron Ciudad Moron 14 86 36 35
2 Loreto Sub 8 Loreto 14 56 41 32
3 Alcala Alcala 14 52 46 24
4 Andalucia Este CF A Andalucia 14 50 46 24
5 Atlético Algabeño Sub 10 Atlético 14 53 48 17
6 CD Antonio Puerta A Antonio 14 47 52 15
7 Villafranco Villafranco 14 49 65 8
8 Consolacion Consolacion 14 22 81 4
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Loreto Sub 8 Loreto 30 202 48 88
2 Villafranco Villafranco 30 157 36 77
3 Castilleja Sub 8 Castilleja 30 143 51 70
4 Mairena del Aljarafe Sub 10 Mairena 30 153 69 64
5 San Roque Balompie Sub 8 Roque 30 127 73 56
6 Tor del Rey de Pilas Pilas 30 151 100 56
7 Camino Viejo Camino Viejo 30 110 102 52
8 Umbrete A Umbrete A 30 120 85 50
9 Benacazon A Benacazon A 30 92 91 45
10 Camas A Camas A 30 79 110 31
11 Juventud Gines Juventud 30 99 119 30
12 Betisevilla Betisevilla 30 101 160 27
13 Guillena Sub 10 Guillena 30 64 163 15
14 Tomares Tomares 30 55 188 14
15 Atletico Libertad A Atletico 30 48 201 12
16 CD Esfubasa B Esfubasa 30 62 167 11
TEMPORADA 2015/2016
4ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Atletico Libertad A Atletico 28 248 36 81
2 Villafranco Villafranco 28 141 60 65
3 Benacazon A Benacazon A 28 185 92 63
4 Camino Viejo A Camino Viejo 28 157 89 59
5 Futbol Base Juv de La Puebl Futbol Base 28 171 81 57
6 Academia Ugena Academia 28 119 71 53
7 Nueva Sevilla A Nueva 28 140 76 50
8 Loreto Sub 8 Loreto 28 135 87 47
9 Cmd San Juan A Juan 28 122 80 40
10 Mairena del Aljarafe A Mairena 28 83 135 26
11 Bormujos Bormujos 28 86 118 25
12 Tor del Rey de Pilas A Pilas 28 95 185 22
13 Gelves Gelves 28 98 228 10
14 El Regate El Regate 28 35 255 7
15 Tomares A Tomares A 28 22 229 3
16 Palomares Junior Palomares 0 0 0 0
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 San Martin B Martin 28 205 30 73
2 Club Atletico Aznalcazar Club 28 194 63 73
3 Puebla Puebla 28 164 72 65
4 Atletico Libertad B Atletico 28 209 75 64
5 Villafranco Villafranco 28 181 62 63
6 Bormujos Mueve A Bormujos 28 112 71 48
7 Gelves Gelves 28 134 83 47
8 Academia Ugena Academia 28 161 91 45
9 Loreto Sub 8 Loreto 28 103 123 37
10 Tor del Rey de Pilas A Pilas 28 119 117 36
11 Benacazon B Benacazon B 28 103 149 26
12 Castilleja B Castilleja 28 61 249 18
13 Palomares Junior Palomares 28 64 170 12
14 Nueva Sevilla B Nueva 28 45 246 12
15 Tomares Tomares 28 33 255 0

  USO DE MEMORIA  
5,680,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5451
Total Execution Time  0.5472
  CADENA URL  
/historico/Ud-Loreto-Benjamin
  GET DATOS  
$_GET['/historico/Ud-Loreto-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0140  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 = 'Ud-Loreto-Benjamin' 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=33264 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=33264 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  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 = 74452
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=33264 AND type_rel = 2
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=855 AND type_rel = 3
0.0128  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 = '33264' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '33264' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '33264' 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,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 = 74452 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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=33264 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0132  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 (74452) 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.0131  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74452 AND teamId = 33264
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 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 = 74452 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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 = '33264' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '33264' and rp.type = 4
0.0135  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 = '33264' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0143  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 = 33264 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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_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 = 74452 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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_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 = 69680 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.0142  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 = 64499 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.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 `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 = 60704 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_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 = 60785 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.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_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 = 54037 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 `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 = 53338 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.0127  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 = 44980 AND t.round = 14 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 `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 = 45297 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 `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 = 40537 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 42868 AND t.round = 14 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 `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 = 34854 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 18249 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 6013 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 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 = 74452 ORDER BY nameShow LIMIT 100