4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Slávia TU Košice
TEMPORADA 2023/2024
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Stará Ľubovňa Stará 23 49 31 43
2 MSK Tesla Stropkov Tesla 22 44 24 41
3 Snina Snina 22 46 34 40
4 Odeva Lipany Odeva Lipany 23 40 29 39
5 FTC Filakovo Filakovo 22 34 30 38
6 Sobota Sobota 23 38 29 35
7 Vranov nad Topľou Vranov 23 50 42 34
8 Novohrad Lučenec Novohrad 24 31 37 33
9 Slávia TU Košice Slávia 22 40 37 32
10 Baník Kalinovo Baník 23 41 42 30
11 Námestovo Námestovo 23 35 42 30
12 Spišské Podhradie Spišské 24 37 42 27
13 Oravské Veselé Oravské 23 27 40 23
14 Bardejov Bardejov 23 27 51 19
15 Svidník Svidník 22 26 55 16
TEMPORADA 2022/2023
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Spišská Nová Ves Spišská 30 68 21 71
2 Odeva Lipany Odeva Lipany 30 69 28 69
3 Vranov nad Topľou Vranov 30 58 25 62
4 Snina Snina 30 54 42 47
5 Sobota Sobota 30 58 58 47
6 Oravské Veselé Oravské 30 48 38 45
7 Slávia TU Košice Slávia 30 52 44 44
8 Bardejov Bardejov 30 46 44 41
9 MSK Tesla Stropkov Tesla 30 45 55 36
10 Svidník Svidník 30 33 48 33
11 FTC Filakovo Filakovo 30 38 55 31
12 Novohrad Lučenec Novohrad 30 23 34 30
13 Baník Kalinovo Baník 30 38 60 30
14 Poprad Poprad 30 33 50 28
15 Slovan Giraltovce Slovan 30 19 53 27
16 Námestovo Námestovo 30 26 53 26
TEMPORADA 2021/2022
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Tatran Prešov Tatran 30 103 20 77
2 Spišská Nová Ves Spišská 30 76 25 67
3 Odeva Lipany Odeva Lipany 30 86 23 66
4 MSK Tesla Stropkov Tesla 30 76 26 61
5 Slávia TU Košice Slávia 30 68 35 56
6 Vranov nad Topľou Vranov 30 59 40 53
7 Snina Snina 30 58 41 48
8 Poprad Poprad 30 42 37 46
9 Mladosť Kalša Mladosť 30 52 80 36
10 Slovan Giraltovce Slovan 30 35 47 35
11 Svidník Svidník 30 39 81 29
12 Spišské Podhradie Spišské 30 26 76 28
13 Sobrance Sobrance 30 37 64 27
14 Raslavice Raslavice 30 35 70 23
15 Rudňany Rudňany 30 40 99 15
16 Pokrok Krompachy Pokrok 30 23 91 13
TEMPORADA 2020/2021
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Humenné Humenné 15 53 9 43
2 Odeva Lipany Odeva Lipany 15 42 10 37
3 Tatran Prešov Tatran 15 40 15 31
4 Slávia TU Košice Slávia 15 37 21 31
5 Vranov nad Topľou Vranov 15 26 20 31
6 Mladosť Kalša Mladosť 15 45 26 25
7 MSK Tesla Stropkov Tesla 15 29 26 22
8 Spišská Nová Ves Spišská 15 23 23 21
9 Družstevník Plavnica Družstevní 15 22 25 21
10 Snina Snina 15 23 23 17
11 Spišské Podhradie Spišské 15 23 38 14
12 Slovan Giraltovce Slovan 15 11 30 13
13 Veľké Revištia Veľké 15 15 39 13
14 Pokrok Krompachy Pokrok 15 18 42 12
15 Svidník Svidník 15 10 46 8
16 Milénium Milénium 15 15 39 6

  USO DE MEMORIA  
5,323,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4667
Total Execution Time  0.4679
  CADENA URL  
/historico/Slavia-Tu-Kosice
  GET DATOS  
$_GET['/historico/Slavia-Tu-Kosice']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0154  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 = 'Slavia-Tu-Kosice' 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.0128  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=89585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=89585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=89585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=89585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 73417
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=89585 AND type_rel = 2
0.0129  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 = '89585' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '89585' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '89585' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 73417 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=89585 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73417,72674,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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73417 AND teamId = 89585
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 89585
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 89585
0.0131  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 = '89585' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '89585' and rp.type = 4
0.0135  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 = '89585' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 = 73417 WHERE rp.league_id = 73417 AND rp.teamId = 89585 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.0142  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 = 73417 WHERE rp.league_id = 73417 AND rp.teamId = 89585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 73417 WHERE rp.league_id = 73417 AND rp.teamId = 89585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 89585 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 = 73417 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.0143  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 = 68510 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.0133  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 = 63447 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.0131  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 = 57293 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