4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
26 Sep 21 Urraca CF BUrraca 0 - 0 Atlético CamochaAtlético ...
26 Sep 21 Independiente CFIndependien 1 - 2 CF EstudiantesEstudiantes ...
26 Sep 21 CD DevaCD Deva 0 - 4 Canicas ACCanicas AC ...
26 Sep 21 CD Manuel RubioManuel 0 - 0 RibadesellaRibadesella ...
26 Sep 21 Quintueles CFQuintueles 2 - 0 Deportiva PiloñesaDeportiva 1
26 Sep 21 Lealtad de Villaviciosa BLealtad 2 - 1 Triple A Gijón Triple 1
Ver jornada
Jornada 2
03 Oct 21 UD SariegoUD Sariego 4 - 0 CD DevaCD Deva ...
03 Oct 21 Canicas ACCanicas AC 4 - 0 CD Manuel RubioManuel ...
03 Oct 21 Deportiva PiloñesaDeportiva 0 - 1 Lealtad de Villaviciosa BLealtad ...
03 Oct 21 CF EstudiantesEstudiantes 0 - 3 Urraca CF BUrraca ...
03 Oct 21 Triple A Gijón Triple 3 - 0 Independiente CFIndependien ...
03 Oct 21 RibadesellaRibadesella 4 - 0 Quintueles CFQuintueles ...
Ver jornada
Jornada 3
10 Oct 21 Urraca CF BUrraca 1 - 2 Triple A Gijón Triple ...
10 Oct 21 Independiente CFIndependien 0 - 3 Deportiva PiloñesaDeportiva ...
10 Oct 21 Lealtad de Villaviciosa BLealtad 2 - 0 RibadesellaRibadesella ...
10 Oct 21 Quintueles CFQuintueles 4 - 0 Canicas ACCanicas AC ...
10 Oct 21 Atlético CamochaAtlético 5 - 1 CF EstudiantesEstudiantes ...
10 Oct 21 CD Manuel RubioManuel 8 - 1 UD SariegoUD Sariego ...
Ver jornada
Jornada 4
17 Oct 21 Triple A Gijón Triple 4 - 1 Atlético CamochaAtlético ...
17 Oct 21 RibadesellaRibadesella 1 - 0 Independiente CFIndependien ...
17 Oct 21 Canicas ACCanicas AC 1 - 3 Lealtad de Villaviciosa BLealtad ...
17 Oct 21 Deportiva PiloñesaDeportiva 0 - 0 Urraca CF BUrraca ...
17 Oct 21 UD SariegoUD Sariego 0 - 3 Quintueles CFQuintueles ...
17 Oct 21 CD DevaCD Deva 1 - 7 CD Manuel RubioManuel ...
Ver jornada
Jornada 5
24 Oct 21 Atlético CamochaAtlético 4 - 1 Deportiva PiloñesaDeportiva ...
24 Oct 21 CF EstudiantesEstudiantes 4 - 2 Triple A Gijón Triple ...
23 Oct 21 Lealtad de Villaviciosa BLealtad 3 - 1 UD SariegoUD Sariego ...
24 Oct 21 Independiente CFIndependien 1 - 1 Canicas ACCanicas AC ...
24 Oct 21 Quintueles CFQuintueles 4 - 0 CD DevaCD Deva ...
24 Oct 21 Urraca CF BUrraca 3 - 0 RibadesellaRibadesella ...
Ver jornada
Jornada 6
07 Nov 21 UD SariegoUD Sariego 2 - 2 Independiente CFIndependien ...
07 Nov 21 RibadesellaRibadesella 3 - 1 Atlético CamochaAtlético ...
07 Nov 21 CD Manuel RubioManuel 1 - 1 Quintueles CFQuintueles ...
07 Nov 21 Deportiva PiloñesaDeportiva 3 - 0 CF EstudiantesEstudiantes ...
07 Nov 21 Canicas ACCanicas AC 1 - 0 Urraca CF BUrraca ...
07 Nov 21 CD DevaCD Deva 0 - 2 Lealtad de Villaviciosa BLealtad ...
Ver jornada
Jornada 7
14 Nov 21 Atlético CamochaAtlético 0 - 2 Canicas ACCanicas AC ...
14 Nov 21 Triple A Gijón Triple 0 - 1 Deportiva PiloñesaDeportiva ...
13 Nov 21 Independiente CFIndependien 2 - 0 CD DevaCD Deva ...
14 Nov 21 CF EstudiantesEstudiantes 1 - 6 RibadesellaRibadesella ...
14 Nov 21 Urraca CF BUrraca 1 - 0 UD SariegoUD Sariego ...
14 Nov 21 Lealtad de Villaviciosa BLealtad 1 - 2 CD Manuel RubioManuel ...
Ver jornada
Jornada 8
21 Nov 21 Canicas ACCanicas AC 7 - 0 CF EstudiantesEstudiantes ...
21 Nov 21 Quintueles CFQuintueles 1 - 1 Lealtad de Villaviciosa BLealtad ...
21 Nov 21 CD DevaCD Deva 0 - 5 Urraca CF BUrraca ...
21 Nov 21 UD SariegoUD Sariego 2 - 2 Atlético CamochaAtlético ...
21 Nov 21 RibadesellaRibadesella 2 - 1 Triple A Gijón Triple ...
21 Nov 21 CD Manuel RubioManuel 6 - 2 Independiente CFIndependien ...
Ver jornada
Jornada 9
28 Nov 21 Deportiva PiloñesaDeportiva 1 - 0 RibadesellaRibadesella ...
28 Nov 21 Atlético CamochaAtlético 3 - 1 CD DevaCD Deva ...
26 Dic 21 Independiente CFIndependien 0 - 0 Quintueles CFQuintueles ...
28 Nov 21 Triple A Gijón Triple 2 - 2 Canicas ACCanicas AC ...
28 Nov 21 Urraca CF BUrraca 2 - 2 CD Manuel RubioManuel ...
28 Nov 21 CF EstudiantesEstudiantes 1 - 1 UD SariegoUD Sariego ...
Ver jornada
Jornada 10
12 Dic 21 CD Manuel RubioManuel 2 - 0 Atlético CamochaAtlético ...
12 Dic 21 CD DevaCD Deva 3 - 4 CF EstudiantesEstudiantes ...
12 Dic 21 Quintueles CFQuintueles 1 - 1 Urraca CF BUrraca ...
11 Dic 21 Lealtad de Villaviciosa BLealtad 3 - 2 Independiente CFIndependien ...
12 Dic 21 UD SariegoUD Sariego 1 - 1 Triple A Gijón Triple ...
12 Dic 21 Canicas ACCanicas AC 2 - 0 Deportiva PiloñesaDeportiva ...
Ver jornada
Jornada 11
19 Dic 21 RibadesellaRibadesella 2 - 1 Canicas ACCanicas AC ...
12 Ene 22 Deportiva PiloñesaDeportiva 2 - 2 UD SariegoUD Sariego ...
19 Dic 21 Atlético CamochaAtlético 2 - 4 Quintueles CFQuintueles ...
19 Dic 21 CF EstudiantesEstudiantes 0 - 0 CD Manuel RubioManuel ...
19 Dic 21 Urraca CF BUrraca 1 - 1 Lealtad de Villaviciosa BLealtad ...
19 Dic 21 Triple A Gijón Triple 5 - 1 CD DevaCD Deva ...
Ver jornada
Jornada 12
09 Ene 22 Quintueles CFQuintueles 1 - 1 CF EstudiantesEstudiantes ...
09 Ene 22 CD Manuel RubioManuel 3 - 0 Triple A Gijón Triple ...
09 Ene 22 CD DevaCD Deva 2 - 4 Deportiva PiloñesaDeportiva ...
09 Ene 22 UD SariegoUD Sariego 1 - 1 RibadesellaRibadesella ...
09 Ene 22 Independiente CFIndependien 2 - 3 Urraca CF BUrraca ...
09 Ene 22 Lealtad de Villaviciosa BLealtad 1 - 2 Atlético CamochaAtlético ...
Ver jornada
Jornada 13
16 Ene 22 Canicas ACCanicas AC 5 - 0 UD SariegoUD Sariego ...
26 Ene 22 Atlético CamochaAtlético 0 - 0 Independiente CFIndependien ...
16 Ene 22 CF EstudiantesEstudiantes 2 - 1 Lealtad de Villaviciosa BLealtad ...
16 Ene 22 Deportiva PiloñesaDeportiva 2 - 2 CD Manuel RubioManuel ...
16 Ene 22 RibadesellaRibadesella 18 - 0 CD DevaCD Deva 4
16 Ene 22 Triple A Gijón Triple 0 - 0 Quintueles CFQuintueles ...
Ver jornada
Jornada 14
23 Ene 22 Atlético CamochaAtlético 6 - 0 Urraca CF BUrraca ...
23 Ene 22 Deportiva PiloñesaDeportiva 0 - 1 Quintueles CFQuintueles ...
23 Ene 22 RibadesellaRibadesella 1 - 1 CD Manuel RubioManuel ...
23 Ene 22 CF EstudiantesEstudiantes 1 - 2 Independiente CFIndependien ...
23 Ene 22 Canicas ACCanicas AC 10 - 2 CD DevaCD Deva ...
23 Ene 22 Triple A Gijón Triple 1 - 2 Lealtad de Villaviciosa BLealtad ...
Ver jornada
Jornada 15
30 Ene 22 Independiente CFIndependien 2 - 1 Triple A Gijón Triple ...
30 Ene 22 Lealtad de Villaviciosa BLealtad 2 - 1 Deportiva PiloñesaDeportiva ...
30 Ene 22 CD DevaCD Deva 0 - 2 UD SariegoUD Sariego ...
30 Ene 22 Quintueles CFQuintueles 0 - 3 RibadesellaRibadesella ...
30 Ene 22 Urraca CF BUrraca 2 - 0 CF EstudiantesEstudiantes ...
30 Ene 22 CD Manuel RubioManuel 0 - 3 Canicas ACCanicas AC ...
Ver jornada
Jornada 16
06 Feb 22 Triple A Gijón Triple 3 - 2 Urraca CF BUrraca ...
06 Feb 22 Canicas ACCanicas AC 1 - 3 Quintueles CFQuintueles ...
06 Feb 22 UD SariegoUD Sariego 3 - 0 CD Manuel RubioManuel ...
06 Feb 22 Deportiva PiloñesaDeportiva 3 - 0 Independiente CFIndependien ...
06 Feb 22 CF EstudiantesEstudiantes 2 - 3 Atlético CamochaAtlético ...
06 Feb 22 RibadesellaRibadesella 0 - 0 Lealtad de Villaviciosa BLealtad ...
Ver jornada
Jornada 17
13 Feb 22 Independiente CFIndependien 1 - 2 RibadesellaRibadesella ...
13 Feb 22 Lealtad de Villaviciosa BLealtad 1 - 1 Canicas ACCanicas AC ...
13 Feb 22 Atlético CamochaAtlético 0 - 0 Triple A Gijón Triple ...
13 Feb 22 Quintueles CFQuintueles 2 - 1 UD SariegoUD Sariego ...
13 Feb 22 Urraca CF BUrraca 3 - 1 Deportiva PiloñesaDeportiva ...
13 Feb 22 CD Manuel RubioManuel 7 - 1 CD DevaCD Deva ...
Ver jornada
Jornada 18
06 Mar 22 Triple A Gijón Triple 8 - 2 CF EstudiantesEstudiantes ...
06 Mar 22 UD SariegoUD Sariego 1 - 1 Lealtad de Villaviciosa BLealtad ...
06 Mar 22 CD DevaCD Deva 0 - 8 Quintueles CFQuintueles ...
06 Mar 22 RibadesellaRibadesella 0 - 0 Urraca CF BUrraca ...
06 Mar 22 Canicas ACCanicas AC 5 - 0 Independiente CFIndependien ...
06 Mar 22 Deportiva PiloñesaDeportiva 0 - 2 Atlético CamochaAtlético ...
Ver jornada
Jornada 19
13 Mar 22 Urraca CF BUrraca 0 - 0 Canicas ACCanicas AC ...
12 Mar 22 Lealtad de Villaviciosa BLealtad 2 - 0 CD DevaCD Deva ...
13 Mar 22 Atlético CamochaAtlético 0 - 1 RibadesellaRibadesella ...
13 Mar 22 Independiente CFIndependien 0 - 1 UD SariegoUD Sariego ...
13 Mar 22 Quintueles CFQuintueles 1 - 3 CD Manuel RubioManuel ...
13 Mar 22 CF EstudiantesEstudiantes 3 - 1 Deportiva PiloñesaDeportiva ...
Ver jornada
Jornada 20
20 Mar 22 RibadesellaRibadesella 6 - 0 CF EstudiantesEstudiantes ...
20 Mar 22 CD DevaCD Deva 5 - 3 Independiente CFIndependien ...
20 Mar 22 CD Manuel RubioManuel 1 - 2 Lealtad de Villaviciosa BLealtad ...
20 Mar 22 Canicas ACCanicas AC 1 - 1 Atlético CamochaAtlético ...
20 Mar 22 UD SariegoUD Sariego 3 - 2 Urraca CF BUrraca ...
20 Mar 22 Deportiva PiloñesaDeportiva 0 - 0 Triple A Gijón Triple ...
Ver jornada
Jornada 21
27 Mar 22 Triple A Gijón Triple 1 - 0 RibadesellaRibadesella 1
27 Mar 22 Lealtad de Villaviciosa BLealtad 3 - 2 Quintueles CFQuintueles ...
27 Mar 22 Atlético CamochaAtlético 5 - 1 UD SariegoUD Sariego ...
27 Mar 22 Urraca CF BUrraca 4 - 0 CD DevaCD Deva ...
27 Mar 22 Independiente CFIndependien 1 - 4 CD Manuel RubioManuel ...
27 Mar 22 CF EstudiantesEstudiantes 2 - 3 Canicas ACCanicas AC ...
Ver jornada
Jornada 22
03 Abr 22 Canicas ACCanicas AC 3 - 3 Triple A Gijón Triple ...
03 Abr 22 Quintueles CFQuintueles 2 - 1 Independiente CFIndependien ...
03 Abr 22 CD DevaCD Deva 1 - 5 Atlético CamochaAtlético ...
03 Abr 22 RibadesellaRibadesella 1 - 0 Deportiva PiloñesaDeportiva ...
02 Abr 22 UD SariegoUD Sariego 2 - 1 CF EstudiantesEstudiantes ...
03 Abr 22 CD Manuel RubioManuel 1 - 2 Urraca CF BUrraca ...
Ver jornada
Jornada 23
24 Abr 22 Deportiva PiloñesaDeportiva 1 - 1 Canicas ACCanicas AC ...
24 Abr 22 Urraca CF BUrraca 2 - 3 Quintueles CFQuintueles ...
24 Abr 22 Triple A Gijón Triple 2 - 0 UD SariegoUD Sariego ...
24 Abr 22 Atlético CamochaAtlético 3 - 1 CD Manuel RubioManuel ...
24 Abr 22 Independiente CFIndependien 0 - 5 Lealtad de Villaviciosa BLealtad ...
24 Abr 22 CF EstudiantesEstudiantes 4 - 1 CD DevaCD Deva ...
Ver jornada
Jornada 24
01 May 22 UD SariegoUD Sariego 2 - 1 Deportiva PiloñesaDeportiva ...
01 May 22 Canicas ACCanicas AC 2 - 2 RibadesellaRibadesella ...
01 May 22 CD Manuel RubioManuel 5 - 0 CF EstudiantesEstudiantes ...
01 May 22 Quintueles CFQuintueles 0 - 3 Atlético CamochaAtlético ...
01 May 22 Lealtad de Villaviciosa BLealtad 4 - 0 Urraca CF BUrraca ...
01 May 22 CD DevaCD Deva 0 - 5 Triple A Gijón Triple ...
Ver jornada
Jornada 25
08 May 22 Atlético CamochaAtlético 3 - 3 Lealtad de Villaviciosa BLealtad ...
08 May 22 Urraca CF BUrraca 1 - 0 Independiente CFIndependien ...
08 May 22 Triple A Gijón Triple 3 - 4 CD Manuel RubioManuel ...
08 May 22 CF EstudiantesEstudiantes 0 - 2 Quintueles CFQuintueles ...
08 May 22 RibadesellaRibadesella 6 - 3 UD SariegoUD Sariego ...
08 May 22 Deportiva PiloñesaDeportiva 2 - 4 CD DevaCD Deva ...
Ver jornada
Jornada 26
15 May 22 UD SariegoUD Sariego 4 - 4 Canicas ACCanicas AC ...
15 May 22 Quintueles CFQuintueles 3 - 2 Triple A Gijón Triple ...
15 May 22 CD Manuel RubioManuel 5 - 0 Deportiva PiloñesaDeportiva ...
15 May 22 CD DevaCD Deva 3 - 5 RibadesellaRibadesella ...
14 May 22 Lealtad de Villaviciosa BLealtad 3 - 1 CF EstudiantesEstudiantes ...
14 May 22 Independiente CFIndependien 0 - 5 Atlético CamochaAtlético ...

Clasificación

Equipo PJ GF GC Puntos
1 Lealtad de Villaviciosa B Lealtad 24 49 24 51
2 Ribadesella Ribadesella 24 64 22 48
3 Quintueles CF Quintueles 24 48 29 45
4 Canicas AC Canicas AC 24 64 31 42
5 CD Manuel Rubio Manuel Rubio 24 65 34 42
6 Atlético Camocha Atlético 24 56 31 42
7 Urraca CF B Urraca CF B 24 38 30 37
8 Triple A Gijón Triple 24 50 36 33
9 UD Sariego UD Sariego 24 38 53 29
10 Deportiva Piloñesa Deportiva 24 27 39 23
11 CF Estudiantes Estudiantes 24 32 71 21
12 Independiente CF Independient 24 22 59 13
13 CD Deva CD Deva 24 25 119 6

  USO DE MEMORIA  
5,802,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1091
Total Execution Time  0.1112
  CADENA URL  
/primera_regional_asturias2022/grupo1/calendario
  GET DATOS  
$_GET['/primera_regional_asturias2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_regional_asturias2022'
0.0037  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_asturias' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 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=709 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 709 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (1088975,806083,759289,50689) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=709 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 = 63765 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63765 ORDER BY round ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 10:16:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 10:16: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-25 10:16:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 10:16:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_regional_asturias' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2022 e ON e.player_id = p.id AND e.league_id = 63765 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63765 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 events2022 e ON e.player_id = p.id AND e.league_id = 63765 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63765 AND (e.action = 4 or e.action = 5) 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 events2022 e ON e.player_id = p.id AND e.league_id = 63765 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63765 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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 = 63765 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