4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 EFMO Boadilla Sub 12 EFMO 26 83 11 66
2 Odon A Odon A 26 57 14 64
3 Club Atletico de Madrid F Club 26 68 28 63
4 Escuela Futbol de Brunete Escuela 26 85 17 60
5 Union Zona Norte B Union Zona. 26 50 28 40
6 Galapagar A Galapagar A 26 52 49 39
7 Rayo Ciudad Alcobendas B Rayo Ciudad 26 35 39 31
8 Atletico Villalba A Atletico 26 38 67 28
9 Las Rozas B Las Rozas B 26 29 53 28
10 Union Adarve C Union Adarve 26 37 52 28
11 Nuevo Boadilla B Nuevo 26 29 73 19
12 Atletico Valdeiglesias Atletico 26 21 73 19
13 San Fernando Escolapio Fernando 26 25 70 18
14 Rayo B Rayo B 26 22 57 15
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Rayo Majadahonda Rayo 26 79 13 65
2 Torrelodones A Torrelodones 26 50 23 55
3 Efmo Boadilla B Efmo 26 53 26 50
4 San Fernando Escolapio Fernando 26 56 30 47
5 Escuela Futbol de Brunete Escuela 26 50 35 44
6 Nuevo Boadilla B Nuevo 26 45 43 40
7 Tres Cantos A Tres Cantos 26 44 35 37
8 Atletico Villalba A Atletico 26 40 45 34
9 Galapagar A Galapagar A 26 53 43 31
10 Siete Picos Colmenar B Siete Picos 26 35 44 30
11 Las Rozas B Las Rozas B 26 38 62 30
12 Villanueva del Pardillo A Villanueva 26 28 67 24
13 Union Deportiva Tres Cantos Union 26 31 87 20
14 Castilla Castilla 26 30 79 14

  USO DE MEMORIA  
4,935,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2832
Total Execution Time  0.2853
  CADENA URL  
/preferente_alevin_madrid2016/grupo1/historico
  GET DATOS  
$_GET['/preferente_alevin_madrid2016/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=985 AND type_rel = 3
0.0144  SELECT id,name,alias,stepParent FROM categories WHERE parentId=985 ORDER BY order_id ASC
0.0146  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 985 AND group_code = 1 and tables = 1 AND year <= 2016 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 6526 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 09:31:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 09:31:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 09:31:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 09:31:58' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  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 events2016 e ON e.player_id = p.id AND e.league_id = 17999 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 17999 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.0146  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 events2016 e ON e.player_id = p.id AND e.league_id = 17999 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 17999 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  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 events2016 e ON e.player_id = p.id AND e.league_id = 17999 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 17999 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(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 = 17999 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC