Jornada 1
19 Sep 21 Castillo de LocubinCastillo 5 - 1 UD CambilUD Cambil ...
19 Sep 21 Atlético MengibarAtlético 2 - 0 UD La GuardiaGuardia ...
19 Sep 21 CD UticaCD Utica 1 - 2 CD HispaniaHispania ...
19 Sep 21 AD LoperaAD Lopera 0 - 4 UDC Torredonjimeno BTorredonjim ...
19 Sep 21 Atlético JaénAtlético 1 - 1 Club At ArjonillaClub ...
19 Sep 21 Martos UniónMartos 0 - 2 Villargordo CFVillargordo ...
Jornada 2
26 Sep 21 UD La GuardiaGuardia 4 - 1 Castillo de LocubinCastillo ...
26 Sep 21 CD HispaniaHispania 1 - 0 Atlético MengibarAtlético ...
26 Sep 21 UDC Torredonjimeno BTorredonjim 4 - 1 CD UticaCD Utica ...
26 Sep 21 Club At ArjonillaClub 2 - 1 AD LoperaAD Lopera ...
26 Sep 21 Villargordo CFVillargordo 1 - 1 Atlético JaénAtlético ...
26 Sep 21 Veteranos AlcaudeteVeteranos 2 - 0 Martos UniónMartos ...
Jornada 3
03 Oct 21 UD CambilUD Cambil 2 - 3 UD La GuardiaGuardia ...
03 Oct 21 Castillo de LocubinCastillo 1 - 3 CD HispaniaHispania ...
03 Oct 21 Atlético MengibarAtlético 2 - 2 UDC Torredonjimeno BTorredonjim ...
03 Oct 21 CD UticaCD Utica 0 - 1 Club At ArjonillaClub ...
03 Oct 21 AD LoperaAD Lopera 6 - 0 Villargordo CFVillargordo ...
03 Oct 21 Atlético JaénAtlético 1 - 0 Veteranos AlcaudeteVeteranos ...
Jornada 4
10 Oct 21 CD HispaniaHispania 2 - 0 UD CambilUD Cambil ...
10 Oct 21 UDC Torredonjimeno BTorredonjim 10 - 1 Castillo de LocubinCastillo ...
10 Oct 21 Club At ArjonillaClub 1 - 0 Atlético MengibarAtlético ...
10 Oct 21 Villargordo CFVillargordo 3 - 2 CD UticaCD Utica ...
10 Oct 21 Veteranos AlcaudeteVeteranos 0 - 2 AD LoperaAD Lopera ...
10 Oct 21 Martos UniónMartos 1 - 3 Atlético JaénAtlético ...
Jornada 5
17 Oct 21 UD La GuardiaGuardia 2 - 2 CD HispaniaHispania ...
17 Oct 21 UD CambilUD Cambil 2 - 6 UDC Torredonjimeno BTorredonjim ...
17 Oct 21 Castillo de LocubinCastillo 4 - 2 Club At ArjonillaClub ...
17 Oct 21 Atlético MengibarAtlético 0 - 1 Villargordo CFVillargordo ...
17 Oct 21 CD UticaCD Utica 1 - 1 Veteranos AlcaudeteVeteranos ...
17 Oct 21 AD LoperaAD Lopera 5 - 0 Martos UniónMartos ...
Jornada 6
23 Oct 21 UDC Torredonjimeno BTorredonjim 3 - 0 UD La GuardiaGuardia ...
24 Oct 21 Club At ArjonillaClub 2 - 1 UD CambilUD Cambil ...
24 Oct 21 Villargordo CFVillargordo 1 - 1 Castillo de LocubinCastillo ...
24 Oct 21 Veteranos AlcaudeteVeteranos 1 - 4 Atlético MengibarAtlético ...
23 Oct 21 Martos UniónMartos 1 - 1 CD UticaCD Utica ...
24 Oct 21 Atlético JaénAtlético 2 - 1 AD LoperaAD Lopera ...
Jornada 7
31 Oct 21 CD HispaniaHispania 0 - 0 UDC Torredonjimeno BTorredonjim 1
30 Oct 21 UD La GuardiaGuardia 3 - 2 Club At ArjonillaClub ...
31 Oct 21 UD CambilUD Cambil 3 - 2 Villargordo CFVillargordo ...
31 Oct 21 Castillo de LocubinCastillo 2 - 2 Veteranos AlcaudeteVeteranos ...
31 Oct 21 Atlético MengibarAtlético 2 - 1 Martos UniónMartos ...
01 Nov 21 CD UticaCD Utica 0 - 3 Atlético JaénAtlético ...
Jornada 8
07 Nov 21 Club At ArjonillaClub 0 - 2 CD HispaniaHispania ...
07 Nov 21 Villargordo CFVillargordo 0 - 1 UD La GuardiaGuardia ...
07 Nov 21 Veteranos AlcaudeteVeteranos 1 - 2 UD CambilUD Cambil ...
07 Nov 21 Martos UniónMartos 0 - 3 Castillo de LocubinCastillo ...
07 Nov 21 Atlético JaénAtlético 3 - 0 Atlético MengibarAtlético ...
07 Nov 21 AD LoperaAD Lopera 3 - 1 CD UticaCD Utica ...
Jornada 9
13 Nov 21 UDC Torredonjimeno BTorredonjim 3 - 1 Club At ArjonillaClub ...
13 Nov 21 CD HispaniaHispania 1 - 0 Villargordo CFVillargordo ...
14 Nov 21 UD La GuardiaGuardia 4 - 1 Veteranos AlcaudeteVeteranos ...
14 Nov 21 UD CambilUD Cambil 5 - 3 Martos UniónMartos ...
14 Nov 21 Castillo de LocubinCastillo 2 - 2 Atlético JaénAtlético ...
14 Nov 21 Atlético MengibarAtlético 4 - 0 AD LoperaAD Lopera ...
Jornada 10
21 Nov 21 Villargordo CFVillargordo 0 - 1 UDC Torredonjimeno BTorredonjim ...
21 Nov 21 Veteranos AlcaudeteVeteranos 2 - 7 CD HispaniaHispania ...
21 Nov 21 Martos UniónMartos 0 - 4 UD La GuardiaGuardia ...
21 Nov 21 Atlético JaénAtlético 1 - 2 UD CambilUD Cambil ...
21 Nov 21 AD LoperaAD Lopera 3 - 3 Castillo de LocubinCastillo ...
21 Nov 21 CD UticaCD Utica 1 - 0 Atlético MengibarAtlético 1
Jornada 11
28 Nov 21 Club At ArjonillaClub 2 - 1 Villargordo CFVillargordo ...
27 Nov 21 UDC Torredonjimeno BTorredonjim 5 - 0 Veteranos AlcaudeteVeteranos ...
28 Nov 21 CD HispaniaHispania 2 - 0 Martos UniónMartos ...
28 Nov 21 UD La GuardiaGuardia 1 - 1 Atlético JaénAtlético ...
28 Nov 21 UD CambilUD Cambil 2 - 3 AD LoperaAD Lopera ...
28 Nov 21 Castillo de LocubinCastillo 2 - 2 CD UticaCD Utica ...
Jornada 12
12 Dic 21 Veteranos AlcaudeteVeteranos 1 - 2 Club At ArjonillaClub ...
12 Dic 21 Martos UniónMartos 1 - 6 UDC Torredonjimeno BTorredonjim 1
12 Dic 21 Atlético JaénAtlético 0 - 2 CD HispaniaHispania ...
12 Dic 21 AD LoperaAD Lopera 0 - 3 UD La GuardiaGuardia ...
12 Dic 21 UD CambilUD Cambil 4 - 3 CD UticaCD Utica ...
12 Dic 21 Atlético MengibarAtlético 4 - 2 Castillo de LocubinCastillo ...
Jornada 13
19 Dic 21 Villargordo CFVillargordo 3 - 1 Veteranos AlcaudeteVeteranos ...
19 Dic 21 Club At ArjonillaClub 2 - 0 Martos UniónMartos ...
19 Dic 21 UDC Torredonjimeno BTorredonjim 2 - 0 Atlético JaénAtlético ...
19 Dic 21 CD HispaniaHispania 1 - 1 AD LoperaAD Lopera ...
19 Dic 21 UD La GuardiaGuardia 2 - 1 CD UticaCD Utica ...
19 Ene 22 UD CambilUD Cambil 3 - 6 Atlético MengibarAtlético ...
Jornada 14
28 Ene 22 UD CambilUD Cambil 2 - 2 Castillo de LocubinCastillo ...
09 Ene 22 UD La GuardiaGuardia 3 - 1 Atlético MengibarAtlético ...
09 Ene 22 CD HispaniaHispania 2 - 2 CD UticaCD Utica ...
26 Ene 22 UDC Torredonjimeno BTorredonjim 3 - 1 AD LoperaAD Lopera ...
26 Ene 22 Club At ArjonillaClub 0 - 1 Atlético JaénAtlético ...
09 Ene 22 Villargordo CFVillargordo 1 - 0 Martos UniónMartos ...
Jornada 15
15 Ene 22 Castillo de LocubinCastillo 1 - 2 UD La GuardiaGuardia ...
26 Ene 22 Atlético MengibarAtlético 1 - 1 CD HispaniaHispania ...
16 Ene 22 CD UticaCD Utica 0 - 6 UDC Torredonjimeno BTorredonjim ...
16 Ene 22 AD LoperaAD Lopera 2 - 0 Club At ArjonillaClub ...
16 Ene 22 Atlético JaénAtlético 2 - 1 Villargordo CFVillargordo ...
03 Feb 22 Martos UniónMartos 2 - 1 Veteranos AlcaudeteVeteranos ...
Jornada 16
23 Ene 22 UD La GuardiaGuardia 4 - 2 UD CambilUD Cambil ...
23 Ene 22 CD HispaniaHispania 6 - 0 Castillo de LocubinCastillo ...
23 Ene 22 UDC Torredonjimeno BTorredonjim 3 - 1 Atlético MengibarAtlético ...
23 Ene 22 Club At ArjonillaClub 3 - 2 CD UticaCD Utica ...
23 Ene 22 Villargordo CFVillargordo 5 - 0 AD LoperaAD Lopera ...
23 Ene 22 Veteranos AlcaudeteVeteranos 0 - 4 Atlético JaénAtlético 1
Jornada 17
30 Ene 22 UD CambilUD Cambil 1 - 2 CD HispaniaHispania ...
30 Ene 22 Castillo de LocubinCastillo 0 - 2 UDC Torredonjimeno BTorredonjim ...
30 Ene 22 Atlético MengibarAtlético 1 - 1 Club At ArjonillaClub ...
30 Ene 22 CD UticaCD Utica 0 - 4 Villargordo CFVillargordo ...
30 Ene 22 AD LoperaAD Lopera 5 - 1 Veteranos AlcaudeteVeteranos ...
30 Ene 22 Atlético JaénAtlético 6 - 0 Martos UniónMartos ...
Jornada 18
06 Feb 22 CD HispaniaHispania 2 - 1 UD La GuardiaGuardia ...
05 Feb 22 UDC Torredonjimeno BTorredonjim 7 - 1 UD CambilUD Cambil ...
06 Feb 22 Club At ArjonillaClub 1 - 0 Castillo de LocubinCastillo ...
06 Feb 22 Villargordo CFVillargordo 0 - 3 Atlético MengibarAtlético ...
06 Feb 22 Veteranos AlcaudeteVeteranos 3 - 3 CD UticaCD Utica ...
06 Feb 22 Martos UniónMartos 0 - 3 AD LoperaAD Lopera ...
Jornada 19
13 Feb 22 UD La GuardiaGuardia 2 - 0 UDC Torredonjimeno BTorredonjim ...
13 Feb 22 UD CambilUD Cambil 4 - 5 Club At ArjonillaClub ...
13 Feb 22 Castillo de LocubinCastillo 0 - 1 Villargordo CFVillargordo ...
13 Feb 22 Atlético MengibarAtlético 2 - 0 Veteranos AlcaudeteVeteranos ...
13 Feb 22 CD UticaCD Utica 2 - 2 Martos UniónMartos ...
13 Feb 22 AD LoperaAD Lopera 0 - 0 Atlético JaénAtlético ...
Jornada 20
20 Feb 22 UDC Torredonjimeno BTorredonjim 1 - 0 CD HispaniaHispania ...
20 Feb 22 Club At ArjonillaClub 0 - 1 UD La GuardiaGuardia ...
20 Feb 22 Villargordo CFVillargordo 2 - 1 UD CambilUD Cambil ...
20 Feb 22 Veteranos AlcaudeteVeteranos 0 - 3 Castillo de LocubinCastillo ...
20 Feb 22 Martos UniónMartos 0 - 3 Atlético MengibarAtlético ...
20 Feb 22 Atlético JaénAtlético 2 - 2 CD UticaCD Utica ...
Jornada 21
25 Feb 22 CD HispaniaHispania 3 - 1 Club At ArjonillaClub ...
27 Feb 22 UD La GuardiaGuardia 2 - 1 Villargordo CFVillargordo 2
28 Feb 22 UD CambilUD Cambil 5 - 2 Veteranos AlcaudeteVeteranos ...
27 Feb 22 Castillo de LocubinCastillo 1 - 2 Martos UniónMartos ...
24 Feb 22 Atlético MengibarAtlético 3 - 2 Atlético JaénAtlético ...
27 Feb 22 CD UticaCD Utica Apl AD LoperaAD Lopera ...
Jornada 22
06 Mar 22 Club At ArjonillaClub 1 - 1 UDC Torredonjimeno BTorredonjim ...
06 Mar 22 Villargordo CFVillargordo 3 - 2 CD HispaniaHispania ...
06 Mar 22 Veteranos AlcaudeteVeteranos 0 - 4 UD La GuardiaGuardia ...
06 Mar 22 Martos UniónMartos 1 - 5 UD CambilUD Cambil ...
06 Mar 22 Atlético JaénAtlético 0 - 0 Castillo de LocubinCastillo ...
06 Mar 22 AD LoperaAD Lopera 3 - 4 Atlético MengibarAtlético ...
Jornada 23
13 Mar 22 UDC Torredonjimeno BTorredonjim 4 - 1 Villargordo CFVillargordo ...
13 Mar 22 CD HispaniaHispania 2 - 0 Veteranos AlcaudeteVeteranos ...
13 Mar 22 UD La GuardiaGuardia 5 - 1 Martos UniónMartos ...
13 Mar 22 UD CambilUD Cambil 1 - 4 Atlético JaénAtlético ...
13 Mar 22 Castillo de LocubinCastillo 0 - 2 AD LoperaAD Lopera ...
13 Mar 22 Atlético MengibarAtlético 5 - 2 CD UticaCD Utica ...
Jornada 24
20 Mar 22 Villargordo CFVillargordo 1 - 4 Club At ArjonillaClub ...
18 Mar 22 Veteranos AlcaudeteVeteranos 0 - 4 UDC Torredonjimeno BTorredonjim ...
20 Mar 22 Martos UniónMartos 0 - 2 CD HispaniaHispania ...
20 Mar 22 Atlético JaénAtlético 0 - 0 UD La GuardiaGuardia ...
20 Mar 22 AD LoperaAD Lopera 6 - 1 UD CambilUD Cambil ...
19 Mar 22 CD UticaCD Utica 2 - 0 Castillo de LocubinCastillo ...
Jornada 25
27 Mar 22 Club At ArjonillaClub 3 - 1 Veteranos AlcaudeteVeteranos ...
27 Mar 22 UDC Torredonjimeno BTorredonjim 9 - 2 Martos UniónMartos ...
27 Mar 22 CD HispaniaHispania 0 - 1 Atlético JaénAtlético ...
27 Mar 22 UD La GuardiaGuardia 0 - 0 AD LoperaAD Lopera ...
27 Mar 22 CD UticaCD Utica 2 - 0 UD CambilUD Cambil ...
27 Mar 22 Castillo de LocubinCastillo 1 - 1 Atlético MengibarAtlético ...
Jornada 26
03 Abr 22 Veteranos AlcaudeteVeteranos 2 - 4 Villargordo CFVillargordo ...
03 Abr 22 Martos UniónMartos Apl Club At ArjonillaClub ...
03 Abr 22 Atlético JaénAtlético 2 - 1 UDC Torredonjimeno BTorredonjim ...
03 Abr 22 AD LoperaAD Lopera 1 - 1 CD HispaniaHispania ...
03 Abr 22 CD UticaCD Utica 2 - 7 UD La GuardiaGuardia ...
03 Abr 22 Atlético MengibarAtlético 4 - 1 UD CambilUD Cambil ...
Clasificación
Equipo PJ GF GC Puntos
1 UDC Torredonjimeno B Torredonjime 24 87 19 60
2 UD La Guardia Guardia 24 58 25 55
3 CD Hispania CD Hispania 24 48 19 51
4 Atlético Jaén Atlético 24 42 21 44
5 Atlético Mengibar Atlético 24 53 33 43
6 Club At Arjonilla Club 23 37 34 39
7 AD Lopera AD Lopera 23 48 37 35
8 Villargordo CF Villargordo 24 38 39 35
9 UD Cambil UD Cambil 24 51 78 22
10 Castillo de Locubin Castillo 24 35 55 20
11 CD Utica CD Utica 23 33 60 16
12 Martos Unión Martos 23 17 75 8
13 Veteranos Alcaudete Veteranos 24 22 74 6
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,815,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1481
Total Execution Time  0.1501
  CADENA URL  
/segunda_andaluza_jaen2022/grupo1/calendario
  GET DATOS  
$_GET['/segunda_andaluza_jaen2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0034  SELECT type FROM routes WHERE alias = 'segunda_andaluza_jaen2022'
0.0072  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_jaen' 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.0034  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=275 AND type_rel = 3
0.0039  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 275 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0043  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 (303358,186954,169056,40171) ORDER BY n.cover_points DESC, update_date DESC
0.0036  SELECT id,name,alias,stepParent FROM categories WHERE parentId=275 ORDER BY order_id ASC
0.0037  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 = 64175 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0072  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 = 64175 ORDER BY round ASC
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 13:23:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 13:23:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 13:23:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 13:23:08' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_jaen' 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.0036  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 = 64175 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64175 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.0036  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 = 64175 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64175 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0036  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 = 64175 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 64175 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  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 = 64175 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