4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Real Jaén B Real Jaén 26 60 26 54
2 CD Tugia CD Tugia 26 63 36 54
3 Baeza CF Baeza CF 26 53 28 50
4 UD La Guardia Guardia 26 51 33 46
5 Puertas Deyma Puertas 26 48 35 46
6 CD Linares B Linares 26 53 36 37
7 C.D. Rus C.D. Rus 26 41 34 36
8 Los Villares CF Villares 26 49 52 36
9 Vilches Vilches 26 60 54 35
10 Villargordo CF Villargordo 26 33 50 31
11 Castillo Locubín Castillo 26 40 67 28
12 Mogon CF Mogon CF 26 36 63 25
13 Veteranos Alcaudete Veteranos 26 45 64 22
14 Jódar CF Jódar CF 26 25 79 9
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Bailén Bailén 34 104 26 89
2 Jódar Al-Andalus Jódar 34 92 25 87
3 Iliturgi CF Iliturgi CF 34 92 27 76
4 Urgavona CF Urgavona CF 34 45 47 50
5 Alcalá Enjoy Sub 19 Alcalá 34 47 54 49
6 F.s.Valdepeñas F.s.Valdepe 34 52 45 47
7 Atlético Jaén Atlético 34 46 47 47
8 Torredonjimeno B Torredonjime 34 60 74 45
9 Vilches Vilches 34 58 67 43
10 CD Linares B Linares 34 47 47 41
11 Puertas Deyma Puertas 34 60 75 41
12 Club At Arjonilla Club 34 46 67 40
13 Real Jaén B Real Jaén 34 47 53 39
14 C.D. Rus C.D. Rus 34 33 47 39
15 Atletico Porcuna Atletico 34 42 67 39
16 Villargordo CF Villargordo 34 40 59 37
17 C.D. Útica C.D. Útica 34 42 81 28
18 Mengibar Mengibar 34 38 83 24
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Recreativo Bailén Recreativo 33 80 29 72
2 Jódar Al-Andalus Jódar 33 69 34 72
3 Club At Arjonilla Club 33 77 36 70
4 Iliturgi CF Iliturgi CF 33 54 26 69
5 CD Linares B Linares 34 60 25 63
6 Real Jaén B Real Jaén 33 69 32 57
7 F.s.Valdepeñas F.s.Valdepe 33 54 47 56
8 CD Villacarrillo Villacarrill 33 55 50 52
9 Urgavona CF Urgavona CF 34 49 46 46
10 Torredonjimeno B Torredonjime 33 51 57 36
11 P.Jienense P.Jienense 33 40 50 35
12 Puertas Deyma Puertas 33 44 62 34
13 Atlético Jaén Atlético 33 37 42 31
14 Vilches Vilches 33 43 67 31
15 Sierra Segura C.F. Sierra 33 43 95 24
16 Ubeda Deportivo Ubeda 33 34 96 21
17 CD Jabalquinto Jabalquinto 19 22 46 19
18 Veteranos Alcaudete Veteranos 33 35 76 16

  USO DE MEMORIA  
5,098,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.0764
Total Execution Time  0.0793
  CADENA URL  
/segunda_andaluza_jaen2005/grupo1/historico
  GET DATOS  
$_GET['/segunda_andaluza_jaen2005/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_andaluza_jaen2005'
0.0042  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 = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=275 ORDER BY order_id ASC
0.0020  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 275 GROUP BY l.categoryId
0.0021  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=275 GROUP BY l.year ORDER BY l.year DESC
0.0021  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 = 2946 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 275 AND group_code = 1 and tables = 1 AND year <= 2005 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 2946 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 2945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 2944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 05:56:45' 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=2 AND last_update > '2024-04-28 05:56:45' 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=4 AND last_update > '2024-04-28 05:56:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 05:56:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  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 = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0024  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 events2005 e ON e.player_id = p.id AND e.league_id = 2946 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2946 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.0025  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 events2005 e ON e.player_id = p.id AND e.league_id = 2946 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2946 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0023  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 events2005 e ON e.player_id = p.id AND e.league_id = 2946 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2946 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0054  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 2946 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC