4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Slavoj Trebišov

Slavoj Trebišov

Entrenador: Ondrej Desiatnik

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Komárno Komárno 27 57 21 64
2 Tatran Prešov Tatran 27 50 19 59
3 FC Petržalka Petržalka 27 57 27 57
4 Považská Bystrica Považská 27 46 33 46
5 Humenné Humenné 27 39 30 44
6 Púchov Púchov 27 47 45 42
7 Žilina II Žilina II 27 54 54 39
8 Spartak Myjava Spartak 27 38 39 39
9 Pohronie Pohronie 27 40 46 35
10 Liptovsky Mikulas Liptovsky 27 45 47 33
11 Slovan Bratislava II Slovan 27 40 50 32
12 Slavoj Trebišov Slavoj 27 32 44 32
13 Šamorín Šamorín 27 43 53 31
14 Malženice Malženice 27 33 45 24
15 Dolný Kubín Dolný 27 22 60 17
16 Spišská Nová Ves Spišská 27 18 48 10
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 1
Equipo PJ GF GC Puntos
1 MFK Dukla MFK Dukla 18 41 20 41
2 Dubnica Dubnica 18 39 24 38
3 Skalica Skalica 18 33 19 35
4 Poprad Poprad 17 26 16 31
5 Žilina II Žilina II 18 38 29 31
6 Podbrezová Podbrezová 18 26 26 28
7 Liptovsky Mikulas Liptovsky 18 28 30 26
8 Púchov Púchov 18 22 24 24
9 Ružomberok II Ružomberok 18 23 36 22
10 FK Košice FK Košice 17 22 18 21
11 Bardejov Bardejov 18 19 23 21
12 Šamorín Šamorín 18 24 31 21
13 Komárno Komárno 18 19 28 20
14 FC Petržalka Petržalka 18 24 34 17
15 Slovan Bratislava II Slovan 18 16 31 17
16 Slavoj Trebišov Slavoj 18 23 34 15
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
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Sered Sered 30 73 25 66
2 Skalica Skalica 30 46 27 62
3 Poprad Poprad 30 45 25 52
4 Lokomotíva Košice Lokomotíva 30 50 35 51
5 Žilina II Žilina II 30 71 41 49
6 Komárno Komárno 30 49 58 43
7 Šamorín Šamorín 30 38 34 42
8 Inter Bratislava Inter 30 45 46 41
9 Pohronie Pohronie 30 41 35 38
10 Slavoj Trebišov Slavoj 30 27 44 37
11 Liptovsky Mikulas Liptovsky 30 38 39 36
12 Bardejov Bardejov 30 39 47 35
13 Nove Mesto Nad Vahom Nove Mesto. 30 33 57 32
14 Spišská Nová Ves Spišská 30 32 60 30
15 Lokomotiva Zvolen Lokomotiva 30 26 53 28
16 Podbrezová II Podbrezová 30 24 51 26
TEMPORADA 2016/2017
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Slavoj Trebišov Slavoj 27 65 12 65
2 Vyšné Opátske Vyšné 27 63 21 59
3 Svit Svit 27 57 35 45
4 Svidník Svidník 27 46 37 45
5 Snina Snina 27 51 30 42
6 Vranov nad Topľou Vranov 27 36 31 41
7 Slovan Giraltovce Slovan 27 41 30 39
8 Družstevník Plavnica Družstevní 27 42 43 37
9 Milénium Milénium 27 43 55 35
10 Slovan Sabinov Slovan 27 40 44 32
11 Veľké Revištia Veľké 27 36 43 30
12 MSK Tesla Stropkov Tesla 27 38 42 29
13 Tatran Prešov II Tatran 27 37 48 24
14 Družstevník Veľký Horeš Družstevní 14 23 19 21
15 Rozvoj Pušovce Rozvoj 27 7 135 4
16 Krásna Krásna 0 0 0 0
TEMPORADA 2015/2016
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Krásna Krásna 30 65 18 74
2 Odeva Lipany Odeva Lipany 30 54 17 67
3 Vyšné Opátske Vyšné 30 63 21 64
4 MSK Tesla Stropkov Tesla 30 47 48 47
5 Vranov nad Topľou Vranov 30 34 31 46
6 Slavoj Trebišov Slavoj 30 38 53 41
7 Slovan Sabinov Slovan 30 38 38 40
8 Milénium Milénium 30 49 42 39
9 Veľké Revištia Veľké 30 29 31 39
10 Slovan Giraltovce Slovan 30 38 43 38
11 Družstevník Plavnica Družstevní 30 28 37 36
12 Futura Humenné Futura 30 37 44 33
13 Snina Snina 30 32 42 33
14 Tatran Prešov II Tatran 30 36 49 33
15 Rozvoj Pušovce Rozvoj 30 29 44 32
16 Bodva Moldava Bodva 30 27 86 13
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
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Baník Ruziná Baník 30 71 38 62
2 Žilina II Žilina II 30 60 35 60
3 Dolný Kubín Dolný 30 46 30 54
4 Poprad Poprad 30 46 31 49
5 Bodva Moldava Bodva 30 51 36 47
6 Fomat Martin Fomat Martin 30 43 32 45
7 Košice II Košice II 30 51 38 44
8 Lokomotíva Košice Lokomotíva 30 36 33 43
9 Slavoj Trebišov Slavoj 30 38 49 43
10 Futura Humenné Futura 30 37 54 42
11 Tatran Prešov II Tatran 30 32 31 39
12 Námestovo Námestovo 30 34 34 35
13 Kremnička Kremnička 30 26 40 30
14 Odeva Lipany Odeva Lipany 30 32 55 29
15 Vranov nad Topľou Vranov 30 30 58 27
16 Milénium Milénium 30 27 66 21
TEMPORADA 2012/2013
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Pohronie Pohronie 30 50 24 60
2 Poprad Poprad 30 40 30 51
3 Lokomotíva Košice Lokomotíva 30 37 30 47
4 Slavoj Trebišov Slavoj 30 52 46 45
5 Odeva Lipany Odeva Lipany 30 38 32 44
6 Námestovo Námestovo 30 42 34 43
7 Bodva Moldava Bodva 30 29 30 43
8 Dukla II Dukla II 30 30 28 42
9 Košice II Košice II 30 47 51 42
10 Vranov nad Topľou Vranov 30 41 36 41
11 Kremnička Kremnička 30 42 46 40
12 Futura Humenné Futura 30 42 40 39
13 Fomat Martin Fomat Martin 30 40 51 38
14 Tatran Prešov II Tatran 30 38 50 36
15 Spišská Nová Ves Spišská 30 37 47 32
16 LAFC Lučenec LAFC 30 25 55 28
TEMPORADA 2011/2012
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bardejov Bardejov 30 56 27 67
2 Baník Ruziná Baník 30 85 34 62
3 Lokomotíva Košice Lokomotíva 30 65 23 62
4 Tatran Prešov II Tatran 30 58 42 50
5 Dukla II Dukla II 30 57 38 49
6 Sokol Dolna Zdana Sokol Dolna 30 46 37 49
7 Vranov nad Topľou Vranov 30 39 45 44
8 Spišská Nová Ves Spišská 30 44 32 43
9 Odeva Lipany Odeva Lipany 30 51 45 43
10 Košice II Košice II 31 53 54 42
11 Poprad Poprad 30 36 32 41
12 Námestovo Námestovo 31 34 49 38
13 Bodva Moldava II Bodva 30 45 61 37
14 Slavoj Trebišov Slavoj 30 41 54 34
15 Kremnička Kremnička 30 37 51 30
16 Lokomotiva Zvolen Lokomotiva 30 31 59 29
17 Stará Ľubovňa Stará 30 12 107 2
TEMPORADA 2010/2011
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Podbrezová II Podbrezová 30 49 15 64
2 Bardejov Bardejov 30 50 27 62
3 Baník Ruziná Baník 30 62 43 53
4 Spišská Nová Ves Spišská 30 50 38 53
5 Poprad Poprad 30 40 38 44
6 Žilina II Žilina II 30 41 41 44
7 Sokol Dolna Zdana Sokol Dolna 30 46 39 43
8 Tatran Prešov II Tatran 30 49 44 43
9 Odeva Lipany Odeva Lipany 30 33 25 42
10 Dukla II Dukla II 30 41 36 40
11 Vranov nad Topľou Vranov 30 43 46 36
12 Košice II Košice II 30 38 47 36
13 Lokomotiva Zvolen Lokomotiva 30 29 41 33
14 Slavoj Trebišov Slavoj 30 26 41 32
15 Stará Ľubovňa Stará 30 20 60 29
16 Futura Humenné Futura 30 21 57 22
TEMPORADA 2009/2010
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bodva Moldava Bodva 30 63 22 64
2 Vranov nad Topľou Vranov 30 56 27 58
3 Podbrezová II Podbrezová 30 50 21 52
4 Odeva Lipany Odeva Lipany 30 43 25 51
5 Tatran Prešov II Tatran 30 48 40 51
6 Slavoj Trebišov Slavoj 30 39 37 47
7 Poprad Poprad 30 39 43 45
8 Dukla II Dukla II 30 40 46 44
9 Spišská Nová Ves Spišská 30 39 43 40
10 Žilina II Žilina II 30 40 44 36
11 Lokomotiva Zvolen Lokomotiva 30 35 38 35
12 Futura Humenné Futura 30 24 38 34
13 Košice II Košice II 30 40 53 30
14 Stará Ľubovňa Stará 30 30 53 25
15 Banská Bystrica Banská 30 31 58 24
16 Čadca Čadca 30 25 54 22
TEMPORADA 2008/2009
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
TEMPORADA 2007/2008
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Tatran Prešov Tatran 33 64 14 77
2 Podbrezová Podbrezová 33 49 34 55
3 Inter Bratislava Inter 33 49 40 53
4 LAFC Lučenec LAFC 33 53 45 51
5 Sobota Sobota 33 40 32 50
6 Baník Horná Nitra Baník 33 46 56 43
7 Slovan Duslo Sala Slovan Duslo 33 41 46 41
8 Košice II Košice II 33 41 47 37
9 Zemplin Michalovce Zemplin 33 33 43 37
10 Futura Humenné Futura 33 30 37 36
11 Slavoj Trebišov Slavoj 33 31 60 34
12 Stará Ľubovňa Stará 33 35 58 30
TEMPORADA 2004/2005
SEGUNDA ESLOVAQUIA
Equipo PJ GF GC Puntos
1 Nitra Nitra 30 59 16 69
2 Steel Trans Licartovce Steel Trans 30 66 26 60
3 Slovan Bratislava Slovan 30 37 24 48
4 Zemplin Michalovce Zemplin 30 43 34 47
5 Tatran Prešov Tatran 30 38 33 44
6 Slovan Duslo Sala Slovan Duslo 30 34 32 43
7 DAC DAC 30 35 46 43
8 Vel'ký Lapás Vel'ký 30 41 34 42
9 Podbrezová Podbrezová 30 28 22 41
10 Senec Senec 30 40 37 41
11 Zlaté Moravce Zlaté 30 34 37 38
12 Družstevník Báč Družstevní 29 35 43 38
13 Rapid Bratislava Rapid 30 37 50 30
14 Baník Horná Nitra Baník 29 26 54 29
15 Slavoj Trebišov Slavoj 30 26 52 26
16 Kremnička Kremnička 30 24 63 18

  USO DE MEMORIA  
7,171,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8576
Total Execution Time  0.8588
  CADENA URL  
/historico/Slavoj-Trebisov
  GET DATOS  
$_GET['/historico/Slavoj-Trebisov']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0157  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 = 'Slavoj-Trebisov' 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=25025 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=25025 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=25025 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=25025 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 72189
0.0153  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 = 72674
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25025 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=388 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 388 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0150  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) ORDER BY n.cover_points DESC, update_date DESC
0.0173  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 = '25025' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0171  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 = '25025' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0198  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 = 72674 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 72189 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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=25025 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (72674,72189,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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 72189 AND teamId = 25025
0.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 25025
0.0168  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 25025
0.0165  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72189 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0212  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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 25025 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.0213  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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 25025 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0199  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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 25025 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 = 25025 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72189 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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 `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.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 `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.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 `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 = 39124 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 `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 = 34131 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 = 15815 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 `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 = 4829 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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.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 `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 = 24443 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 = 24452 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 24459 AND t.round = 32 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 `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 = 24474 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 `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 = 24479 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24486 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 14264 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 14267 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72189 ORDER BY nameShow LIMIT 100