4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Slovan Sabinov
TEMPORADA 2023/2024
CUARTA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Lokomotíva Košice Lokomotíva 24 88 20 62
2 Poprad Poprad 24 77 17 62
3 Spartak Medzev Spartak 24 64 24 53
4 Sokol Ľubotice Sokol 24 58 35 47
5 Kežmarok Kežmarok 24 45 27 45
6 Kechnec Kechnec 24 43 53 34
7 Slovan Sabinov Slovan 24 32 46 34
8 Gerlachov Gerlachov 24 47 47 33
9 Sobrance Sobrance 24 38 40 32
10 FK Čaňa FK Čaňa 24 46 40 30
11 Pavlovce nad Uhom Pavlovce 24 38 43 27
12 Spartak Medzilaborce Spartak 24 41 59 27
13 Raslavice Raslavice 24 47 51 25
14 Rudňany Rudňany 24 27 69 17
15 Pivovar Veľký Šariš Pivovar 24 18 82 12
16 Mladosť Kalša Mladosť 24 26 82 8
TEMPORADA 2022/2023
CUARTA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Stará Ľubovňa Stará 30 85 30 66
2 Spišské Podhradie Spišské 30 70 26 65
3 Spartak Medzev Spartak 30 76 45 64
4 Mladosť Kalša Mladosť 30 87 51 61
5 FK Čaňa FK Čaňa 30 56 47 58
6 Slovan Sabinov Slovan 30 56 32 55
7 Sokol Ľubotice Sokol 30 69 51 53
8 Kechnec Kechnec 30 77 48 51
9 Spartak Medzilaborce Spartak 30 58 46 43
10 Gerlachov Gerlachov 30 54 54 42
11 Pavlovce nad Uhom Pavlovce 30 52 70 32
12 Rudňany Rudňany 30 48 68 32
13 Raslavice Raslavice 30 38 67 31
14 Sobrance Sobrance 30 21 76 16
15 Pivovar Veľký Šariš Pivovar 30 20 79 16
16 Tatra Sokolany Tatra 30 12 89 6
TEMPORADA 2017/2018
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Odeva Lipany Odeva Lipany 30 60 16 67
2 Vyšné Opátske Vyšné 30 69 24 63
3 Vranov nad Topľou Vranov 30 70 27 63
4 Snina Snina 30 66 35 57
5 MSK Tesla Stropkov Tesla 30 44 29 54
6 Šarišské Michaľany Šarišské 30 41 31 46
7 Svidník Svidník 30 43 34 46
8 Roznava Roznava 30 44 41 44
9 Družstevník Plavnica Družstevní 30 41 44 41
10 Pokrok Krompachy Pokrok 30 48 54 41
11 Veľké Revištia Veľké 30 30 49 35
12 Tatran Prešov II Tatran 30 60 57 32
13 Milénium Milénium 30 32 58 30
14 Slovan Giraltovce Slovan 30 23 57 25
15 Svit Svit 30 22 78 21
16 Slovan Sabinov Slovan 30 26 85 13
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
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Spišská Nová Ves Spišská 30 65 30 56
2 Haniska Haniska 30 63 35 55
3 Odeva Lipany Odeva Lipany 30 37 30 52
4 Tatran Prešov II Tatran 30 47 27 50
5 Vranov nad Topľou Vranov 30 43 30 50
6 Vyšné Opátske Vyšné 30 52 44 47
7 Snina Snina 30 39 34 47
8 Veľké Revištia Veľké 30 40 49 43
9 Slovan Giraltovce Slovan 30 31 42 43
10 MSK Tesla Stropkov Tesla 30 47 38 42
11 Družstevník Plavnica Družstevní 30 35 39 39
12 Milénium Milénium 30 37 52 39
13 Slovan Sabinov Slovan 30 42 38 37
14 Futura Humenné Futura 30 31 60 36
15 Starý Smokovec Starý 30 43 45 33
16 Zemplin Michalovce II Zemplin 30 26 85 13

  USO DE MEMORIA  
5,558,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1160
Total Execution Time  0.1181
  CADENA URL  
/historico/Slovan-Sabinov
  GET DATOS  
$_GET['/historico/Slovan-Sabinov']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0048  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 = 'Slovan-Sabinov' 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.0021  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=61082 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=61082 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=61082 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0049  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 = 73412
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61082 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2728 AND type_rel = 3
0.0043  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 = '61082' ORDER BY l.year DESC,cat.coefficient DESC
0.0036  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 = '61082' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '61082' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0057  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.0028  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 = 73412 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  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=61082 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (73412,72674,67320) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73412 AND teamId = 61082
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 61082
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 61082
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 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 = 73412 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '61082' 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 = '61082' 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 = '61082' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73412 WHERE rp.league_id = 73412 AND rp.teamId = 61082 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.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 = 73412 WHERE rp.league_id = 73412 AND rp.teamId = 61082 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 73412 WHERE rp.league_id = 73412 AND rp.teamId = 61082 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 = 61082 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73412 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 `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 = 70545 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 `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 = 39127 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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.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 `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 = 9374 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 73412 ORDER BY nameShow LIMIT 100