4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lokomotíva Košice
TEMPORADA 2023/2024
CUARTA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Poprad Poprad 24 77 17 62
2 Lokomotíva Košice Lokomotíva 23 84 17 59
3 Spartak Medzev Spartak 23 62 22 52
4 Sokol Ľubotice Sokol 23 56 33 46
5 Kežmarok Kežmarok 24 45 27 45
6 Kechnec Kechnec 24 43 53 34
7 Gerlachov Gerlachov 23 46 45 33
8 Sobrance Sobrance 24 38 40 32
9 Slovan Sabinov Slovan 23 30 46 31
10 FK Čaňa FK Čaňa 23 43 36 30
11 Spartak Medzilaborce Spartak 24 41 59 27
12 Raslavice Raslavice 23 45 46 25
13 Pavlovce nad Uhom Pavlovce 23 33 41 24
14 Rudňany Rudňany 24 27 69 17
15 Pivovar Veľký Šariš Pivovar 23 16 81 9
16 Mladosť Kalša Mladosť 23 26 80 8
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
SEGUNDA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 FC VSS Kosice Kosice 12 12 20 61
2 Nitra Nitra 12 23 6 59
3 Skalica Skalica 12 19 9 58
4 Šamorín Šamorín 12 17 10 55
5 Žilina II Žilina II 12 37 20 51
6 Sered Sered 12 18 15 48
7 Lokomotíva Košice Lokomotíva 12 15 17 47
8 Pohronie Pohronie 12 20 16 46
9 Bardejov Bardejov 12 20 22 46
10 Liptovsky Mikulas Liptovsky 12 15 19 45
11 Lokomotiva Zvolen Lokomotiva 12 12 22 35
12 Spišská Nová Ves Spišská 12 2 34 28
TEMPORADA 2015/2016
SEGUNDA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tatran Prešov Tatran 10 15 8 58
2 Liptovsky Mikulas Liptovsky 10 20 11 56
3 FC VSS Kosice Kosice 10 12 8 56
4 Lokomotíva Košice Lokomotíva 10 22 12 54
5 Bardejov Bardejov 10 19 10 53
6 Pohronie Pohronie 12 9 15 51
7 Nitra Nitra 12 16 13 46
8 Žilina II Žilina II 12 13 14 41
9 Lokomotiva Zvolen Lokomotiva 10 5 12 39
10 Sered Sered 12 15 20 38
11 Slovan Bratislava II Slovan 12 8 31 31
12 Borčice Borčice 0 0 0 0
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

  USO DE MEMORIA  
5,911,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6816
Total Execution Time  0.6828
  CADENA URL  
/historico/Lokomotiva-Kosice
  GET DATOS  
$_GET['/historico/Lokomotiva-Kosice']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0155  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 = 'Lokomotiva-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.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=25027 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=25027 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=25027 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 = 73412
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.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25027 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2728 AND type_rel = 3
0.0151  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 = '25027' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '25027' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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.0147  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.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=25027 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73412 AND teamId = 25027
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 25027
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 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 = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0152  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 = 25027 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.0161  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 = 25027 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0166  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 = 25027 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 25027 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  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 = 24 ORDER BY team.conference ASC,t.position 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 `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.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 `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.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 `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 = 33684 AND t.round = 18 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 `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 = 38660 AND t.round = 12 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 `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 = 15806 AND t.round = 22 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 `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 = 23886 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0181  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.0153  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.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 `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.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 `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.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 `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.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 = 73412 ORDER BY nameShow LIMIT 100
0.0153  SELECT c.name,l.categoryId,l.group_code,c.CountryCode,c.alias FROM categories_besoccer c INNER JOIN leagues_besoccer l ON l.categoryId = c.id WHERE c.active_year = l.year AND c.location = 'sk' AND (c.ctype = 1) AND c.id != 2728 GROUP BY c.id ORDER BY c.troncal=1 DESC,c.coefficient DESC LIMIT 10
0.0146  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 2728 AND l.year = 2024 ORDER BY l.group_code ASC