4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dabas
TEMPORADA 2023/2024
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Békéscsaba Békéscsaba 25 75 18 68
2 ESMTK ESMTK 25 66 23 58
3 Körösladány Körösladá 25 55 34 48
4 Hódmezővásárhelyi Hódmezővá 24 34 20 47
5 Szolnoki MÁV Szolnoki 25 49 32 45
6 Budapesti Vasas II Budapesti 25 47 30 40
7 BKV Előre BKV Előre 25 33 42 39
8 Monori SE Monori SE 25 42 46 35
9 Dabas Dabas 25 31 49 29
10 Penzugyor Penzugyor 25 30 37 26
11 Budapest Honvéd II Budapest 25 38 50 26
12 Martfui LSE Martfui LSE 25 39 54 25
13 Kecskemeti TE II Kecskemeti 25 33 35 24
14 Szeged II Szeged II 25 30 37 21
15 Füzesgyarmati Füzesgyarma 24 28 69 18
16 Cegledi Cegledi 25 21 75 10
TEMPORADA 2022/2023
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Iváncsa Iváncsa 35 88 34 86
2 Hódmezővásárhelyi Hódmezővá 34 68 33 74
3 ESMTK ESMTK 34 57 27 65
4 MTK Budapest II Budapest 34 73 40 59
5 Budapest Honvéd II Budapest 34 51 46 58
6 Ferencváros II Ferencváros 34 60 43 56
7 PTE-PEAC PTE-PEAC 35 48 34 56
8 Újpest FC II Újpest 36 48 57 56
9 Dunaújváros Dunaújváro 34 67 49 51
10 Monori SE Monori SE 34 58 54 45
11 Paksi SE II Paksi SE II 34 55 58 43
12 Szolnoki MÁV Szolnoki 35 51 58 41
13 Szekszárdi UFC Szekszárdi 34 35 48 40
14 Majosi SE Majosi SE 34 37 50 39
15 Kecskemeti TE II Kecskemeti 34 44 67 35
16 Dabas Dabas 34 29 67 30
17 Cegledi Cegledi 34 40 81 27
18 Bánk Dalnoki Akadémia Bánk 34 30 90 16
19 Makó FC Makó FC 4 6 8 6
20 Balassagyarmat VSE Balassagyarm 1 1 2 0
TEMPORADA 2021/2022
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Kozarmisleny Kozarmisleny 38 80 23 92
2 Balassagyarmat VSE Balassagyarm 38 69 35 81
3 Dunaújváros Dunaújváro 38 76 37 78
4 Budapest Honvéd II Budapest 38 68 53 70
5 Makó FC Makó FC 38 60 33 69
6 Paksi SE II Paksi SE II 38 66 46 64
7 Iváncsa Iváncsa 38 74 45 62
8 Monori SE Monori SE 38 59 43 61
9 Ferencváros II Ferencváros 38 58 50 59
10 MTK Budapest II Budapest 38 49 52 52
11 Hódmezővásárhelyi Hódmezővá 38 55 62 52
12 Dabas Dabas 38 63 56 50
13 ESMTK ESMTK 38 52 47 47
14 Szekszárdi UFC Szekszárdi 38 48 50 46
15 Cegledi Cegledi 38 41 68 41
16 Samsung Vác FC Samsung Vác 38 44 68 39
17 Build Mohács Build 38 37 76 30
18 Dabas-Gyón Dabas-Gyón 38 30 72 30
19 Rákosmenti KSK Rákosmenti 38 40 87 23
20 Gerjeni SK Gerjeni SK 38 25 91 19
TEMPORADA 2020/2021
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Iváncsa Iváncsa 38 78 27 86
2 Kecskemét Kecskemét 38 90 32 80
3 Dabas Dabas 38 66 29 74
4 Budapest Honvéd II Budapest 38 83 50 72
5 Ferencváros II Ferencváros 38 75 36 70
6 Kozarmisleny Kozarmisleny 38 70 57 57
7 ESMTK ESMTK 38 56 50 57
8 Monori SE Monori SE 38 64 54 56
9 Dabas-Gyón Dabas-Gyón 38 48 45 55
10 Paksi SE II Paksi SE II 38 60 56 52
11 Újpest FC II Újpest 38 58 50 51
12 Rákosmenti KSK Rákosmenti 38 40 48 48
13 Samsung Vác FC Samsung Vác 38 53 54 47
14 Dunaújváros Dunaújváro 38 52 56 47
15 Szekszárdi UFC Szekszárdi 38 41 53 47
16 Hódmezővásárhelyi Hódmezővá 38 48 72 46
17 Körösladány Körösladá 38 59 71 40
18 Taksony Taksony 38 49 95 32
19 Szegedi VSE Szegedi VSE 38 30 94 24
20 Majosi SE Majosi SE 38 27 118 14
TEMPORADA 2019/2020
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Pécsi MFC Pécsi MFC 19 65 9 48
2 Szentlőrinc SE Szentlőrinc 19 30 10 44
3 Monori SE Monori SE 19 32 14 38
4 Iváncsa Iváncsa 19 31 18 35
5 Kozarmisleny Kozarmisleny 19 31 25 31
6 Dunaújváros Dunaújváro 19 27 26 31
7 Rákosmenti KSK Rákosmenti 19 29 30 25
8 Dabas-Gyón Dabas-Gyón 19 20 28 25
9 Budapest Honvéd II Budapest 19 33 28 24
10 Dabas Dabas 19 13 19 23
11 Kecskemét Kecskemét 19 25 26 21
12 Szekszárdi UFC Szekszárdi 19 22 34 19
13 Taksony Taksony 19 17 30 18
14 Szabadkikoto Szabadkikoto 19 20 54 15
15 Dunaharaszti MTK Dunaharaszti 19 12 37 11
16 Kelen Kelen 19 20 39 10
TEMPORADA 2018/2019
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Szeged 2011 Szeged 2011 30 52 17 68
2 Szentlőrinc SE Szentlőrinc 30 53 21 63
3 Szeol Szeol 30 40 20 55
4 Dunaújváros Dunaújváro 30 34 19 49
5 Budapest Honvéd II Budapest 30 34 40 43
6 Dabas Dabas 30 40 38 41
7 Rákosmenti KSK Rákosmenti 30 33 40 40
8 Iváncsa Iváncsa 30 46 44 39
9 Kecskemét Kecskemét 30 36 35 39
10 Kozarmisleny Kozarmisleny 30 33 29 38
11 Pécsi MFC Pécsi MFC 30 32 34 38
12 Taksony Taksony 30 35 44 36
13 Szekszárdi UFC Szekszárdi 30 24 29 34
14 Paksi SE II Paksi SE II 30 27 44 26
15 Hódmezővásárhelyi Hódmezővá 30 25 58 26
16 Makó FC Makó FC 30 25 57 20
TEMPORADA 2017/2018
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Tiszakécske Tiszakécske 30 75 32 71
2 Pécsi MFC Pécsi MFC 30 75 23 68
3 Iváncsa Iváncsa 30 62 41 60
4 Dunaújváros Dunaújváro 30 53 33 55
5 Szeol Szeol 30 42 29 53
6 Dabas Dabas 30 44 40 44
7 Szentlőrinc SE Szentlőrinc 30 43 42 44
8 Szekszárdi UFC Szekszárdi 30 36 41 39
9 Budapest Honvéd II Budapest 30 47 44 38
10 Paksi SE II Paksi SE II 30 39 47 37
11 Kozarmisleny Kozarmisleny 30 31 45 34
12 Rákosmenti KSK Rákosmenti 30 32 41 33
13 Makó FC Makó FC 30 34 62 31
14 Hódmezővásárhelyi Hódmezővá 30 30 49 30
15 Mórahalom Mórahalom 30 28 62 17
16 Vecsés FC Vecsés FC 30 20 60 17
TEMPORADA 2016/2017
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Budafoki Budafoki 34 75 24 87
2 Pécsi MFC Pécsi MFC 34 92 22 76
3 Szigetszentmiklosi Szigetszentm 34 77 39 68
4 Dunaújváros Dunaújváro 34 77 41 64
5 Hódmezővásárhelyi Hódmezővá 34 47 37 58
6 Paksi SE II Paksi SE II 34 58 45 53
7 Szekszárdi UFC Szekszárdi 34 38 32 52
8 Szentlőrinc SE Szentlőrinc 34 53 56 47
9 Penzugyor Penzugyor 34 43 48 46
10 Dabas Dabas 34 31 38 43
11 Dunaharaszti MTK Dunaharaszti 34 39 47 42
12 Ferencváros II Ferencváros 34 50 54 41
13 Mórahalom Mórahalom 34 50 57 39
14 Bekescsaba B Bekescsaba 34 44 66 36
15 Gyulai Termál Gyulai 34 29 56 36
16 Dabas-Gyón Dabas-Gyón 34 39 92 31
17 Méhkeréki Méhkeréki 34 34 58 29
18 Komlói Bányász SK Komlói 34 24 88 9
TEMPORADA 2015/2016
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Kozarmisleny Kozarmisleny 32 81 15 81
2 Szeol Szeol 32 54 25 63
3 Dabas Dabas 32 52 34 51
4 Újbuda TC Újbuda TC 32 47 34 50
5 Komlói Bányász SK Komlói 32 33 34 49
6 Penzugyor Penzugyor 32 36 30 46
7 Dunaharaszti MTK Dunaharaszti 32 38 42 45
8 Szentlőrinc SE Szentlőrinc 32 40 44 44
9 Paksi SE II Paksi SE II 32 53 54 42
10 Budapest Honvéd II Budapest 32 50 46 40
11 ESMTK ESMTK 32 32 40 39
12 Monori SE Monori SE 32 34 43 39
13 Gyulai Termál Gyulai 32 40 56 36
14 Bekescsaba B Bekescsaba 32 37 50 35
15 Hódmezővásárhelyi Hódmezővá 32 31 45 33
16 Szekszárdi UFC Szekszárdi 32 26 55 30
17 Bölcskei Bölcskei 32 32 69 29
TEMPORADA 2014/2015
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2013/2014
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2012/2013
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2011/2012
TERCERA HUNGRÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Dabas Dabas 30 64 22 64
2 Dunaharaszti MTK Dunaharaszti 30 58 19 64
3 Gyulai Termál Gyulai 30 51 25 53
4 Szeol Szeol 30 72 38 51
5 Kecskemeti TE II Kecskemeti 30 53 34 51
6 Tápiószecső Tápiószecs 30 58 47 47
7 Tököl Tököl 30 55 38 45
8 Csepel FC Csepel FC 30 39 27 43
9 Monori SE Monori SE 30 44 50 39
10 Üllő SE Üllő SE 30 45 54 37
11 Hódmezővásárhelyi Hódmezővá 30 35 43 35
12 Makó FC Makó FC 30 40 44 34
13 Szolnoki MÁV II Szolnoki 30 29 48 33
14 Pilisi LK Pilisi LK 30 18 58 30
15 Szarvasi FC Szarvasi FC 30 38 61 25
16 Jánoshidai Jánoshidai 30 24 115 17
TEMPORADA 2010/2011
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2009/2010
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2008/2009
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Budapest Honvéd II Budapest 30 73 29 63
2 Szolnoki Spartacus Szolnoki 30 60 30 62
3 Kecskemeti TE II Kecskemeti 30 76 36 59
4 Algyo SK Algyo SK 30 73 34 59
5 Budafoki LC Budafoki LC 30 46 30 54
6 Hódmezővásárhelyi Hódmezővá 30 51 39 50
7 Orosháza Orosháza 30 59 47 48
8 Erdi VSE Erdi VSE 30 39 33 46
9 Gyulai Termál Gyulai 30 55 54 39
10 Dabas Dabas 30 53 60 39
11 Szeol Szeol 30 44 50 37
12 Monori SE Monori SE 30 40 64 34
13 Újbuda TC Újbuda TC 30 51 78 31
14 Izsaki Sarfeher Izsaki 30 35 62 29
15 Kiskunfelegyhazi Kiskunfelegy 30 27 68 22
16 Jászapáti VSE Jászapáti 30 17 85 14
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

  USO DE MEMORIA  
7,321,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1439
Total Execution Time  0.1451
  CADENA URL  
/historico/Dabas
  GET DATOS  
$_GET['/historico/Dabas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0044  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 = 'Dabas' 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=17459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=17459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=17459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046  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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17459 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0026  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.0021  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.0030  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 = '17459' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '17459' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 72645 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=17459 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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,72645,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72645 AND teamId = 17459
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 17459
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17459
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 = '17459' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17459' and rp.type = 4
0.0022  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 = '17459' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 72645 WHERE rp.league_id = 72645 AND rp.teamId = 17459 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.0019  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 = 72645 WHERE rp.league_id = 72645 AND rp.teamId = 17459 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 72645 WHERE rp.league_id = 72645 AND rp.teamId = 17459 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 17459 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68429 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 = 63555 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 = 57110 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 `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 = 50573 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.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 `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 = 44611 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 = 39610 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 = 33940 AND t.round = 34 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 `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 = 15967 AND t.round = 34 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 `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.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 `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.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 `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 = 24615 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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.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 `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 = 24666 AND t.round = 30 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 `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