4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
15 Sep 19 UD GuarromanGuarroman 3 - 0 Huesa UDHuesa UD ...
15 Sep 19 UD UbedaUD Ubeda 0 - 2 Beas De SeguraBeas Segura ...
15 Sep 19 CD Sierra Pozo AlconSierra Pozo 0 - 5 Canena AtleticoCanena ...
15 Sep 19 Jódar CFJódar CF 1 - 0 UD CazorlaUD Cazorla ...
15 Sep 19 At SabioteAt Sabiote 3 - 1 Orcera CFOrcera CF ...
15 Sep 19 Sierra Segura C.F.Sierra 1 - 3 CarolinenseCarolinense ...
Ver jornada
Jornada 2
22 Sep 19 Huesa UDHuesa UD 2 - 1 Sierra Segura C.F.Sierra ...
22 Sep 19 Beas De SeguraBeas Segura 1 - 2 UD GuarromanGuarroman ...
22 Sep 19 Canena AtleticoCanena 1 - 3 UD UbedaUD Ubeda ...
22 Sep 19 UD CazorlaUD Cazorla 3 - 2 CD Sierra Pozo AlconSierra Pozo ...
22 Sep 19 Orcera CFOrcera CF 1 - 2 Jódar CFJódar CF ...
22 Sep 19 CarolinenseCarolinense 0 - 2 At SabioteAt Sabiote ...
Ver jornada
Jornada 3
29 Sep 19 Huesa UDHuesa UD 4 - 2 Beas De SeguraBeas Segura ...
29 Sep 19 UD GuarromanGuarroman 0 - 4 Canena AtleticoCanena ...
29 Sep 19 UD UbedaUD Ubeda 0 - 4 UD CazorlaUD Cazorla ...
29 Sep 19 CD Sierra Pozo AlconSierra Pozo 3 - 3 Orcera CFOrcera CF ...
29 Sep 19 Jódar CFJódar CF 1 - 1 CarolinenseCarolinense ...
29 Sep 19 Sierra Segura C.F.Sierra 3 - 2 At SabioteAt Sabiote ...
Ver jornada
Jornada 4
06 Oct 19 Beas De SeguraBeas Segura 1 - 1 Sierra Segura C.F.Sierra ...
06 Oct 19 Canena AtleticoCanena 1 - 0 Huesa UDHuesa UD ...
06 Oct 19 UD CazorlaUD Cazorla 2 - 1 UD GuarromanGuarroman ...
06 Oct 19 Orcera CFOrcera CF 3 - 1 UD UbedaUD Ubeda ...
06 Oct 19 CarolinenseCarolinense 6 - 0 CD Sierra Pozo AlconSierra Pozo ...
06 Oct 19 At SabioteAt Sabiote 0 - 1 Jódar CFJódar CF ...
Ver jornada
Jornada 5
13 Oct 19 Beas De SeguraBeas Segura 2 - 0 Canena AtleticoCanena ...
13 Oct 19 Huesa UDHuesa UD 3 - 1 UD CazorlaUD Cazorla ...
13 Oct 19 UD GuarromanGuarroman 2 - 0 Orcera CFOrcera CF ...
13 Oct 19 UD UbedaUD Ubeda 2 - 2 CarolinenseCarolinense ...
13 Oct 19 CD Sierra Pozo AlconSierra Pozo 0 - 3 At SabioteAt Sabiote ...
13 Oct 19 Sierra Segura C.F.Sierra 2 - 0 Jódar CFJódar CF ...
Ver jornada
Jornada 6
20 Oct 19 Canena AtleticoCanena 2 - 1 Sierra Segura C.F.Sierra ...
20 Oct 19 UD CazorlaUD Cazorla 2 - 0 Beas De SeguraBeas Segura ...
20 Oct 19 Orcera CFOrcera CF 2 - 0 Huesa UDHuesa UD ...
19 Oct 19 CarolinenseCarolinense 4 - 1 UD GuarromanGuarroman ...
20 Oct 19 At SabioteAt Sabiote 2 - 2 UD UbedaUD Ubeda ...
20 Oct 19 Jódar CFJódar CF 4 - 0 CD Sierra Pozo AlconSierra Pozo ...
Ver jornada
Jornada 7
27 Oct 19 Canena AtleticoCanena 2 - 1 UD CazorlaUD Cazorla ...
27 Oct 19 Beas De SeguraBeas Segura 2 - 0 Orcera CFOrcera CF ...
27 Oct 19 Huesa UDHuesa UD 2 - 2 CarolinenseCarolinense ...
27 Oct 19 UD GuarromanGuarroman 1 - 0 At SabioteAt Sabiote ...
27 Oct 19 UD UbedaUD Ubeda 0 - 5 Jódar CFJódar CF ...
27 Oct 19 Sierra Segura C.F.Sierra 1 - 1 CD Sierra Pozo AlconSierra Pozo ...
Ver jornada
Jornada 8
03 Nov 19 UD CazorlaUD Cazorla 1 - 0 Sierra Segura C.F.Sierra ...
01 Nov 19 Orcera CFOrcera CF 2 - 0 Canena AtleticoCanena ...
03 Nov 19 CarolinenseCarolinense 0 - 0 Beas De SeguraBeas Segura ...
03 Nov 19 At SabioteAt Sabiote 3 - 1 Huesa UDHuesa UD ...
03 Nov 19 Jódar CFJódar CF 2 - 0 UD GuarromanGuarroman ...
03 Nov 19 CD Sierra Pozo AlconSierra Pozo 1 - 1 UD UbedaUD Ubeda ...
Ver jornada
Jornada 9
10 Nov 19 UD CazorlaUD Cazorla 4 - 2 Orcera CFOrcera CF ...
10 Nov 19 Canena AtleticoCanena 2 - 0 CarolinenseCarolinense ...
10 Nov 19 Beas De SeguraBeas Segura 3 - 2 At SabioteAt Sabiote ...
10 Nov 19 Huesa UDHuesa UD 1 - 1 Jódar CFJódar CF ...
10 Nov 19 UD GuarromanGuarroman 3 - 0 CD Sierra Pozo AlconSierra Pozo ...
10 Nov 19 Sierra Segura C.F.Sierra 7 - 2 UD UbedaUD Ubeda ...
Ver jornada
Jornada 10
17 Nov 19 Sierra Segura C.F.Sierra 2 - 1 Orcera CFOrcera CF ...
17 Nov 19 CarolinenseCarolinense 1 - 5 UD CazorlaUD Cazorla ...
17 Nov 19 At SabioteAt Sabiote 1 - 2 Canena AtleticoCanena ...
17 Nov 19 Jódar CFJódar CF 4 - 1 Beas De SeguraBeas Segura ...
17 Nov 19 CD Sierra Pozo AlconSierra Pozo 0 - 3 Huesa UDHuesa UD ...
17 Nov 19 UD UbedaUD Ubeda 1 - 6 UD GuarromanGuarroman ...
Ver jornada
Jornada 11
24 Nov 19 Orcera CFOrcera CF 2 - 1 CarolinenseCarolinense ...
24 Nov 19 UD CazorlaUD Cazorla 4 - 2 At SabioteAt Sabiote ...
24 Nov 19 Canena AtleticoCanena 0 - 0 Jódar CFJódar CF ...
24 Nov 19 Beas De SeguraBeas Segura 2 - 0 CD Sierra Pozo AlconSierra Pozo ...
24 Nov 19 Huesa UDHuesa UD 9 - 0 UD UbedaUD Ubeda ...
24 Nov 19 UD GuarromanGuarroman 1 - 1 Sierra Segura C.F.Sierra ...
Ver jornada
Jornada 12
01 Dic 19 Huesa UDHuesa UD 4 - 1 UD GuarromanGuarroman ...
01 Dic 19 Beas De SeguraBeas Segura 6 - 0 UD UbedaUD Ubeda ...
01 Dic 19 Canena AtleticoCanena 6 - 0 CD Sierra Pozo AlconSierra Pozo ...
01 Dic 19 UD CazorlaUD Cazorla 1 - 1 Jódar CFJódar CF ...
01 Dic 19 Orcera CFOrcera CF 2 - 4 At SabioteAt Sabiote ...
01 Dic 19 CarolinenseCarolinense 2 - 1 Sierra Segura C.F.Sierra ...
Ver jornada
Jornada 13
02 Feb 20 Sierra Segura C.F.Sierra 2 - 2 Huesa UDHuesa UD ...
02 Feb 20 UD GuarromanGuarroman 1 - 5 Beas De SeguraBeas Segura ...
02 Feb 20 UD UbedaUD Ubeda 0 - 3 Canena AtleticoCanena ...
02 Feb 20 CD Sierra Pozo AlconSierra Pozo Apl UD CazorlaUD Cazorla ...
02 Feb 20 Jódar CFJódar CF 3 - 1 Orcera CFOrcera CF ...
02 Feb 20 At SabioteAt Sabiote 2 - 1 CarolinenseCarolinense ...
Ver jornada
Jornada 14
09 Feb 20 Beas De SeguraBeas Segura 1 - 1 Huesa UDHuesa UD ...
09 Feb 20 Canena AtleticoCanena 4 - 0 UD GuarromanGuarroman ...
09 Feb 20 UD CazorlaUD Cazorla 2 - 0 UD UbedaUD Ubeda ...
09 Feb 20 Orcera CFOrcera CF Apl CD Sierra Pozo AlconSierra Pozo ...
09 Feb 20 CarolinenseCarolinense 1 - 0 Jódar CFJódar CF ...
09 Feb 20 At SabioteAt Sabiote 5 - 0 Sierra Segura C.F.Sierra ...
Ver jornada
Jornada 15
16 Feb 20 Sierra Segura C.F.Sierra 4 - 1 Beas De SeguraBeas Segura ...
16 Feb 20 Huesa UDHuesa UD 2 - 0 Canena AtleticoCanena ...
16 Feb 20 UD GuarromanGuarroman 1 - 3 UD CazorlaUD Cazorla ...
16 Feb 20 UD UbedaUD Ubeda 0 - 2 Orcera CFOrcera CF ...
16 Feb 20 CD Sierra Pozo AlconSierra Pozo Apl CarolinenseCarolinense ...
16 Feb 20 Jódar CFJódar CF 0 - 1 At SabioteAt Sabiote ...
Ver jornada
Jornada 16
23 Feb 20 Canena AtleticoCanena 3 - 0 Beas De SeguraBeas Segura ...
23 Feb 20 UD CazorlaUD Cazorla 2 - 0 Huesa UDHuesa UD ...
23 Feb 20 Orcera CFOrcera CF 1 - 0 UD GuarromanGuarroman ...
23 Feb 20 CarolinenseCarolinense 4 - 0 UD UbedaUD Ubeda ...
23 Feb 20 At SabioteAt Sabiote Apl CD Sierra Pozo AlconSierra Pozo ...
23 Feb 20 Jódar CFJódar CF 0 - 0 Sierra Segura C.F.Sierra ...
Ver jornada
Jornada 17
01 Mar 20 Sierra Segura C.F.Sierra 1 - 0 Canena AtleticoCanena ...
28 Feb 20 Beas De SeguraBeas Segura 2 - 1 UD CazorlaUD Cazorla ...
01 Mar 20 Huesa UDHuesa UD 3 - 2 Orcera CFOrcera CF ...
01 Mar 20 UD GuarromanGuarroman 2 - 2 CarolinenseCarolinense ...
01 Mar 20 UD UbedaUD Ubeda Apl At SabioteAt Sabiote ...
01 Mar 20 CD Sierra Pozo AlconSierra Pozo Apl Jódar CFJódar CF ...
Ver jornada
Jornada 18
08 Mar 20 UD CazorlaUD Cazorla 1 - 0 Canena AtleticoCanena ...
08 Mar 20 Orcera CFOrcera CF 2 - 3 Beas De SeguraBeas Segura ...
08 Mar 20 CarolinenseCarolinense 3 - 0 Huesa UDHuesa UD ...
08 Mar 20 At SabioteAt Sabiote 3 - 1 UD GuarromanGuarroman ...
08 Mar 20 Jódar CFJódar CF Apl UD UbedaUD Ubeda ...
08 Mar 20 CD Sierra Pozo AlconSierra Pozo Apl Sierra Segura C.F.Sierra ...
Ver jornada
Jornada 19
15 Mar 20 Sierra Segura C.F.Sierra Apl UD CazorlaUD Cazorla ...
15 Mar 20 Canena AtleticoCanena Apl Orcera CFOrcera CF ...
15 Mar 20 Beas De SeguraBeas Segura Apl CarolinenseCarolinense ...
15 Mar 20 Huesa UDHuesa UD Apl At SabioteAt Sabiote ...
15 Mar 20 UD GuarromanGuarroman Apl Jódar CFJódar CF ...
15 Mar 20 UD UbedaUD Ubeda Apl CD Sierra Pozo AlconSierra Pozo ...
Ver jornada
Jornada 20
22 Mar 20 Orcera CFOrcera CF Apl UD CazorlaUD Cazorla ...
22 Mar 20 CarolinenseCarolinense Apl Canena AtleticoCanena ...
22 Mar 20 At SabioteAt Sabiote Apl Beas De SeguraBeas Segura ...
22 Mar 20 Jódar CFJódar CF Apl Huesa UDHuesa UD ...
22 Mar 20 CD Sierra Pozo AlconSierra Pozo Apl UD GuarromanGuarroman ...
22 Mar 20 UD UbedaUD Ubeda Apl Sierra Segura C.F.Sierra ...
Ver jornada
Jornada 21
29 Mar 20 Orcera CFOrcera CF Apl Sierra Segura C.F.Sierra ...
29 Mar 20 UD CazorlaUD Cazorla Apl CarolinenseCarolinense ...
29 Mar 20 Canena AtleticoCanena Apl At SabioteAt Sabiote ...
29 Mar 20 Beas De SeguraBeas Segura Apl Jódar CFJódar CF ...
29 Mar 20 Huesa UDHuesa UD Apl CD Sierra Pozo AlconSierra Pozo ...
29 Mar 20 UD GuarromanGuarroman Apl UD UbedaUD Ubeda ...
Ver jornada
Jornada 22
05 Abr 20 CarolinenseCarolinense Apl Orcera CFOrcera CF ...
05 Abr 20 At SabioteAt Sabiote Apl UD CazorlaUD Cazorla ...
05 Abr 20 Jódar CFJódar CF Apl Canena AtleticoCanena ...
05 Abr 20 CD Sierra Pozo AlconSierra Pozo Apl Beas De SeguraBeas Segura ...
05 Abr 20 UD UbedaUD Ubeda Apl Huesa UDHuesa UD ...
05 Abr 20 Sierra Segura C.F.Sierra Apl UD GuarromanGuarroman ...

Clasificación

Equipo PJ GF GC Puntos
1 UD Cazorla UD Cazorla 17 37 18 40
2 Jódar CF Jódar CF 16 25 10 35
3 At Sabiote At Sabiote 16 35 22 34
4 Canena Atletico Canena 18 35 14 34
5 Huesa UD Huesa UD 18 37 27 34
6 Beas De Segura Beas Segura 18 34 27 33
7 Carolinense Carolinense 17 33 23 29
8 Sierra Segura C.F. Sierra 17 28 26 29
9 UD Guarroman Guarroman 18 26 37 26
10 Orcera CF Orcera CF 17 27 33 22
11 UD Ubeda UD Ubeda 16 12 59 6
12 CD Sierra Pozo Alcon Sierra Pozo 12 7 40 3

  USO DE MEMORIA  
5,543,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.0973
Total Execution Time  0.1003
  CADENA URL  
/segunda_andaluza_jaen2020/grupo2/calendario
  GET DATOS  
$_GET['/segunda_andaluza_jaen2020/grupo2/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_andaluza_jaen2020'
0.0040  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 = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=275 AND type_rel = 3
0.0020  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.0021  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.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=275 ORDER BY order_id ASC
0.0019  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 = 51358 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 51358 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 18:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 18:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 18:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 51358 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51358 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.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 51358 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51358 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 51358 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51358 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 51358 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC