4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
20 Oct 19 Santa CroyaSanta Croya 1 - 5 ToresanaToresana ...
19 Oct 19 Sporting ZamoraSporting 1 - 1 Morales VinoMorales ...
19 Oct 19 Racing Club BenaventeRacing Club 3 - 1 Atlético ZamoraAtlético ...
19 Oct 19 VillalpandoVillalpando 2 - 1 CoresesCoreses ...
19 Oct 19 C D San CristobalCristobal 2 - 2 CD Villaralbo BVillaralbo 1
20 Oct 19 Fresno de La RiberaFresno 9 - 1 Camarzana Y Los VallesCamarzana ...
Ver jornada
Jornada 2
26 Oct 19 Atlético ZamoraAtlético 2 - 2 C D San CristobalCristobal ...
26 Oct 19 Morales VinoMorales 5 - 3 Santa CroyaSanta Croya ...
26 Oct 19 Camarzana Y Los VallesCamarzana 3 - 3 Racing Club BenaventeRacing Club ...
26 Oct 19 CoresesCoreses 2 - 1 Fresno de La RiberaFresno ...
26 Oct 19 ToresanaToresana 2 - 3 VillalpandoVillalpando ...
27 Oct 19 CD Villaralbo BVillaralbo 1 - 0 Sporting ZamoraSporting ...
Ver jornada
Jornada 3
02 Nov 19 Santa CroyaSanta Croya 5 - 3 CD Villaralbo BVillaralbo ...
02 Nov 19 Fresno de La RiberaFresno 3 - 1 ToresanaToresana ...
02 Nov 19 VillalpandoVillalpando 3 - 1 Morales VinoMorales ...
02 Nov 19 Atlético ZamoraAtlético 1 - 2 Camarzana Y Los VallesCamarzana ...
02 Nov 19 C D San CristobalCristobal 1 - 3 Sporting ZamoraSporting ...
02 Nov 19 Racing Club BenaventeRacing Club 1 - 4 CoresesCoreses ...
Ver jornada
Jornada 4
10 Nov 19 CD Villaralbo BVillaralbo 4 - 1 VillalpandoVillalpando ...
09 Nov 19 Camarzana Y Los VallesCamarzana 1 - 3 C D San CristobalCristobal ...
09 Nov 19 Morales VinoMorales 0 - 1 Fresno de La RiberaFresno ...
09 Nov 19 CoresesCoreses 5 - 2 Atlético ZamoraAtlético ...
09 Nov 19 Sporting ZamoraSporting 3 - 0 Santa CroyaSanta Croya ...
09 Nov 19 ToresanaToresana 3 - 3 Racing Club BenaventeRacing Club ...
Ver jornada
Jornada 5
16 Nov 19 Racing Club BenaventeRacing Club 1 - 4 Morales VinoMorales ...
16 Nov 19 Camarzana Y Los VallesCamarzana 1 - 6 CoresesCoreses ...
16 Nov 19 Atlético ZamoraAtlético 0 - 3 ToresanaToresana ...
16 Nov 19 C D San CristobalCristobal 0 - 1 Santa CroyaSanta Croya ...
16 Nov 19 Fresno de La RiberaFresno 1 - 1 CD Villaralbo BVillaralbo ...
16 Nov 19 VillalpandoVillalpando 4 - 2 Sporting ZamoraSporting ...
Ver jornada
Jornada 6
24 Nov 19 CD Villaralbo BVillaralbo 3 - 2 Racing Club BenaventeRacing Club ...
23 Nov 19 Morales VinoMorales 5 - 3 Atlético ZamoraAtlético ...
23 Nov 19 Santa CroyaSanta Croya 4 - 1 VillalpandoVillalpando ...
23 Nov 19 ToresanaToresana 2 - 2 Camarzana Y Los VallesCamarzana ...
23 Nov 19 Sporting ZamoraSporting 1 - 3 Fresno de La RiberaFresno ...
23 Nov 19 CoresesCoreses 2 - 0 C D San CristobalCristobal ...
Ver jornada
Jornada 7
30 Nov 19 Racing Club BenaventeRacing Club 2 - 0 Sporting ZamoraSporting ...
30 Nov 19 C D San CristobalCristobal 6 - 2 VillalpandoVillalpando ...
30 Nov 19 Atlético ZamoraAtlético 2 - 1 CD Villaralbo BVillaralbo ...
30 Nov 19 Fresno de La RiberaFresno 8 - 0 Santa CroyaSanta Croya ...
30 Nov 19 Camarzana Y Los VallesCamarzana 7 - 2 Morales VinoMorales ...
30 Nov 19 CoresesCoreses 2 - 1 ToresanaToresana ...
Ver jornada
Jornada 8
14 Dic 19 Morales VinoMorales 1 - 2 CoresesCoreses ...
15 Dic 19 Santa CroyaSanta Croya 5 - 3 Racing Club BenaventeRacing Club ...
14 Dic 19 ToresanaToresana 3 - 3 C D San CristobalCristobal ...
14 Dic 19 CD Villaralbo BVillaralbo 1 - 1 Camarzana Y Los VallesCamarzana ...
14 Dic 19 VillalpandoVillalpando 1 - 0 Fresno de La RiberaFresno ...
14 Dic 19 Sporting ZamoraSporting 2 - 2 Atlético ZamoraAtlético ...
Ver jornada
Jornada 9
25 Ene 20 Atlético ZamoraAtlético 4 - 3 Santa CroyaSanta Croya ...
25 Ene 20 Racing Club BenaventeRacing Club 0 - 0 VillalpandoVillalpando ...
25 Ene 20 Camarzana Y Los VallesCamarzana 2 - 1 Sporting ZamoraSporting ...
25 Ene 20 CoresesCoreses 3 - 4 CD Villaralbo BVillaralbo 2
25 Ene 20 C D San CristobalCristobal 4 - 1 Fresno de La RiberaFresno ...
26 Ene 20 ToresanaToresana 3 - 1 Morales VinoMorales ...
Ver jornada
Jornada 10
01 Feb 20 Sporting ZamoraSporting 1 - 3 CoresesCoreses 1
01 Feb 20 Santa CroyaSanta Croya 0 - 2 Camarzana Y Los VallesCamarzana ...
01 Feb 20 C D San CristobalCristobal 1 - 4 Morales VinoMorales ...
01 Feb 20 VillalpandoVillalpando 5 - 1 Atlético ZamoraAtlético ...
02 Feb 20 CD Villaralbo BVillaralbo 3 - 3 ToresanaToresana ...
01 Feb 20 Fresno de La RiberaFresno 4 - 0 Racing Club BenaventeRacing Club ...
Ver jornada
Jornada 11
08 Feb 20 ToresanaToresana 4 - 3 Sporting ZamoraSporting ...
08 Feb 20 Racing Club BenaventeRacing Club 0 - 0 C D San CristobalCristobal ...
08 Feb 20 Morales VinoMorales 1 - 2 CD Villaralbo BVillaralbo ...
08 Feb 20 CoresesCoreses 3 - 1 Santa CroyaSanta Croya ...
09 Feb 20 Camarzana Y Los VallesCamarzana 1 - 0 VillalpandoVillalpando ...
08 Feb 20 Atlético ZamoraAtlético 1 - 3 Fresno de La RiberaFresno ...
Ver jornada
Jornada 12
15 Feb 20 Camarzana Y Los VallesCamarzana 0 - 1 Fresno de La RiberaFresno ...
15 Feb 20 CoresesCoreses 4 - 1 VillalpandoVillalpando ...
15 Feb 20 Morales VinoMorales 2 - 1 Sporting ZamoraSporting ...
15 Feb 20 CD Villaralbo BVillaralbo 1 - 1 C D San CristobalCristobal ...
15 Feb 20 ToresanaToresana 1 - 1 Santa CroyaSanta Croya ...
15 Feb 20 Atlético ZamoraAtlético 2 - 3 Racing Club BenaventeRacing Club ...
Ver jornada
Jornada 13
29 Feb 20 Sporting ZamoraSporting 1 - 5 CD Villaralbo BVillaralbo ...
01 Mar 20 C D San CristobalCristobal 1 - 0 Atlético ZamoraAtlético ...
29 Feb 20 Racing Club BenaventeRacing Club 2 - 3 Camarzana Y Los VallesCamarzana ...
29 Feb 20 VillalpandoVillalpando 6 - 1 ToresanaToresana ...
01 Mar 20 Fresno de La RiberaFresno 2 - 0 CoresesCoreses ...
29 Feb 20 Santa CroyaSanta Croya 2 - 2 Morales VinoMorales ...
Ver jornada
Jornada 14
08 Mar 20 Morales VinoMorales 3 - 3 VillalpandoVillalpando ...
07 Mar 20 Sporting ZamoraSporting 3 - 1 C D San CristobalCristobal ...
07 Mar 20 CoresesCoreses 3 - 1 Racing Club BenaventeRacing Club ...
08 Mar 20 CD Villaralbo BVillaralbo 2 - 0 Santa CroyaSanta Croya ...
08 Mar 20 ToresanaToresana 0 - 4 Fresno de La RiberaFresno ...
07 Mar 20 Camarzana Y Los VallesCamarzana 4 - 3 Atlético ZamoraAtlético ...
Ver jornada
Jornada 15
14 Mar 20 Atlético ZamoraAtlético Apl CoresesCoreses ...
14 Mar 20 Fresno de La RiberaFresno Apl Morales VinoMorales ...
14 Mar 20 C D San CristobalCristobal Apl Camarzana Y Los VallesCamarzana ...
14 Mar 20 Santa CroyaSanta Croya Apl Sporting ZamoraSporting ...
14 Mar 20 VillalpandoVillalpando Apl CD Villaralbo BVillaralbo ...
14 Mar 20 Racing Club BenaventeRacing Club Apl ToresanaToresana ...
Ver jornada
Jornada 16
22 Mar 20 ToresanaToresana Apl Atlético ZamoraAtlético ...
22 Mar 20 Santa CroyaSanta Croya Apl C D San CristobalCristobal ...
22 Mar 20 CoresesCoreses Apl Camarzana Y Los VallesCamarzana ...
22 Mar 20 CD Villaralbo BVillaralbo Apl Fresno de La RiberaFresno ...
22 Mar 20 Morales VinoMorales Apl Racing Club BenaventeRacing Club ...
22 Mar 20 Sporting ZamoraSporting Apl VillalpandoVillalpando ...
Ver jornada
Jornada 17
29 Mar 20 VillalpandoVillalpando Apl Santa CroyaSanta Croya ...
29 Mar 20 C D San CristobalCristobal Apl CoresesCoreses ...
29 Mar 20 Camarzana Y Los VallesCamarzana Apl ToresanaToresana ...
29 Mar 20 Racing Club BenaventeRacing Club Apl CD Villaralbo BVillaralbo ...
29 Mar 20 Fresno de La RiberaFresno Apl Sporting ZamoraSporting ...
29 Mar 20 Atlético ZamoraAtlético Apl Morales VinoMorales ...
Ver jornada
Jornada 18
19 Abr 20 CD Villaralbo BVillaralbo Apl Atlético ZamoraAtlético ...
19 Abr 20 VillalpandoVillalpando Apl C D San CristobalCristobal ...
19 Abr 20 ToresanaToresana Apl CoresesCoreses ...
19 Abr 20 Santa CroyaSanta Croya Apl Fresno de La RiberaFresno ...
19 Abr 20 Morales VinoMorales Apl Camarzana Y Los VallesCamarzana ...
19 Abr 20 Sporting ZamoraSporting Apl Racing Club BenaventeRacing Club ...
Ver jornada
Jornada 19
26 Abr 20 Atlético ZamoraAtlético Apl Sporting ZamoraSporting ...
26 Abr 20 C D San CristobalCristobal Apl ToresanaToresana ...
26 Abr 20 Racing Club BenaventeRacing Club Apl Santa CroyaSanta Croya ...
26 Abr 20 CoresesCoreses Apl Morales VinoMorales ...
26 Abr 20 Fresno de La RiberaFresno Apl VillalpandoVillalpando ...
26 Abr 20 Camarzana Y Los VallesCamarzana Apl CD Villaralbo BVillaralbo ...
Ver jornada
Jornada 20
03 May 20 Fresno de La RiberaFresno Apl C D San CristobalCristobal ...
03 May 20 Sporting ZamoraSporting Apl Camarzana Y Los VallesCamarzana ...
03 May 20 Morales VinoMorales Apl ToresanaToresana ...
03 May 20 VillalpandoVillalpando Apl Racing Club BenaventeRacing Club ...
03 May 20 Santa CroyaSanta Croya Apl Atlético ZamoraAtlético ...
03 May 20 CD Villaralbo BVillaralbo Apl CoresesCoreses ...
Ver jornada
Jornada 21
10 May 20 Atlético ZamoraAtlético Apl VillalpandoVillalpando ...
10 May 20 Morales VinoMorales Apl C D San CristobalCristobal ...
10 May 20 Camarzana Y Los VallesCamarzana Apl Santa CroyaSanta Croya ...
10 May 20 Racing Club BenaventeRacing Club Apl Fresno de La RiberaFresno ...
10 May 20 CoresesCoreses Apl Sporting ZamoraSporting ...
10 May 20 ToresanaToresana Apl CD Villaralbo BVillaralbo ...
Ver jornada
Jornada 22
17 May 20 CD Villaralbo BVillaralbo Apl Morales VinoMorales ...
17 May 20 Sporting ZamoraSporting Apl ToresanaToresana ...
17 May 20 Fresno de La RiberaFresno Apl Atlético ZamoraAtlético ...
17 May 20 C D San CristobalCristobal Apl Racing Club BenaventeRacing Club ...
17 May 20 VillalpandoVillalpando Apl Camarzana Y Los VallesCamarzana ...
17 May 20 Santa CroyaSanta Croya Apl CoresesCoreses ...

