4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tatabánya
TEMPORADA 2023/2024
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Tatabánya Tatabánya 26 51 26 56
2 Veszprém Veszprém 26 55 32 53
3 Bicskei Bicskei 25 40 23 50
4 III. Kerületi TVE III. 25 41 24 48
5 Komaromi Komaromi 26 33 28 39
6 Budaörsi Budaörsi 26 44 44 38
7 Gyirmót II Gyirmót II 26 49 50 38
8 Dorogi FC Dorogi FC 26 37 33 37
9 Sopron Sopron 25 35 31 34
10 Puskás Akadémia II Puskás 26 41 33 33
11 Balatonfüredi Balatonfüre 26 31 38 32
12 Kelen Kelen 26 32 47 32
13 Győri ETO II Győri 26 39 41 28
14 Haladas / Zanati Haladas 26 35 55 22
15 Zalaegerszegi TE II Zalaegerszeg 26 25 51 17
16 Csornai SE Csornai SE 25 26 58 12
TEMPORADA 2022/2023
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Veszprém Veszprém 38 82 24 92
2 Tatabánya Tatabánya 38 77 35 90
3 Nagykanizsai ULE Nagykanizsai 38 105 41 87
4 Puskás Akadémia II Puskás 38 77 35 70
5 III. Kerületi TVE III. 38 82 40 68
6 Erdi VSE Erdi VSE 38 55 33 65
7 Bicskei Bicskei 38 59 41 63
8 Kaposvari Rakoczi Kaposvari 38 58 44 60
9 Budaörsi Budaörsi 38 56 43 60
10 Balatonfüredi Balatonfüre 38 50 52 56
11 Fehérvár II Fehérvár 38 48 56 55
12 Komaromi Komaromi 38 57 53 53
13 Győri ETO II Győri 38 61 60 52
14 Gyirmót II Gyirmót II 38 65 83 39
15 Zalaegerszegi TE II Zalaegerszeg 38 45 83 38
16 Kelen Kelen 38 42 60 32
17 Csornai SE Csornai SE 38 42 85 27
18 Teskánd Teskánd 38 50 111 25
19 Móri SE Móri SE 38 35 93 21
20 Zsámbéki Zsámbéki 38 33 107 13
TEMPORADA 2021/2022
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Mosonmagyaróvári TE Mosonmagyar 38 114 20 100
2 Budapest BVSC Budapest 38 93 32 88
3 Veszprém Veszprém 38 69 29 80
4 Győri ETO II Győri 38 68 45 67
5 Puskás Akadémia II Puskás 38 65 39 66
6 Bicskei Bicskei 38 50 44 62
7 Pápai Perutz Pápai 38 49 41 59
8 Tatabánya Tatabánya 38 52 43 57
9 Kaposvari Rakoczi Kaposvari 38 50 46 53
10 Nagykanizsai ULE Nagykanizsai 38 60 67 53
11 Fehérvár II Fehérvár 38 47 54 52
12 Zalaegerszegi TE II Zalaegerszeg 38 59 63 48
13 Balatonfüredi Balatonfüre 38 54 67 47
14 Erdi VSE Erdi VSE 38 56 69 46
15 Kelen Kelen 38 43 52 42
16 Gyirmót II Gyirmót II 38 61 71 40
17 Komaromi Komaromi 38 55 73 35
18 Sopron Sopron 38 37 81 28
19 Gárdony Gárdony 38 35 72 22
20 Andráshida Andráshida 38 26 135 11
TEMPORADA 2020/2021
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 III. Kerületi TVE III. 38 91 22 88
2 Mosonmagyaróvári TE Mosonmagyar 38 79 35 74
3 Veszprém Veszprém 37 61 44 67
4 Nagykanizsai ULE Nagykanizsai 38 77 50 66
5 Tatabánya Tatabánya 37 56 39 61
6 Lipot SK Lipot SK 38 66 58 60
7 Sopron Sopron 38 56 50 60
8 Puskás Akadémia II Puskás 38 67 51 58
9 Komaromi Komaromi 38 52 59 56
10 Erdi VSE Erdi VSE 38 51 54 54
11 Balatonfüredi Balatonfüre 38 69 58 52
12 Bicskei Bicskei 38 42 50 50
13 Zalaegerszegi TE II Zalaegerszeg 38 56 64 49
14 Lombard Pápa TFC Lombard 38 48 56 48
15 Fehérvár II Fehérvár 38 52 58 47
16 BKV Előre BKV Előre 38 46 60 44
17 Gárdony Gárdony 38 58 82 44
18 Szabadkikoto Szabadkikoto 38 63 82 37
19 Ménfőcsanak Ménfőcsana 38 37 72 29
20 Nagyatádi FC Nagyatádi 38 32 115 12
TEMPORADA 2016/2017
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Györi ETO Györi ETO 32 84 22 81
2 Erdi VSE Erdi VSE 32 70 36 72
3 Kaposvari Rakoczi Kaposvari 32 65 26 64
4 FC Ajka FC Ajka 32 58 39 59
5 Csornai SE Csornai SE 32 44 34 54
6 Puskás Akadémia II Puskás 32 54 38 51
7 Budapest Honvéd II Budapest 32 63 49 46
8 III. Kerületi TVE III. 32 47 43 45
9 Csepel FC Csepel FC 32 35 35 44
10 Andráshida Andráshida 32 41 46 43
11 Gyirmót II Gyirmót II 32 34 43 40
12 Veszprém Veszprém 32 32 49 40
13 Videoton II Videoton II 32 41 60 35
14 Sárvári FC Sárvári 32 24 42 33
15 Héviz FC Héviz FC 32 27 42 31
16 Komaromi Komaromi 32 27 65 19
17 Diósdi TC Diósdi TC 32 15 92 16
18 Tatabánya Tatabánya 0 0 0 0
TEMPORADA 2015/2016
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Ferencváros II Ferencváros 32 65 26 72
2 Mosonmagyaróvári TE Mosonmagyar 32 72 34 69
3 Dorogi FC Dorogi FC 32 44 16 68
4 Györi ETO Györi ETO 32 60 33 57
5 Tatabánya Tatabánya 32 55 40 55
6 Videoton II Videoton II 32 70 50 53
7 Andráshida Andráshida 32 49 38 50
8 BKV Előre BKV Előre 32 49 39 47
9 MTK Budapest II Budapest 32 44 46 46
10 Erdi VSE Erdi VSE 32 47 47 44
11 Puskás Akadémia II Puskás 32 56 53 39
12 III. Kerületi TVE III. 32 47 55 39
13 Diósdi TC Diósdi TC 32 39 48 39
14 Csepel FC Csepel FC 32 27 71 26
15 Csornai SE Csornai SE 32 26 62 21
16 Sárvári FC Sárvári 32 28 76 20
17 Balatonfüredi Balatonfüre 32 26 70 17
TEMPORADA 2014/2015
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Budaörsi Budaörsi 28 63 19 64
2 Dorogi FC Dorogi FC 28 36 18 57
3 Győri ETO II Győri 28 50 26 54
4 Diósdi TC Diósdi TC 28 37 35 47
5 Tatabánya Tatabánya 28 53 35 45
6 Rákosmenti KSK Rákosmenti 28 44 30 45
7 Újbuda TC Újbuda TC 28 34 33 44
8 BKV Előre BKV Előre 28 41 38 40
9 Sárvári FC Sárvári 28 33 43 35
10 III. Kerületi TVE III. 28 39 48 34
11 Balatonfüredi Balatonfüre 28 37 42 30
12 Mosonmagyaróvári TE Mosonmagyar 28 32 43 29
13 Csepel FC Csepel FC 28 25 34 28
14 Nagyatádi FC Nagyatádi 28 22 49 24
15 Tököl Tököl 28 13 66 7
16 Veszprém Veszprém 0 0 0 0
TEMPORADA 2013/2014
SEGUNDA HUNGRÍA
Equipo PJ GF GC Puntos
1 Nyíregyháza Spartacus FC Nyíregyház 30 57 23 66
2 Dunaújváros Dunaújváro 30 50 25 62
3 Gyirmot Gyirmot 30 63 33 57
4 Budapesti Vasas Budapesti 30 59 43 52
5 BFC Siófok BFC Siófok 30 44 36 49
6 Békéscsaba Békéscsaba 30 50 43 43
7 FC Ajka FC Ajka 30 46 44 43
8 Balmazujvaros Balmazujvaro 30 49 48 41
9 Zalaegerszegi TE Zalaegerszeg 30 43 48 39
10 Soproni Vasutas SE Soproni 30 40 47 38
11 Szigetszentmiklosi Szigetszentm 30 31 41 37
12 Szolnoki MÁV Szolnoki 30 39 41 36
13 Kisvarda Kisvarda 30 39 44 31
14 Cegledi Cegledi 30 33 53 31
15 Kozarmisleny Kozarmisleny 30 24 49 21
16 Tatabánya Tatabánya 30 24 73 18
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
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 30 67 20 69
2 Kozarmisleny Kozarmisleny 30 50 30 55
3 Gyirmot Gyirmot 30 50 43 52
4 FC Ajka FC Ajka 30 48 34 50
5 Tatabánya Tatabánya 30 50 34 49
6 Veszprém Veszprém 30 44 37 47
7 Szigetszentmiklosi Szigetszentm 30 52 38 45
8 Videoton II Videoton II 30 38 35 41
9 Bajai Bajai 30 46 50 37
10 Ferencváros II Ferencváros 30 46 54 36
11 BKV Előre BKV Előre 30 32 45 35
12 Paksi SE II Paksi SE II 30 27 41 31
13 Győri ETO II Győri 30 37 49 30
14 Soproni Vasutas SE Soproni 30 28 52 30
15 Dunaújváros Dunaújváro 30 25 58 28
16 Budaörsi Budaörsi 30 37 57 25
TEMPORADA 2010/2011
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Pécsi MFC Pécsi MFC 30 55 17 66
2 Gyirmot Gyirmot 30 62 29 63
3 Videoton II Videoton II 30 58 32 58
4 Bajai Bajai 30 51 38 54
5 BKV Előre BKV Előre 30 38 37 48
6 FC Ajka FC Ajka 30 47 35 46
7 Tatabánya Tatabánya 30 47 39 46
8 Kozarmisleny Kozarmisleny 30 41 37 45
9 Szigetszentmiklosi Szigetszentm 30 45 40 42
10 Győri ETO II Győri 30 42 47 42
11 Budaörsi Budaörsi 30 42 41 41
12 Ferencváros II Ferencváros 30 36 35 34
13 Bárcsi SC Bárcsi SC 30 35 61 33
14 Veszprém Veszprém 30 33 54 30
15 Budapest Honvéd II Budapest 30 24 57 18
16 Kaposvölgye VSC Kaposvölgye 30 21 78 14
TEMPORADA 2009/2010
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 BFC Siófok BFC Siófok 28 49 20 63
2 Gyirmot Gyirmot 28 56 25 62
3 Pécsi MFC Pécsi MFC 28 56 25 55
4 FC Ajka FC Ajka 28 47 45 47
5 Tatabánya Tatabánya 28 49 41 45
6 Kozarmisleny Kozarmisleny 28 42 35 41
7 Győri ETO II Győri 28 43 31 39
8 Szigetszentmiklosi Szigetszentm 28 43 45 38
9 Videoton II Videoton II 28 41 43 36
10 Budaörsi Budaörsi 28 38 47 33
11 Kaposvölgye VSC Kaposvölgye 28 36 44 31
12 Budapest Honvéd II Budapest 28 29 54 27
13 Bárcsi SC Bárcsi SC 28 25 45 23
14 Zalaegerszegi TE II Zalaegerszeg 28 29 51 20
15 Héviz FC Héviz FC 28 23 55 20
TEMPORADA 2008/2009
SEGUNDA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Gyirmot Gyirmot 30 60 30 67
2 Lombard Pápa TFC Lombard 30 65 19 66
3 Pécsi MFC Pécsi MFC 30 62 21 65
4 Tatabánya Tatabánya 30 49 35 51
5 FC Ajka FC Ajka 30 44 31 49
6 Kaposvölgye VSC Kaposvölgye 30 45 42 48
7 Budaörsi Budaörsi 30 48 51 40
8 Kozarmisleny Kozarmisleny 30 40 40 39
9 Zalaegerszegi TE II Zalaegerszeg 30 41 43 38
10 FC Felcsút FC Felcsút 30 37 41 38
11 DAC Györ DAC Györ 30 38 39 34
12 Bárcsi SC Bárcsi SC 30 33 52 33
13 Győri ETO II Győri 30 46 55 32
14 Bajai Bajai 30 35 44 32
15 Százhalombattai Százhalomba 30 24 59 22
16 Dunaújváros Dunaújváro 30 16 81 13
TEMPORADA 2007/2008
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 MTK Budapest Budapest 30 67 23 66
2 Debreceni VSC Debreceni 30 67 29 64
3 Györi ETO Györi ETO 30 64 35 58
4 Újpest FC Újpest FC 30 58 40 55
5 Fehérvár Fehérvár 30 48 32 54
6 Kaposvari Rakoczi Kaposvari 30 48 38 51
7 Zalaegerszegi TE Zalaegerszeg 30 55 39 46
8 Budapest Honved Budapest 30 45 36 43
9 Budapesti Vasas Budapesti 30 41 45 41
10 Nyíregyháza Spartacus FC Nyíregyház 30 34 37 40
11 Paksi SE Paksi SE 30 51 51 37
12 REAC REAC 30 42 60 30
13 Diósgyőr VTK Diósgyőr 30 43 63 28
14 BFC Siófok BFC Siófok 30 33 46 27
15 Tatabánya Tatabánya 30 34 93 10
16 Sopron Sopron 30 10 73 0
TEMPORADA 2006/2007
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 63 21 69
2 MTK Budapest Budapest 30 61 33 61
3 Zalaegerszegi TE Zalaegerszeg 30 54 38 55
4 Újpest FC Újpest FC 30 39 32 46
5 Budapesti Vasas Budapesti 30 43 41 45
6 Fehérvár Fehérvár 30 45 43 44
7 Budapest Honved Budapest 30 48 43 41
8 Kaposvari Rakoczi Kaposvari 30 40 36 41
9 Diósgyőr VTK Diósgyőr 30 40 52 38
10 Paksi SE Paksi SE 30 34 38 37
11 Sopron Sopron 30 33 46 37
12 Tatabánya Tatabánya 30 46 58 36
13 Györi ETO Györi ETO 30 37 43 35
14 REAC REAC 30 42 55 34
15 Pécsi MFC Pécsi MFC 30 31 41 33
16 Samsung Vác FC Samsung Vác 30 21 57 19
TEMPORADA 2005/2006
LIGA HUNGRÍA
Equipo PJ GF GC Puntos
1 Debreceni VSC Debreceni 30 69 34 68
2 Újpest FC Újpest FC 30 74 37 65
3 Fehérvár Fehérvár 30 52 24 64
4 MTK Budapest Budapest 30 65 33 60
5 Ferencvárosi Ferencváros 30 43 38 41
6 Tatabánya Tatabánya 30 46 45 41
7 Kaposvari Rakoczi Kaposvari 30 35 41 37
8 Diósgyőr VTK Diósgyőr 30 33 44 37
9 Györi ETO Györi ETO 30 47 50 36
10 Sopron Sopron 30 39 39 35
11 Zalaegerszegi TE Zalaegerszeg 30 42 47 35
12 Pécsi MFC Pécsi MFC 30 37 41 33
13 Budapest Honved Budapest 30 33 52 33
14 REAC REAC 30 30 59 26
15 Budapesti Vasas Budapesti 30 32 47 25
16 Lombard Pápa TFC Lombard 30 30 76 22
TEMPORADA 2004/2005
SEGUNDA HUNGRÍA
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
TEMPORADA 2003/2004
SEGUNDA HUNGRÍA
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
TEMPORADA 2002/2003
SEGUNDA HUNGRÍA
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
TEMPORADA 2000/2001
LIGA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 22 36 14 44
2 Dunaújváros Dunaújváro 22 40 35 41
3 Györi ETO Györi ETO 22 34 32 38
4 Budapesti Vasas Budapesti 22 42 33 36
5 Újpest FC Újpest FC 22 40 37 35
6 Budapest Honved Budapest 22 33 31 33
7 MTK Budapest Budapest 22 31 22 29
8 Fehérvár Fehérvár 22 37 34 29
9 Zalaegerszegi TE Zalaegerszeg 22 33 36 28
10 Sopron Sopron 22 26 30 27
11 Debreceni VSC Debreceni 22 31 44 21
12 Tatabánya Tatabánya 22 20 55 6

  USO DE MEMORIA  
7,768,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5489
Total Execution Time  0.5503
  CADENA URL  
/historico/Tatabanya
  GET DATOS  
$_GET['/historico/Tatabanya']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0295  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 = 73256
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13161 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13161 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  SELECT /*35 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 (100827) ORDER BY n.cover_points DESC, update_date DESC
0.0158  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 = '13161' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 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 = 72644 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153  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 = 13161 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72644 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 68427 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.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 `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 = 63556 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.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 `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 = 57111 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.0149  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 = 33944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 15968 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0178  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 = 4411 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 2849 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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.0151  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 = 14531 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 `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 = 14529 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 14527 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 14525 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 665 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 666 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 667 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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.0151  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.0153  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.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 `tables2001` 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 = 14007 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC