4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Puerto De Motril CF
TEMPORADA 2022/2023
4ª ANDALUZA GRANADA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Albuñol Albuñol 26 116 46 69
2 Costa Tropical Costa 25 103 40 62
3 Almuñecar City Almuñecar 26 106 40 60
4 Atletico Salobreña Atletico 26 102 30 56
5 Puerto De Motril CF Puerto 26 67 44 50
6 CD Velez De Benaudalla Velez 26 74 59 45
7 Club Deportivo Almuñecar 20 Club 26 93 76 40
8 Padul Balompie Padul 26 71 62 35
9 Los Marinos Los Marinos 26 47 101 24
10 Club Deportivo Origen Valle Club 25 49 87 20
11 Torrenueva 1972 Torrenueva 23 39 85 17
12 CD Durcal CD Durcal 25 40 104 15
13 Orgiva Orgiva 26 63 108 14
14 CD Cultural Asako Motril Cultural 26 33 121 11
TEMPORADA 2021/2022
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 C.D. Churriana de la Vega C.D. 29 101 41 66
2 CD Vandalia de Peligros Vandalia 30 89 57 60
3 Atlético La Zubia A Atlético 30 81 42 58
4 Cubillas de Albolote Cubillas 30 76 48 55
5 Otura CF Otura CF 30 82 55 49
6 U.D. Alfacar U.D. Alfacar 30 58 48 49
7 Reino De Granada B Reino 30 71 57 46
8 UD Maracena C Maracena 30 67 63 42
9 CD UD Illora Illora 29 66 70 40
10 Club de Fútbol Estudiantes Club Fútbol 30 72 85 39
11 CF Sierra Nevada-Cenes Sierra 30 85 91 38
12 Fuente Vaqueros Fuente 30 60 74 36
13 Puerto De Motril CF Puerto 29 49 98 30
14 Sporting Vegas del Genil Sporting 30 53 86 27
15 Atletico Salobreña Atletico 30 50 83 27
16 Zaidin Zaidin 29 40 102 16
TEMPORADA 2020/2021
3ª ANDALUZA GRANADA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Ogijares 89 CF Ogijares 16 59 27 35
2 Almuñécar 77 Almuñécar 16 60 25 34
3 Ciudad de Granada Ciudad 16 45 43 29
4 Atlético Salobreña Atlético 16 48 24 28
5 Puerto De Motril CF Puerto 16 33 28 22
6 At. La Zubia Zubia 16 29 32 19
7 Otura CF Otura CF 15 31 50 15
8 At. Padul At. Padul 15 20 55 12
9 Gabia Atlético CF Gabia 16 17 58 6
TEMPORADA 2019/2020
3ª ANDALUZA GRANADA JUVENIL
Equipo PJ GF GC Puntos
1 CF Sierra Nevada-Cenes Sierra 24 59 33 56
2 Huétor Vega CD Huétor Vega 24 68 44 55
3 Zaidin Zaidin 24 63 23 48
4 Fuente Vaqueros Fuente 24 52 37 47
5 CD Ciudad de Granada FF Abo Ciudad 24 61 29 45
6 UD Maracena C Maracena 22 61 42 42
7 At. Padul At. Padul 24 57 50 37
8 C.D. Albolote Soccer Alda A C.D. 24 49 42 37
9 CD Huescar CD Huescar 24 49 48 37
10 Montefrio CF Montefrio 24 48 41 34
11 Granada Origen Granada 24 51 46 34
12 At. La Zubia Zubia 23 33 34 31
13 Ogijares 89 CF Ogijares 24 36 49 29
14 Puerto De Motril CF Puerto 24 40 55 25
15 Gabia Atlético CF Gabia 24 42 58 17
16 Otura CF Otura CF 23 34 63 14
17 Estrellas Parque Nueva Gran Estrellas 24 41 90 11
18 Celtic CF Celtic CF 24 19 79 4

  USO DE MEMORIA  
4,896,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0621
Total Execution Time  0.0640
  CADENA URL  
/historico/Puerto-De-Motril-Cf-Juvenil
  GET DATOS  
$_GET['/historico/Puerto-De-Motril-Cf-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0043  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 = 69877
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=127990 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=443 AND type_rel = 3
0.0020  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 = '127990' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 69877 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=127990 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (69877,65919) 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.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69877 AND teamId = 127990
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65919 AND teamId = 127990
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 = 127990 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 69877 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.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 `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 = 65919 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.0021  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 = 59774 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.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 `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 = 53859 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