Clasificación

Equipo PJ GF GC Puntos
1 Coreses Coreses 14 40 19 33
2 Fresno de La Ribera Fresno 14 41 12 31
3 CD Villaralbo B Villaralbo 15 38 24 29
4 Camarzana Y Los Valles Camarzana 15 33 36 27
5 Villalpando Villalpando 15 38 31 26
6 Morales Vino Morales Vino 15 34 35 19
7 C D San Cristobal Cristobal 14 25 25 17
8 Toresana Toresana 15 33 41 17
9 Santa Croya Santa Croya 15 28 44 15
10 Racing Club Benavente Racing Club 15 26 38 13
11 Sporting Zamora Sporting 15 23 36 11
12 Atlético Zamora Atlético 14 24 42 8

  USO DE MEMORIA  
5,563,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3502
Total Execution Time  0.3522
  CADENA URL  
/primera_castilla_y_leon2020/grupo9/calendario
  GET DATOS  
$_GET['/primera_castilla_y_leon2020/grupo9/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_castilla_y_leon' AND (l.group_code = 9 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=9 DESC LIMIT 1
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1298 ORDER BY order_id ASC
0.0146  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 = 51317 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 51317 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 18:19:19' 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-28 18:19:19' 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-28 18:19:19' 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-04-28 18:19:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 = 51317 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51317 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 = 51317 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51317 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 events2020 e ON e.player_id = p.id AND e.league_id = 51317 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51317 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  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 = 51317 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC