4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Atletico Fuenlabreño Atletico 21 62 17 58
2 Municipal Arroyomolinos Municipal 21 73 11 51
3 CD Lugo Fuenlabrada B Lugo 21 78 32 51
4 CD Griñon B Griñon 21 72 24 50
5 UD Arroyomolinos B Arroyomolino 21 51 22 42
6 Makavi - La Avanzada Makavi 21 54 43 32
7 EM Torrejón de la Calzada Torrejón 21 60 48 31
8 Nuevo Ciudad Nuevo Ciudad 21 39 31 30
9 Rayo 13 Rayo 13 21 55 53 30
10 CD Arroyo CD Arroyo 20 61 53 27
11 Racing Calypso Racing 20 39 49 19
12 San Pedro Humanes B Pedro 21 30 67 17
13 Atletico Hispanidad Atletico 21 40 82 14
14 Fuenalbrada El Naranjo B Fuenalbrada 20 22 24 11
15 Racing Sur Madrid Racing 21 31 78 9
16 Paco Cordoba B Paco Cordoba 20 3 136 1
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Aguilas del Lucero Aguilas 30 89 30 77
2 Aluche Bulls Aluche Bulls 29 79 35 73
3 Libertad Alcorcón Libertad 30 97 38 65
4 Marianistas Amoros Marianistas 29 95 37 65
5 Plata B Plata B 29 77 42 56
6 Villanueva del Pardillo C Villanueva 29 73 63 46
7 Encinas de Boadilla Encinas 29 60 56 42
8 Iglesia La Vid FC Iglesia 29 57 75 38
9 Mentema Boadilla Mentema 30 77 92 36
10 Rojo y Blanco Rojo Blanco 30 60 77 35
11 S. Clube de Castilla Clube 28 65 69 34
12 Lucero Linces B Lucero 29 58 73 34
13 Juventud Los Carmenes ' B' Juventud 30 60 81 28
14 Cantera B Cantera B 30 60 107 23
15 CD Ferilan CD Ferilan 30 45 96 13
16 Madrid Sur Latina Madrid 29 59 140 11
17 Vesubio de Villa Vesubio 0 0 0 0
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Nuevo Boadilla Nuevo 33 97 43 78
2 Ciudad de Leganes Ciudad 34 84 29 73
3 Atletico Aluche Atletico 34 95 55 70
4 Arroyoculebro Arroyoculebr 34 103 56 69
5 Estudiantes Alcorcon Estudiantes 34 95 26 67
6 Marianistas Amoros Marianistas 34 102 56 62
7 CD Elithe CD Elithe 34 76 69 57
8 Aluche Bull´s Aluche 32 80 50 56
9 Parque Picasso Parque 34 78 46 55
10 Libertad Alcorcón Libertad 34 98 69 52
11 CDAV San Nicasio A CDAV Nicasio 34 95 65 50
12 Mentema Boadilla Mentema 31 86 89 38
13 Encinas de Boadilla Encinas 33 83 97 34
14 Rocio Leganes Rocio 34 54 117 22
15 At. Cañada Alcorcon B Cañada 34 50 135 22
16 CD Celmig CD Celmig 30 41 114 16
17 Iglesia La Vid FC Iglesia 34 54 142 16
18 UD Móstoles Balompié Móstoles 31 37 150 8
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Leganés C Leganés C 34 121 37 82
2 Bercial 2009 Bercial 2009 34 86 40 78
3 Caserio Perales Caserio 34 94 43 76
4 Parque Picasso Parque 34 86 43 72
5 Arroyoculebro Arroyoculebr 33 79 51 66
6 Torrejon de la Calzada Torrejon 34 83 42 65
7 Ciudad de Leganes Ciudad 34 62 51 57
8 Juventud Canario Juventud 34 58 59 50
9 Getafe Atletico Getafe 34 67 55 49
10 Colmenar Oreja B Colmenar 34 80 70 48
11 Rocio Leganes Rocio 34 69 63 44
12 FC Zarzaquemada Zarzaquemada 34 58 77 37
13 Rayo Ciempozuelos Rayo 34 56 74 36
14 Santa Bárbara Getafe Santa 34 66 102 35
15 E United Leganes United 32 42 58 29
16 EF Valdemoro B Valdemoro 34 65 107 27
17 CDAV San Nicasio B CDAV Nicasio 34 25 119 12
18 At. Valdemoro Valdemoro 33 20 126 9
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Marianistas Amoros Marianistas 29 89 24 67
2 Rojo y Blanco Rojo Blanco 29 109 33 64
3 La Mutual Juan XXIII Mutual Juan 29 86 33 62
4 Campamento Campamento 27 82 26 61
5 United Leganés United 30 66 52 53
6 Parque Picasso Parque 29 75 60 51
7 Parque Europa Parque 28 55 47 50
8 Ciudad de Leganes Ciudad 29 50 46 41
9 CDAV San Nicasio B CDAV Nicasio 29 57 79 40
10 FC Zarzaquemada Zarzaquemada 29 53 78 32
11 CD Ferilan CD Ferilan 29 46 69 28
12 Cantera B Cantera B 28 74 99 27
13 Union el Rastro Union Rastro 29 49 80 21
14 Rocio Leganes Rocio 29 33 80 19
15 Pais Tropical Pais 16 30 49 18
16 EF Madrid Sur Madrid 29 43 142 9
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Sporting Laguna Sporting 28 102 35 67
2 La Garrota La Garrota 28 74 42 60
3 La Mutual Juan XXIII Mutual Juan 28 71 36 58
4 Rojo y Blanco Rojo Blanco 27 77 43 53
5 Parque Europa Parque 26 53 25 53
6 Parque Ondarreta Parque 26 70 65 45
7 Juventud Los Carmenes Juventud 27 61 43 40
8 CD Celmig CD Celmig 27 48 36 39
9 Union el Rastro Union Rastro 27 53 53 33
10 Estudiantes Alcorcon Estudiantes 28 48 60 33
11 Aguilas del Lucero B Aguilas 27 46 71 32
12 Cantera B Cantera B 28 44 72 26
13 CD Elithe CD Elithe 28 48 77 23
14 Hogar-70 Hogar-70 27 30 110 5
15 Nuestra Señora de los Remed Nuestra 18 19 76 2

  USO DE MEMORIA  
5,591,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4641
Total Execution Time  0.4660
  CADENA URL  
/tercera_madrid2020/grupo10/historico
  GET DATOS  
$_GET['/tercera_madrid2020/grupo10/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  SELECT type FROM routes WHERE alias = 'tercera_madrid2020'
0.0291  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 = 10 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=693 AND type_rel = 3
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 693 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0154  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 (974404,950677,780808,746018,305610) ORDER BY n.cover_points DESC, update_date DESC
0.0146  SELECT id,name,alias,stepParent FROM categories WHERE parentId=693 ORDER BY order_id ASC
0.0148  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 = 51530 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 693 AND group_code = 10 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149  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` 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 = 51530 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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` 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 = 45257 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2018` 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 = 39845 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2017` 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 = 34307 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2016` 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 = 16863 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 4041 AND t.round = 30 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-05-02 15:14:51' 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-05-02 15:14:51' 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=4 AND last_update > '2024-05-02 15:14:51' 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=3 AND last_update > '2024-05-02 15:14:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2020 e ON e.player_id = p.id AND e.league_id = 51530 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51530 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 events2020 e ON e.player_id = p.id AND e.league_id = 51530 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51530 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0147  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 events2020 e ON e.player_id = p.id AND e.league_id = 51530 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51530 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0167  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 51530 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC