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 Cultural Valdeganga Cultural 29 48 30 52
2 U.B. Conquense B U.B. 28 61 35 48
3 Atlético Tarazona Atlético 29 41 34 48
4 CD Manchego Provencio Manchego 28 36 28 47
5 Cristo Minglanilla Cristo 28 42 34 46
6 U.D. Alpera U.D. Alpera 29 47 41 44
7 Quintanar del Rey B Quintanar 28 30 29 42
8 Imperial de Bonete Imperial 29 47 57 41
9 Atletico Jareño Atletico 28 41 35 38
10 Atlético Ibañés Atlético 28 44 50 38
11 Deportivo Barrax Deportivo 28 36 43 35
12 Higueruela Higueruela 28 44 55 34
13 Munera Munera 28 36 42 32
14 Olimpico Madrigueras Olimpico 27 34 35 30
15 Casasimarro Casasimarro 28 32 43 30
16 Balona Conquense Balona 19 15 43 8
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 C.D. Caudetano C.D. 29 74 31 71
2 Socuéllamos B Socuéllamos 30 63 37 57
3 Cristo Minglanilla Cristo 30 52 36 53
4 Imperial de Bonete Imperial 30 52 40 47
5 CD Manchego Provencio Manchego 30 52 43 45
6 Munera Munera 30 49 45 45
7 Deportivo Barrax Deportivo 29 52 43 44
8 Las Mesas Las Mesas 30 40 43 40
9 Casasimarro Casasimarro 30 40 54 40
10 Atlético Tarazona Atlético 30 35 37 38
11 Higueruela Higueruela 30 50 57 36
12 Olimpico Madrigueras Olimpico 30 46 53 35
13 U.D. Alpera U.D. Alpera 29 49 59 32
14 Atletico Jareño Atletico 30 30 60 29
15 Mahora Mahora 29 29 55 25
16 Al-Basit Al-Basit 30 46 66 23
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Socuéllamos B Socuéllamos 29 45 23 60
2 Atco. Pedro Muñoz Atco. Pedro 29 63 25 57
3 Motilla CF Motilla CF 29 59 35 56
4 Olimpico Madrigueras Olimpico 29 49 28 54
5 Imperial de Bonete Imperial 28 52 40 50
6 CD Manchego Provencio Manchego 28 41 25 48
7 Deportivo Barrax Deportivo 29 65 49 44
8 U.D. Alpera U.D. Alpera 29 51 48 42
9 Cristo Minglanilla Cristo 30 56 55 40
10 Atletico Jareño Atletico 29 46 64 36
11 Mahora Mahora 29 31 37 33
12 Al-Basit Al-Basit 29 45 55 30
13 Casasimarro Casasimarro 30 37 51 30
14 La Gineta La Gineta 29 47 67 26
15 Atlético Ossa CF Atlético 28 30 71 15
16 Villarrobledo B Villarrobled 18 9 53 4
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 EFB La Roda EFB La Roda 24 47 20 51
2 C.D. Caudetano C.D. 24 43 16 51
3 Deportivo Barrax Deportivo 25 42 29 44
4 Imperial de Bonete Imperial 24 56 31 42
5 Cristo Minglanilla Cristo 24 54 45 40
6 Atletico Jareño Atletico 24 33 35 38
7 Motilla CF Motilla CF 25 41 37 37
8 Casasimarro Casasimarro 24 43 44 32
9 Al-Basit Al-Basit 24 38 43 31
10 U.D. Alpera U.D. Alpera 24 40 47 28
11 Villamalea Villamalea 24 30 38 27
12 Mahora Mahora 24 32 42 27
13 Hellin CF Hellin CF 24 0 72 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Munera Munera 23 59 20 53
2 Casasimarro Casasimarro 23 33 20 44
3 Atlético Ossa CF Atlético 23 36 27 42
4 EFB La Roda EFB La Roda 23 34 21 38
5 Imperial de Bonete Imperial 23 34 22 38
6 Mahora Mahora 22 32 30 35
7 Almansa B Almansa B 22 32 30 34
8 Hellin CF Hellin CF 23 39 40 33
9 C.D. Caudetano C.D. 23 40 42 29
10 Motilla CF Motilla CF 23 37 41 29
11 Atletico Jareño Atletico 23 25 26 28
12 Al-Basit Al-Basit 23 23 40 26
13 U.D. Alpera U.D. Alpera 23 36 34 25
14 El Bonillo El Bonillo 23 24 39 23
15 Villamalea Villamalea 23 25 42 18
16 Casas de Haro Casas Haro 23 11 46 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Atletico Jareño Atletico 30 52 29 57
2 Atlético Tarazona Atlético 30 47 26 56
3 Casasimarro Casasimarro 29 58 33 50
4 Motilla CF Motilla CF 30 43 34 47
5 Villamalea Villamalea 30 39 32 46
6 EFB La Roda EFB La Roda 30 41 36 46
7 CD Manchego Provencio Manchego 30 42 44 44
8 Atlético Ossa CF Atlético 29 47 42 40
9 Munera Munera 30 40 41 40
10 Imperial de Bonete Imperial 30 44 47 37
11 Casas de Haro Casas Haro 30 18 36 34
12 El Bonillo El Bonillo 30 30 37 33
13 Al-Basit Al-Basit 30 35 44 32
14 U.D. Alpera U.D. Alpera 30 38 53 32
15 Olimpico Madrigueras Olimpico 30 33 56 29
16 Deportivo Barrax Deportivo 30 43 60 27
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Hellin CF Hellin CF 30 70 29 63
2 AD Campillo AD Campillo 30 52 26 62
3 Atlético Tarazona Atlético 30 58 28 59
4 CD Manchego Provencio Manchego 30 49 29 53
5 Villamalea Villamalea 30 46 47 40
6 Motilla CF Motilla CF 30 39 44 40
7 El Bonillo El Bonillo 30 49 56 40
8 Casasimarro Casasimarro 30 45 41 39
9 Munera Munera 30 47 49 38
10 Olimpico Madrigueras Olimpico 30 45 41 36
11 Al-Basit Al-Basit 30 38 42 35
12 EFB La Roda EFB La Roda 30 39 52 35
13 U.D. Alpera U.D. Alpera 30 42 51 34
14 Casas de Haro Casas Haro 30 26 42 34
15 Teatinos Teatinos 30 34 51 33
16 Chinchilla Chinchilla 30 29 80 14
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 AD San Clemente Clemente 30 45 21 57
2 Cultural Valdeganga Cultural 30 61 41 57
3 Las Mesas Las Mesas 30 48 36 51
4 Casasimarro Casasimarro 30 68 48 49
5 Atlético Tarazona Atlético 30 54 43 46
6 Olimpico Madrigueras Olimpico 30 45 51 42
7 Ascensores Eninter Los Llan Ascensores 30 34 36 41
8 Al-Basit Al-Basit 30 46 46 40
9 El Bonillo El Bonillo 30 36 39 39
10 EFB La Roda EFB La Roda 30 40 45 38
11 AD Campillo AD Campillo 29 38 46 37
12 Motilla CF Motilla CF 30 30 39 35
13 CD Manchego Provencio Manchego 29 46 51 34
14 CD Mota Del Cuervo Mota Cuervo 30 34 44 33
15 Chinchilla Chinchilla 30 30 49 33
16 Quintanar del Rey B Quintanar 30 33 53 31
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Villamalea Villamalea 29 66 23 62
2 Atletico Jareño Atletico 30 64 33 61
3 Atlético Tarazona Atlético 29 47 29 55
4 Quintanar del Rey B Quintanar 29 54 35 53
5 EFB La Roda EFB La Roda 29 61 39 45
6 Las Mesas Las Mesas 30 49 44 45
7 CD Manchego Provencio Manchego 30 57 47 43
8 Cultural Valdeganga Cultural 29 45 57 37
9 AD San Clemente Clemente 29 47 48 36
10 El Bonillo El Bonillo 30 41 55 35
11 Olimpico Madrigueras Olimpico 29 42 56 35
12 Chinchilla Chinchilla 29 45 55 33
13 CD Mota Del Cuervo Mota Cuervo 29 40 52 33
14 Ibañes B Ibañes B 29 48 50 31
15 Mahora Mahora 30 30 55 26
16 Almendras De La Mancha Almendras 20 20 78 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Atco. Pedro Muñoz Atco. Pedro 30 62 37 63
2 Huracan de Balazote Huracan 30 58 29 59
3 Al-Basit Al-Basit 30 66 46 56
4 Villamalea Villamalea 30 69 41 55
5 CD Manchego Provencio Manchego 30 51 35 50
6 Atlético Tarazona Atlético 30 41 33 44
7 El Bonillo El Bonillo 30 52 44 40
8 San Clemente Clemente 30 42 51 40
9 Chinchilla Chinchilla 30 54 54 39
10 Elche Sierra Elche Sierra 30 54 72 38
11 Olimpico Madrigueras Olimpico 30 49 52 36
12 Albacer Albacer 30 48 55 36
13 Cultural Valdeganga Cultural 30 38 51 36
14 Quintanar del Rey B Quintanar 30 40 65 32
15 Casasimarro Casasimarro 30 43 70 26
16 Aguas Nuevas Aguas Nuevas 30 28 60 21

  USO DE MEMORIA  
6,245,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1640
Total Execution Time  0.1661
  CADENA URL  
/primera_castilla_la_mancha2024/grupo1/historico
  GET DATOS  
$_GET['/primera_castilla_la_mancha2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0020  SELECT type FROM routes WHERE alias = 'primera_castilla_la_mancha2024'
0.0048  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_castilla_la_mancha' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=842 AND type_rel = 3
0.0049  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 842 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0042  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 (915689,634735,309041,225873,64036) ORDER BY n.cover_points DESC, update_date DESC
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=842 ORDER BY order_id ASC
0.0030  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 = 73951 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 842 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0034  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 = 73951 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 69449 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 64481 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables2021` 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 = 59882 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 51319 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.0031  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 = 45377 AND t.round = 30 ORDER BY team.conference 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 `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 = 39791 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 34565 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 16789 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 5244 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 09:15:34' 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-30 09:15:34' 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-30 09:15:34' 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=3 AND last_update > '2024-04-30 09:15:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_castilla_la_mancha' AND (l.group_code = 0 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=0 DESC LIMIT 1
0.0151  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 = 73951 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73951 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.0318  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 = 73951 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73951 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  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 = 73951 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73951 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  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 = 73951 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC