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 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,028,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1599
Total Execution Time  0.1620
  CADENA URL  
/historico/Csakvari-Tk/2018
  GET DATOS  
$_GET['/historico/Csakvari-Tk/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0036  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 = 2018 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.0025  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.0018  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.0018  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.0018  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.0074  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 = 39020
0.0029  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 = 40058
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17478 AND type_rel = 2
0.0026  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 = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0029  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.0026  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 = 40058 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 39020 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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 (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (45243,44343,43475) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 44343 AND teamId = 17478
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 45243 AND teamId = 17478
0.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 17478
0.0039  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '17478' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17478' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '17478' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049  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 events2018 e ON e.player_id = p.id AND e.league_id = 39020 WHERE rp.league_id = 39020 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.0048  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 events2018 e ON e.player_id = p.id AND e.league_id = 39020 WHERE rp.league_id = 39020 AND rp.teamId = 17478 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046  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 events2018 e ON e.player_id = p.id AND e.league_id = 39020 WHERE rp.league_id = 39020 AND rp.teamId = 17478 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0034  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.0031  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.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 `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.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 `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.0030  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.0041  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.0031  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