4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Csákvári TK
TEMPORADA 2018/2019
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Zalaegerszegi TE Zalaegerszeg 38 77 41 82
2 Kaposvari Rakoczi Kaposvari 38 62 41 74
3 Gyirmot Gyirmot 38 75 50 65
4 Budapesti Vasas Budapesti 38 73 64 65
5 Budaörsi Budaörsi 38 65 46 64
6 Békéscsaba Békéscsaba 38 56 49 60
7 Soroksár SC Soroksár 38 68 61 59
8 Györi ETO Györi ETO 38 60 46 58
9 Kazincbarcika Kazincbarcik 38 59 50 56
10 Nyíregyháza Spartacus FC Nyíregyház 38 53 49 56
11 Csákvári TK Csákvári 38 57 59 52
12 BFC Siófok BFC Siófok 38 49 53 47
13 Samsung Vác FC Samsung Vác 38 44 51 46
14 Dorogi FC Dorogi FC 38 54 59 43
15 Tiszakécske Tiszakécske 38 34 52 43
16 Budafoki Budafoki 38 46 66 41
17 Balmazujvaros Balmazujvaro 38 33 48 40
18 Cegledi Cegledi 38 35 68 32
19 Mosonmagyaróvári TE Mosonmagyar 38 35 61 31
20 Monori SE Monori SE 38 49 70 30
TEMPORADA 2017/2018
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 38 88 44 82
2 Kisvárda Kisvárda 38 70 40 75
3 Békéscsaba Békéscsaba 38 64 43 65
4 Budaörsi Budaörsi 38 70 52 63
5 Nyíregyháza Spartacus FC Nyíregyház 38 54 40 60
6 Gyirmot Gyirmot 38 58 46 59
7 Györi ETO Györi ETO 38 55 53 58
8 Soroksár SC Soroksár 38 48 41 56
9 Cegledi Cegledi 38 42 49 52
10 Samsung Vác FC Samsung Vác 38 42 38 51
11 Csákvári TK Csákvári 38 50 66 47
12 Dorogi FC Dorogi FC 38 45 47 46
13 BFC Siófok BFC Siófok 38 40 45 45
14 Budafoki Budafoki 38 42 56 45
15 Mosonmagyaróvári TE Mosonmagyar 38 38 45 45
16 Zalaegerszegi TE Zalaegerszeg 38 45 58 44
17 Kazincbarcika Kazincbarcik 38 39 56 44
18 Szolnoki MÁV Szolnoki 38 38 58 42
19 Szeged 2011 Szeged 2011 38 31 40 41
20 Soproni Vasutas SE Soproni 38 31 73 20
TEMPORADA 2016/2017
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Puskás Akadémia Puskás 38 67 39 77
2 Balmazujvaros Balmazujvaro 38 49 34 73
3 Kisvárda Kisvárda 38 55 30 69
4 Soroksár SC Soroksár 38 63 40 67
5 Békéscsaba Békéscsaba 38 55 34 65
6 Samsung Vác FC Samsung Vác 38 45 38 59
7 Zalaegerszegi TE Zalaegerszeg 38 56 49 55
8 Dorogi FC Dorogi FC 38 46 35 54
9 Mosonmagyaróvári TE Mosonmagyar 38 48 40 54
10 Szolnoki MÁV Szolnoki 38 49 50 52
11 Szeged 2011 Szeged 2011 38 39 29 51
12 Nyíregyháza Spartacus FC Nyíregyház 38 48 50 50
13 Soproni Vasutas SE Soproni 38 37 38 49
14 BFC Siófok BFC Siófok 38 43 51 48
15 Budaörsi Budaörsi 38 48 56 47
16 Csákvári TK Csákvári 38 44 57 40
17 Cegledi Cegledi 38 42 55 39
18 Kozarmisleny Kozarmisleny 38 33 61 37
19 Cigánd SE Cigánd SE 38 27 64 29
20 Szeol Szeol 38 20 64 19
TEMPORADA 2015/2016
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Gyirmot Gyirmot 30 58 28 65
2 Mezőkövesd-Zsory Mezőkövesd 30 45 25 57
3 Zalaegerszegi TE Zalaegerszeg 30 55 30 55
4 Kisvárda Kisvárda 30 63 36 52
5 Balmazujvaros Balmazujvaro 30 46 39 51
6 Csákvári TK Csákvári 30 55 55 48
7 Soroksár SC Soroksár 30 45 29 47
8 Budaörsi Budaörsi 30 45 43 43
9 BFC Siófok BFC Siófok 30 36 47 41
10 Szeged 2011 Szeged 2011 30 42 40 40
11 Soproni Vasutas SE Soproni 30 38 42 33
12 Samsung Vác FC Samsung Vác 30 32 51 33
13 Szolnoki MÁV Szolnoki 30 34 41 31
14 Szigetszentmiklosi Szigetszentm 30 31 61 27
15 Dunaújváros Dunaújváro 30 32 63 27
16 FC Ajka FC Ajka 30 24 51 20
TEMPORADA 2014/2015
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Budapesti Vasas Budapesti 30 68 31 66
2 Békéscsaba Békéscsaba 30 42 23 61
3 Gyirmot Gyirmot 30 54 32 59
4 Mezőkövesd-Zsory Mezőkövesd 30 53 37 48
5 Soproni Vasutas SE Soproni 30 46 38 48
6 Szolnoki MÁV Szolnoki 30 50 47 46
7 Szeged 2011 Szeged 2011 30 36 32 45
8 Zalaegerszegi TE Zalaegerszeg 30 42 47 38
9 Soroksár SC Soroksár 30 32 41 33
10 Szigetszentmiklosi Szigetszentm 30 24 35 33
11 FC Ajka FC Ajka 30 43 46 32
12 Csákvári TK Csákvári 30 44 56 32
13 Balmazujvaros Balmazujvaro 30 35 52 32
14 BFC Siófok BFC Siófok 30 40 52 31
15 Cegledi Cegledi 30 33 56 27
16 Kaposvari Rakoczi Kaposvari 30 30 47 23
TEMPORADA 2013/2014
TERCERA HUNGRÍA GRUPO 2
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
TEMPORADA 2012/2013
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Puskás Akadémia Puskás 30 57 18 70
2 Kozarmisleny Kozarmisleny 30 55 28 60
3 Gyirmot Gyirmot 30 57 39 56
4 Zalaegerszegi TE Zalaegerszeg 30 50 35 51
5 FC Ajka FC Ajka 30 36 27 51
6 Tatabánya Tatabánya 30 46 32 50
7 Szigetszentmiklosi Szigetszentm 30 50 43 46
8 Soproni Vasutas SE Soproni 30 45 39 46
9 Csákvári TK Csákvári 30 41 40 44
10 Szombathelyi Haladás II Szombathelyi 30 41 43 42
11 Veszprém Veszprém 30 51 51 36
12 BKV Előre BKV Előre 30 36 54 33
13 Kaposvári Rákóczi II Kaposvári 30 29 50 26
14 Győri ETO II Győri 30 40 51 25
15 Bajai Bajai 30 29 75 17
16 Paksi SE II Paksi SE II 30 21 59 16
TEMPORADA 2011/2012
TERCERA HUNGRÍA GRUPO 6
Equipo PJ GF GC Puntos
1 Csákvári TK Csákvári 28 81 18 75
2 Szombathelyi Haladás II Szombathelyi 28 78 15 71
3 Csornai SE Csornai SE 28 56 26 60
4 Balatonfüredi Balatonfüre 28 51 34 50
5 Héviz FC Héviz FC 28 34 32 43
6 Répcelaki Répcelaki 28 35 33 42
7 Zalaegerszegi TE II Zalaegerszeg 28 50 51 39
8 Móri SE Móri SE 28 43 44 38
9 Mosonmagyaróvári TE Mosonmagyar 28 48 38 37
10 Lombard Pápa II Lombard 28 47 37 37
11 Körmendi FC Körmendi 28 46 58 35
12 Nagykanizsai TE Nagykanizsai 28 44 55 32
13 Sárvári FC Sárvári 28 31 45 25
14 Várpalotai BSK Várpalotai 28 27 90 19
15 Badacsonytomaj Badacsonytom 28 8 103 0

  USO DE MEMORIA  
6,214,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4566
Total Execution Time  0.4586
  CADENA URL  
/historico/Csakvari-Tk/2019
  GET DATOS  
$_GET['/historico/Csakvari-Tk/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0120  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Csakvari-Tk' AND l.year = 2019 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0107  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=17478 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0226  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 45243
0.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17478 AND type_rel = 2
0.0133  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '17478' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0135  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '17478' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 45243 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 44343 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=17478 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0114  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (51354,50172,49506) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 50172 AND teamId = 17478
0.0120  SELECT count(id) as num_players from rel_players WHERE league_id = 51354 AND teamId = 17478
0.0121  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 17478
0.0121  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2019` 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 = 44343 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2019 e ON e.player_id = p.id AND e.league_id = 44343 WHERE rp.league_id = 44343 AND rp.teamId = 17478 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2019 e ON e.player_id = p.id AND e.league_id = 44343 WHERE rp.league_id = 44343 AND rp.teamId = 17478 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2019 e ON e.player_id = p.id AND e.league_id = 44343 WHERE rp.league_id = 44343 AND rp.teamId = 17478 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 17478 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2019` 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 = 44343 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 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 `tables2018` 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 = 39020 AND t.round = 38 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 `tables2017` 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 = 33936 AND t.round = 38 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 `tables2016` 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 = 15505 AND t.round = 30 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 `tables2015` 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 = 4363 AND t.round = 30 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 `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.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 `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 = 14533 AND t.round = 30 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 `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 = 24618 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 44343 ORDER BY nameShow LIMIT 100