4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 San Jose Obrero Jose Obrero 33 79 40 71
2 Munera Munera 33 73 27 70
3 CF La Solana Solana 33 78 38 70
4 Atlético Tomelloso Atlético 34 86 35 65
5 U.B. Conquense B U.B. 33 52 40 57
6 UD Tobarra UD Tobarra 33 49 34 54
7 Motilla CF Motilla CF 33 54 40 53
8 UD Carrión UD Carrión 33 46 34 51
9 CD Quintanar de la Orden Quintanar 33 50 48 45
10 Cd Miguelturreño Miguelturre 33 39 51 39
11 U.D. Alpera U.D. Alpera 33 50 61 37
12 C.D.B.F. Cervantes C.D.B.F. 33 38 54 35
13 C.F. Almodovar C.F. 33 41 62 35
14 C.D. Caudetano C.D. 33 36 66 35
15 EF Zona 5 EF Zona 5 33 31 64 35
16 CD Mota Del Cuervo Mota Cuervo 32 28 63 20
17 Cd Piedrabuena Piedrabuena 32 27 77 19
18 Tomelloso Tomelloso 18 21 44 12
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Almagro CF Almagro CF 34 60 30 71
2 Daimiel Daimiel 34 61 34 69
3 Munera Munera 34 55 37 66
4 San Jose Obrero Jose Obrero 34 70 39 65
5 CF La Solana Solana 34 70 51 57
6 Isso CF Isso CF 34 58 35 57
7 CD Quintanar de la Orden Quintanar 34 58 41 54
8 Tomelloso Tomelloso 34 60 53 53
9 CD Mota Del Cuervo Mota Cuervo 34 58 47 45
10 Cervantes Cervantes 34 51 71 42
11 La Roda CF B Roda 34 42 55 41
12 Miguelturreño Miguelturre 34 40 49 40
13 Piedrabuena Piedrabuena 34 51 49 40
14 UD Tobarra UD Tobarra 34 40 55 37
15 CDB Herencia Herencia 34 50 61 37
16 Madrigueras UD Madrigueras 34 39 64 32
17 Criptanense Criptanense 34 50 68 31
18 Atlético Teresiano Atlético 34 19 93 12
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 La Gineta La Gineta 34 89 29 86
2 EF Zona 5 EF Zona 5 34 67 28 76
3 Atlético Ibañés Atlético 34 72 31 74
4 EMD Solana EMD Solana 34 54 33 66
5 Daimiel Daimiel 34 51 25 64
6 Almagro CF Almagro CF 34 54 43 56
7 Munera Munera 34 49 43 55
8 Tomelloso Tomelloso 34 64 48 53
9 Cd Piedrabuena Piedrabuena 34 55 52 49
10 Isso CF Isso CF 34 45 54 42
11 Madrigueras UD Madrigueras 34 42 53 41
12 Cd Miguelturreño Miguelturre 34 46 56 40
13 CDB Herencia Herencia 34 37 63 40
14 UD Carrión UD Carrión 34 44 54 32
15 Atlético Teresiano Atlético 34 42 54 32
16 Valdepeñas Valdepeñas 34 48 52 29
17 Piedrabuena Dintel Piedrabuena 34 31 100 21
18 Puertollano B Puertollano 34 24 96 10
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 CD Manchego Ciudad Real Manchego 34 77 33 71
2 Daimiel Daimiel 34 65 33 64
3 Almagro CF Almagro CF 34 57 31 64
4 CF La Solana Solana 34 62 47 57
5 CD Pedroñeras Pedroñeras 34 46 33 55
6 Piedrabuena Piedrabuena 34 58 45 54
7 CD Mota Del Cuervo Mota Cuervo 34 56 47 51
8 Atlético Teresiano Atlético 34 51 51 50
9 Motilla Cf Motilla Cf 34 52 60 49
10 EF Zona 5 EF Zona 5 34 67 47 48
11 Cdb Herencia Herencia 34 57 61 47
12 Munera Munera 34 44 53 46
13 Ud Carrión Ud Carrión 34 42 51 44
14 Miguelturreño Miguelturre 34 42 51 42
15 Villamalea Villamalea 34 45 63 37
16 Unión Criptanense Unión 34 52 66 35
17 Efud Albacer Efud Albacer 34 27 65 24
18 Deportivo Barrax Deportivo 34 35 98 23
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Atlético Ibañés Atlético 34 75 36 76
2 Puertollano B Puertollano 34 90 39 75
3 Atlético Teresiano Atlético 34 76 28 72
4 CF La Solana Solana 34 71 41 61
5 San Jose Obrero Jose Obrero 34 71 43 60
6 Daimiel Daimiel 34 57 24 59
7 Munera Munera 34 55 49 54
8 Almagro CF Almagro CF 34 54 34 53
9 CDE Zona 5 CDE Zona 5 34 54 54 46
10 Villamalea Villamalea 34 46 43 46
11 Albacer Albacer 34 49 42 45
12 Deportivo Barrax Deportivo 34 53 75 43
13 Miguelturreño Miguelturre 34 39 49 41
14 Aldea del Rey Aldea 34 50 55 38
15 Sporting Torrenueva Sporting 34 37 82 27
16 Tomelloso B Tomelloso B 34 41 89 26
17 Bolañego Bolañego 34 22 82 14
18 CD Manchego Provencio Manchego 34 30 105 13
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Manzanares CF Manzanares 34 67 32 70
2 CF La Solana Solana 34 82 51 69
3 Villarrubia CF Villarrubia 34 55 33 69
4 Aldea del Rey Aldea 34 113 49 65
5 Puertollano B Puertollano 34 77 48 61
6 Miguelturreño Miguelturre 34 56 49 52
7 Atlético Ibañés Atlético 34 49 56 51
8 Atlético Teresiano Atlético 34 57 61 49
9 Albacer Albacer 34 46 42 47
10 Almagro CF Almagro CF 34 65 56 45
11 CD Manchego Provencio Manchego 34 49 62 44
12 Villamalea Villamalea 34 45 50 41
13 Bolañego Bolañego 34 40 50 40
14 Deportivo Barrax Deportivo 34 48 54 39
15 Hellín B Hellín B 34 44 56 38
16 CD Quintanar de la Orden Quintanar 34 39 63 36
17 Atlético Tarazona Atlético 34 39 58 33
18 CD Pedroñeras Pedroñeras 34 19 120 7
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 CD Quintanar del Rey Quintanar 34 66 20 80
2 La Gineta La Gineta 34 67 28 69
3 Atlético Teresiano Atlético 33 63 31 65
4 Miguelturreño Miguelturre 34 59 37 65
5 Villamalea Villamalea 34 44 32 58
6 Manzanares CF Manzanares 34 57 35 57
7 Almagro CF Almagro CF 34 44 43 45
8 Albacer Albacer 34 46 42 44
9 Deportivo Barrax Deportivo 34 50 58 44
10 Almansa B Almansa B 34 45 55 44
11 Altobuey Altobuey 33 49 46 41
12 Puertollano B Puertollano 34 49 47 41
13 Bolañego Bolañego 34 51 53 40
14 Aldea del Rey Aldea 34 47 52 40
15 Munera Munera 33 40 63 31
16 Atco. Pedro Muñoz Atco. Pedro 34 40 66 31
17 El Bonillo El Bonillo 31 28 66 26
18 Atlético Daimiel Atlético 34 18 89 13

  USO DE MEMORIA  
5,896,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0036
Controller Execution Time ( Home / Category )  0.3648
Total Execution Time  0.3684
  CADENA URL  
/primera_autonomica_castilla_la_mancha2015/grupo1/historico
  GET DATOS  
$_GET['/primera_autonomica_castilla_la_mancha2015/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0106  SELECT type FROM routes WHERE alias = 'primera_autonomica_castilla_la_mancha2015'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_autonomica_castilla_la_mancha' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=86 AND type_rel = 3
0.0115  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 86 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0124  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 (1304399,1199941,1184917,1070918,701719) ORDER BY n.cover_points DESC, update_date DESC
0.0116  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 = 4077 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0119  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 86 AND group_code = 1 and tables = 1 AND year <= 2015 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0136  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 = 4077 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2014` 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 = 2697 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 `tables2013` 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 = 2255 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2011` 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 = 1190 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 `tables2010` 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 = 948 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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 `tables2009` 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 = 299 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 11:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 11:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 11:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 11:40:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_autonomica_castilla_la_mancha' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2015 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0120  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 events2015 e ON e.player_id = p.id AND e.league_id = 4077 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4077 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.0116  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 events2015 e ON e.player_id = p.id AND e.league_id = 4077 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4077 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  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 events2015 e ON e.player_id = p.id AND e.league_id = 4077 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4077 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0174  SELECT *,(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 = 4077 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC