4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Algeciras CF Algeciras 34 64 30 69
2 Conil Conil 34 64 39 69
3 Arcos CF Arcos CF 34 70 32 67
4 CD Rota CD Rota 34 55 48 54
5 Punta Umbria Punta Umbria 34 40 42 53
6 Roteña Roteña 34 59 48 50
7 La Palma La Palma 34 49 44 49
8 Xerez B Xerez B 34 47 45 47
9 Atl. Cortegana Atl. 34 46 48 42
10 San Roque de Lepe B Roque Lepe 34 31 42 41
11 Balón de Cádiz CF Balón 34 36 41 40
12 Isla Cristina Isla 34 34 41 39
13 Ol. Valverdeña Valverdeña 34 37 55 39
14 San Fernando CD Fernando 34 41 49 38
15 Atlético Tharsis Atlético 34 36 50 38
16 Ud Bornense Ud Bornense 34 45 60 32
17 Tesorillo Tesorillo 34 39 56 31
18 Chiclana Industrial Chiclana 34 24 47 31
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Atlético Onubense Atlético 34 75 19 75
2 Chiclana CF Chiclana CF 34 57 28 68
3 Tesorillo Tesorillo 34 67 38 66
4 Conil Conil 34 65 43 66
5 Punta Umbria Punta Umbria 34 52 32 64
6 La Palma La Palma 34 45 38 56
7 Ol. Valverdeña Valverdeña 34 37 31 53
8 CD Rota CD Rota 34 39 44 43
9 At. Cortegana Cortegana 34 40 48 43
10 Atlético Tharsis Atlético 34 40 48 42
11 San Fernando CD Fernando 34 63 54 40
12 Los Cortijillos Cortijillos 34 37 55 38
13 Roteña Roteña 34 43 61 37
14 Chiclana Industrial Chiclana 34 45 66 37
15 Atlético Cruceño Atlético 34 36 51 36
16 Barbate Barbate 34 36 65 31
17 Pastores Pastores 34 40 73 28
18 Chipiona CF Chipiona CF 34 31 54 26
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 AD Cartaya AD Cartaya 30 64 21 69
2 San Roque de Lepe Roque Lepe 30 60 17 64
3 Punta Umbria Punta Umbria 30 57 33 63
4 Tesorillo Tesorillo 30 64 38 52
5 Atlético Onubense Atlético 30 63 41 52
6 La Palma La Palma 30 43 37 46
7 Roteña Roteña 30 36 28 36
8 Barbate Barbate 30 45 41 36
9 Los Cortijillos Cortijillos 30 39 42 36
10 Conil Conil 30 33 38 36
11 Chiclana Industrial Chiclana 30 24 45 35
12 Algeciras CF B Algeciras 30 37 55 34
13 At. Cortegana Cortegana 30 39 59 33
14 Bollullos CF Bollullos 30 29 46 29
15 Ubrique Ind. Ubrique Ind. 30 25 51 26
16 Hinojos Hinojos 30 25 91 9

  USO DE MEMORIA  
5,251,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.2711
Total Execution Time  0.2741
  CADENA URL  
/andaluza2009/grupo1/historico
  GET DATOS  
$_GET['/andaluza2009/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0111  SELECT type FROM routes WHERE alias = 'andaluza2009'
0.0216  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0108  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 = 323 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 5 AND group_code = 1 and tables = 1 AND year <= 2009 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0118  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 = 323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 = 114 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 115 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 01:21:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 01:21:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 01:21:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 01:21:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0113  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 = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0109  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 events2009 e ON e.player_id = p.id AND e.league_id = 323 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 323 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.0109  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 events2009 e ON e.player_id = p.id AND e.league_id = 323 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 323 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0108  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 events2009 e ON e.player_id = p.id AND e.league_id = 323 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 323 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0122  SELECT *,(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 = 323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC