Resultados
« Jornada Anterior
Jornada 30
Jornada Siguiente »
 
20 Abr 24
Sin comenzar 		Rapitenca Rapitenca
17:30
 		UE Vilassar de Mar UE Vilassar de Mar más información ...
 
21 Abr 24
Sin comenzar 		FE Grama FE Grama
11:45
 		CF Pobla de Mafumet CF Pobla de Mafumet más información ...
 
21 Abr 24
Sin comenzar 		CP San Cristóbal CP San Cristóbal
12:00
 		CF Peralada CF Peralada más información ...
 
21 Abr 24
Sin comenzar 		Castelldefels Castelldefels
12:00
 		FC Vilafranca FC Vilafranca más información ...
 
21 Abr 24
Sin comenzar 		CFJ Mollerussa CFJ Mollerussa
12:00
 		Girona FC B Girona FC B más información ...
 
21 Abr 24
Sin comenzar 		AE Prat AE Prat
12:00
 		Reus FC Reddis Reus FC Reddis más información 15
21 Abr 24
Sin comenzar 		L´Hospitalet L´Hospitalet
12:30
 		L'Escala L'Escala más información 1
 
21 Abr 24
Sin comenzar 		Olot Olot
16:30
 		Tona Tona más información 1
 
21 Abr 24
Sin comenzar 		Badalona Badalona
17:30
 		Montañesa Montañesa más información ...
Clasificación
« Jornada Anterior
Jornada 30
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Olot Olot 69 29 21 6 2 46 15
  • VICTORIA
  • Olot 2
  • CFJ Mollerussa 1
  • VICTORIA
  • Olot 1
  • UE Vilassar de Mar 0
  • VICTORIA
  • AE Prat 1
  • Olot 2
  • VICTORIA
  • Olot 4
  • Rapitenca 0
  • VICTORIA
  • Reus FC Reddis 0
  • Olot 2
2 L´Hospitalet L´Hospitalet 54 29 17 3 9 45 27
  • DERROTA
  • AE Prat 2
  • L´Hospitalet 0
  • DERROTA
  • L´Hospitalet 1
  • Rapitenca 2
  • EMPATE
  • Reus FC Reddis 1
  • L´Hospitalet 1
  • VICTORIA
  • L´Hospitalet 2
  • Tona 1
  • DERROTA
  • Girona FC B 3
  • L´Hospitalet 2
3 UE Vilassar de Mar Vilassar 53 29 15 8 6 35 23
  • VICTORIA
  • UE Vilassar de Mar 2
  • Montañesa 1
  • DERROTA
  • Olot 1
  • UE Vilassar de Mar 0
  • VICTORIA
  • UE Vilassar de Mar 2
  • CF Peralada 1
  • EMPATE
  • AE Prat 0
  • UE Vilassar de Mar 0
  • VICTORIA
  • UE Vilassar de Mar 1
  • CF Pobla de Mafume. 0
4 Badalona Badalona 47 29 14 5 10 34 29
  • VICTORIA
  • Reus FC Reddis 0
  • Badalona 1
  • VICTORIA
  • Badalona 3
  • Tona 2
  • VICTORIA
  • Girona FC B 1
  • Badalona 2
  • VICTORIA
  • Badalona 1
  • L'Escala 0
  • EMPATE
  • FC Vilafranca 0
  • Badalona 0
5 AE Prat AE Prat 43 29 11 10 8 30 24
  • VICTORIA
  • AE Prat 2
  • L´Hospitalet 0
  • DERROTA
  • CFJ Mollerussa 1
  • AE Prat 0
  • DERROTA
  • AE Prat 1
  • Olot 2
  • EMPATE
  • AE Prat 0
  • UE Vilassar de Mar 0
  • VICTORIA
  • Rapitenca 1
  • AE Prat 2
6 L'Escala L'Escala 42 29 12 6 11 48 49
  • DERROTA
  • L'Escala 0
  • CF Pobla de Mafume. 1
  • VICTORIA
  • FE Grama 1
  • L'Escala 2
  • VICTORIA
  • L'Escala 3
  • CP San Cristóbal 1
  • DERROTA
  • Badalona 1
  • L'Escala 0
  • VICTORIA
  • L'Escala 4
  • Castelldefels 2
7 CF Peralada CF Peralada 40 29 11 7 11 30 27
  • DERROTA
  • FC Vilafranca 3
  • CF Peralada 0
  • VICTORIA
  • CF Peralada 2
  • Montañesa 0
  • DERROTA
  • UE Vilassar de Mar 2
  • CF Peralada 1
  • VICTORIA
  • CF Pobla de Mafume. 0
  • CF Peralada 1
  • DERROTA
  • CF Peralada 1
  • FE Grama 2
8 Tona Tona 40 29 11 7 11 42 40
  • DERROTA
  • Badalona 3
  • Tona 2
  • VICTORIA
  • Tona 4
  • Castelldefels 1
  • DERROTA
  • L´Hospitalet 2
  • Tona 1
  • VICTORIA
  • Tona 3
  • CF Pobla de Mafume. 2
  • EMPATE
  • Tona 0
  • CFJ Mollerussa 0
9 Reus FC Reddis Reus FC Reddis 37 29 10 7 12 25 25
  • DERROTA
  • Reus FC Reddis 0
  • Badalona 1
  • EMPATE
  • Castelldefels 0
  • Reus FC Reddis 0
  • EMPATE
  • Reus FC Reddis 1
  • L´Hospitalet 1
  • DERROTA
  • CFJ Mollerussa 1
  • Reus FC Reddis 0
  • DERROTA
  • Reus FC Reddis 0
  • Olot 2
10 FE Grama FE Grama 37 29 11 4 14 33 40
  • DERROTA
  • Girona FC B 4
  • FE Grama 3
  • DERROTA
  • FE Grama 1
  • L'Escala 2
  • EMPATE
  • FC Vilafranca 0
  • FE Grama 0
  • VICTORIA
  • FE Grama 3
  • Montañesa 1
  • VICTORIA
  • CF Peralada 1
  • FE Grama 2
11 Montañesa Montañesa 37 29 10 7 12 26 30
  • DERROTA
  • UE Vilassar de Mar 2
  • Montañesa 1
  • DERROTA
  • CF Peralada 2
  • Montañesa 0
  • DERROTA
  • Montañesa 0
  • CF Pobla de Mafume. 2
  • DERROTA
  • FE Grama 3
  • Montañesa 1
  • VICTORIA
  • Montañesa 2
  • CP San Cristóbal 0
12 Girona FC B Girona FC B 36 29 9 9 11 41 35
  • VICTORIA
  • Girona FC B 4
  • FE Grama 3
  • VICTORIA
  • CP San Cristóbal 1
  • Girona FC B 2
  • DERROTA
  • Girona FC B 1
  • Badalona 2
  • EMPATE
  • Castelldefels 0
  • Girona FC B 0
  • VICTORIA
  • Girona FC B 3
  • L´Hospitalet 2
13 CF Pobla de Mafumet Pobla Mafumet 35 29 9 8 12 29 31
  • EMPATE
  • CF Pobla de Mafume. 1
  • FC Vilafranca 1
  • VICTORIA
  • Montañesa 0
  • CF Pobla de Mafume. 2
  • DERROTA
  • CF Pobla de Mafume. 0
  • CF Peralada 1
  • DERROTA
  • Tona 3
  • CF Pobla de Mafume. 2
  • DERROTA
  • UE Vilassar de Mar 1
  • CF Pobla de Mafume. 0
14 CFJ Mollerussa CFJ Mollerussa 35 28 10 5 13 26 37
  • DERROTA
  • CFJ Mollerussa 0
  • UE Vilassar de Mar 2
  • DERROTA
  • Olot 2
  • CFJ Mollerussa 1
  • VICTORIA
  • CFJ Mollerussa 1
  • AE Prat 0
  • VICTORIA
  • CFJ Mollerussa 1
  • Reus FC Reddis 0
  • EMPATE
  • Tona 0
  • CFJ Mollerussa 0
15 CP San Cristóbal Cristóbal 33 29 10 3 16 28 48
  • VICTORIA
  • Tona 1
  • CP San Cristóbal 2
  • DERROTA
  • CP San Cristóbal 1
  • Girona FC B 2
  • DERROTA
  • L'Escala 3
  • CP San Cristóbal 1
  • VICTORIA
  • CP San Cristóbal 3
  • FC Vilafranca 2
  • DERROTA
  • Montañesa 2
  • CP San Cristóbal 0
16 FC Vilafranca FC Vilafranca 29 29 7 8 14 26 43
  • VICTORIA
  • FC Vilafranca 3
  • CF Peralada 0
  • EMPATE
  • CF Pobla de Mafume. 1
  • FC Vilafranca 1
  • EMPATE
  • FC Vilafranca 0
  • FE Grama 0
  • DERROTA
  • CP San Cristóbal 3
  • FC Vilafranca 2
  • EMPATE
  • FC Vilafranca 0
  • Badalona 0
17 Rapitenca Rapitenca 29 28 9 2 17 29 37
  • DERROTA
  • Badalona 3
  • Rapitenca 1
  • DERROTA
  • Rapitenca 0
  • Castelldefels 1
  • VICTORIA
  • L´Hospitalet 1
  • Rapitenca 2
  • DERROTA
  • Olot 4
  • Rapitenca 0
  • DERROTA
  • Rapitenca 1
  • AE Prat 2
18 Castelldefels Castelldefels 27 29 6 9 14 26 39
  • VICTORIA
  • Rapitenca 0
  • Castelldefels 1
  • EMPATE
  • Castelldefels 0
  • Reus FC Reddis 0
  • DERROTA
  • Tona 4
  • Castelldefels 1
  • EMPATE
  • Castelldefels 0
  • Girona FC B 0
  • DERROTA
  • L'Escala 4
  • Castelldefels 2
Ascenso : Olot
Playoff Ascenso : L´Hospitalet, Vilassar, Badalona, AE Prat
Descenso : FC Vilafranca, Rapitenca, Castelldefels
JUGADORES DESTACADOS

Tercera Federación

20 Abr 24 17:30
Estadi Mpal. De La Devesa
21 Abr 24 11:45
Nou Camp Mpal. De Santa Coloma
21 Abr 24 12:00
Municipal Sagnier
21 Abr 24 12:00
Estadi Municipal San Cristòbal
21 Abr 24 12:00
Camp Municipal D'Esports De Mollerussa

  USO DE MEMORIA  
6,264,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.2520
Total Execution Time  0.2549
  CADENA URL  
/tercera_division_rfef/grupo5
  GET DATOS  
$_GET['/tercera_division_rfef/grupo5']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0123  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=2470 ORDER BY l.group_code ASC
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 00:15:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-19 00:15:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 00:15:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 00:15:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0115  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-19 00:00:00' AND c.`shedule` < '2024-04-23 23:59:59' AND l.id = 72264 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0122  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 213784
0.0117  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 213776
0.0117  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 213783
0.0117  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 213777
0.0117  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 213781
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=2470
0.0111  SELECT group_code, extraName from `leagues` WHERE categoryId=2470 AND year=2024