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

  USO DE MEMORIA  
6,352,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3088
Total Execution Time  0.3107
  CADENA URL  
/torneo_federal_b2007/grupo1/historico
  GET DATOS  
$_GET['/torneo_federal_b2007/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0125  SELECT type FROM routes WHERE alias = 'torneo_federal_b2007'
0.0255  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 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=1814 ORDER BY order_id ASC
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1814 AND group_code = 1 and tables = 1 AND year <= 2007 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0133  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 = 27943 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 05:46:49' 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=2 AND last_update > '2024-05-08 05:46:49' 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=4 AND last_update > '2024-05-08 05:46:49' 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=3 AND last_update > '2024-05-08 05:46:49' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  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 = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0129  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 events2007 e ON e.player_id = p.id AND e.league_id = 27943 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27943 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.0129  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 events2007 e ON e.player_id = p.id AND e.league_id = 27943 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27943 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0132  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 events2007 e ON e.player_id = p.id AND e.league_id = 27943 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27943 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0305  SELECT *,(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 = 27943 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC