4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Romeral Sub 16
TEMPORADA 2023/2024
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 Puerto Malagueño Sub 16 B Puerto 27 85 25 74
2 Mortadelo Sub 16 Mortadelo 27 76 21 70
3 Malaka Sub 16 Malaka 27 84 15 69
4 26 de Febrero Sub 16 Febrero 27 84 36 60
5 Alh. De La Torre Sub 16 B Alh. Torre 27 43 47 38
6 El Palo FC Sub 16 Palo 27 60 48 37
7 Fuengirola Boliches Sub 16 Fuengirola 27 41 43 35
8 Estepona Sub 16 Estepona 27 42 45 34
9 Velez F. Castejón Sub 16 Velez 26 37 50 34
10 Romeral Sub 16 Romeral 27 41 51 31
11 Jose Santacruz Sub 16 Jose 27 39 60 29
12 Tiro Pichon Sub 16 B Tiro Pichon 27 40 56 28
13 Carlinda Sub 16 Carlinda 27 34 71 23
14 Athl. Puerta Blanca Sub 16 Athl. Puerta 26 33 62 21
15 D. Hermanas S.Andres Sub 16 Hermanas 27 37 81 21
16 Alora Sub 16 Alora 27 24 89 14
TEMPORADA 2022/2023
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 Marbella Paraiso Sub 16 Marbella 30 127 41 77
2 Mortadelo Sub 16 Mortadelo 30 112 37 76
3 D. Hermanas S.Andres Sub 16 Hermanas 30 73 41 64
4 Tiro Pichon Sub 16 B Tiro Pichon 30 79 54 60
5 Malaka Sub 16 Malaka 30 65 48 55
6 26 de Febrero Sub 16 Febrero 30 68 64 48
7 Fuengirola Boliches Sub 16 Fuengirola 30 73 53 47
8 El Palo FC Sub 16 Palo 30 66 64 39
9 Romeral Sub 16 Romeral 30 78 78 38
10 Jose Santacruz Sub 16 Jose 30 52 65 37
11 Puerto Malagueño Sub 16 B Puerto 30 46 57 34
12 Velez F. Castejón Sub 16 Velez 30 62 82 34
13 Vázquez Cultural Vázquez 30 46 79 28
14 CD Juventud De Torremolinos Juventud 30 56 107 22
15 Atletico Estacion Sub 16 Atletico 30 39 115 14
16 Mijas Las Lagunas Mijas 30 29 86 12
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 D. Hermanas S.Andres Sub 16 Hermanas 29 95 42 73
2 Atletico Juval Atletico 29 105 38 71
3 Atletico Estacion Sub 16 Atletico 30 88 35 70
4 Antequera Antequera 30 82 49 52
5 Romeral Sub 16 Romeral 30 84 60 51
6 Puerto Malagueño C Puerto 30 66 49 48
7 La Unidad Nueva Malaga Unidad Nueva 30 49 59 45
8 Faro de Torrox Asociacion Faro Torrox 29 67 73 42
9 Rincon A Rincon A 30 70 72 41
10 Mortadelo A Mortadelo A 30 64 73 37
11 Malaka Sub 16 Malaka 30 65 74 36
12 San Estanislao Sub 16 Estanislao 30 44 67 36
13 Olimpica Victoriana Sub 16 Olimpica 29 72 85 34
14 AD Cortijillo Bazan Cortijillo 30 57 75 26
15 EF Velez Francisco Castejon Velez 30 33 74 16
16 Pizarra Atlético Pizarra 30 41 157 5
TEMPORADA 2020/2021
4ª ANDALUZA MÁLAGA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 San Félix Sub 16 Félix 28 101 22 72
2 Malaka A Malaka A 28 119 31 69
3 CD Trabuco CD Trabuco 28 152 34 68
4 Carlinda Sub 16 Carlinda 27 124 54 50
5 CD Conejito de Malaga Conejito 27 94 63 47
6 Puerto Malagueño C Puerto 28 83 62 45
7 Sierra de Yeguas Sierra 26 77 78 41
8 Villanueva Rosario Villanueva 28 94 83 39
9 La Unidad Nueva Malaga A Unidad Nueva 28 65 82 38
10 CD Málaga Litoral CF Málaga 28 89 104 34
11 San Estanislao B Estanislao 28 61 119 25
12 Portada Alta Atco. Portada Alta 28 60 108 24
13 Casabermeja Casabermeja 28 34 77 20
14 Romeral Sub 16 Romeral 28 35 124 16
15 Alhaurin de la torre C Alhaurin 28 36 183 6
TEMPORADA 2019/2020
2ª ANDALUZA MÁLAGA CADETE
Equipo PJ GF GC Puntos
1 Marbella FC Marbella FC 24 67 26 57
2 Velez Francisco Castejon EF Velez 24 56 28 50
3 UD San Pedro Pedro 24 65 37 48
4 Estepona Sub 16 Estepona 23 52 25 47
5 Romeral Sub 16 Romeral 24 42 32 43
6 Conejito de Malaga Conejito 24 48 37 37
7 Antequera Antequera 24 51 47 36
8 Tiro Pichon Sub 16 B Tiro Pichon 22 41 33 35
9 CD Rincón CD Rincón 24 46 38 34
10 26 de Febrero Sub 16 Febrero 24 48 46 34
11 Alhaurin de La Torre Alhaurin 23 39 37 34
12 Mortadelo Sub 16 Mortadelo 23 41 45 32
13 D. Hermanas S.Andres Sub 16 Hermanas 24 44 59 28
14 Atletico Benamiel A Atletico 24 33 49 23
15 Puerto de La Torre Los Mora Puerto Torre 24 36 55 23
16 Athletic Club Fuengirola Athletic 23 39 47 22
17 Athletic Puerta Blanca Athletic 24 45 77 14
18 Peña Compadres Peña 24 20 95 4
TEMPORADA 2018/2019
4ª ANDALUZA MÁLAGA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Malaka A Malaka A 29 169 16 81
2 Portada Alta Atlético Portada Alta 30 170 28 74
3 EF de Velez F. Castejon Velez 30 129 36 70
4 Carlinda Sub 16 Carlinda 30 149 38 67
5 Nerja Fund. Cueva B Nerja Fund. 30 125 38 66
6 Santa Rosalia Maqueda Santa 30 96 46 61
7 La Mosca C La Mosca C 30 117 62 56
8 Athletic de Coin B Athletic 29 75 87 43
9 Romeral Sub 16 Romeral 30 49 97 37
10 San Estanislao B Estanislao 30 63 120 30
11 Pizarra B Pizarra B 30 59 116 30
12 Torremoya B Torremoya B 30 41 87 28
13 La Unidad Nueva Malaga A Unidad Nueva 30 41 160 14
14 Málaga C.F. SAD Fem Málaga C.F. 30 31 131 12
15 Lauro B Lauro B 30 30 167 12
16 Los Morales Sub Sub 16 B Morales 30 33 148 11
TEMPORADA 2017/2018
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Puerto Malagueño C Puerto 30 116 12 85
2 Tiro Pichon Sub 16 B Tiro Pichon 30 128 50 68
3 Cortijillo Bazan Cortijillo 30 80 34 64
4 El Palo FC Sub 16 Palo 30 116 45 61
5 Atlético Juval Atlético 30 126 40 60
6 Romeral Sub 16 Romeral 30 90 41 60
7 Peña Compadres B Peña 30 92 50 52
8 Puerto de La Torre Los Mora Puerto Torre 30 87 78 49
9 Asociacion Faro de Torrox Asociacion 30 65 46 41
10 Jose Santacruz Sub 16 Jose 30 61 86 36
11 Mortadelo A Mortadelo A 30 53 74 35
12 La Unidad Nueva Malaga Unidad Nueva 30 38 76 27
13 CD Juventud De Torremolinos Juventud 30 51 105 23
14 La Mosca C La Mosca C 30 43 134 16
15 Algarrobo Algarrobo 30 44 110 14
16 La Cala A La Cala A 30 21 230 5
TEMPORADA 2016/2017
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Roma Luz C.F. Roma C.F. 30 89 23 73
2 Mortadelo Sub 16 Mortadelo 29 114 33 67
3 Asociacion Faro de Torrox Asociacion 30 114 40 66
4 El Palo FC Sub 16 Palo 30 85 40 65
5 Puerto Malagueño C Puerto 30 82 39 55
6 Jose Santacruz Sub 16 Jose 30 96 49 53
7 Tiro Pichón B Tiro Pichón 30 76 51 47
8 Atlético Juval Atlético 30 60 59 42
9 Algarrobo Algarrobo 30 65 81 40
10 Puerto de La Torre Los Mora Puerto Torre 30 62 51 38
11 La Mosca C La Mosca C 30 66 87 32
12 La Unidad Nueva Malaga Unidad Nueva 30 65 84 28
13 Romeral Sub 16 Romeral 30 48 78 25
14 Portada Alta Atlético Portada Alta 30 59 122 24
15 Futbol Base Torreño CDAD Futbol Base 30 32 145 13
16 Malaka A Malaka A 29 31 162 9
TEMPORADA 2015/2016
4ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 Puerto Malagueño CJ GI Puerto 30 172 18 86
2 Carlinda Sub 16 Carlinda 30 170 44 74
3 26 de Febrero Sub 16 Febrero 30 135 39 69
4 Romeral Sub 16 Romeral 30 114 42 65
5 Lauro A Lauro A 30 85 46 54
6 Mortadelo A Mortadelo A 30 94 61 51
7 Olimpica Victoriana Sub 16 Olimpica 30 121 79 48
8 AD Cortijillo Bazan Cortijillo 30 104 60 46
9 El Palo FC Sub 16 B Palo 30 93 105 38
10 Rincon A Rincon A 30 80 111 38
11 Portada Alta Atlético Portada Alta 30 49 127 30
12 Santa Rosalia Maqueda Santa 30 59 124 26
13 La Unidad Nueva Malaga A Unidad Nueva 30 47 97 25
14 San Estanislao Sub 16 Estanislao 30 61 189 24
15 Puerto de la Torre A Puerto Torre 30 40 200 11
16 Atletico Estacion A Atletico 30 53 135 10
TEMPORADA 2014/2015
4ª ANDALUZA MÁLAGA CADETE GRUPO 2
Equipo PJ GF GC Puntos
1 La Unidad Nueva Malaga A Unidad Nueva 26 95 22 69
2 Mortadelo A Mortadelo A 26 112 21 64
3 Atletico Estacion A Atletico 26 114 35 57
4 Puerto Malagueño CJ GI Puerto 26 73 47 47
5 La Cala A La Cala A 26 113 57 46
6 AD Cortijillo Bazan Cortijillo 26 74 38 46
7 Romeral Sub 16 Romeral 26 62 41 42
8 Atletico Juval Atletico 26 53 36 37
9 Rincon A Rincon A 26 54 64 32
10 El Palo FC Sub 16 B Palo 26 47 75 28
11 Lauro Sub 16 Lauro 26 43 118 17
12 Puerto Torre Morales A Puerto Torre 26 34 114 17
13 Amigos del Deporte Colmenar Amigos 26 40 143 10
14 Portada Alta Portada Alta 26 35 138 10

  USO DE MEMORIA  
5,810,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5036
Total Execution Time  0.5049
  CADENA URL  
/historico/Futbol-Romera-Cadete
  GET DATOS  
$_GET['/historico/Futbol-Romera-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
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 = 'Futbol-Romera-Cadete' 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=25541 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=25541 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 74230
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25541 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=449 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 = '25541' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '25541' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 74230 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=25541 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (74230) 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_base WHERE league_id = 74230 AND teamId = 25541
0.0126  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 = 74230 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '25541' 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 = '25541' and rp.type = 4
0.0128  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 = '25541' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129  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 = 25541 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74230 AND t.round = 27 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 `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 = 69858 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.0134  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 = 66044 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.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 `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 = 66113 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.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 `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 = 59161 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 `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 = 60449 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.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 `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 = 52470 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.0145  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 = 45488 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 40574 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 34346 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 17293 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 4887 AND t.round = 26 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 = 74230 ORDER BY nameShow LIMIT 100