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 Budapest Honved Budapest 33 75 23 75
2 Budapesti Vasas Budapesti 33 57 36 61
3 Kaposvari Rakoczi Kaposvari 33 52 31 60
4 Diósgyőr VTK Diósgyőr 33 54 43 57
5 Nyíregyháza Spartacus FC Nyíregyház 33 40 36 55
6 REAC REAC 33 46 37 52
7 BKV Előre BKV Előre 33 39 36 48
8 Tatabánya Tatabánya 33 44 41 45
9 Lombard Pápa TFC Lombard 33 46 53 45
10 Balassagyarmat VSE Balassagyarm 33 36 35 43
11 Bodajk FC Bodajk FC 33 49 50 42
12 Kecskemét Kecskemét 33 33 33 41
13 Szeged SC Szeged SC 33 44 63 38
14 Szolnoki MÁV Szolnoki 33 42 43 37
15 Samsung Vác FC Samsung Vác 33 38 54 35
16 Dunaújváros Dunaújváro 33 37 51 34
17 Dabas Dabas 33 37 60 33
18 Héviz FC Héviz FC 33 32 76 23
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Pécsi MFC Pécsi MFC 34 71 34 73
2 Szombathelyi Haladas Szombathelyi 34 55 28 62
3 Buki TK Buki TK 34 55 22 60
4 REAC II REAC II 34 60 44 60
5 Nyíregyháza Spartacus FC Nyíregyház 34 63 44 55
6 Százhalombattai Százhalomba 34 53 48 53
7 Kaposvari Rakoczi Kaposvari 34 52 39 51
8 Lombard Pápa TFC Lombard 34 52 45 50
9 Kecskemét Kecskemét 34 57 42 48
10 Szolnoki MÁV Szolnoki 34 57 58 48
11 DVTK Borsodi DVTK Borsodi 34 45 50 44
12 Foti Foti 34 46 54 44
13 BKV Előre BKV Előre 34 54 56 43
14 Balassagyarmat VSE Balassagyarm 34 49 57 40
15 Héviz FC Héviz FC 34 50 61 38
16 Tatabánya Tatabánya 34 40 57 33
17 Celldömölk VSE Celldömölk 34 27 60 30
18 Monori SE Monori SE 34 24 111 8
Ver
TEMPORADA 1998/1999
Equipo PJ GF GC Puntos
1 Tatabánya Tatabánya 38 85 50 83
2 Nagykanizsa Nagykanizsa 38 66 38 71
3 Szeged SC Szeged SC 38 73 32 70
4 Salgótarjáni BTC Salgótarjá 38 63 39 67
5 Sopron Sopron 38 61 50 62
6 Tiszaújváros Tiszaújvár 38 54 48 60
7 Komaromi Komaromi 38 59 50 57
8 Érd VSE Érd VSE 38 59 52 57
9 Szolnoki MÁV Szolnoki 38 57 55 53
10 Komlói Bányász SK Komlói 38 56 59 53
11 Tiszakécske Tiszakécske 38 52 54 52
12 Tiszavasvari Tiszavasvari 38 46 40 50
13 Békéscsaba Békéscsaba 38 45 38 49
14 Kaposvari Rakoczi Kaposvari 38 49 66 47
15 Demecser FC Demecser FC 38 47 54 45
16 Pécsi MFC Pécsi MFC 38 52 63 45
17 Kaba SE Kaba SE 38 63 69 44
18 Soroksár SC Soroksár 38 48 84 35
19 Soproni Vasutas SE Soproni 38 39 84 24
20 Kecskemét Kecskemét 38 32 81 19

  USO DE MEMORIA  
5,283,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3250
Total Execution Time  0.3271
  CADENA URL  
/nb_ii_hungria2004/grupo1/historico
  GET DATOS  
$_GET['/nb_ii_hungria2004/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0124  SELECT type FROM routes WHERE alias = 'nb_ii_hungria2004'
0.0253  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nb_ii_hungria' 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.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=369 ORDER BY order_id ASC
0.0126  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 = 14516 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 369 AND group_code = 1 and tables = 1 AND year <= 2004 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0130  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 = 14516 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 27656 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1999` 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 = 14515 AND t.round = 38 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-04-28 16:27:41' 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-04-28 16:27:41' 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=4 AND last_update > '2024-04-28 16:27:41' 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=3 AND last_update > '2024-04-28 16:27:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nb_ii_hungria' 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.0126  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 = 14516 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14516 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.0126  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 = 14516 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14516 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 = 14516 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14516 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  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 = 14516 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC