4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Náutico Náutico 23 46 27 45
2 Brasiliense Brasiliense 23 43 23 44
3 Bahía Bahía 23 38 24 43
4 Ituano Ituano 23 41 20 42
5 Fortaleza EC Fortaleza 23 42 28 39
6 Marília Marília 23 38 29 36
7 Avaí Avaí 23 28 30 36
8 Santa Cruz Santa Cruz 23 35 25 35
9 Paulista Paulista 23 32 32 35
10 Caxias do Sul Caxias 23 30 32 34
11 Anapolina Anapolina 23 25 28 32
12 Portuguesa Portuguesa 23 31 31 31
13 Ceará Ceará 23 31 33 31
14 Santo André Santo André 23 38 28 29
15 CRB CRB 23 32 33 29
16 São Raimundo AM São 23 30 36 28
17 Sport Recife Sport Recife 23 24 31 28
18 Vila Nova Vila Nova 23 33 38 26
19 América RJ América RJ 23 22 36 26
20 Remo Remo 23 32 41 25
21 América Mineiro América 23 25 39 23
22 Mogi Mirim Mogi Mirim 23 25 37 18
23 Joinville Joinville 23 25 44 18
24 Londrina Londrina 23 19 40 17
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Palmeiras Palmeiras 23 54 25 47
2 Botafogo Botafogo 23 45 26 41
3 Remo Remo 23 42 33 39
4 Náutico Náutico 23 41 27 38
5 Brasiliense Brasiliense 23 34 24 38
6 Sport Recife Sport Recife 23 32 20 37
7 Marília Marília 23 32 24 36
8 Santa Cruz Santa Cruz 23 35 38 35
9 Paulista Paulista 23 37 29 33
10 Londrina Londrina 23 39 42 31
11 Portuguesa Portuguesa 23 39 33 30
12 Ceará Ceará 23 36 30 30
13 Avaí Avaí 23 23 30 30
14 América RJ América RJ 23 34 36 28
15 Joinville Joinville 23 33 41 27
16 CRB CRB 23 28 37 27
17 Anapolina Anapolina 23 30 43 27
18 São Raimundo AM São 23 27 31 26
19 Vila Nova Vila Nova 23 32 39 26
20 Mogi Mirim Mogi Mirim 23 28 43 26
21 América Mineiro América 23 35 38 24
22 Caxias do Sul Caxias 23 27 39 24
23 Gama Gama 23 28 41 19
24 União São João União São 23 22 44 16
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Criciúma Criciúma 25 45 34 51
2 Sport Recife Sport Recife 25 38 21 50
3 Fortaleza EC Fortaleza 25 48 24 48
4 Santa Cruz Santa Cruz 25 46 24 47
5 Avaí Avaí 25 39 20 46
6 América Mineiro América 25 49 36 40
7 Paulista Paulista 25 37 27 39
8 CRB CRB 25 35 32 38
9 Remo Remo 25 37 35 38
10 América RJ América RJ 25 46 35 36
11 Mogi Mirim Mogi Mirim 25 37 39 35
12 Joinville Joinville 25 36 44 34
13 Ceará Ceará 25 35 27 33
14 Caxias do Sul Caxias 25 31 24 33
15 Vila Nova Vila Nova 25 40 35 33
16 Anapolina Anapolina 25 33 35 33
17 Londrina Londrina 25 28 30 33
18 União São João União São 25 32 40 33
19 Náutico Náutico 25 38 35 32
20 Americano Americano 25 34 36 32
21 São Raimundo AM São 25 34 37 32
22 Botafogo SP Botafogo SP 25 36 60 30
23 Sampaio Correa Sampaio 25 25 50 25
24 Guarany de Sobral Guarany 25 28 51 20
25 XV de Piracicaba Piracicaba 25 19 44 19
26 RB Bragantino Bragantino 25 23 54 17
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 26 44 26 47
2 Caxias do Sul Caxias 26 44 35 46
3 Ceará Ceará 26 50 36 41
4 Náutico Náutico 26 43 34 41
5 CRB CRB 26 35 36 41
6 Fortaleza EC Fortaleza 26 40 27 40
7 América RN América RN 26 32 30 38
8 SAO Raimundo EC Raimundo 26 36 37 38
9 Anapolina Anapolina 26 45 47 34
10 Sergipe Sergipe 26 38 41 32
11 Remo Remo 26 33 39 32
12 Sampaio Correa Sampaio 26 32 40 32
13 Tuna Luso Tuna Luso 26 36 45 30
14 ABC ABC 26 32 40 29
15 Nacional AM Nacional AM 26 30 48 25
16 Figueirense Figueirense 26 50 38 42
17 Avaí Avaí 26 36 31 42
18 União São João União São 26 45 31 41
19 Joinville Joinville 26 39 26 41
20 XV de Piracicaba Piracicaba 26 39 45 38
21 Londrina Londrina 26 45 36 37
22 Vila Nova Vila Nova 26 43 44 37
23 América RJ América RJ 26 32 36 37
24 RB Bragantino Bragantino 26 40 43 35
25 J. Malucelli Malucelli 26 32 37 32
26 Criciúma Criciúma 26 35 40 30
27 Ferroviário Ferroviário 26 26 48 29
28 Serra FC Serra FC 26 33 49 24

  USO DE MEMORIA  
5,945,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0764
Total Execution Time  0.0784
  CADENA URL  
/segunda_brasilena2004/grupo1/historico
  GET DATOS  
$_GET['/segunda_brasilena2004/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_brasilena2004'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_brasilena' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=188 ORDER BY order_id ASC
0.0020  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 = 12965 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 188 AND group_code = 1 and tables = 1 AND year <= 2004 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0027  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 = 12965 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 12968 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2002` 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 = 12971 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2001` 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 = 23357 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 07:12:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 07:12:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 07:12:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 07:12:33' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_brasilena' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2004 e ON e.player_id = p.id AND e.league_id = 12965 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12965 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.0019  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 events2004 e ON e.player_id = p.id AND e.league_id = 12965 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12965 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2004 e ON e.player_id = p.id AND e.league_id = 12965 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 12965 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  SELECT *,(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 = 12965 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC