4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Nueva Castilla Nueva 28 109 41 69
2 SAD Fundación Rayo Vallecan Fundación 27 95 24 65
3 Parque Arganzuela B Parque 27 93 30 63
4 Sport Villa de Vallecas Sport Villa 28 90 30 60
5 Rayo Vallecano D Rayo 28 90 49 55
6 Sección Dep. del Pozo B Sección 27 95 44 53
7 Cosmos Huracan Cosmos 28 88 49 50
8 Españoleto B Españoleto 28 60 53 44
9 Gigantes B Gigantes B 28 57 60 44
10 Atletico Vallecas A Atletico 28 49 46 37
11 La Gavia CF La Gavia CF 28 45 71 33
12 Victoria Madrid Victoria 28 63 82 30
13 Independiente de Vallecas Independient 28 40 68 23
14 Cantera B Cantera B 28 19 110 7
15 C.D.E. INTER VICTORIA B C.D.E. INTER 27 15 107 6
16 CD Ferilan B Ferilan 28 24 168 2
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Buenavista Castilla Buenavista 34 150 36 87
2 EF Carabanchel B Carabanchel 34 127 27 84
3 San Viator San Viator 34 107 29 80
4 RCD Carabanchel B Carabanchel 34 137 49 77
5 CD Plata CD Plata 34 68 44 60
6 Madrid Rio B Madrid 34 84 58 56
7 Guindalera B Guindalera 34 83 80 54
8 Inter Promesas Inter 34 97 80 51
9 Rayo Vallecano D Rayo 34 81 67 51
10 Union el Rastro Union Rastro 34 64 69 48
11 Escfut Villa de Madrid B Escfut Villa 34 103 111 48
12 Cantera B Cantera B 34 84 92 45
13 Alfa Alfa 34 60 86 33
14 Gigantes B Gigantes B 34 71 99 32
15 Parque Arganzuela Parque 34 54 119 18
16 Juventud Los Carmenes ' B' Juventud 34 55 130 18
17 Chamberi de Madrid Chamberi 34 57 188 18
18 CD Batan CD Batan 34 46 164 12
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Agrupacion Lucero Linces B Agrupacion 32 117 34 82
2 Aguilas del Lucero Aguilas 32 85 32 72
3 Atletico Aluche Atletico 32 90 46 69
4 Juventud Los Carmenes Juventud 32 79 49 60
5 CD Plata CD Plata 32 77 49 57
6 Piqueñas B Piqueñas B 32 82 53 52
7 Marianistas Amoros B Marianistas 32 77 86 46
8 Parque Europa Parque 32 61 66 44
9 Madrid Sur Latina Madrid 32 56 69 44
10 CD Goya B CD Goya B 32 63 64 41
11 Cantera B Cantera B 32 67 79 39
12 Escfut Villa de Madrid B Escfut Villa 32 68 93 36
13 Campamento B Campamento 32 58 80 35
14 ACD Fatima ACD Fatima 32 72 97 32
15 Sporting Laguna B Sporting 32 56 95 29
16 Rayo Latina A Rayo Latina 32 46 89 20
17 La Mutual Juan XXIII B Mutual Juan 32 47 120 8

  USO DE MEMORIA  
5,198,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0752
Total Execution Time  0.0772
  CADENA URL  
/tercera_madrid2024/grupo17/historico
  GET DATOS  
$_GET['/tercera_madrid2024/grupo17/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_madrid' AND (l.group_code = 17 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=17 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=693 ORDER BY order_id ASC
0.0023  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74673 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 693 AND group_code = 17 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 74673 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.0029  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` 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 = 69408 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.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 `tables2022` 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 = 64219 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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:20:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 16:20:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 16:20:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0049  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 16:20:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74673 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74673 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74673 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74673 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74673 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74673 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 74673 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