4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Faro de Torrox Asociacion
TEMPORADA 2022/2023
3ª ANDALUZA MÁLAGA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Malaka Sub 16 Malaka 29 102 28 72
2 Carlinda Sub 16 Carlinda 29 85 43 65
3 CD Athletic Puerta Blanca Athletic 29 78 52 58
4 Antequera Antequera 30 89 41 54
5 Ronda Union Deportiva Ronda Union 29 84 62 49
6 Faro de Torrox Asociacion Faro Torrox 30 90 63 47
7 Puerto Malagueño C Puerto 30 68 54 46
8 La Unidad Nueva Malaga Unidad Nueva 30 70 79 42
9 CD Rincón CD Rincón 29 61 57 40
10 Mortadelo Sub 16 Mortadelo 29 76 69 39
11 CD Atletico Benamiel CF Atletico 29 78 62 38
12 Atletico Juval Atletico 29 59 71 31
13 Fútbol Romeral Fútbol 29 63 76 31
14 San Estanislao Sub 16 Estanislao 30 45 95 25
15 Olimpica Victoriana Sub 16 Olimpica 21 25 113 9
16 CD Conejito de Malaga Conejito 30 34 142 5
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

  USO DE MEMORIA  
4,687,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0605
Total Execution Time  0.0620
  CADENA URL  
/historico/Faro-De-Torrox-Asociacion-Cadete
  GET DATOS  
$_GET['/historico/Faro-De-Torrox-Asociacion-Cadete']  
  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 = 70183
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=148077 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=454 AND type_rel = 3
0.0021  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 = '148077' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 70183 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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=148077 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 (70183) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70183 AND teamId = 148077
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 `tables2023` 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 = 70183 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '148077' 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 = '148077' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 148077 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 70183 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.0037  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