4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
23 Oct 20 Inter de Jaén CFInter Jaén 0 - 0 Huelma CPHuelma CP ...
18 Oct 20 Urgavona CFUrgavona 1 - 2 Recreativo BailénRecreativo ...
08 Dic 20 Fuensanta CFFuensanta 3 - 1 Iliturgi 2016Iliturgi 3
18 Oct 20 Mancha Real ADMancha Real 3 - 0 Los Villares CFVillares ...
18 Oct 20 Valdepeñas de Jaén CFValdepeñas 4 - 3 UDC Torredonjimeno BTorredonjim ...
Ver jornada
Jornada 2
25 Oct 20 Recreativo BailénRecreativo 3 - 0 Huelma CPHuelma CP ...
25 Oct 20 Iliturgi 2016Iliturgi 1 - 1 Urgavona CFUrgavona 1
25 Oct 20 Los Villares CFVillares 5 - 0 Fuensanta CFFuensanta ...
11 Nov 20 UDC Torredonjimeno BTorredonjim 2 - 2 Mancha Real ADMancha Real ...
25 Oct 20 UD La GuardiaGuardia 3 - 3 Valdepeñas de Jaén CFValdepeñas ...
Ver jornada
Jornada 3
31 Oct 20 Inter de Jaén CFInter Jaén 2 - 4 Recreativo BailénRecreativo ...
31 Oct 20 Huelma CPHuelma CP 0 - 2 Iliturgi 2016Iliturgi 5
31 Oct 20 Urgavona CFUrgavona 2 - 4 Los Villares CFVillares ...
31 Oct 20 Fuensanta CFFuensanta 0 - 1 UDC Torredonjimeno BTorredonjim ...
31 Oct 20 Mancha Real ADMancha Real 1 - 0 UD La GuardiaGuardia ...
Ver jornada
Jornada 4
02 Nov 20 Iliturgi 2016Iliturgi 4 - 0 Inter de Jaén CFInter Jaén 3
02 Nov 20 Los Villares CFVillares 3 - 1 Huelma CPHuelma CP ...
02 Nov 20 UDC Torredonjimeno BTorredonjim 1 - 1 Urgavona CFUrgavona ...
02 Nov 20 UD La GuardiaGuardia 3 - 1 Fuensanta CFFuensanta ...
02 Nov 20 Valdepeñas de Jaén CFValdepeñas 1 - 1 Mancha Real ADMancha Real ...
Ver jornada
Jornada 5
08 Nov 20 Recreativo BailénRecreativo 0 - 0 Iliturgi 2016Iliturgi 2
08 Nov 20 Inter de Jaén CFInter Jaén 0 - 0 Los Villares CFVillares ...
08 Nov 20 Huelma CPHuelma CP 1 - 1 UDC Torredonjimeno BTorredonjim ...
08 Nov 20 Urgavona CFUrgavona 1 - 3 UD La GuardiaGuardia ...
08 Nov 20 Fuensanta CFFuensanta 2 - 5 Valdepeñas de Jaén CFValdepeñas ...
Ver jornada
Jornada 6
15 Nov 20 Los Villares CFVillares 2 - 1 Recreativo BailénRecreativo ...
15 Nov 20 UDC Torredonjimeno BTorredonjim 0 - 3 Inter de Jaén CFInter Jaén ...
15 Nov 20 UD La GuardiaGuardia 1 - 3 Huelma CPHuelma CP ...
15 Nov 20 Valdepeñas de Jaén CFValdepeñas 2 - 2 Urgavona CFUrgavona ...
15 Nov 20 Mancha Real ADMancha Real 3 - 1 Fuensanta CFFuensanta ...
Ver jornada
Jornada 7
22 Nov 20 Iliturgi 2016Iliturgi 6 - 1 Los Villares CFVillares 3
22 Nov 20 Recreativo BailénRecreativo 5 - 1 UDC Torredonjimeno BTorredonjim ...
22 Nov 20 Inter de Jaén CFInter Jaén 1 - 0 UD La GuardiaGuardia ...
22 Nov 20 Huelma CPHuelma CP 1 - 1 Valdepeñas de Jaén CFValdepeñas ...
22 Nov 20 Urgavona CFUrgavona 1 - 0 Mancha Real ADMancha Real ...
Ver jornada
Jornada 8
29 Nov 20 UDC Torredonjimeno BTorredonjim 2 - 2 Iliturgi 2016Iliturgi 3
29 Nov 20 UD La GuardiaGuardia 1 - 1 Recreativo BailénRecreativo ...
29 Nov 20 Valdepeñas de Jaén CFValdepeñas 0 - 0 Inter de Jaén CFInter Jaén ...
29 Nov 20 Mancha Real ADMancha Real 4 - 2 Huelma CPHuelma CP ...
29 Nov 20 Fuensanta CFFuensanta 0 - 1 Urgavona CFUrgavona ...
Ver jornada
Jornada 9
06 Dic 20 Los Villares CFVillares 6 - 1 UDC Torredonjimeno BTorredonjim ...
06 Dic 20 Iliturgi 2016Iliturgi 3 - 0 UD La GuardiaGuardia 1
06 Dic 20 Recreativo BailénRecreativo 2 - 3 Valdepeñas de Jaén CFValdepeñas ...
06 Dic 20 Inter de Jaén CFInter Jaén 1 - 2 Mancha Real ADMancha Real ...
06 Dic 20 Huelma CPHuelma CP 3 - 3 Fuensanta CFFuensanta ...
Ver jornada
Jornada 10
13 Dic 20 UD La GuardiaGuardia 1 - 2 Los Villares CFVillares ...
13 Dic 20 Valdepeñas de Jaén CFValdepeñas 1 - 0 Iliturgi 2016Iliturgi ...
13 Dic 20 Mancha Real ADMancha Real 0 - 2 Recreativo BailénRecreativo ...
13 Dic 20 Fuensanta CFFuensanta 5 - 4 Inter de Jaén CFInter Jaén ...
13 Dic 20 Urgavona CFUrgavona 0 - 0 Huelma CPHuelma CP ...
Ver jornada
Jornada 11
20 Dic 20 UDC Torredonjimeno BTorredonjim 3 - 0 UD La GuardiaGuardia ...
20 Dic 20 Los Villares CFVillares 0 - 3 Valdepeñas de Jaén CFValdepeñas ...
20 Dic 20 Iliturgi 2016Iliturgi 2 - 0 Mancha Real ADMancha Real 2
20 Dic 20 Recreativo BailénRecreativo 1 - 1 Fuensanta CFFuensanta ...
20 Dic 20 Inter de Jaén CFInter Jaén 2 - 0 Urgavona CFUrgavona ...
Ver jornada
Jornada 12
10 Ene 21 Huelma CPHuelma CP 1 - 1 Inter de Jaén CFInter Jaén ...
10 Ene 21 Recreativo BailénRecreativo 2 - 1 Urgavona CFUrgavona ...
10 Ene 21 Iliturgi 2016Iliturgi 2 - 1 Fuensanta CFFuensanta 2
10 Ene 21 Los Villares CFVillares 0 - 0 Mancha Real ADMancha Real ...
10 Ene 21 UDC Torredonjimeno BTorredonjim 2 - 1 Valdepeñas de Jaén CFValdepeñas ...
Ver jornada
Jornada 13
26 Feb 21 Huelma CPHuelma CP 2 - 1 Recreativo BailénRecreativo ...
17 Ene 21 Urgavona CFUrgavona 0 - 4 Iliturgi 2016Iliturgi 1
29 Ene 21 Fuensanta CFFuensanta 3 - 4 Los Villares CFVillares ...
16 Ene 21 Mancha Real ADMancha Real 4 - 0 UDC Torredonjimeno BTorredonjim ...
28 Ene 21 Valdepeñas de Jaén CFValdepeñas 3 - 1 UD La GuardiaGuardia ...
Ver jornada
Jornada 14
24 Ene 21 Recreativo BailénRecreativo 0 - 0 Inter de Jaén CFInter Jaén ...
24 Ene 21 Iliturgi 2016Iliturgi 4 - 2 Huelma CPHuelma CP 3
24 Ene 21 Los Villares CFVillares 0 - 2 Urgavona CFUrgavona ...
24 Ene 21 UDC Torredonjimeno BTorredonjim 0 - 2 Fuensanta CFFuensanta ...
03 Feb 21 UD La GuardiaGuardia 1 - 3 Mancha Real ADMancha Real ...
Ver jornada
Jornada 15
31 Ene 21 Inter de Jaén CFInter Jaén 1 - 1 Iliturgi 2016Iliturgi 2
31 Ene 21 Huelma CPHuelma CP 3 - 2 Los Villares CFVillares ...
31 Ene 21 Urgavona CFUrgavona 3 - 1 UDC Torredonjimeno BTorredonjim ...
31 Ene 21 Fuensanta CFFuensanta 2 - 2 UD La GuardiaGuardia ...
31 Ene 21 Mancha Real ADMancha Real 0 - 1 Valdepeñas de Jaén CFValdepeñas ...
Ver jornada
Jornada 16
07 Feb 21 Iliturgi 2016Iliturgi 3 - 0 Recreativo BailénRecreativo 1
07 Feb 21 Los Villares CFVillares 0 - 1 Inter de Jaén CFInter Jaén ...
07 Feb 21 UDC Torredonjimeno BTorredonjim 2 - 1 Huelma CPHuelma CP ...
07 Feb 21 UD La GuardiaGuardia 1 - 3 Urgavona CFUrgavona ...
07 Feb 21 Valdepeñas de Jaén CFValdepeñas 1 - 1 Fuensanta CFFuensanta ...
Ver jornada
Jornada 17
14 Feb 21 Recreativo BailénRecreativo 3 - 0 Los Villares CFVillares ...
14 Feb 21 Inter de Jaén CFInter Jaén 2 - 1 UDC Torredonjimeno BTorredonjim ...
14 Feb 21 Huelma CPHuelma CP 3 - 1 UD La GuardiaGuardia ...
14 Feb 21 Urgavona CFUrgavona 0 - 1 Valdepeñas de Jaén CFValdepeñas ...
14 Feb 21 Fuensanta CFFuensanta 2 - 0 Mancha Real ADMancha Real ...
Ver jornada
Jornada 18
21 Feb 21 Los Villares CFVillares 0 - 1 Iliturgi 2016Iliturgi ...
21 Feb 21 UDC Torredonjimeno BTorredonjim 5 - 2 Recreativo BailénRecreativo ...
21 Feb 21 UD La GuardiaGuardia 1 - 0 Inter de Jaén CFInter Jaén ...
21 Feb 21 Valdepeñas de Jaén CFValdepeñas 2 - 0 Huelma CPHuelma CP ...
21 Feb 21 Mancha Real ADMancha Real 2 - 0 Urgavona CFUrgavona ...
Ver jornada
Jornada 19
28 Feb 21 Iliturgi 2016Iliturgi 4 - 0 UDC Torredonjimeno BTorredonjim 1
01 Mar 21 Recreativo BailénRecreativo 1 - 1 UD La GuardiaGuardia 2
28 Feb 21 Inter de Jaén CFInter Jaén 0 - 2 Valdepeñas de Jaén CFValdepeñas ...
01 Mar 21 Huelma CPHuelma CP 0 - 1 Mancha Real ADMancha Real ...
28 Feb 21 Urgavona CFUrgavona 2 - 1 Fuensanta CFFuensanta ...
Ver jornada
Jornada 20
07 Mar 21 UDC Torredonjimeno BTorredonjim 5 - 1 Los Villares CFVillares ...
07 Mar 21 UD La GuardiaGuardia 0 - 3 Iliturgi 2016Iliturgi 2
07 Mar 21 Valdepeñas de Jaén CFValdepeñas 2 - 1 Recreativo BailénRecreativo ...
07 Mar 21 Mancha Real ADMancha Real 2 - 3 Inter de Jaén CFInter Jaén ...
07 Mar 21 Fuensanta CFFuensanta 2 - 1 Huelma CPHuelma CP ...
Ver jornada
Jornada 21
14 Mar 21 Los Villares CFVillares 2 - 0 UD La GuardiaGuardia ...
14 Mar 21 Iliturgi 2016Iliturgi 2 - 1 Valdepeñas de Jaén CFValdepeñas 2
14 Mar 21 Recreativo BailénRecreativo 1 - 0 Mancha Real ADMancha Real ...
14 Mar 21 Inter de Jaén CFInter Jaén 1 - 1 Fuensanta CFFuensanta ...
14 Mar 21 Huelma CPHuelma CP 2 - 0 Urgavona CFUrgavona ...
Ver jornada
Jornada 22
21 Mar 21 UD La GuardiaGuardia 2 - 0 UDC Torredonjimeno BTorredonjim ...
21 Mar 21 Valdepeñas de Jaén CFValdepeñas 3 - 1 Los Villares CFVillares ...
21 Mar 21 Mancha Real ADMancha Real 1 - 0 Iliturgi 2016Iliturgi 1
21 Mar 21 Fuensanta CFFuensanta 2 - 1 Recreativo BailénRecreativo ...
21 Mar 21 Urgavona CFUrgavona 1 - 0 Inter de Jaén CFInter Jaén ...

Clasificación

Equipo PJ GF GC Puntos
1 Iliturgi 2016 Iliturgi 20 45 14 43
2 Valdepeñas de Jaén CF Valdepeñas 20 40 22 42
3 Mancha Real AD Mancha Real 20 29 20 33
4 Recreativo Bailén Recreativo 20 33 27 29
5 Inter de Jaén CF Inter Jaén 20 22 25 25
6 Urgavona CF Urgavona CF 20 22 29 25
7 Los Villares CF Villares 20 33 39 23
8 Fuensanta CF Fuensanta 20 33 41 23
9 UDC Torredonjimeno B Torredonjime 20 31 46 22
10 Huelma CP Huelma CP 20 26 34 21
11 UD La Guardia Guardia 20 22 39 16

  USO DE MEMORIA  
5,558,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3917
Total Execution Time  0.3938
  CADENA URL  
/andaluza2021/grupo13/calendario
  GET DATOS  
$_GET['/andaluza2021/grupo13/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0149  SELECT type FROM routes WHERE alias = 'andaluza2021'
0.0304  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'andaluza' AND (l.group_code = 13 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=13 DESC LIMIT 1
0.0154  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 = 59412 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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 = 59412 ORDER BY round ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 08:59:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-06 08:59:18' 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-05-06 08:59:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-06 08:59:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0163  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'andaluza' AND (l.group_code = 0 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=0 DESC LIMIT 1
0.0536  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 = 59412 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59412 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.0219  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 = 59412 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59412 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 = 59412 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 59412 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 `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 = 59412 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