4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Central Córdoba Central 6 9 4 14
2 Crucero del Norte Crucero 6 9 6 13
3 Central Norte Central 6 6 9 4
4 Guaraní A. Franco Guaraní 6 3 8 2
5 Patronato Patronato 6 13 3 13
6 Douglas Haig Douglas Haig 6 9 9 8
7 Atenas Pocito Atenas 6 6 9 8
8 La Emilia La Emilia 6 5 12 4
9 Sportivo Belgrano Sportivo 6 8 6 11
10 Dep. Maipú Dep. Maipú 6 6 5 9
11 El Linqueño Linqueño 6 6 4 8
12 Dep. Roca Dep. Roca 6 4 9 4
13 Alvarado Alvarado 6 13 3 13
14 Deportivo Madryn Deportivo 6 9 6 8
15 Racing Olavarría Racing 6 6 10 7
16 Bella Vista Bahia Blanca Bella Vista 6 7 16 5
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Racing Olavarría Racing 14 30 17 33
2 Dep. Maipú Dep. Maipú 14 20 11 30
3 Cipolletti Cipolletti 13 30 13 28
4 Racing Trelew Racing 14 25 17 27
5 Boca Unidos Boca Unidos 14 28 14 26
6 Sportivo Belgrano Sportivo 14 28 13 25
7 Sportivo Las Parejas Sportivo 14 33 25 24
8 Libertad Sunchales Libertad 14 19 13 24
9 Sportivo 9 de Julio Sportivo 14 17 9 23
10 Central Córdoba Central 14 19 19 23
11 JU Gualeguaychu Gualeguaychu 14 23 24 23
12 9 de Julio Morteros Julio 14 23 14 22
13 Crucero del Norte Crucero 13 29 21 22
14 Concepción FC Concepción 14 17 17 22
15 La Emilia La Emilia 14 24 16 21
16 Villa del Parque Villa Parque 14 28 23 21
17 Independiente Neuquén Independient 14 24 20 21
18 Sol de América Formosa América 14 19 19 21
19 Bella Vista Bahia Blanca Bella Vista 13 23 19 20
20 Alvarado Alvarado 13 18 16 20
21 Ñuñorco Ñuñorco 14 20 22 20
22 Guaymallén Guaymallén 14 15 12 19
23 Guaraní A. Franco Guaraní 14 24 24 19
24 Estudiantes Río Cuarto Estudiantes 14 16 19 19
25 Grupo Universitario de Tand Grupo 13 24 19 18
26 General Paz Juniors General 14 18 15 18
27 Juventud Alianza Juventud 14 15 16 18
28 Sarm. Resistencia Sarm. 13 14 15 18
29 Deportivo Madryn Deportivo 14 20 26 18
30 Cruz del Sur Cruz 13 17 15 17
31 Chaco For Ever Chaco Ever 13 18 18 17
32 El Linqueño Linqueño 14 18 19 17
33 Patronato Patronato 13 17 19 17
34 Gimnasia y Esgrima de Santa Gimnasia 14 17 31 16
35 Huracán de Comodoro Huracán 14 19 22 14
36 Independiente La Rioja Independient 14 16 20 14
37 Atlético Policial Atlético 14 19 28 14
38 Sporting Punta Alta Sporting 14 15 24 14
39 Textil Mandiyú Textil 13 14 22 13
40 Trinidad San Juan Trinidad 14 15 20 12
41 Gimnasia y Tiro Gimnasia 14 16 25 12
42 Dep. Roca Dep. Roca 14 9 23 12
43 Cadetes de San Martin Cadetes 12 21 25 11
44 Atlético Uruguay Atlético 13 16 20 11
45 Alianza Cutral Có Alianza 14 11 19 11
46 Candelaria Candelaria 14 17 30 8
47 AD Centenario Centenario 14 11 25 8
48 CD Coreano CD Coreano 13 14 30 7

  USO DE MEMORIA  
5,274,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2556
Total Execution Time  0.2575
  CADENA URL  
/torneo_federal_b2008/grupo2/historico
  GET DATOS  
$_GET['/torneo_federal_b2008/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0105  SELECT type FROM routes WHERE alias = 'torneo_federal_b2008'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_b' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0107  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 = 27964 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1814 AND group_code = 2 and tables = 1 AND year <= 2008 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 27964 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 27944 AND t.round = 14 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 16:04:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 16:04:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 16:04:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 16:04:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'torneo_federal_b' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0106  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 events2008 e ON e.player_id = p.id AND e.league_id = 27964 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27964 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.0106  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 events2008 e ON e.player_id = p.id AND e.league_id = 27964 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27964 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  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 events2008 e ON e.player_id = p.id AND e.league_id = 27964 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27964 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0118  SELECT *,(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 = 27964 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC