4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Putnok VSE Putnok VSE 25 62 19 53
2 Cigánd SE Cigánd SE 25 44 17 50
3 Kisvárda II Kisvárda 25 40 23 50
4 Debreceni VSC II Debreceni 25 56 32 44
5 Debreceni EAC Debreceni 25 33 30 40
6 Tiszaújváros Tiszaújvár 25 44 33 39
7 Újpest FC II Újpest 25 44 42 39
8 Eger Eger 25 29 29 38
9 Karcag SE Karcag SE 25 32 33 33
10 Sényő Carnifex Sényő 25 38 48 29
11 Salgótarjáni BTC Salgótarjá 25 28 40 29
12 Diósgyőr VTK II Diósgyőr 25 31 39 28
13 FC Hatvan FC Hatvan 25 26 40 27
14 Tiszafuredi Tiszafuredi 25 35 44 25
15 REAC REAC 25 25 58 20
16 Gyongyosi Gyongyosi 25 20 60 7
Ver
TEMPORADA 2022/2023
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
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Kazincbarcika Kazincbarcik 38 106 24 101
2 Debreceni EAC Debreceni 38 93 31 83
3 BKV Előre BKV Előre 38 64 45 74
4 Hajdúszoboszlói SE Hajdúszobos 38 74 39 70
5 Tiszaújváros Tiszaújvár 38 79 54 69
6 Kisvárda II Kisvárda 38 67 47 65
7 Sényő Carnifex Sényő 38 66 59 62
8 Putnok VSE Putnok VSE 38 66 48 59
9 Újpest FC II Újpest 38 67 53 57
10 Füzesgyarmati Füzesgyarma 38 49 53 51
11 Bekescsaba B Bekescsaba 38 82 75 50
12 Diósgyőr VTK II Diósgyőr 38 73 71 50
13 Tiszafuredi Tiszafuredi 38 57 60 47
14 Debreceni VSC II Debreceni 38 63 67 45
15 Eger Eger 38 47 66 44
16 Jászberényi Vasas Jászberény 38 44 71 35
17 Salgótarjáni BTC Salgótarjá 38 38 65 31
18 Hidasnémeti VSC Hidasnémeti 38 39 109 27
19 Törökszentmiklós Törökszent 38 36 93 21
20 Tallya KSE Tallya KSE 38 27 107 21
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Tiszakécske Tiszakécske 38 94 27 94
2 Budapest BVSC Budapest 38 75 39 78
3 Jászberényi Vasas Jászberény 38 78 41 73
4 Füzesgyarmati Füzesgyarma 38 70 44 72
5 Kisvárda II Kisvárda 38 57 45 68
6 Eger Eger 38 62 36 66
7 Balassagyarmat VSE Balassagyarm 38 46 32 64
8 Sényő Carnifex Sényő 38 65 58 57
9 Diósgyőr VTK II Diósgyőr 38 65 57 54
10 Cegledi Cegledi 38 45 47 50
11 Tiszafuredi Tiszafuredi 38 59 68 48
12 Tiszaújváros Tiszaújvár 38 51 62 48
13 Debreceni VSC II Debreceni 38 58 59 46
14 Tallya KSE Tallya KSE 38 52 57 43
15 Putnok VSE Putnok VSE 38 57 75 42
16 Salgótarján Salgótarjá 38 54 76 41
17 Gyöngyös Gyöngyös 38 54 80 39
18 FC Hatvan FC Hatvan 38 46 64 38
19 Sajóbábony Vegyész Sajóbábony 38 41 102 24
20 Mezőkövesd II Mezőkövesd 38 43 103 20
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Debreceni EAC Debreceni 17 45 20 38
2 Füzesgyarmati Füzesgyarma 18 30 18 38
3 Cegledi Cegledi 18 36 24 36
4 Sényő Carnifex Sényő 17 37 28 32
5 ESMTK ESMTK 18 29 20 31
6 Jászberényi Vasas Jászberény 18 37 31 29
7 Tiszaújváros Tiszaújvár 18 30 27 26
8 Putnok VSE Putnok VSE 18 27 25 25
9 Balassagyarmat VSE Balassagyarm 18 27 28 24
10 Eger Eger 18 19 31 20
11 Gyöngyös Gyöngyös 18 28 36 20
12 Tallya KSE Tallya KSE 17 20 25 18
13 Debreceni VSC II Debreceni 18 29 36 16
14 FC Hatvan FC Hatvan 17 16 33 10
15 Diósgyőr VTK II Diósgyőr 18 19 47 8
16 Ózdi FC Ózdi FC 0 0 0 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Szolnoki MÁV Szolnoki 30 61 31 65
2 Jászberényi Vasas Jászberény 30 75 31 64
3 ESMTK ESMTK 30 50 28 60
4 Füzesgyarmati Füzesgyarma 30 65 32 55
5 Sényő Carnifex Sényő 30 56 46 49
6 Putnok VSE Putnok VSE 30 49 50 49
7 Tiszaújváros Tiszaújvár 30 54 37 48
8 Nyírbátori FC Nyírbátori 30 39 39 46
9 Debreceni EAC Debreceni 30 57 58 44
10 Eger Eger 30 33 43 36
11 Gyöngyös Gyöngyös 30 40 52 30
12 Diósgyőr VTK II Diósgyőr 30 36 59 30
13 Tallya KSE Tallya KSE 30 27 47 29
14 Salgótarjáni BTC Salgótarjá 30 33 60 29
15 Sajóbábony Vegyész Sajóbábony 30 33 67 25
16 Cigánd SE Cigánd SE 30 30 58 22
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Kaposvari Rakoczi Kaposvari 30 66 24 70
2 FC Ajka FC Ajka 30 76 31 64
3 Erdi VSE Erdi VSE 30 56 34 57
4 Puskás Akadémia II Puskás 30 57 34 53
5 III. Kerületi TVE III. 30 49 43 50
6 Andráshida Andráshida 30 43 41 48
7 Pápai Perutz Pápai 30 48 43 46
8 BKV Előre BKV Előre 30 37 36 45
9 Csepel FC Csepel FC 30 43 34 42
10 Videoton II Videoton II 30 48 54 39
11 Dunaharaszti MTK Dunaharaszti 30 38 46 33
12 Penzugyor Penzugyor 30 32 53 29
13 Szabadkikoto Szabadkikoto 30 30 72 27
14 Csornai SE Csornai SE 30 27 55 26
15 Veszprém Veszprém 30 38 58 26
16 Gyirmót II Gyirmót II 30 28 58 23
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Kazincbarcika Kazincbarcik 34 88 33 79
2 Monori SE Monori SE 34 53 34 66
3 Jászberényi Vasas Jászberény 34 63 33 65
4 MTK Budapest II Budapest 34 64 37 56
5 Diósgyőr VTK II Diósgyőr 34 53 49 50
6 Putnok VSE Putnok VSE 34 46 49 49
7 Tallya KSE Tallya KSE 34 53 58 49
8 Rákosmenti KSK Rákosmenti 34 69 54 48
9 Salgótarján Salgótarjá 34 56 45 48
10 ESMTK ESMTK 34 41 45 47
11 Nyírbátori FC Nyírbátori 34 51 42 46
12 BKV Előre BKV Előre 34 57 58 45
13 Tiszaújváros Tiszaújvár 34 38 40 45
14 Debreceni VSC II Debreceni 34 49 50 42
15 FC Hatvan FC Hatvan 34 48 50 40
16 REAC REAC 34 42 55 40
17 Hajdúböszörményi Hajdúbösz 34 33 72 29
18 Újpest FC II Újpest 34 24 124 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Nyíregyháza Spartacus FC Nyíregyház 32 74 19 83
2 Cegledi Cegledi 32 62 25 76
3 Cigánd SE Cigánd SE 32 82 40 66
4 Putnok VSE Putnok VSE 32 58 37 59
5 Kazincbarcika Kazincbarcik 32 56 32 55
6 FC Hatvan FC Hatvan 32 48 36 55
7 Rákosmenti KSK Rákosmenti 32 70 48 51
8 Jászberényi Vasas Jászberény 32 57 45 43
9 Somos SE Somos SE 32 37 50 41
10 Újpest FC II Újpest 32 34 62 41
11 Debreceni VSC II Debreceni 32 46 48 39
12 Diósgyőr VTK II Diósgyőr 32 38 48 37
13 Tallya KSE Tallya KSE 32 31 54 25
14 Tiszaújváros Tiszaújvár 32 24 52 25
15 Nyírbátori FC Nyírbátori 32 30 68 25
16 REAC REAC 32 36 73 24
17 Felsőtárkány SE Felsőtárk 32 28 74 21
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Samsung Vác FC Samsung Vác 28 64 27 57
2 Kozarmisleny Kozarmisleny 28 67 23 55
3 REAC REAC 28 51 39 48
4 Szeol Szeol 28 41 30 46
5 Monori SE Monori SE 28 47 40 45
6 Videoton II Videoton II 28 48 34 44
7 Dunaharaszti MTK Dunaharaszti 28 38 31 42
8 ESMTK ESMTK 28 37 30 42
9 Dabas Dabas 28 47 41 42
10 Bölcskei Bölcskei 28 53 44 39
11 Szekszárdi UFC Szekszárdi 28 40 40 39
12 Gyulai Termál Gyulai 28 39 49 38
13 Szentlőrinc SE Szentlőrinc 28 33 48 30
14 Orosháza Orosháza 28 22 49 26
15 Bajai Bajai 28 20 76 19
16 Maglódi TC Maglódi TC 28 19 65 11
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Soroksár SC Soroksár 28 73 16 69
2 Szeged 2011 Szeged 2011 28 68 29 63
3 Budapest Honvéd II Budapest 28 70 40 56
4 Rákosmenti KSK Rákosmenti 28 59 34 51
5 Videoton II Videoton II 28 46 29 50
6 Dunaharaszti MTK Dunaharaszti 28 38 36 44
7 Gyulai Termál Gyulai 28 38 34 39
8 Orosháza Orosháza 28 40 48 34
9 Szekszárdi UFC Szekszárdi 28 36 48 32
10 Bajai Bajai 28 27 47 30
11 Bölcskei Bölcskei 28 39 49 30
12 Monori SE Monori SE 28 41 55 27
13 Dabas Dabas 28 37 60 26
14 ESMTK ESMTK 28 37 53 26
15 Maglódi TC Maglódi TC 28 37 60 25
16 Komlói Bányász SK Komlói 28 12 60 12
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Soroksár SC Soroksár 26 44 20 52
2 Monori SE Monori SE 26 52 31 50
3 Gyulai Termál Gyulai 26 53 23 48
4 Dunaharaszti MTK Dunaharaszti 26 41 27 48
5 Tököl Tököl 26 39 28 45
6 Dabas Dabas 26 49 38 40
7 Mórahalom Mórahalom 26 45 38 38
8 Nagykorosi Kinizsi Nagykorosi 26 40 47 32
9 Vecsés FC Vecsés FC 26 45 54 32
10 Szeol Szeol 26 31 34 30
11 Kecskemeti TE II Kecskemeti 26 35 46 28
12 Üllő SE Üllő SE 26 35 58 27
13 Makó FC Makó FC 26 30 50 22
14 Hódmezővásárhelyi Hódmezővá 26 16 61 13
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Kaposvári Rákóczi II Kaposvári 28 60 23 63
2 Pécsi II Pécsi II 28 62 23 57
3 Nagyatádi FC Nagyatádi 28 53 32 56
4 Szekszárdi UFC Szekszárdi 28 55 18 53
5 Szentlőrinc SE Szentlőrinc 28 52 26 52
6 Komlói Bányász SK Komlói 28 49 39 46
7 Bölcskei Bölcskei 28 50 42 41
8 Bonyhád Völgység Bonyhád 28 51 58 41
9 Siófok II Siófok II 28 53 51 40
10 Nagybajomi Nagybajomi 28 50 48 39
11 Balatonlelle SE Balatonlelle 28 36 50 31
12 Dombóvári Fc Dombóvári 28 31 48 26
13 Bátaszék SE Bátaszék 28 31 60 20
14 Mohácsi Mohácsi 28 34 77 19
15 Bárcsi SC Bárcsi SC 28 11 83 7
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Tököl Tököl 28 52 23 56
2 Szeged 2011 Szeged 2011 28 57 26 55
3 Újbuda TC Újbuda TC 28 56 35 53
4 Gyulai Termál Gyulai 28 48 27 52
5 Szolnoki MÁV II Szolnoki 28 51 30 49
6 Csepel FC Csepel FC 28 55 32 47
7 Dabas Dabas 28 44 28 45
8 Szeol Szeol 28 40 35 42
9 Kecskemeti TE II Kecskemeti 28 53 43 40
10 Hódmezővásárhelyi Hódmezővá 28 46 37 39
11 Jánoshidai Jánoshidai 28 40 80 25
12 Szarvasi FC Szarvasi FC 28 43 72 23
13 Szolnoki Spartacus Szolnoki 28 42 75 22
14 Jászberényi Vasas Jászberény 28 28 65 18
15 Szabadkigyösi Szabadkigyö 28 28 75 16
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Orosháza Orosháza 24 61 32 47
2 Szolnoki Spartacus Szolnoki 24 36 29 46
3 ESMTK ESMTK 24 41 31 40
4 Szeol Szeol 24 34 28 39
5 Kecskemeti TE II Kecskemeti 24 47 39 38
6 Budapesti Vasas II Budapesti 24 35 33 36
7 Hódmezővásárhelyi Hódmezővá 24 27 37 31
8 Monori SE Monori SE 24 33 31 30
9 Soroksár SC Soroksár 24 30 29 30
10 Százhalombattai Százhalomba 24 33 42 29
11 Dabas Dabas 24 26 42 28
12 Gyulai Termál Gyulai 24 31 36 26
13 Battonyai Battonyai 24 29 54 19
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Szigetszentmiklosi Szigetszentm 30 77 22 73
2 Velence SE Velence SE 30 80 38 68
3 Soroksár SC Soroksár 30 59 30 64
4 Siófok II Siófok II 30 54 26 53
5 Dunaharaszti MTK Dunaharaszti 30 63 40 52
6 Móri SE Móri SE 30 47 36 42
7 Törökbálinti TC Törökbáli 30 55 54 39
8 Penzugyor Penzugyor 30 37 46 38
9 Csepel FC Csepel FC 29 36 40 37
10 Videoton II Videoton II 30 40 49 35
11 Sárisápi Bányász Sárisápi 29 35 49 31
12 Dorogi FC Dorogi FC 29 36 52 31
13 III. Kerületi TVE III. 30 39 63 30
14 Kornye Kornye 30 36 65 26
15 Balatonlelle SE Balatonlelle 29 29 54 24
16 Csillaghegyi Csillaghegyi 30 29 88 14

JUGADORES DESTACADOS


  USO DE MEMORIA  
7,003,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1261
Total Execution Time  0.1280
  CADENA URL  
/nb_iii_hungria2024/grupo1/historico
  GET DATOS  
$_GET['/nb_iii_hungria2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0018  SELECT type FROM routes WHERE alias = 'nb_iii_hungria2024'
0.0039  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 583 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 (100827) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=583 ORDER BY order_id ASC
0.0020  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 = 72641 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 583 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 72641 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.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 `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.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 `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 = 63554 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 = 57109 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 = 50572 AND t.round = 30 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 `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 = 44610 AND t.round = 30 ORDER BY team.conference 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 `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 = 39608 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 `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 = 33938 AND t.round = 34 ORDER BY team.conference 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 `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 = 15966 AND t.round = 34 ORDER BY team.conference 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 `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 = 4410 AND t.round = 30 ORDER BY team.conference 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 `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 = 3580 AND t.round = 30 ORDER BY team.conference 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 `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 = 24516 AND t.round = 26 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 `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 = 24589 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 `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 = 24620 AND t.round = 30 ORDER BY team.conference 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 `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 = 24639 AND t.round = 26 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 `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 = 24661 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:59:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:59:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:59:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 13:59:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  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 events2024 e ON e.player_id = p.id AND e.league_id = 72641 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72641 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.0020  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 events2024 e ON e.player_id = p.id AND e.league_id = 72641 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72641 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  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 events2024 e ON e.player_id = p.id AND e.league_id = 72641 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72641 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  SELECT *,(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 = 72641 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