4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dubnica
TEMPORADA 2023/2024
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Lokomotiva Zvolen Lokomotiva 25 38 26 49
2 Slovan Galanta Slovan 25 36 24 48
3 Sered Sered 25 48 22 46
4 Hamsik Academy Hamsik 25 37 20 43
5 Fomat Martin Fomat Martin 25 43 35 43
6 Slovan Duslo Sala Slovan Duslo 25 41 28 42
7 Beluša Beluša 25 39 33 41
8 FC Malacky FC Malacky 25 32 27 34
9 Baník Lehota Baník 25 34 31 34
10 FK Rača FK Rača 25 30 26 33
11 Podkonice Podkonice 25 40 50 29
12 Veľké Ludince Veľké 25 29 33 26
13 OK Častkovce Častkovce 25 32 40 26
14 Bánová Bánová 25 29 35 25
15 Nove Mesto Nad Vahom Nove Mesto. 25 26 58 16
16 Dubnica Dubnica 25 25 71 4
TEMPORADA 2022/2023
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 FK Košice FK Košice 30 61 21 66
2 Tatran Prešov Tatran 30 49 24 62
3 Komárno Komárno 30 41 26 53
4 Žilina II Žilina II 30 63 53 47
5 Pohronie Pohronie 30 45 41 44
6 Spartak Myjava Spartak 30 46 41 43
7 Slovan Bratislava II Slovan 30 43 45 43
8 Považská Bystrica Považská 30 52 48 40
9 Šamorín Šamorín 30 44 50 40
10 Púchov Púchov 30 47 44 38
11 Slavoj Trebišov Slavoj 30 32 44 36
12 FC Petržalka Petržalka 30 40 43 34
13 Dolný Kubín Dolný 30 36 60 34
14 Humenné Humenné 30 24 35 32
15 FK Rača FK Rača 30 25 52 26
16 Dubnica Dubnica 30 38 59 25
TEMPORADA 2021/2022
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Podbrezová Podbrezová 30 86 25 74
2 MFK Dukla MFK Dukla 30 62 24 69
3 Skalica Skalica 30 49 20 62
4 Komárno Komárno 30 51 29 59
5 FK Košice FK Košice 30 73 38 56
6 Humenné Humenné 30 36 30 56
7 Šamorín Šamorín 30 47 42 44
8 FC Petržalka Petržalka 30 54 48 41
9 Žilina II Žilina II 30 46 48 37
10 Slavoj Trebišov Slavoj 30 28 48 34
11 Dubnica Dubnica 30 33 51 31
12 Púchov Púchov 30 36 49 29
13 Rohoznik Rohoznik 30 30 58 29
14 Slovan Bratislava II Slovan 30 36 61 26
15 Bardejov Bardejov 30 26 54 18
16 Námestovo Námestovo 30 19 87 9
TEMPORADA 2020/2021
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Liptovsky Mikulas Liptovsky 28 55 26 60
2 MFK Dukla MFK Dukla 28 70 38 56
3 Skalica Skalica 28 55 32 55
4 Podbrezová Podbrezová 28 57 25 54
5 FK Košice FK Košice 28 40 27 49
6 Šamorín Šamorín 28 41 34 41
7 Púchov Púchov 28 40 45 38
8 Komárno Komárno 28 31 42 38
9 FC Petržalka Petržalka 28 37 41 37
10 Slavoj Trebišov Slavoj 28 47 48 35
11 Žilina II Žilina II 28 56 47 33
12 Dubnica Dubnica 28 28 37 33
13 Bardejov Bardejov 28 27 41 28
14 Slovan Bratislava II Slovan 28 32 70 21
15 Poprad Poprad 28 25 88 4
TEMPORADA 2019/2020
SEGUNDA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dubnica Dubnica 4 7 3 8
2 MFK Dukla MFK Dukla 4 12 6 7
3 Skalica Skalica 4 2 2 7
4 Podbrezová Podbrezová 3 6 3 5
5 Žilina II Žilina II 3 4 4 3
6 Poprad Poprad 4 1 14 0
TEMPORADA 2018/2019
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Pohronie Pohronie 30 48 25 61
2 Poprad Poprad 30 52 36 58
3 Skalica Skalica 30 47 32 53
4 Liptovsky Mikulas Liptovsky 30 56 41 50
5 MFK Dukla MFK Dukla 30 49 35 46
6 Komárno Komárno 30 48 38 46
7 Dubnica Dubnica 30 55 42 45
8 FC Petržalka Petržalka 30 41 38 45
9 Žilina II Žilina II 30 54 59 41
10 Bardejov Bardejov 30 41 46 39
11 Lokomotíva Košice Lokomotíva 30 38 44 38
12 Šamorín Šamorín 30 46 48 37
13 Slavoj Trebišov Slavoj 30 24 44 30
14 Inter Bratislava Inter 30 37 56 29
15 Tatran Prešov Tatran 30 30 41 27
16 Odeva Lipany Odeva Lipany 30 23 64 24
TEMPORADA 2017/2018
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Dubnica Dubnica 34 83 10 86
2 Borčice Borčice 34 78 35 71
3 Nové Zámky Nové Zámky 34 58 31 71
4 Lednické Rovne Lednické 34 61 33 66
5 Slovan Galanta Slovan 34 58 42 53
6 DAC II DAC II 34 51 38 52
7 Zlaté Moravce - Vrablé II Zlaté 34 60 53 52
8 Spartak Trnava II Spartak 34 59 46 50
9 MŠK Púchov MŠK Púchov 34 68 49 48
10 Nitra II Nitra II 34 57 47 48
11 Veľké Ludince Veľké 34 50 57 47
12 Gabčíkovo Gabčíkovo 34 55 47 46
13 Slovan Duslo Sala Slovan Duslo 34 49 65 45
14 Slovan Nemsova Slovan 34 46 59 42
15 Beluša Beluša 34 50 62 38
16 Baník Horná Nitra Baník 34 36 75 25
17 Spartak Bánovce Spartak 34 23 90 20
18 Topoľčany Topoľčany 34 25 128 12
TEMPORADA 2016/2017
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Komárno Komárno 36 83 32 78
2 Lednické Rovne Lednické 36 68 34 71
3 MŠK Púchov MŠK Púchov 36 61 28 70
4 DAC II DAC II 36 56 37 57
5 Zlaté Moravce - Vrablé II Zlaté 36 53 44 55
6 Dubnica Dubnica 36 49 43 55
7 Beluša Beluša 36 47 52 53
8 Slovan Galanta Slovan 36 58 49 52
9 Veľké Ludince Veľké 36 49 49 52
10 Slovan Nemsova Slovan 36 54 53 51
11 Gabčíkovo Gabčíkovo 36 40 47 47
12 Horses Surovce Horses 36 53 66 46
13 Topoľčany Topoľčany 36 41 53 45
14 Nové Zámky Nové Zámky 36 50 49 42
15 Baník Horná Nitra Baník 36 46 62 42
16 Slovan Duslo Sala Slovan Duslo 36 36 43 41
17 Šurany Šurany 36 55 79 39
18 Veľký Meder Veľký 36 40 76 33
19 Neded Neded 36 41 84 27
TEMPORADA 2015/2016
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Šamorín Šamorín 32 61 32 66
2 MŠK Púchov MŠK Púchov 32 53 29 60
3 Horses Surovce Horses 33 69 41 59
4 Veľký Meder Veľký 33 52 39 58
5 DAC II DAC II 33 41 30 52
6 Slovan Nemsova Slovan 32 46 34 51
7 Veľké Ludince Veľké 33 46 40 50
8 Baník Horná Nitra Baník 32 51 45 47
9 Komárno Komárno 32 51 51 46
10 Slovan Galanta Slovan 33 54 62 45
11 Nové Zámky Nové Zámky 32 43 39 42
12 Lednické Rovne Lednické 32 37 44 42
13 Spartak Vráble Spartak 33 31 45 39
14 Topoľčany Topoľčany 33 33 57 35
15 Dubnica Dubnica 33 30 46 31
16 Neded Neded 32 40 62 27
17 Palárikovo Palárikovo 33 25 64 16
18 Gabčíkovo Gabčíkovo 9 11 14 6
TEMPORADA 2014/2015
SEGUNDA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Lokomotíva Košice Lokomotíva 10 21 10 46
2 Sobota Sobota 10 13 11 41
3 Dolný Kubín Dolný 10 15 7 40
4 Košice II Košice II 10 15 10 37
5 Bodva Moldava Bodva 10 13 15 33
6 Slavoj Trebišov Slavoj 10 6 30 20
7 Pohronie Pohronie 10 24 10 58
8 Slovan Bratislava II Slovan 10 22 17 39
9 Spartak Trnava II Spartak 10 17 14 34
10 Nove Mesto Nad Vahom Nove Mesto. 10 12 9 30
11 Šamorín Šamorín 10 7 18 29
12 Dubnica Dubnica 10 6 20 21
TEMPORADA 2013/2014
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Podbrezová Podbrezová 33 64 16 82
2 Bardejov Bardejov 33 49 25 61
3 Zemplin Michalovce Zemplin 33 55 28 61
4 Tatran Prešov Tatran 33 56 28 60
5 Senec Senec 33 39 32 49
6 Spartak Trnava II Spartak 33 57 64 39
7 Sobota Sobota 33 32 39 38
8 Dubnica Dubnica 33 30 64 35
9 Pohronie Pohronie 33 38 60 34
10 Slovan Duslo Sala Slovan Duslo 33 30 45 32
11 FC ŠTK 1914 ŠTK 1914 33 33 55 31
12 Liptovsky Mikulas Liptovsky 33 25 52 28
TEMPORADA 2012/2013
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 DAC DAC 33 41 26 65
2 Podbrezová Podbrezová 33 45 20 61
3 Senec Senec 33 48 32 57
4 Bardejov Bardejov 33 41 36 53
5 Zemplin Michalovce Zemplin 33 41 43 43
6 FC ŠTK 1914 ŠTK 1914 33 29 32 41
7 Slovan Duslo Sala Slovan Duslo 33 41 45 41
8 Dubnica Dubnica 33 31 38 41
9 Sobota Sobota 33 39 47 40
10 Liptovsky Mikulas Liptovsky 33 26 39 36
11 Dolný Kubín Dolný 33 34 42 34
12 Baník Ruziná Baník 33 38 54 30
TEMPORADA 2011/2012
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Spartak Myjava Spartak 33 64 16 71
2 Podbrezová Podbrezová 33 53 19 65
3 Dolný Kubín Dolný 33 43 42 51
4 Senec Senec 33 41 33 50
5 Sobota Sobota 33 42 42 48
6 Zemplin Michalovce Zemplin 33 41 46 46
7 Ružomberok II Ružomberok 33 42 39 45
8 Dubnica Dubnica 33 32 31 43
9 Bodva Moldava Bodva 33 30 35 42
10 Liptovsky Mikulas Liptovsky 33 34 48 35
11 LAFC Lučenec LAFC 33 26 65 24
12 FC Petržalka Petržalka 33 22 54 19
TEMPORADA 2010/2011
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Slovan Bratislava Slovan 33 60 22 66
2 Senica Senica 33 54 30 61
3 Žilina Žilina 33 47 25 55
4 Spartak Trnava Spartak 33 40 30 49
5 Dukla Dukla 33 39 32 48
6 Zlaté Moravce Zlaté 33 35 31 46
7 Ruzomberok Ruzomberok 33 23 33 41
8 Nitra Nitra 33 30 51 40
9 DAC DAC 33 24 39 36
10 FC VSS Kosice Kosice 33 28 44 33
11 Tatran Prešov Tatran 33 30 49 33
12 Dubnica Dubnica 33 23 47 31
TEMPORADA 2009/2010
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Žilina Žilina 33 59 17 73
2 Slovan Bratislava Slovan 33 54 24 70
3 Dukla Dukla 33 45 30 56
4 Nitra Nitra 33 42 40 48
5 Ruzomberok Ruzomberok 33 33 35 47
6 Senica Senica 33 34 44 43
7 Spartak Trnava Spartak 33 52 46 41
8 Tatran Prešov Tatran 33 32 38 38
9 Dubnica Dubnica 33 27 42 36
10 DAC DAC 33 28 47 33
11 FC VSS Kosice Kosice 33 32 57 33
12 FC Petržalka Petržalka 33 33 51 29
TEMPORADA 2008/2009
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Slovan Bratislava Slovan 33 69 25 70
2 Žilina Žilina 33 56 26 62
3 Spartak Trnava Spartak 33 45 38 55
4 FC VSS Kosice Kosice 33 48 42 52
5 Ruzomberok Ruzomberok 33 48 34 47
6 FC Petržalka Petržalka 33 50 38 47
7 Tatran Prešov Tatran 33 40 50 41
8 Dubnica Dubnica 33 43 49 37
9 DAC DAC 33 32 59 36
10 Dukla Dukla 33 30 39 35
11 Nitra Nitra 33 34 53 35
12 Zlaté Moravce Zlaté 33 21 63 23
TEMPORADA 2007/2008
LIGA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 FC Petržalka Petržalka 33 77 30 84
2 Žilina Žilina 33 75 30 73
3 Nitra Nitra 33 40 26 57
4 Spartak Trnava Spartak 33 52 40 52
5 Slovan Bratislava Slovan 33 46 37 51
6 FC VSS Kosice Kosice 33 45 44 45
7 Ruzomberok Ruzomberok 33 46 43 44
8 Dukla Dukla 33 41 37 39
9 Dubnica Dubnica 33 34 53 33
10 Senec Senec 33 30 51 28
11 Zlaté Moravce Zlaté 33 22 66 25
12 Trenčín Trenčín 33 26 77 16
TEMPORADA 2006/2007
LIGA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Žilina Žilina 22 53 13 52
2 FC Petržalka Petržalka 22 40 28 42
3 FC VSS Kosice Kosice 22 29 29 34
4 Ruzomberok Ruzomberok 22 26 18 31
5 Dukla Dukla 22 24 26 31
6 Senec Senec 22 22 30 31
7 Nitra Nitra 22 16 21 30
8 Slovan Bratislava Slovan 22 24 32 26
9 Inter Bratislava Inter 22 25 25 25
10 Dubnica Dubnica 22 24 35 25
11 Spartak Trnava Spartak 22 22 33 24
12 Trenčín Trenčín 22 18 33 14

  USO DE MEMORIA  
7,023,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1942
Total Execution Time  0.1954
  CADENA URL  
/historico/Dubnica
  GET DATOS  
$_GET['/historico/Dubnica']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0224  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 = 'Dubnica' 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.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=13491 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=13491 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=13491 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=13491 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0044  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 = 72793
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13491 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1607 AND type_rel = 3
0.0025  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1607 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (16697,1411) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '13491' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '13491' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72793 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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=13491 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72793,72674,71432,68107) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 68107 AND teamId = 13491
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72793 AND teamId = 13491
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 13491
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13491
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 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 = 72793 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '13491' 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 = '13491' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '13491' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72793 WHERE rp.league_id = 72793 AND rp.teamId = 13491 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.0023  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 = 72793 WHERE rp.league_id = 72793 AND rp.teamId = 13491 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 72793 WHERE rp.league_id = 72793 AND rp.teamId = 13491 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 13491 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72793 AND t.round = 25 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 `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 = 68107 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.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 `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 = 63443 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 `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 = 57040 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.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 `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 = 50117 AND t.round = 18 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 = 56775 AND t.round = 5 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 = 44175 AND t.round = 30 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 `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 = 39128 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 34132 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15818 AND t.round = 34 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 `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 = 4828 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 12479 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 2873 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 14259 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 = 14260 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 2595 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 2594 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 247 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 10334 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 = 10335 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC