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 Cristo Minglanilla Cristo 21 60 14 53
2 Deportivo Barrax Deportivo 22 54 16 50
3 Olimpico Madrigueras Olimpico 22 46 19 50
4 Higueruela Higueruela 21 44 25 37
5 Iniestense Iniestense 20 39 31 36
6 Rayo Fuentealbilla Rayo 21 54 33 34
7 El Herrumblar Herrumblar 21 23 26 32
8 CF La Santa Cruz Santa Cruz 21 25 35 28
9 Alto Jucar Alto Jucar 21 42 39 27
10 Teatinos Teatinos 21 35 35 27
11 Chinchilla Chinchilla 21 31 48 27
12 Villalpardo Villalpardo 22 27 37 25
13 Alatoz Alatoz 20 37 47 22
14 CD Valera CD Valera 21 17 44 17
15 AD Alumni AD Alumni 22 28 61 17
16 Aguas Nuevas Aguas Nuevas 19 28 38 14
17 Ledaña Ledaña 20 18 60 9
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Mahora Mahora 30 93 26 75
2 Almansa B Almansa B 32 94 36 69
3 Teatinos Teatinos 31 67 30 62
4 Chinchilla Chinchilla 31 68 32 59
5 Iniestense Iniestense 31 62 31 56
6 Alto Jucar Alto Jucar 31 65 35 52
7 El Herrumblar Herrumblar 32 50 48 47
8 Quintanar del Rey B Quintanar 30 50 55 39
9 Aguas Nuevas Aguas Nuevas 30 44 58 39
10 Cristo Minglanilla Cristo 31 59 77 38
11 CF La Santa Cruz Santa Cruz 31 34 45 36
12 Ledaña Ledaña 32 48 81 35
13 Alatoz Alatoz 31 61 85 32
14 CD Sport Five Tobarra Sport Five. 23 40 43 29
15 CD Valera CD Valera 30 46 63 28
16 Rayo Fuentealbilla Rayo 28 37 100 13
17 Higueruela Higueruela 26 23 96 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Sporting La Gineta B Sporting 30 66 30 69
2 Imperial de Bonete Imperial 30 77 37 68
3 Elche Sierra Elche Sierra 28 64 35 56
4 Atlético Ossa CF Atlético 30 64 49 54
5 Deportivo Barrax Deportivo 30 61 40 48
6 Aguas Nuevas Aguas Nuevas 30 61 40 47
7 Quintanar del Rey B Quintanar 29 63 44 46
8 Mahora Mahora 30 72 50 44
9 CD Sport Five Tobarra Sport Five. 30 62 51 43
10 Cristo Minglanilla Cristo 30 69 60 42
11 Iniestense Iniestense 30 57 47 41
12 Ledaña Ledaña 29 42 77 30
13 Villalpardo Villalpardo 30 46 52 29
14 Rayo Fuentealbilla Rayo 30 46 104 27
15 Alatoz Alatoz 30 41 95 11
16 Alto Jucar Alto Jucar 30 26 106 9
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Hellin CF Hellin CF 16 42 14 37
2 Aguas Nuevas Aguas Nuevas 16 33 20 31
3 Atlético Ossa CF Atlético 16 31 36 27
4 Sporting La Gineta B Sporting 16 29 22 25
5 Imperial de Bonete Imperial 16 28 28 24
6 Higueruela Higueruela 16 29 27 23
7 Munera CF B Munera CF B 16 25 31 18
8 Deportivo Barrax Deportivo 16 17 23 17
9 Alatoz Alatoz 16 18 51 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Casasimarro Casasimarro 38 107 38 87
2 Ascensores Eninter Los Llan Ascensores 37 86 35 82
3 AD Campillo AD Campillo 38 92 35 82
4 Atlético Ossa CF Atlético 38 99 56 82
5 Teatinos Teatinos 38 91 45 74
6 Aguas Nuevas Aguas Nuevas 38 73 51 67
7 Villalpardo Villalpardo 38 84 55 65
8 Rayo Fuentealbilla Rayo 37 76 64 58
9 Casas de Juan Núñez Casas Juan. 38 59 60 55
10 Iniestense Iniestense 38 83 70 54
11 Deportivo Barrax Deportivo 38 58 53 50
12 Imperial de Bonete Imperial 38 66 79 49
13 Higueruela Higueruela 38 79 88 45
14 Cristo Minglanilla Cristo 38 46 71 42
15 El Herrumblar Herrumblar 38 47 67 39
16 Munera CF B Munera CF B 38 53 77 38
17 Casas de Haro Casas Haro 38 34 74 37
18 Alto Jucar Alto Jucar 38 50 109 32
19 Ledaña Ledaña 37 39 113 18
20 Alatoz Alatoz 37 33 115 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Ibañes B Ibañes B 26 72 24 62
2 Isso Isso 26 65 26 50
3 Mahora Mahora 25 47 34 48
4 Villalpardo Villalpardo 25 54 34 47
5 Rayo Fuentealbilla Rayo 25 52 30 46
6 El Herrumblar Herrumblar 25 38 32 43
7 Cristo Minglanilla Cristo 26 41 36 39
8 Imperial de Bonete Imperial 25 47 38 37
9 Iniestense Iniestense 26 51 51 30
10 Pozo Cañada Pozo Cañada 21 48 41 26
11 Hellin CF Hellin CF 26 40 61 24
12 Hoya Gonzalo Hoya Gonzalo 26 35 63 23
13 Ledaña Ledaña 26 35 68 22
14 Alatoz Alatoz 26 20 107 5

  USO DE MEMORIA  
5,526,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0802
Total Execution Time  0.0821
  CADENA URL  
/segunda_castilla_la_mancha2020/grupo1/historico
  GET DATOS  
$_GET['/segunda_castilla_la_mancha2020/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_castilla_la_mancha' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=843 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 843 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (340774,277281) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=843 ORDER BY order_id ASC
0.0020  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 = 51491 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 843 AND group_code = 1 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 51491 AND t.round = 23 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 `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 = 45639 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 40377 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 36168 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 16937 AND t.round = 38 ORDER BY team.conference 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 `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 = 5248 AND t.round = 26 ORDER BY team.conference 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-27 06:46:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:46:53' 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-27 06:46:53' 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=3 AND last_update > '2024-04-27 06:46:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  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 = 51491 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51491 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.0019  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 = 51491 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51491 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0018  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 = 51491 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51491 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  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 = 51491 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC