4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Atlético Espeleño Atlético 32 68 30 70
2 C.D. El Higuerón - Especolc C.D. 32 73 37 67
3 Rud La Carlota Carlota 32 73 40 63
4 Salerm Pte.Genil Salerm 32 51 24 61
5 C.D. Alcázar B C.D. 32 53 35 60
6 Las Palmeras Ud Palmeras 32 69 48 55
7 Ciudad de Lucena Ciudad 32 67 47 46
8 Palma del Rio Atletico CF Palma 32 46 46 44
9 La Ribera Guadalq. Ribera 32 63 61 43
10 Hinojosa Hinojosa 32 50 54 43
11 Almodóvar del Río Almodóvar 32 54 60 43
12 CD Apedem B CD Apedem B 32 48 48 41
13 Don Bosco CF C Bosco 32 52 63 38
14 Belmezano Belmezano 32 40 53 37
15 Parque Cruz Conde Parque Cruz 32 45 70 27
16 Villa De Espejo CD Villa Espejo 32 32 90 20
17 La Rambla Fem Rambla 32 27 105 6
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 La Voz La Voz 36 72 43 77
2 Prasa Torrecampo Prasa 36 61 26 73
3 Ciudad Jardín Ciudad 36 75 34 70
4 Rud La Carlota Carlota 36 64 41 68
5 Atlético Espeleño Atlético 36 74 57 57
6 CD Apedem CD Apedem 36 49 49 56
7 Almodóvar del Río Almodóvar 36 58 52 55
8 Salerm Pte.Genil Salerm 36 56 46 53
9 Hinojosa Hinojosa 36 55 58 50
10 Las Palmeras Ud Palmeras 36 51 57 49
11 C.D. El Higuerón - Especolc C.D. 36 48 50 47
12 Palma del Rio Atletico CF Palma 36 43 51 47
13 Dielesur La Rambla Dielesur 36 47 57 46
14 Villa De Espejo CD Villa Espejo 36 43 42 43
15 CD Montalbeño Montalbeño 36 46 58 42
16 Priego Ind. Priego Ind. 36 51 68 39
17 UD Villanueva Rosario Villanueva 36 42 58 34
18 Egabrense Egabrense 36 53 87 31
19 Pozoalbense Pozoalbense 36 36 90 23
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Fc Aguilarense Aguilarense 34 82 27 75
2 Las Palmeras Ud Palmeras 34 91 57 69
3 Belmezano Belmezano 34 65 36 69
4 Dielesur La Rambla Dielesur 34 67 43 66
5 Pozoalbense Pozoalbense 34 75 51 58
6 Atlético Espeleño Atlético 33 75 47 56
7 Hinojosa Hinojosa 34 54 48 53
8 CD Apedem CD Apedem 34 63 55 50
9 Prasa Torrecampo Prasa 34 51 52 46
10 Rud La Carlota Carlota 34 52 55 45
11 Villa De Espejo CD Villa Espejo 34 65 62 44
12 UD Villanueva Rosario Villanueva 34 51 49 43
13 Palma del Rio Atletico CF Palma 34 38 54 43
14 Ciudad Jardín Ciudad 34 66 65 42
15 C.D. Alcázar B C.D. 34 52 52 39
16 Sur Sur 33 32 73 29
17 Benamejí Benamejí 33 24 91 14
18 Belalcázar Belalcázar 33 28 114 14
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Baena At. Baena At. 34 70 16 86
2 Egabrense Egabrense 34 82 32 69
3 Priego Ind. Priego Ind. 34 79 32 68
4 UD Villanueva Rosario Villanueva 34 61 34 65
5 Miralbaida Miralbaida 34 70 45 62
6 CD Apedem CD Apedem 34 46 41 50
7 Belmezano Belmezano 34 52 44 48
8 Sur Sur 34 52 58 48
9 Ciudad Jardín Ciudad 34 50 48 45
10 Atlético Espeleño Atlético 34 45 49 42
11 Dielesur La Rambla Dielesur 34 35 45 42
12 Palma del Rio Atletico CF Palma 34 49 73 42
13 Posadas Bpie. Posadas 34 49 59 40
14 Guadalquivir Guadalquivir 34 49 61 40
15 C.D. Alcázar B C.D. 34 28 53 34
16 Hinojosa Hinojosa 34 40 60 31
17 Benamejí Benamejí 34 42 71 27
18 Fray Albino-UCO Fray 34 28 106 10
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Fc Aguilarense Aguilarense 32 62 22 75
2 Peñarroya Pueblonuevo Peñarroya 32 82 22 69
3 Dielesur La Rambla Dielesur 32 70 32 61
4 Miralbaida Miralbaida 32 61 52 48
5 Hinojosa Hinojosa 32 55 52 47
6 Posadas Bpie. Posadas 32 56 54 47
7 Belmezano Belmezano 32 52 55 47
8 Atlético Espeleño Atlético 32 48 43 46
9 CD Apedem CD Apedem 32 43 40 45
10 Egabrense Egabrense 32 60 39 44
11 Guadalquivir Guadalquivir 32 51 61 39
12 Priego Ind. Priego Ind. 32 39 62 39
13 Victoria Cf Victoria Cf 32 38 74 33
14 Puente Genil Puente Genil 32 54 72 32
15 CD Castro Del Rio-Cajasol Castro 32 47 59 30
16 Villa De Espejo CD Villa Espejo 32 37 65 30
17 Almedinilla Atl Almedinilla 32 36 87 26
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 CD Montalbeño Montalbeño 30 94 35 75
2 Palma del Rio Atletico CF Palma 30 68 19 67
3 Dielesur La Rambla Dielesur 30 52 29 56
4 Hinojosa Hinojosa 30 59 40 55
5 Puente Genil Puente Genil 30 52 42 53
6 Belmezano Belmezano 30 51 39 51
7 CD Apedem CD Apedem 30 52 37 46
8 CD Castro Del Rio-Cajasol Castro 30 38 50 40
9 Fc Aguilarense Aguilarense 30 37 50 33
10 Atlético Espeleño Atlético 30 42 48 32
11 Miralbaida Miralbaida 30 40 53 31
12 Cdad. Córdoba Cdad. 30 39 56 29
13 Almedinilla Atl Almedinilla 30 36 67 29
14 El Carpio El Carpio 30 43 64 28
15 Séneca B Séneca B 30 41 60 27
16 Rute Calidad Rute Calidad 30 42 97 15
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 CD Pozoblanco Pozoblanco 34 96 12 87
2 Egabrense Egabrense 34 64 30 72
3 Baena At. Baena At. 34 57 25 67
4 UD Villanueva Rosario Villanueva 34 56 32 63
5 Posadas Bpie. Posadas 34 67 29 62
6 Fray Albino-UCO Fray 34 79 36 61
7 Priego Ind. Priego Ind. 34 61 47 58
8 Rute Calidad Rute Calidad 34 63 39 55
9 Peñarroya Pueblonuevo Peñarroya 34 75 65 49
10 CD Montalbeño Montalbeño 34 62 59 49
11 Palma del Rio Atletico CF Palma 34 49 46 44
12 CD Apedem CD Apedem 34 34 55 38
13 Dielesur La Rambla Dielesur 34 42 58 35
14 Séneca B Séneca B 34 34 68 28
15 CD Colonia Fuente Palmera Colonia 34 31 82 28
16 Hinojosa Hinojosa 34 38 74 25
17 Cerro Muriano Cf Cerro 34 42 107 25
18 Miralbaida Miralbaida 34 20 106 15
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Egabrense Egabrense 35 95 15 87
2 CD Pozoblanco Pozoblanco 35 90 21 79
3 Dielesur La Rambla Dielesur 35 59 36 66
4 Posadas Bpie. Posadas 35 52 42 59
5 Hinojosa Hinojosa 35 45 40 58
6 Peñarroya Pueblonuevo Peñarroya 35 75 52 56
7 Atl. Cordobes Atl. 35 46 31 52
8 Séneca B Séneca B 35 66 56 52
9 Universidad Cordoba Universidad 35 48 50 52
10 Miralbaida Miralbaida 35 47 61 47
11 Villa Del Rio CF Villa 35 51 46 46
12 Priego Ind. Priego Ind. 35 51 51 44
13 Rute Calidad Rute Calidad 35 49 39 42
14 CD Colonia Fuente Palmera Colonia 35 39 77 39
15 Palma del Rio Atletico CF Palma 35 42 63 37
16 Puente Genil Puente Genil 35 40 95 33
17 Virgen Del Valle AD Virgen Valle 35 30 89 20
18 Ciudad Jardín Ciudad 35 35 84 18
19 Fc Aguilarense Aguilarense 18 28 40 17

  USO DE MEMORIA  
5,928,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3944
Total Execution Time  0.3962
  CADENA URL  
/segunda_andaluza_cordoba2010/grupo1/historico
  GET DATOS  
$_GET['/segunda_andaluza_cordoba2010/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0125  SELECT type FROM routes WHERE alias = 'segunda_andaluza_cordoba2010'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_cordoba' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=278 ORDER BY order_id ASC
0.0126  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 = 2932 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 278 AND group_code = 1 and tables = 1 AND year <= 2010 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0129  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 `tables2010` 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 = 2932 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2009` 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 = 2931 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2008` 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 = 2930 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2007` 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 = 2929 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2006` 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 = 2928 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 2927 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 2926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 2925 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:11:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 18:11:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 18:11:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 18:11:42' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_andaluza_cordoba' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2010 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0128  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 events2010 e ON e.player_id = p.id AND e.league_id = 2932 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2932 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.0128  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 events2010 e ON e.player_id = p.id AND e.league_id = 2932 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2932 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 events2010 e ON e.player_id = p.id AND e.league_id = 2932 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2932 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 2932 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC