4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Guadalmar A
TEMPORADA 2021/2022
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Athl. Puerta Blanca Sub 19 Athl. Puerta 28 99 28 69
2 CD Rincón Sub 19 Rincón 30 89 31 68
3 Pto.Malagueño C.Jrdn Sub 19 Pto.Malague 30 88 39 63
4 Futbol Romeral CD Futbol 30 69 45 52
5 CD Conejito de Malaga Conejito 30 59 49 52
6 Guadalmar A Guadalmar A 30 86 72 51
7 Cortijillo Bazán Sub 19 Cortijillo 29 69 48 49
8 UD Dos Hermanas SA C Hermanas 30 73 64 45
9 Club Deportivo Trabuco Club 29 55 51 43
10 Mortadelo Sub 19 Mortadelo 30 53 79 38
11 Olimpica Victoriana CF A Olimpica 29 64 71 37
12 Malaka CF Sub 19 Malaka 30 46 63 33
13 Alhaurin de la Torre CF B Alhaurin 30 55 80 30
14 Roma Luz Sub 19 Roma 30 35 73 22
15 Cartama CD Cartama CD 28 38 85 18
16 Campanillas Campanillas 29 20 120 1
TEMPORADA 2020/2021
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CD La Unidad Nueva Malaga Unidad Nueva 16 38 11 34
2 Club Deportivo Trabuco Club 16 34 25 29
3 Mortadelo Sub 19 Mortadelo 16 38 38 25
4 Roma Luz Sub 19 Roma 16 25 23 24
5 Malaka CF Sub 19 Malaka 16 29 32 23
6 Campanillas Campanillas 16 42 33 22
7 Guadalmar A Guadalmar A 16 27 33 20
8 Archidona Archidona 16 30 40 18
9 Benalmadena CD Benalmadena 16 16 44 8
TEMPORADA 2019/2020
3ª ANDALUZA MÁLAGA JUVENIL
Equipo PJ GF GC Puntos
1 Futbol Romeral CD Futbol 22 60 20 53
2 Malaka CF Sub 19 Malaka 22 92 38 50
3 Mortadelo Sub 19 Mortadelo 22 55 29 50
4 Archidona Archidona 22 40 33 40
5 Pto.Malagueño C.Jrdn Sub 19 Pto.Malague 22 59 40 37
6 Club Deportivo Trabuco Club 22 46 36 31
7 Vélez C.F. Vélez C.F. 22 56 52 30
8 Futbol Base Torreño Futbol Base 22 37 33 28
9 Benagalbon CD Benagalbon 22 43 48 28
10 Roma Luz Sub 19 Roma 22 33 38 26
11 Campanillas Campanillas 22 50 60 26
12 UD Dos Hermanas SA C Hermanas 22 37 40 25
13 Benalmadena CD Benalmadena 22 30 54 21
14 Alhaurin de la Torre CF B Alhaurin 22 22 47 18
15 Cartama CD Cartama CD 22 26 77 14
16 Guadalmar A Guadalmar A 22 35 76 9
TEMPORADA 2018/2019
3ª ANDALUZA MÁLAGA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Ronda UD Ronda UD 29 60 29 65
2 Benagalbon CD Benagalbon 30 62 41 56
3 El Palo FC Sub 19 Palo 29 60 33 54
4 Campanillas Campanillas 29 66 41 50
5 Torrox CD Torrox CD 30 52 49 43
6 Roma Luz Sub 19 Roma 29 48 45 43
7 Archidona Archidona 30 44 39 42
8 Club Deportivo Trabuco Club 29 54 59 41
9 Futbol Base Torreño Futbol Base 29 34 36 36
10 Guadalmar A Guadalmar A 29 53 61 35
11 Vélez C.F. Vélez C.F. 30 48 59 35
12 Futbol Romeral CD Futbol 30 48 54 34
13 Cartama CD Cartama CD 30 41 54 33
14 Malaka CF Sub 19 Malaka 29 36 66 29
15 Atlético Juval B Atlético 29 41 58 27
16 Algarrobo Algarrobo 21 32 55 17

  USO DE MEMORIA  
4,882,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.3127
Total Execution Time  0.3140
  CADENA URL  
/historico/Cd-Guadalmar-A-Juvenil
  GET DATOS  
$_GET['/historico/Cd-Guadalmar-A-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=95264 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=440 AND type_rel = 3
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 440 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (990553,139180,70968) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '95264' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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 = '95264' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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=95264 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (65927) 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.0149  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65927 AND teamId = 95264
0.0158  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 = 95264 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0168  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 = 65927 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.0147  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 = 59780 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.0153  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 = 52186 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.0153  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 = 45801 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC