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 Kecskemét Kecskemét 30 74 23 75
2 Ferencvárosi Ferencváros 30 63 35 62
3 Szolnoki MÁV Szolnoki 30 51 29 62
4 Makó FC Makó FC 30 51 33 50
5 Samsung Vác FC Samsung Vác 30 57 45 45
6 Vecsés FC Vecsés FC 30 43 42 45
7 Kazincbarcika Kazincbarcik 30 43 41 44
8 Bocs KSC Bocs KSC 30 47 42 42
9 Jászberényi Vasas Jászberény 30 28 36 36
10 Cegledi Cegledi 30 33 53 35
11 Baktalórántháza VSE Baktalórán 30 31 43 34
12 Tököl Tököl 30 28 52 32
13 BKV Előre BKV Előre 30 43 49 29
14 Orosháza Orosháza 30 41 56 29
15 Tuzsér SE Tuzsér SE 30 29 59 23
16 Mezőkövesd-Zsory Mezőkövesd 30 25 49 21
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Nyíregyháza Spartacus FC Nyíregyház 30 67 24 69
2 Ferencvárosi Ferencváros 30 70 21 65
3 Orosháza Orosháza 30 58 40 55
4 Szolnoki MÁV Szolnoki 30 45 35 49
5 Bocs KSC Bocs KSC 30 37 37 46
6 Tuzsér SE Tuzsér SE 30 40 47 45
7 Vecsés FC Vecsés FC 30 49 43 42
8 Kecskemét Kecskemét 30 46 46 40
9 Karcag SE Karcag SE 30 31 39 37
10 Baktalórántháza VSE Baktalórán 30 33 44 33
11 Kazincbarcika Kazincbarcik 30 41 45 32
12 Makó FC Makó FC 30 30 45 32
13 Jászberényi Vasas Jászberény 30 40 55 29
14 Békéscsaba Békéscsaba 30 33 48 28
15 Jászapáti VSE Jászapáti 30 26 48 27
16 Budafoki LC Budafoki LC 30 31 60 23
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Samsung Vác FC Samsung Vác 28 60 25 61
2 Szolnoki MÁV Szolnoki 28 45 23 49
3 Jászapáti VSE Jászapáti 28 54 34 48
4 Makó FC Makó FC 28 44 34 47
5 Nyíregyháza Spartacus FC Nyíregyház 28 48 30 45
6 Soroksár SC Soroksár 28 44 34 45
7 Bocs KSC Bocs KSC 28 39 40 44
8 Kazincbarcika Kazincbarcik 28 46 44 38
9 Kecskemét Kecskemét 28 46 49 38
10 Orosháza Orosháza 28 51 46 36
11 Baktalórántháza VSE Baktalórán 28 41 37 35
12 Vecsés FC Vecsés FC 28 34 53 28
13 Karcag SE Karcag SE 28 36 63 28
14 Budafoki LC Budafoki LC 28 30 50 27
15 ESMTK ESMTK 28 20 76 11
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
1 Tatabánya Tatabánya 26 74 19 62
2 REAC REAC 26 43 19 53
3 Samsung Vác FC Samsung Vác 26 39 37 42
4 Kecskemét Kecskemét 26 45 36 40
5 Dunaújváros Dunaújváro 26 43 45 38
6 Szolnoki MÁV Szolnoki 26 30 36 36
7 Szeged SC Szeged SC 26 37 36 34
8 BKV Előre BKV Előre 26 35 37 33
9 Bodajk FC Bodajk FC 26 35 36 32
10 Mosonmagyaróvári TE Mosonmagyar 26 29 43 30
11 Orosháza Orosháza 26 26 50 30
12 Makó FC Makó FC 26 39 47 29
13 Szombathelyi Haladas Szombathelyi 26 29 39 28
14 Héviz FC Héviz FC 26 33 57 22
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,713,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  1.2078
Total Execution Time  1.2102
  CADENA URL  
/nb_ii_hungria2008/grupo1/historico
  GET DATOS  
$_GET['/nb_ii_hungria2008/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0017  SELECT type FROM routes WHERE alias = 'nb_ii_hungria2008'
0.0313  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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0247  SELECT id,name,alias,stepParent FROM categories WHERE parentId=369 ORDER BY order_id ASC
0.0092  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 = 14522 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0349  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 369 AND group_code = 1 and tables = 1 AND year <= 2008 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.1216  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 = 14522 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0777  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 = 14520 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1357  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 = 14518 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0705  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 `tables2005` 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 = 14517 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0680  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.1063  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.1619  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.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:42:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0057  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 13:42:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0098  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:42:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0058  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 13:42:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0478  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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0376  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 = 14522 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14522 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.0207  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 = 14522 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14522 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0445  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 = 14522 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14522 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.1432  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 = 14522 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC