4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Šamorín
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 49 19 57
3 FC Petržalka Petržalka 26 53 25 54
4 Považská Bystrica Považská 26 42 31 43
5 Humenné Humenné 26 38 29 43
6 Púchov Púchov 27 47 45 42
7 Žilina II Žilina II 26 52 50 39
8 Spartak Myjava Spartak 26 35 38 36
9 Pohronie Pohronie 27 40 46 35
10 Liptovsky Mikulas Liptovsky 26 43 43 33
11 Slavoj Trebišov Slavoj 27 32 43 33
12 Slovan Bratislava II Slovan 26 39 47 32
13 Šamorín Šamorín 27 43 53 31
14 Malženice Malženice 26 32 44 23
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
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
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 2011/2012
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Slovan Duslo Sala Slovan Duslo 28 62 25 59
2 Šamorín Šamorín 28 48 21 52
3 Nove Mesto Nad Vahom Nove Mesto. 28 45 36 51
4 Sered Sered 28 45 28 48
5 Spartak Vráble Spartak 28 43 35 41
6 Slovan Bratislava II Slovan 28 49 45 41
7 Spartak Trnava II Spartak 28 60 55 39
8 Dunajská Lužná Dunajská 28 29 39 39
9 Vrbové Vrbové 28 27 40 36
10 Nové Zámky Nové Zámky 28 34 34 34
11 Nitra II Nitra II 28 39 43 34
12 Pezinok Pezinok 28 23 35 34
13 OSK Moravany nad Váhom Moravany 28 32 52 30
14 Slovan Nemsova Slovan 28 38 52 29
15 Topoľčany Topoľčany 28 29 63 18
16 Púchov Púchov 0 0 0 0
TEMPORADA 2010/2011
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Myjava Spartak 30 63 14 67
2 Slovan Nemsova Slovan 30 55 23 60
3 Spartak Vráble Spartak 30 38 36 52
4 Nove Mesto Nad Vahom Nove Mesto. 30 55 33 51
5 Nitra II Nitra II 30 51 45 47
6 Slovan Bratislava II Slovan 30 45 32 46
7 Vrbové Vrbové 30 38 39 45
8 Spartak Trnava II Spartak 30 47 42 41
9 Nové Zámky Nové Zámky 30 37 47 37
10 Topoľčany Topoľčany 30 36 46 37
11 OSK Moravany nad Váhom Moravany 30 31 51 37
12 Pezinok Pezinok 30 33 43 36
13 Šamorín Šamorín 30 45 39 35
14 FK Rača FK Rača 30 32 59 29
15 Jaslovské Bohunice Jaslovské 30 35 64 27
16 Bernolákovo Bernolákovo 30 31 59 25

  USO DE MEMORIA  
6,542,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.8604
Total Execution Time  0.8624
  CADENA URL  
/historico/Samorin
  GET DATOS  
$_GET['/historico/Samorin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25023 AND type_rel = 2
0.0149  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 = '25023' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0149  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=25023 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72189 AND teamId = 25023
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 25023
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 25023
0.0453  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 = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.2799  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 = '25023' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '25023' and rp.type = 4
0.0147  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 = '25023' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0168  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 = 25023 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.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 = 72189 WHERE rp.league_id = 72189 AND rp.teamId = 25023 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 25023 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 25023 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 27 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 `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.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 `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.0149  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.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 `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.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 `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.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 `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.0149  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 = 33685 AND t.round = 22 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 = 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.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 `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.0149  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.0147  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.0149  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 = 24468 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 `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 = 24476 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC