4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
17 Oct 20 Caramanchel BCaramanchel 6 - 1 Plana JovisaPlana ...
17 Oct 20 CF PistaCF Pista 0 - 4 Vedruna BVedruna B ...
18 Oct 20 CF Clínica Oftalmológica DrClínica 2 - 1 Club Esportiu Sant RocClub ...
18 Oct 20 Español de Alcoy AEspañol 2 - 3 Imperial Dksystem AImperial ...
18 Oct 20 CDF IndependienteIndependien 4 - 3 Salesiano ASalesiano ...
Ver jornada
Jornada 2
24 Oct 20 Salesiano ASalesiano 3 - 6 CF Clínica Oftalmológica DrClínica ...
24 Oct 20 Club Esportiu Sant RocClub 1 - 2 Español de Alcoy AEspañol ...
25 Oct 20 Plana JovisaPlana 1 - 4 CDF IndependienteIndependien ...
25 Oct 20 Cocentaina BCocentaina 7 - 2 CF PistaCF Pista ...
25 Oct 20 Vedruna BVedruna B 1 - 1 Caramanchel BCaramanchel ...
Ver jornada
Jornada 3
08 Nov 20 Caramanchel BCaramanchel 3 - 0 CDF IndependienteIndependien ...
08 Nov 20 CF Clínica Oftalmológica DrClínica 1 - 1 Plana JovisaPlana ...
08 Nov 20 Español de Alcoy AEspañol 2 - 3 Salesiano ASalesiano ...
07 Nov 20 CF PistaCF Pista 1 - 1 Imperial Dksystem AImperial ...
07 Nov 20 Vedruna BVedruna B 0 - 2 Cocentaina BCocentaina ...
Ver jornada
Jornada 4
14 Nov 20 CDF IndependienteIndependien 1 - 3 CF Clínica Oftalmológica DrClínica ...
15 Nov 20 Plana JovisaPlana 0 - 3 Español de Alcoy AEspañol ...
15 Nov 20 Club Esportiu Sant RocClub 3 - 2 CF PistaCF Pista ...
14 Nov 20 Imperial Dksystem AImperial 1 - 1 Vedruna BVedruna B ...
15 Nov 20 Cocentaina BCocentaina 3 - 4 Caramanchel BCaramanchel ...
Ver jornada
Jornada 5
06 Dic 20 Caramanchel BCaramanchel 1 - 2 CF Clínica Oftalmológica DrClínica ...
21 Nov 20 Español de Alcoy AEspañol 1 - 0 CDF IndependienteIndependien ...
21 Nov 20 CF PistaCF Pista 5 - 2 Salesiano ASalesiano ...
22 Nov 20 Vedruna BVedruna B 2 - 1 Club Esportiu Sant RocClub ...
22 Nov 20 Cocentaina BCocentaina 1 - 4 Imperial Dksystem AImperial ...
Ver jornada
Jornada 6
29 Nov 20 CF Clínica Oftalmológica DrClínica 1 - 4 Español de Alcoy AEspañol ...
29 Nov 20 Plana JovisaPlana 1 - 1 CF PistaCF Pista ...
29 Nov 20 Salesiano ASalesiano 0 - 10 Vedruna BVedruna B ...
28 Nov 20 Club Esportiu Sant RocClub 1 - 7 Cocentaina BCocentaina ...
28 Nov 20 Imperial Dksystem AImperial 2 - 0 Caramanchel BCaramanchel ...
Ver jornada
Jornada 7
13 Dic 20 Caramanchel BCaramanchel 3 - 3 Español de Alcoy AEspañol ...
12 Dic 20 CF PistaCF Pista 3 - 1 CDF IndependienteIndependien ...
13 Dic 20 Vedruna BVedruna B 3 - 0 Plana JovisaPlana 1
13 Dic 20 Cocentaina BCocentaina 3 - 3 Salesiano ASalesiano ...
13 Dic 20 Imperial Dksystem AImperial 8 - 0 Club Esportiu Sant RocClub ...
Ver jornada
Jornada 8
20 Dic 20 CF Clínica Oftalmológica DrClínica 4 - 1 CF PistaCF Pista ...
19 Dic 20 CDF IndependienteIndependien 3 - 5 Vedruna BVedruna B ...
20 Dic 20 Plana JovisaPlana 0 - 3 Cocentaina BCocentaina ...
20 Dic 20 Salesiano ASalesiano 2 - 2 Imperial Dksystem AImperial ...
19 Dic 20 Club Esportiu Sant RocClub 1 - 2 Caramanchel BCaramanchel ...
Ver jornada
Jornada 9
27 Mar 21 CF PistaCF Pista 0 - 4 Español de Alcoy AEspañol ...
28 Mar 21 Vedruna BVedruna B 3 - 2 CF Clínica Oftalmológica DrClínica ...
27 Mar 21 Cocentaina BCocentaina 3 - 1 CDF IndependienteIndependien ...
28 Mar 21 Imperial Dksystem AImperial 2 - 0 Plana JovisaPlana ...
28 Mar 21 Club Esportiu Sant RocClub 0 - 4 Salesiano ASalesiano ...
Ver jornada
Jornada 10
03 Abr 21 Español de Alcoy AEspañol 5 - 3 Vedruna BVedruna B ...
05 Abr 21 CF Clínica Oftalmológica DrClínica 1 - 1 Cocentaina BCocentaina ...
03 Abr 21 CDF IndependienteIndependien 0 - 3 Imperial Dksystem AImperial ...
05 Abr 21 Plana JovisaPlana 1 - 2 Club Esportiu Sant RocClub ...
01 Abr 21 Caramanchel BCaramanchel 3 - 2 Salesiano ASalesiano ...
Ver jornada
Jornada 11
11 Abr 21 CF PistaCF Pista 0 - 6 Caramanchel BCaramanchel ...
10 Abr 21 Cocentaina BCocentaina 3 - 2 Español de Alcoy AEspañol ...
11 Abr 21 Imperial Dksystem AImperial 0 - 0 CF Clínica Oftalmológica DrClínica ...
10 Abr 21 Club Esportiu Sant RocClub 2 - 1 CDF IndependienteIndependien ...
11 Abr 21 Salesiano ASalesiano 1 - 2 Plana JovisaPlana ...
Ver jornada
Jornada 12
01 Jun 21 Plana JovisaPlana Apl Caramanchel BCaramanchel ...
01 Jun 21 Salesiano ASalesiano Apl CDF IndependienteIndependien ...
01 Jun 21 Club Esportiu Sant RocClub Apl CF Clínica Oftalmológica DrClínica ...
01 Jun 21 Imperial Dksystem AImperial Apl Español de Alcoy AEspañol ...
01 Jun 21 Vedruna BVedruna B Apl CF PistaCF Pista ...
Ver jornada
Jornada 13
02 Jun 21 CDF IndependienteIndependien Apl Plana JovisaPlana ...
02 Jun 21 CF Clínica Oftalmológica DrClínica Apl Salesiano ASalesiano ...
02 Jun 21 Español de Alcoy AEspañol Apl Club Esportiu Sant RocClub ...
02 Jun 21 CF PistaCF Pista Apl Cocentaina BCocentaina ...
02 Jun 21 Caramanchel BCaramanchel Apl Vedruna BVedruna B ...
Ver jornada
Jornada 14
03 Jun 21 CDF IndependienteIndependien Apl Caramanchel BCaramanchel ...
03 Jun 21 Plana JovisaPlana Apl CF Clínica Oftalmológica DrClínica ...
03 Jun 21 Salesiano ASalesiano Apl Español de Alcoy AEspañol ...
03 Jun 21 Imperial Dksystem AImperial Apl CF PistaCF Pista ...
03 Jun 21 Cocentaina BCocentaina Apl Vedruna BVedruna B ...
Ver jornada
Jornada 15
04 Jun 21 CF Clínica Oftalmológica DrClínica Apl CDF IndependienteIndependien ...
04 Jun 21 Español de Alcoy AEspañol Apl Plana JovisaPlana ...
04 Jun 21 CF PistaCF Pista Apl Club Esportiu Sant RocClub ...
04 Jun 21 Vedruna BVedruna B Apl Imperial Dksystem AImperial ...
04 Jun 21 Caramanchel BCaramanchel Apl Cocentaina BCocentaina ...
Ver jornada
Jornada 16
05 Jun 21 CF Clínica Oftalmológica DrClínica Apl Caramanchel BCaramanchel ...
05 Jun 21 CDF IndependienteIndependien Apl Español de Alcoy AEspañol ...
05 Jun 21 Salesiano ASalesiano Apl CF PistaCF Pista ...
05 Jun 21 Club Esportiu Sant RocClub Apl Vedruna BVedruna B ...
05 Jun 21 Imperial Dksystem AImperial Apl Cocentaina BCocentaina ...
Ver jornada
Jornada 17
06 Jun 21 Español de Alcoy AEspañol Apl CF Clínica Oftalmológica DrClínica ...
06 Jun 21 CF PistaCF Pista Apl Plana JovisaPlana ...
06 Jun 21 Vedruna BVedruna B Apl Salesiano ASalesiano ...
06 Jun 21 Cocentaina BCocentaina Apl Club Esportiu Sant RocClub ...
06 Jun 21 Caramanchel BCaramanchel Apl Imperial Dksystem AImperial ...
Ver jornada
Jornada 18
07 Jun 21 Español de Alcoy AEspañol Apl Caramanchel BCaramanchel ...
07 Jun 21 CDF IndependienteIndependien Apl CF PistaCF Pista ...
07 Jun 21 Plana JovisaPlana Apl Vedruna BVedruna B ...
07 Jun 21 Salesiano ASalesiano Apl Cocentaina BCocentaina ...
07 Jun 21 Club Esportiu Sant RocClub Apl Imperial Dksystem AImperial ...
Ver jornada
Jornada 19
08 Jun 21 CF PistaCF Pista Apl CF Clínica Oftalmológica DrClínica ...
08 Jun 21 Vedruna BVedruna B Apl CDF IndependienteIndependien ...
08 Jun 21 Cocentaina BCocentaina Apl Plana JovisaPlana ...
08 Jun 21 Imperial Dksystem AImperial Apl Salesiano ASalesiano ...
08 Jun 21 Caramanchel BCaramanchel Apl Club Esportiu Sant RocClub ...
Ver jornada
Jornada 20
09 Jun 21 Español de Alcoy AEspañol Apl CF PistaCF Pista ...
09 Jun 21 CF Clínica Oftalmológica DrClínica Apl Vedruna BVedruna B ...
09 Jun 21 CDF IndependienteIndependien Apl Cocentaina BCocentaina ...
09 Jun 21 Plana JovisaPlana Apl Imperial Dksystem AImperial ...
09 Jun 21 Salesiano ASalesiano Apl Club Esportiu Sant RocClub ...
Ver jornada
Jornada 21
10 Jun 21 Vedruna BVedruna B Apl Español de Alcoy AEspañol ...
10 Jun 21 Cocentaina BCocentaina Apl CF Clínica Oftalmológica DrClínica ...
10 Jun 21 Imperial Dksystem AImperial Apl CDF IndependienteIndependien ...
10 Jun 21 Club Esportiu Sant RocClub Apl Plana JovisaPlana ...
10 Jun 21 Salesiano ASalesiano Apl Caramanchel BCaramanchel ...
Ver jornada
Jornada 22
11 Jun 21 Caramanchel BCaramanchel Apl CF PistaCF Pista ...
11 Jun 21 Español de Alcoy AEspañol Apl Cocentaina BCocentaina ...
11 Jun 21 CF Clínica Oftalmológica DrClínica Apl Imperial Dksystem AImperial ...
11 Jun 21 CDF IndependienteIndependien Apl Club Esportiu Sant RocClub ...
11 Jun 21 Plana JovisaPlana Apl Salesiano ASalesiano ...

Clasificación

Equipo PJ GF GC Puntos
1 Imperial Dksystem A Imperial 10 26 7 22
2 Vedruna B Vedruna B 10 32 15 20
3 Cocentaina B Cocentaina 10 33 18 20
4 Caramanchel B Caramanchel 10 29 15 20
5 Español de Alcoy A Español 10 28 17 19
6 CF Clínica Oftalmológica Dr Clínica 10 22 16 18
7 Club Esportiu Sant Roc Club 10 12 31 9
8 Salesiano A Salesiano A 10 23 37 8
9 CF Pista CF Pista 10 15 33 8
10 CDF Independiente Independient 10 15 27 6
11 Plana Jovisa Plana Jovisa 10 7 26 5

  USO DE MEMORIA  
5,367,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3394
Total Execution Time  0.3413
  CADENA URL  
/primera_local_alcoy2021/grupo1/calendario
  GET DATOS  
$_GET['/primera_local_alcoy2021/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0144  SELECT type FROM routes WHERE alias = 'primera_local_alcoy2021'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_local_alcoy' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1139 AND type_rel = 3
0.0149  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1139 ORDER BY order_id ASC
0.0177  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 calendars2021 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 59962 ORDER BY round ASC
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 22:20:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 22:20:18' 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=4 AND last_update > '2024-05-01 22:20:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 22:20:18' 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 events2021 e ON e.player_id = p.id AND e.league_id = 59962 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59962 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 events2021 e ON e.player_id = p.id AND e.league_id = 59962 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59962 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 events2021 e ON e.player_id = p.id AND e.league_id = 59962 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59962 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157  SELECT *,(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 = 59962 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC