4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
01 Oct 23 Agramunt Escolagerard GatelAgramunt 6 - 1 Ribera D'ondara A ARibera ...
01 Oct 23 Calaf BCalaf B 1 - 2 Cervera BCervera B ...
01 Oct 23 Sant Guim Club Futbol A ASant Guim. 3 - 6 Rialp F.C.Rialp F.C. ...
01 Oct 23 Linyola CF BLinyola 4 - 0 Sant Ramón FCSant Ramón ...
01 Oct 23 Ivars de Urgel AIvars Urgel 3 - 2 Butsenit AButsenit A ...
01 Oct 23 Verdu Cercavins CF AVerdu 3 - 1 Solsona BSolsona B ...
Jornada 2
08 Oct 23 Ribera D'ondara A ARibera 0 - 4 Verdu Cercavins CF AVerdu ...
08 Oct 23 Agramunt Escolagerard GatelAgramunt 2 - 5 Cervera BCervera B ...
08 Oct 23 Rialp F.C.Rialp F.C. 3 - 0 Calaf BCalaf B ...
08 Oct 23 Sant Ramón FCSant Ramón 0 - 3 Sant Guim Club Futbol A ASant Guim. ...
08 Oct 23 Butsenit AButsenit A 1 - 4 Linyola CF BLinyola ...
08 Oct 23 Solsona BSolsona B 2 - 1 Ivars de Urgel AIvars Urgel ...
Jornada 3
15 Oct 23 Ribera D'ondara A ARibera 0 - 6 Cervera BCervera B ...
15 Oct 23 Agramunt Escolagerard GatelAgramunt 1 - 1 Rialp F.C.Rialp F.C. ...
15 Oct 23 Calaf BCalaf B 2 - 0 Sant Ramón FCSant Ramón ...
15 Oct 23 Sant Guim Club Futbol A ASant Guim. 2 - 1 Butsenit AButsenit A ...
15 Oct 23 Linyola CF BLinyola 2 - 0 Solsona BSolsona B ...
15 Oct 23 Verdu Cercavins CF AVerdu 1 - 1 Ivars de Urgel AIvars Urgel ...
Jornada 4
22 Oct 23 Verdu Cercavins CF AVerdu 3 - 2 Cervera BCervera B ...
22 Oct 23 Rialp F.C.Rialp F.C. 6 - 0 Ribera D'ondara A ARibera ...
22 Oct 23 Sant Ramón FCSant Ramón 0 - 3 Agramunt Escolagerard GatelAgramunt ...
22 Oct 23 Butsenit AButsenit A 3 - 1 Calaf BCalaf B ...
22 Oct 23 Solsona BSolsona B 0 - 1 Sant Guim Club Futbol A ASant Guim. ...
22 Oct 23 Ivars de Urgel AIvars Urgel 1 - 0 Linyola CF BLinyola ...
Jornada 5
10 Dic 23 Cervera BCervera B 1 - 4 Rialp F.C.Rialp F.C. ...
29 Oct 23 Ribera D'ondara A ARibera 0 - 1 Sant Ramón FCSant Ramón ...
29 Oct 23 Agramunt Escolagerard GatelAgramunt 0 - 1 Butsenit AButsenit A ...
29 Oct 23 Calaf BCalaf B 1 - 3 Solsona BSolsona B ...
29 Oct 23 Sant Guim Club Futbol A ASant Guim. 0 - 2 Ivars de Urgel AIvars Urgel ...
29 Oct 23 Verdu Cercavins CF AVerdu 7 - 0 Linyola CF BLinyola ...
Jornada 6
05 Nov 23 Rialp F.C.Rialp F.C. 0 - 3 Verdu Cercavins CF AVerdu ...
05 Nov 23 Cervera BCervera B 3 - 0 Sant Ramón FCSant Ramón ...
05 Nov 23 Butsenit AButsenit A 7 - 1 Ribera D'ondara A ARibera ...
05 Nov 23 Solsona BSolsona B 2 - 1 Agramunt Escolagerard GatelAgramunt ...
05 Nov 23 Ivars de Urgel AIvars Urgel 4 - 0 Calaf BCalaf B ...
05 Nov 23 Linyola CF BLinyola 1 - 0 Sant Guim Club Futbol A ASant Guim. ...
Jornada 7
12 Nov 23 Rialp F.C.Rialp F.C. 4 - 0 Sant Ramón FCSant Ramón ...
12 Nov 23 Cervera BCervera B 1 - 0 Butsenit AButsenit A ...
12 Nov 23 Ribera D'ondara A ARibera 1 - 7 Solsona BSolsona B ...
12 Nov 23 Agramunt Escolagerard GatelAgramunt 1 - 2 Ivars de Urgel AIvars Urgel ...
01 Dic 23 Calaf BCalaf B 3 - 5 Linyola CF BLinyola ...
12 Nov 23 Verdu Cercavins CF AVerdu 5 - 2 Sant Guim Club Futbol A ASant Guim. ...
Jornada 8
19 Nov 23 Sant Ramón FCSant Ramón 0 - 3 Verdu Cercavins CF AVerdu ...
19 Nov 23 Butsenit AButsenit A 2 - 3 Rialp F.C.Rialp F.C. ...
19 Nov 23 Solsona BSolsona B 2 - 1 Cervera BCervera B ...
19 Nov 23 Ivars de Urgel AIvars Urgel 9 - 0 Ribera D'ondara A ARibera ...
19 Nov 23 Linyola CF BLinyola 1 - 1 Agramunt Escolagerard GatelAgramunt ...
19 Nov 23 Sant Guim Club Futbol A ASant Guim. 3 - 0 Calaf BCalaf B ...
Jornada 9
26 Nov 23 Sant Ramón FCSant Ramón 1 - 4 Butsenit AButsenit A ...
26 Nov 23 Rialp F.C.Rialp F.C. 0 - 1 Solsona BSolsona B ...
26 Nov 23 Cervera BCervera B 3 - 2 Ivars de Urgel AIvars Urgel ...
26 Nov 23 Ribera D'ondara A ARibera 1 - 3 Linyola CF BLinyola ...
26 Nov 23 Agramunt Escolagerard GatelAgramunt 2 - 0 Sant Guim Club Futbol A ASant Guim. ...
26 Nov 23 Verdu Cercavins CF AVerdu 3 - 0 Calaf BCalaf B ...
Jornada 10
02 Dic 23 Verdu Cercavins CF AVerdu 4 - 2 Butsenit AButsenit A ...
02 Dic 23 Solsona BSolsona B 5 - 1 Sant Ramón FCSant Ramón ...
02 Dic 23 Ivars de Urgel AIvars Urgel 3 - 1 Rialp F.C.Rialp F.C. ...
03 Dic 23 Linyola CF BLinyola 4 - 4 Cervera BCervera B ...
03 Dic 23 Sant Guim Club Futbol A ASant Guim. 4 - 3 Ribera D'ondara A ARibera ...
03 Dic 23 Calaf BCalaf B 1 - 2 Agramunt Escolagerard GatelAgramunt ...
Jornada 11
16 Dic 23 Butsenit AButsenit A 1 - 0 Solsona BSolsona B ...
16 Dic 23 Sant Ramón FCSant Ramón 1 - 2 Ivars de Urgel AIvars Urgel ...
17 Dic 23 Rialp F.C.Rialp F.C. 2 - 0 Linyola CF BLinyola ...
16 Dic 23 Cervera BCervera B 3 - 0 Sant Guim Club Futbol A ASant Guim. ...
16 Dic 23 Ribera D'ondara A ARibera 2 - 1 Calaf BCalaf B ...
16 Dic 23 Agramunt Escolagerard GatelAgramunt 4 - 0 Verdu Cercavins CF AVerdu ...
Jornada 12
13 Ene 24 Ribera D'ondara A ARibera 1 - 3 Agramunt Escolagerard GatelAgramunt ...
14 Ene 24 Cervera BCervera B 3 - 0 Calaf BCalaf B ...
14 Ene 24 Rialp F.C.Rialp F.C. 4 - 0 Sant Guim Club Futbol A ASant Guim. ...
13 Ene 24 Sant Ramón FCSant Ramón 3 - 3 Linyola CF BLinyola ...
13 Ene 24 Butsenit AButsenit A 3 - 0 Ivars de Urgel AIvars Urgel ...
13 Ene 24 Solsona BSolsona B 0 - 1 Verdu Cercavins CF AVerdu ...
Jornada 13
20 Ene 24 Verdu Cercavins CF AVerdu 10 - 0 Ribera D'ondara A ARibera ...
21 Ene 24 Cervera BCervera B 3 - 2 Agramunt Escolagerard GatelAgramunt ...
20 Ene 24 Calaf BCalaf B 0 - 6 Rialp F.C.Rialp F.C. ...
21 Ene 24 Sant Guim Club Futbol A ASant Guim. 3 - 3 Sant Ramón FCSant Ramón ...
20 Ene 24 Linyola CF BLinyola 3 - 2 Butsenit AButsenit A ...
21 Ene 24 Ivars de Urgel AIvars Urgel 2 - 3 Solsona BSolsona B ...
Jornada 14
27 Ene 24 Cervera BCervera B 2 - 3 Ribera D'ondara A ARibera ...
28 Ene 24 Rialp F.C.Rialp F.C. 1 - 0 Agramunt Escolagerard GatelAgramunt ...
27 Ene 24 Sant Ramón FCSant Ramón 0 - 1 Calaf BCalaf B ...
27 Ene 24 Butsenit AButsenit A 3 - 1 Sant Guim Club Futbol A ASant Guim. ...
27 Ene 24 Solsona BSolsona B 2 - 2 Linyola CF BLinyola ...
28 Ene 24 Ivars de Urgel AIvars Urgel 3 - 4 Verdu Cercavins CF AVerdu ...
Jornada 15
03 Feb 24 Cervera BCervera B 1 - 0 Verdu Cercavins CF AVerdu ...
03 Feb 24 Ribera D'ondara A ARibera 0 - 2 Rialp F.C.Rialp F.C. ...
03 Feb 24 Agramunt Escolagerard GatelAgramunt 2 - 1 Sant Ramón FCSant Ramón ...
03 Feb 24 Calaf BCalaf B 0 - 4 Butsenit AButsenit A ...
04 Feb 24 Sant Guim Club Futbol A ASant Guim. 0 - 4 Solsona BSolsona B ...
03 Feb 24 Linyola CF BLinyola 0 - 0 Ivars de Urgel AIvars Urgel ...
Jornada 16
18 Feb 24 Rialp F.C.Rialp F.C. 1 - 2 Cervera BCervera B ...
17 Feb 24 Sant Ramón FCSant Ramón 3 - 2 Ribera D'ondara A ARibera ...
17 Feb 24 Butsenit AButsenit A 1 - 1 Agramunt Escolagerard GatelAgramunt ...
17 Feb 24 Solsona BSolsona B 3 - 0 Calaf BCalaf B ...
18 Feb 24 Ivars de Urgel AIvars Urgel 6 - 0 Sant Guim Club Futbol A ASant Guim. ...
17 Feb 24 Linyola CF BLinyola 4 - 3 Verdu Cercavins CF AVerdu ...
Jornada 17
24 Feb 24 Verdu Cercavins CF AVerdu 3 - 1 Rialp F.C.Rialp F.C. ...
24 Feb 24 Sant Ramón FCSant Ramón 0 - 3 Cervera BCervera B ...
24 Feb 24 Ribera D'ondara A ARibera 1 - 7 Butsenit AButsenit A ...
24 Feb 24 Agramunt Escolagerard GatelAgramunt 1 - 7 Solsona BSolsona B ...
24 Feb 24 Calaf BCalaf B 2 - 7 Ivars de Urgel AIvars Urgel ...
25 Feb 24 Sant Guim Club Futbol A ASant Guim. 0 - 2 Linyola CF BLinyola ...
Jornada 18
02 Mar 24 Sant Ramón FCSant Ramón 0 - 3 Rialp F.C.Rialp F.C. ...
02 Mar 24 Butsenit AButsenit A 2 - 3 Cervera BCervera B ...
02 Mar 24 Solsona BSolsona B 5 - 1 Ribera D'ondara A ARibera ...
03 Mar 24 Ivars de Urgel AIvars Urgel 3 - 1 Agramunt Escolagerard GatelAgramunt ...
02 Mar 24 Linyola CF BLinyola 3 - 1 Calaf BCalaf B ...
03 Mar 24 Sant Guim Club Futbol A ASant Guim. 0 - 2 Verdu Cercavins CF AVerdu ...
Jornada 19
09 Mar 24 Verdu Cercavins CF AVerdu 4 - 0 Sant Ramón FCSant Ramón ...
29 Mar 24 Rialp F.C.Rialp F.C. 2 - 1 Butsenit AButsenit A ...
09 Mar 24 Cervera BCervera B 4 - 1 Solsona BSolsona B ...
29 Mar 24 Ribera D'ondara A ARibera 0 - 2 Ivars de Urgel AIvars Urgel ...
09 Mar 24 Agramunt Escolagerard GatelAgramunt 3 - 1 Linyola CF BLinyola ...
09 Mar 24 Calaf BCalaf B 1 - 3 Sant Guim Club Futbol A ASant Guim. ...
Jornada 20
16 Mar 24 Butsenit AButsenit A 2 - 1 Sant Ramón FCSant Ramón ...
16 Mar 24 Solsona BSolsona B 3 - 3 Rialp F.C.Rialp F.C. ...
17 Mar 24 Ivars de Urgel AIvars Urgel 0 - 2 Cervera BCervera B ...
16 Mar 24 Linyola CF BLinyola 6 - 0 Ribera D'ondara A ARibera ...
17 Mar 24 Sant Guim Club Futbol A ASant Guim. 1 - 1 Agramunt Escolagerard GatelAgramunt ...
16 Mar 24 Calaf BCalaf B 0 - 3 Verdu Cercavins CF AVerdu ...
Jornada 21
23 Mar 24 Butsenit AButsenit A 2 - 3 Verdu Cercavins CF AVerdu ...
23 Mar 24 Sant Ramón FCSant Ramón 0 - 6 Solsona BSolsona B ...
24 Mar 24 Rialp F.C.Rialp F.C. 2 - 4 Ivars de Urgel AIvars Urgel ...
23 Mar 24 Cervera BCervera B 2 - 1 Linyola CF BLinyola ...
23 Mar 24 Ribera D'ondara A ARibera 2 - 2 Sant Guim Club Futbol A ASant Guim. ...
23 Mar 24 Agramunt Escolagerard GatelAgramunt 3 - 2 Calaf BCalaf B ...
Jornada 22
06 Abr 24 Solsona BSolsona B 3 - 2 Butsenit AButsenit A ...
07 Abr 24 Ivars de Urgel AIvars Urgel 4 - 1 Sant Ramón FCSant Ramón ...
06 Abr 24 Linyola CF BLinyola 2 - 2 Rialp F.C.Rialp F.C. ...
07 Abr 24 Sant Guim Club Futbol A ASant Guim. 1 - 2 Cervera BCervera B ...
06 Abr 24 Calaf BCalaf B 0 - 1 Ribera D'ondara A ARibera ...
06 Abr 24 Verdu Cercavins CF AVerdu 1 - 0 Agramunt Escolagerard GatelAgramunt ...

Clasificación

Equipo PJ GF GC Puntos
1 Verdu Cercavins CF A Verdu 22 70 23 55
2 Cervera B Cervera B 22 58 29 52
3 Ivars de Urgel A Ivars Urgel 22 61 29 44
4 Solsona B Solsona B 22 60 29 44
5 Rialp F.C. Rialp F.C. 22 57 29 42
6 Linyola CF B Linyola 22 51 38 39
7 Butsenit A Butsenit A 22 53 38 31
8 Agramunt Escolagerard Gatel Agramunt 22 40 36 31
9 Sant Guim Club Futbol A A Sant Guim C. 22 29 53 21
10 Ribera D'ondara A A Ribera 22 20 96 10
11 Sant Ramón FC Sant Ramón 22 16 66 8
12 Calaf B Calaf B 22 17 66 6

  USO DE MEMORIA  
5,557,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3142
Total Execution Time  0.3162
  CADENA URL  
/cuarta_catalana2024/grupo28/calendario
  GET DATOS  
$_GET['/cuarta_catalana2024/grupo28/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0256  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_catalana' AND (l.group_code = 28 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=28 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=745 ORDER BY order_id ASC
0.0126  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 = 74062 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 74062 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 07:30:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 07:30:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 07:30:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 07:30:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0133  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_catalana' 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.0130  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 = 74062 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74062 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.0129  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 = 74062 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74062 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0129  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 = 74062 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74062 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 = 74062 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC