4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Debreceni VSC II
TEMPORADA 2023/2024
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Putnok VSE Putnok VSE 26 64 20 56
2 Cigánd SE Cigánd SE 26 44 17 51
3 Kisvárda II Kisvárda 26 41 27 50
4 Debreceni VSC II Debreceni 26 59 34 47
5 Debreceni EAC Debreceni 26 33 30 41
6 Eger Eger 26 33 30 41
7 Tiszaújváros Tiszaújvár 26 44 33 40
8 Újpest FC II Újpest 26 44 42 40
9 Karcag SE Karcag SE 26 33 33 36
10 Salgótarjáni BTC Salgótarjá 26 29 41 30
11 Diósgyőr VTK II Diósgyőr 26 31 39 29
12 Sényő Carnifex Sényő 26 39 50 29
13 FC Hatvan FC Hatvan 26 26 41 27
14 Tiszafuredi Tiszafuredi 26 35 44 26
15 REAC REAC 26 27 61 20
16 Gyongyosi Gyongyosi 26 21 61 8
TEMPORADA 2022/2023
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Budapest BVSC Budapest 38 101 15 102
2 Putnok VSE Putnok VSE 38 70 46 79
3 Debreceni EAC Debreceni 38 65 29 67
4 Debreceni VSC II Debreceni 37 78 57 62
5 Körösladány Körösladá 38 57 55 60
6 Kisvárda II Kisvárda 38 63 42 59
7 Karcag SE Karcag SE 38 58 51 58
8 Sényő Carnifex Sényő 38 58 66 57
9 BKV Előre BKV Előre 38 55 55 51
10 Penzugyor Penzugyor 38 57 50 50
11 Diósgyőr VTK II Diósgyőr 38 52 58 49
12 FC Hatvan FC Hatvan 38 64 73 49
13 Budapesti Vasas II Budapesti 38 70 60 48
14 Tiszaújváros Tiszaújvár 38 53 73 48
15 Füzesgyarmati Füzesgyarma 38 52 59 47
16 Hajdúszoboszlói SE Hajdúszobos 38 45 50 46
17 Tiszafuredi Tiszafuredi 38 56 70 46
18 Eger Eger 38 50 56 44
19 Bekescsaba B Bekescsaba 38 53 103 25
20 Jászberényi FC Jászberény 37 28 117 16
TEMPORADA 2021/2022
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2020/2021
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2019/2020
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2016/2017
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2015/2016
TERCERA HUNGRÍA GRUPO 1
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
TEMPORADA 2014/2015
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Kisvárda Kisvárda 28 92 21 74
2 Putnok VSE Putnok VSE 28 71 24 69
3 FC Hatvan FC Hatvan 28 59 36 51
4 Kazincbarcika Kazincbarcik 28 46 25 51
5 Cigánd SE Cigánd SE 28 46 30 49
6 Tiszaújváros Tiszaújvár 28 36 52 44
7 Budapest Honvéd II Budapest 28 44 29 41
8 Nyírbátori FC Nyírbátori 28 52 51 39
9 Jászberényi Vasas Jászberény 28 46 50 39
10 Debreceni VSC II Debreceni 28 48 33 38
11 Felsőtárkány SE Felsőtárk 28 37 64 31
12 Veresegyhaz VSK Veresegyhaz 28 28 61 24
13 Hajdúböszörményi Hajdúbösz 28 32 57 21
14 Salgótarjáni BTC Salgótarjá 28 32 70 19
15 Gyöngyös Gyöngyös 28 13 79 8
16 Létavértes SC Létavértes 0 0 0 0
TEMPORADA 2013/2014
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Létavértes SC Létavértes 28 74 28 64
2 Kazincbarcika Kazincbarcik 28 53 25 58
3 Debreceni VSC II Debreceni 28 61 37 54
4 Putnok VSE Putnok VSE 28 56 34 51
5 Cigánd SE Cigánd SE 28 54 38 50
6 Felsőtárkány SE Felsőtárk 28 50 35 48
7 Tiszaújváros Tiszaújvár 28 37 37 41
8 Nyírbátori FC Nyírbátori 28 46 42 40
9 FC Hatvan FC Hatvan 28 43 42 39
10 Hajdúböszörményi Hajdúbösz 28 42 45 37
11 Jászapáti VSE Jászapáti 28 37 51 32
12 REAC REAC 28 36 48 29
13 Ferencváros II Ferencváros 28 36 45 25
14 Veresegyhaz VSK Veresegyhaz 28 31 67 20
15 Ebes KKSE Ebes KKSE 28 23 64 17
16 Eger Eger 28 20 61 16
TEMPORADA 2012/2013
SEGUNDA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Mezőkövesd-Zsory Mezőkövesd 30 60 36 58
2 Békéscsaba Békéscsaba 30 58 38 55
3 Budapesti Vasas Budapesti 30 49 34 55
4 Balmazujvaros Balmazujvaro 30 50 37 50
5 Nyíregyháza Spartacus FC Nyíregyház 30 44 33 49
6 Szolnoki MÁV Szolnoki 30 54 41 48
7 Szeged 2011 Szeged 2011 30 43 41 42
8 Ferencváros II Ferencváros 30 49 49 41
9 Cegledi Cegledi 30 50 47 40
10 Orosháza Orosháza 30 51 57 39
11 Újpest FC II Újpest 30 43 49 38
12 Budapest Honvéd II Budapest 30 48 56 38
13 Putnok VSE Putnok VSE 30 43 51 35
14 Debreceni VSC II Debreceni 30 49 58 30
15 Kazincbarcika Kazincbarcik 30 40 63 30
16 Samsung Vác FC Samsung Vác 30 22 63 22
TEMPORADA 2011/2012
SEGUNDA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Eger Eger 30 42 26 59
2 Szolnoki MÁV Szolnoki 30 55 32 55
3 Békéscsaba Békéscsaba 30 44 30 51
4 Cegledi Cegledi 30 46 43 47
5 Orosháza Orosháza 30 47 39 44
6 Mezőkövesd-Zsory Mezőkövesd 30 43 40 44
7 Nyíregyháza Spartacus FC Nyíregyház 30 50 47 43
8 Balmazujvaros Balmazujvaro 30 52 40 42
9 Debreceni VSC II Debreceni 30 42 41 42
10 Újpest FC II Újpest 30 46 60 40
11 Samsung Vác FC Samsung Vác 30 44 48 38
12 Szeged 2011 Szeged 2011 30 46 43 37
13 Kazincbarcika Kazincbarcik 30 32 47 35
14 Budapest Honvéd II Budapest 30 36 44 34
15 REAC REAC 30 44 61 31
16 Vecsés FC Vecsés FC 30 21 49 17
TEMPORADA 2010/2011
SEGUNDA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Diósgyőr VTK Diósgyőr 30 66 23 68
2 Mezőkövesd-Zsory Mezőkövesd 30 47 20 62
3 Nyíregyháza Spartacus FC Nyíregyház 30 66 23 60
4 Samsung Vác FC Samsung Vác 30 47 27 60
5 MTK Budapest II Budapest 30 48 34 55
6 Békéscsaba Békéscsaba 30 45 40 43
7 Vecsés FC Vecsés FC 30 36 37 38
8 Debreceni VSC II Debreceni 30 37 45 37
9 Újpest FC II Újpest 30 43 58 35
10 REAC REAC 30 30 38 33
11 Kazincbarcika Kazincbarcik 30 37 60 31
12 Hajdúböszörményi Hajdúbösz 30 29 42 30
13 Cegledi Cegledi 30 46 61 30
14 Orosháza Orosháza 30 32 51 30
15 Makó FC Makó FC 30 30 54 30
16 Bocs KSC Bocs KSC 30 27 53 22
TEMPORADA 2009/2010
SEGUNDA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Szolnoki MÁV Szolnoki 28 54 28 60
2 Debreceni VSC II Debreceni 28 53 26 55
3 Samsung Vác FC Samsung Vác 28 47 36 52
4 REAC REAC 28 76 36 50
5 Mezőkövesd-Zsory Mezőkövesd 28 37 35 42
6 Vecsés FC Vecsés FC 28 45 32 41
7 Makó FC Makó FC 28 46 46 38
8 BKV Előre BKV Előre 28 38 39 38
9 Bocs KSC Bocs KSC 28 33 36 38
10 Hajdúböszörményi Hajdúbösz 28 33 36 37
11 MTK Budapest II Budapest 28 53 48 35
12 Kazincbarcika Kazincbarcik 28 35 50 32
13 Békéscsaba Békéscsaba 28 31 44 28
14 Cegledi Cegledi 28 40 53 27
15 Baktalórántháza VSE Baktalórán 28 21 97 0
TEMPORADA 2008/2009
SEGUNDA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Ferencvárosi Ferencváros 30 94 22 78
2 Debreceni VSC II Debreceni 30 72 38 61
3 Makó FC Makó FC 30 61 44 56
4 Bocs KSC Bocs KSC 30 56 34 52
5 Kazincbarcika Kazincbarcik 30 52 47 51
6 Szolnoki MÁV Szolnoki 30 52 42 47
7 MTK Budapest II Budapest 30 42 45 42
8 BKV Előre BKV Előre 30 53 47 40
9 Samsung Vác FC Samsung Vác 30 63 67 37
10 Cegledi Cegledi 30 41 48 37
11 Vecsés FC Vecsés FC 30 45 51 36
12 Békéscsaba Békéscsaba 30 42 62 34
13 Baktalórántháza VSE Baktalórán 30 37 63 30
14 ESMTK ESMTK 30 47 68 29
15 Jászberényi Vasas Jászberény 30 31 56 28
16 Tököl Tököl 30 29 83 15

  USO DE MEMORIA  
6,697,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7319
Total Execution Time  0.7331
  CADENA URL  
/historico/Debrecen-Ii
  GET DATOS  
$_GET['/historico/Debrecen-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0156  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 = 'Debrecen-Ii' 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.0145  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=17490 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=17490 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17490 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 72641
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17490 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0146  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.0146  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.0150  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 = '17490' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '17490' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 72641 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=17490 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (72641,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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72641 AND teamId = 17490
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17490
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 = 72641 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '17490' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17490' and rp.type = 4
0.0146  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 = '17490' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0151  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 = 72641 WHERE rp.league_id = 72641 AND rp.teamId = 17490 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.0146  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 = 72641 WHERE rp.league_id = 72641 AND rp.teamId = 17490 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 72641 WHERE rp.league_id = 72641 AND rp.teamId = 17490 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 17490 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 = 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.0296  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 = 68428 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.0296  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.0293  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.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 `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.0155  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.0158  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 = 4412 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 3582 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 14532 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 14530 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0176  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 = 14528 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 14526 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 `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 = 14524 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC