4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Csákvári TK Csákvári 28 70 32 64
2 Budaörsi Budaörsi 28 69 30 54
3 Andráshida Andráshida 28 49 26 52
4 BKV Előre BKV Előre 28 45 22 52
5 Győri ETO II Győri 28 59 44 51
6 Csepel FC Csepel FC 28 43 27 44
7 Balatonfüredi Balatonfüre 28 39 28 43
8 Újbuda TC Újbuda TC 28 42 40 39
9 Mosonmagyaróvári TE Mosonmagyar 28 38 39 39
10 Nagyatádi FC Nagyatádi 28 32 37 36
11 Dorogi FC Dorogi FC 28 41 45 34
12 Szombathelyi Haladás II Szombathelyi 28 35 43 31
13 Diósdi TC Diósdi TC 28 30 48 27
14 Veszprém Veszprém 28 34 62 27
15 Tököl Tököl 28 22 65 23
16 Körmendi FC Körmendi 28 27 87 16
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Dorogi FC Dorogi FC 26 57 21 58
2 Andráshida Andráshida 26 44 24 56
3 Mosonmagyaróvári TE Mosonmagyar 26 51 20 54
4 Balatonfüredi Balatonfüre 26 51 24 50
5 Újbuda TC Újbuda TC 26 55 37 49
6 Körmendi FC Körmendi 26 57 38 45
7 Répcelaki Répcelaki 26 43 42 35
8 Sárvári FC Sárvári 26 36 45 35
9 Csornai SE Csornai SE 26 37 37 31
10 Héviz FC Héviz FC 26 34 45 30
11 Nagykanizsai TE Nagykanizsai 26 29 54 25
12 Móri SE Móri SE 26 29 54 19
13 Lombard Pápa II Lombard 26 21 40 18
14 Komaromi Komaromi 26 21 84 10
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Erdi VSE Erdi VSE 30 75 21 75
2 Dorogi FC Dorogi FC 30 51 14 68
3 ESMTK ESMTK 30 64 25 61
4 Újbuda TC Újbuda TC 30 58 38 55
5 Soroksár SC Soroksár 30 46 26 51
6 Diósdi TC Diósdi TC 30 54 39 48
7 Sárisápi Bányász Sárisápi 30 42 37 48
8 Biatorbágy Biatorbágy 30 43 35 46
9 Penzugyor Penzugyor 30 47 40 44
10 Százhalombattai Százhalomba 30 48 52 37
11 RAFC RAFC 30 31 51 33
12 Bicskei Bicskei 30 33 51 28
13 III. Kerületi TVE III. 30 39 62 28
14 Budafoki LC Budafoki LC 30 27 51 28
15 Törökbálinti TC Törökbáli 30 34 79 19
16 Gázművek Gázművek 30 21 92 5
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Soproni Vasutas SE Soproni 30 80 19 71
2 Lombard Pápa II Lombard 30 58 21 65
3 Héviz FC Héviz FC 30 55 22 63
4 Mosonmagyaróvári TE Mosonmagyar 30 51 45 53
5 Szombathelyi Haladás II Szombathelyi 30 63 24 52
6 Balatonfüredi Balatonfüre 30 42 21 50
7 Sárvári FC Sárvári 30 47 36 48
8 Zalaegerszegi TE II Zalaegerszeg 30 52 43 45
9 Csornai SE Csornai SE 30 37 49 37
10 Lipot SK Lipot SK 30 39 45 34
11 Répcelaki Répcelaki 30 41 50 34
12 Buk TK Buk TK 30 24 41 32
13 Badacsonytomaj Badacsonytom 30 42 62 32
14 Celldömölk VSE Celldömölk 30 41 52 31
15 Várpalotai BSK Várpalotai 30 23 71 14
16 Köszegi Köszegi 30 21 115 10
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Veszprém Veszprém 26 73 16 68
2 Lipot SK Lipot SK 26 49 24 54
3 Soproni Vasutas SE Soproni 26 29 12 47
4 Szombathelyi Haladás II Szombathelyi 26 48 29 45
5 Mosonmagyaróvári TE Mosonmagyar 26 31 26 44
6 Csornai SE Csornai SE 26 31 32 44
7 Sárvári FC Sárvári 26 23 32 35
8 Badacsonytomaj Badacsonytom 26 37 37 30
9 Lombard Pápa II Lombard 26 30 34 30
10 Celldömölk VSE Celldömölk 26 32 38 30
11 Körmendi FC Körmendi 26 26 40 27
12 Répcelaki Répcelaki 26 25 48 23
13 KSE Csesztreg Csesztreg 26 25 55 15
14 Buk TK Buk TK 26 22 58 11
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Budapest Honvéd II Budapest 30 73 29 63
2 Szolnoki Spartacus Szolnoki 30 60 30 62
3 Kecskemeti TE II Kecskemeti 30 76 36 59
4 Algyo SK Algyo SK 30 73 34 59
5 Budafoki LC Budafoki LC 30 46 30 54
6 Hódmezővásárhelyi Hódmezővá 30 51 39 50
7 Orosháza Orosháza 30 59 47 48
8 Erdi VSE Erdi VSE 30 39 33 46
9 Gyulai Termál Gyulai 30 55 54 39
10 Dabas Dabas 30 53 60 39
11 Szeol Szeol 30 44 50 37
12 Monori SE Monori SE 30 40 64 34
13 Újbuda TC Újbuda TC 30 51 78 31
14 Izsaki Sarfeher Izsaki 30 35 62 29
15 Kiskunfelegyhazi Kiskunfelegy 30 27 68 22
16 Jászapáti VSE Jászapáti 30 17 85 14

  USO DE MEMORIA  
5,487,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3536
Total Execution Time  0.3555
  CADENA URL  
/nb_iii_hungria2014/grupo2/historico
  GET DATOS  
$_GET['/nb_iii_hungria2014/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'nb_iii_hungria' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=583 ORDER BY order_id ASC
0.0130  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 = 3581 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 583 AND group_code = 2 and tables = 1 AND year <= 2014 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0138  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 `tables2014` 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 = 3581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 24519 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 24595 AND t.round = 30 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 `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 = 24625 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 24641 AND t.round = 26 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 `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 = 24666 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:30:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 04:30:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 04:30:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 04:30:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0140  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 events2014 e ON e.player_id = p.id AND e.league_id = 3581 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3581 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.0137  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 events2014 e ON e.player_id = p.id AND e.league_id = 3581 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3581 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 events2014 e ON e.player_id = p.id AND e.league_id = 3581 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3581 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0191  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 3581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC