4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 CD Olmedo CD Olmedo 44 76 43 92
2 Mushuc Runa Mushuc Runa 44 52 44 81
3 Imbabura Imbabura 44 63 47 74
4 Aucas Aucas 44 69 53 69
5 Guayaquil City Guayaquil 44 57 43 68
6 Técnico Universitario Técnico 44 60 53 65
7 Municipal Canar Municipal 44 48 60 56
8 Espoli Espoli 44 44 55 49
9 UT Cotopaxi UT Cotopaxi 44 48 57 48
10 Deportivo Azogues Deportivo 44 49 70 46
11 Grecia Grecia 44 44 64 45
12 Ferroviarios Ferroviarios 44 47 68 37
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Universidad Católica Universidad 22 41 21 39
2 Deportivo Azogues Deportivo 22 26 17 37
3 Ferroviarios Ferroviarios 22 29 27 35
4 Deportivo Quevedo Deportivo 22 24 22 31
5 Espoli Espoli 22 35 25 30
6 Guayaquil City Guayaquil 22 22 20 30
7 Rocafuerte Rocafuerte 22 23 22 29
8 UT Cotopaxi UT Cotopaxi 22 21 30 29
9 Grecia Grecia 22 24 36 26
10 Imbabura Imbabura 22 26 33 24
11 Mushuc Runa Mushuc Runa 22 19 33 23
12 Valle del Chota Valle Chota 22 28 32 22
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Técnico Universitario Técnico 44 71 32 90
2 Macará Macará 44 77 42 79
3 Universidad Católica Universidad 44 74 47 78
4 Guayaquil City Guayaquil 44 72 48 63
5 Rocafuerte Rocafuerte 44 52 47 59
6 Valle del Chota Valle Chota 44 61 61 56
7 Deportivo Quevedo Deportivo 44 61 69 55
8 Deportivo Azogues Deportivo 44 54 69 53
9 UT Cotopaxi UT Cotopaxi 44 52 68 51
10 Grecia Grecia 44 42 72 51
11 LDU de Portoviejo Portoviejo 44 50 73 47
12 Atlético Audaz Atlético 44 51 89 41
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Imbabura Imbabura 22 41 22 45
2 LDU Loja LDU Loja 22 37 23 43
3 Rocafuerte Rocafuerte 22 33 25 39
4 Atlético Audaz Atlético 22 34 35 33
5 Técnico Universitario Técnico 22 37 37 32
6 Guayaquil City Guayaquil 22 25 21 31
7 LDU de Portoviejo Portoviejo 22 20 21 29
8 UT Cotopaxi UT Cotopaxi 22 21 28 28
9 Grecia Grecia 22 34 41 26
10 Deportivo Azogues Deportivo 22 28 36 23
11 CSD Universidad Equinoccial Universidad 22 31 34 21
12 Municipal Canar Municipal 22 20 38 18
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Universidad Católica Universidad 18 34 16 35
2 Independiente del Valle Independient 18 39 19 34
3 Grecia Grecia 18 25 27 29
4 Deportivo Azogues Deportivo 18 26 21 27
5 Imbabura Imbabura 18 23 22 27
6 Municipal Canar Municipal 18 20 21 22
7 LDU Loja LDU Loja 18 18 26 22
8 Aucas Aucas 18 21 26 18
9 Atlético Audaz Atlético 18 12 26 17
10 Rocafuerte Rocafuerte 18 18 32 15
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Manta Manta 18 26 11 36
2 LDU de Portoviejo Portoviejo 18 23 20 33
3 Grecia Grecia 18 28 15 30
4 LDU Cuenca LDU Cuenca 18 22 21 24
5 LDU Loja LDU Loja 18 28 25 23
6 Independiente del Valle Independient 18 26 28 23
7 Aucas Aucas 18 18 20 23
8 Imbabura Imbabura 18 17 23 23
9 Municipal Canar Municipal 18 20 30 20
10 Brasilia Quininde Brasilia 18 13 28 13
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Universidad Católica Universidad 18 22 19 31
2 Técnico Universitario Técnico 18 30 21 30
3 Espoli Espoli 18 28 15 29
4 Municipal Canar Municipal 18 22 19 26
5 Aucas Aucas 18 26 25 26
6 Manta Manta 18 27 29 26
7 LDU de Portoviejo Portoviejo 18 28 29 25
8 Brasilia Quininde Brasilia 18 20 31 25
9 LDU Loja LDU Loja 18 24 31 17
10 Delfín Delfín 18 20 28 14
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Deportivo Azogues Deportivo 18 45 23 35
2 Universidad Católica Universidad 18 25 18 31
3 Manta Manta 18 38 29 29
4 Técnico Universitario Técnico 18 26 27 29
5 LDU Loja LDU Loja 18 20 18 25
6 Imbabura Imbabura 18 29 27 24
7 Delfín Delfín 18 21 25 21
8 LDU de Portoviejo Portoviejo 18 20 25 19
9 Deportivo Quevedo Deportivo 18 19 34 12
10 Esmeraldas Petrolero Esmeraldas 18 16 33 11

JUGADORES DESTACADOS

Nombre Goles Equipo
Juan Arroyo ec Juan Arroyo 1 FER Ferroviarios
L. Pantoja ec L. Pantoja 1 IMB Imbabura
Adan Ayala ec Adan Ayala 1 IMB Imbabura
P. Mancilla ec P. Mancilla 1 FER Ferroviarios

  USO DE MEMORIA  
5,383,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3473
Total Execution Time  0.3492
  CADENA URL  
/segunda_ecuador2013/grupo1/historico
  GET DATOS  
$_GET['/segunda_ecuador2013/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0106  SELECT type FROM routes WHERE alias = 'segunda_ecuador2013'
0.0213  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_ecuador' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT id,name,alias,stepParent FROM categories WHERE parentId=190 ORDER BY order_id ASC
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 = 2412 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 190 AND group_code = 1 and tables = 1 AND year <= 2013 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0111  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 `tables2013` 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 = 2412 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 `tables2012` 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 = 1577 AND t.round = 22 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 `tables2011` 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 = 1384 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 16107 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 16106 AND t.round = 18 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 `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 = 16105 AND t.round = 18 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 `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 = 16104 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 16103 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 02:06:43' 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-10 02:06:43' 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-10 02:06:43' 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-10 02:06:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_ecuador' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  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 events2013 e ON e.player_id = p.id AND e.league_id = 2412 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2412 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.0107  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 events2013 e ON e.player_id = p.id AND e.league_id = 2412 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2412 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 events2013 e ON e.player_id = p.id AND e.league_id = 2412 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2412 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 2412 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC