Escudo del Csákvári TK
TEMPORADA 2023/2024
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Nyíregyháza Spartacus FC Nyíregyház 25 51 21 55
2 Budapesti Vasas Budapesti 25 53 23 48
3 Györi ETO Györi ETO 25 43 27 48
4 Szeged 2011 Szeged 2011 25 26 15 45
5 Kozarmisleny Kozarmisleny 25 42 29 42
6 Gyirmot Gyirmot 25 32 29 35
7 Soroksár SC Soroksár 25 27 30 34
8 Budapest Honved Budapest 25 29 28 33
9 Kazincbarcika Kazincbarcik 25 26 29 33
10 Szombathelyi Haladas Szombathelyi 25 34 38 33
11 Csákvári TK Csákvári 25 28 32 33
12 FC Ajka FC Ajka 25 22 25 31
13 Budapest BVSC Budapest 25 21 30 30
14 Budafoki Budafoki 25 27 36 27
15 Pécsi MFC Pécsi MFC 25 12 24 27
16 BFC Siófok BFC Siófok 25 26 42 24
17 Tiszakécske Tiszakécske 25 22 33 19
18 Mosonmagyaróvári TE Mosonmagyar 25 19 49 11
TEMPORADA 2022/2023
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Diósgyőr VTK Diósgyőr 38 79 36 87
2 MTK Budapest Budapest 38 86 48 74
3 FC Ajka FC Ajka 38 54 37 68
4 Szeged 2011 Szeged 2011 38 50 38 64
5 Soroksár SC Soroksár 38 57 48 61
6 Gyirmot Gyirmot 38 59 46 60
7 Pécsi MFC Pécsi MFC 38 38 31 58
8 BFC Siófok BFC Siófok 38 45 51 56
9 Szombathelyi Haladas Szombathelyi 38 54 56 51
10 Budafoki Budafoki 38 39 46 47
11 Tiszakécske Tiszakécske 38 38 50 46
12 Mosonmagyaróvári TE Mosonmagyar 38 36 44 46
13 Györi ETO Györi ETO 38 37 42 46
14 Kazincbarcika Kazincbarcik 38 41 56 45
15 Csákvári TK Csákvári 38 44 50 42
16 Kozarmisleny Kozarmisleny 38 46 63 41
17 Szentlőrinc SE Szentlőrinc 38 44 58 39
18 Nyíregyháza Spartacus FC Nyíregyház 38 46 55 38
19 Békéscsaba Békéscsaba 38 47 56 37
20 Dorogi FC Dorogi FC 38 32 61 31
TEMPORADA 2021/2022
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Budapesti Vasas Budapesti 38 80 22 85
2 Kecskemét Kecskemét 38 75 36 77
3 Diósgyőr VTK Diósgyőr 38 57 40 72
4 Szeged 2011 Szeged 2011 38 64 34 66
5 BFC Siófok BFC Siófok 38 42 37 59
6 Szombathelyi Haladas Szombathelyi 38 37 30 57
7 Györi ETO Györi ETO 38 57 46 56
8 Soroksár SC Soroksár 38 67 61 52
9 FC Ajka FC Ajka 38 49 49 51
10 Nyíregyháza Spartacus FC Nyíregyház 38 45 51 50
11 Pécsi MFC Pécsi MFC 38 38 39 48
12 Csákvári TK Csákvári 38 52 57 43
13 Tiszakécske Tiszakécske 38 41 65 42
14 Budafoki Budafoki 38 39 50 42
15 Békéscsaba Békéscsaba 38 53 69 42
16 Szentlőrinc SE Szentlőrinc 38 39 57 42
17 Dorogi FC Dorogi FC 38 35 60 41
18 Szolnoki MÁV Szolnoki 38 35 55 38
19 Budaörsi Budaörsi 38 40 61 38
20 III. Kerületi TVE III. 38 36 62 37
TEMPORADA 2020/2021
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 38 89 40 80
2 Gyirmot Gyirmot 38 60 31 78
3 Budapesti Vasas Budapesti 38 65 35 78
4 Pécsi MFC Pécsi MFC 38 51 33 64
5 FC Ajka FC Ajka 38 65 47 62
6 Budaörsi Budaörsi 38 62 59 59
7 Nyíregyháza Spartacus FC Nyíregyház 38 40 31 57
8 Soroksár SC Soroksár 38 51 44 57
9 Szolnoki MÁV Szolnoki 38 43 40 57
10 Szeged 2011 Szeged 2011 38 46 54 56
11 Szombathelyi Haladas Szombathelyi 38 50 42 54
12 Györi ETO Györi ETO 38 53 48 46
13 BFC Siófok BFC Siófok 38 49 58 45
14 Dorogi FC Dorogi FC 38 34 50 44
15 Békéscsaba Békéscsaba 38 43 60 44
16 Szentlőrinc SE Szentlőrinc 38 32 52 42
17 Csákvári TK Csákvári 38 54 66 38
18 Kazincbarcika Kazincbarcik 38 32 61 33
19 Kaposvari Rakoczi Kaposvari 38 33 65 33
20 Debreceni EAC Debreceni 38 32 68 23
TEMPORADA 2019/2020
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 27 60 33 59
2 Budafoki Budafoki 27 42 23 54
3 Budapesti Vasas Budapesti 27 55 39 47
4 Csákvári TK Csákvári 26 40 43 43
5 BFC Siófok BFC Siófok 26 40 31 42
6 Györi ETO Györi ETO 27 36 32 41
7 Gyirmot Gyirmot 27 32 29 38
8 Nyíregyháza Spartacus FC Nyíregyház 27 45 45 35
9 FC Ajka FC Ajka 26 41 40 35
10 Soroksár SC Soroksár 26 38 44 35
11 Budaörsi Budaörsi 26 38 37 34
12 Szeged 2011 Szeged 2011 26 31 29 34
13 Dorogi FC Dorogi FC 26 29 29 33
14 Kazincbarcika Kazincbarcik 27 33 38 33
15 Békéscsaba Békéscsaba 26 30 35 32
16 Szolnoki MÁV Szolnoki 26 22 27 31
17 Szombathelyi Haladas Szombathelyi 27 32 34 30
18 Tiszakécske Tiszakécske 27 25 50 26
19 Samsung Vác FC Samsung Vác 27 17 48 12
20 Balmazujvaros Balmazujvaro 0 0 0 0
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 cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,023,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1292
Total Execution Time  0.1304
  CADENA URL  
/historico/Csakvari-Tk
  GET DATOS  
$_GET['/historico/Csakvari-Tk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0028  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 = 2024 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.0019  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17478 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=369 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 369 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (414190) ORDER BY n.cover_points DESC, update_date DESC
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' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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.0023  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 (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73256,72462,71432) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 72462 AND teamId = 17478
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 17478
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17478
0.0022  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.0037  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 events2024 e ON e.player_id = p.id AND e.league_id = 72462 WHERE rp.league_id = 72462 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.0047  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 events2024 e ON e.player_id = p.id AND e.league_id = 72462 WHERE rp.league_id = 72462 AND rp.teamId = 17478 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 events2024 e ON e.player_id = p.id AND e.league_id = 72462 WHERE rp.league_id = 72462 AND rp.teamId = 17478 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 `tables2024` 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 = 72462 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2023` 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 = 68258 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2022` 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 = 63278 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables2021` 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 = 57039 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2020` 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 = 50172 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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.0025  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.0025  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.0026  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.0024  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.0026  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.0026  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.0024  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