4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SFC Kalinkovo
TEMPORADA 2022/2023
CUARTA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Rovinka Rovinka 29 81 25 74
2 FC Malacky FC Malacky 29 60 17 68
3 Slovan Ivanka pri Dunaji Slovan 29 73 31 63
4 Tomášov Tomášov 29 56 36 48
5 Rusovce Rusovce 29 40 34 45
6 MŠK Senec MŠK Senec 29 31 24 42
7 Slovan Most Slovan Most 29 36 41 37
8 Domino Bratislava Domino 29 34 42 36
9 Nová Dedinka Nová 29 28 37 36
10 Pezinok Pezinok 29 28 46 32
11 Dunajská Lužná Dunajská 29 27 43 31
12 Rohoznik Rohoznik 29 29 51 30
13 Bernolákovo Bernolákovo 29 33 48 28
14 NMSK 1922 Bratislava NMSK 1922 B. 29 27 49 28
15 SFC Kalinkovo Kalinkovo 29 21 48 24
16 Jarovce Bratislava Jarovce 29 34 66 18
TEMPORADA 2021/2022
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 FK Rača FK Rača 30 93 31 75
2 Slovan Ivanka pri Dunaji Slovan 30 63 23 72
3 Inter Bratislava Inter 30 79 18 69
4 Rusovce Rusovce 30 61 31 60
5 Rovinka Rovinka 30 57 26 58
6 Vrakuňa Vrakuňa 30 61 49 52
7 FC Malacky FC Malacky 30 47 38 52
8 MŠK Senec MŠK Senec 30 35 48 37
9 Tomášov Tomášov 30 43 46 35
10 Pezinok Pezinok 30 39 51 32
11 Dunajská Lužná Dunajská 30 35 56 32
12 Bernolákovo Bernolákovo 30 31 56 29
13 Nová Dedinka Nová 30 29 73 21
14 Slovan Most Slovan Most 30 23 62 20
15 SFC Kalinkovo Kalinkovo 30 25 62 19
16 Lokomotiva DNV Lokomotiva 30 19 70 18
TEMPORADA 2020/2021
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Rohoznik Rohoznik 15 32 6 37
2 Inter Bratislava Inter 15 53 21 31
3 FK Rača FK Rača 15 37 19 31
4 Rovinka Rovinka 15 34 19 27
5 FC Malacky FC Malacky 15 28 14 27
6 Slovan Ivanka pri Dunaji Slovan 15 26 23 22
7 MŠK Senec MŠK Senec 14 19 27 22
8 Tomášov Tomášov 15 20 35 22
9 Pezinok Pezinok 15 32 30 21
10 Slovan Most Slovan Most 15 24 32 20
11 Bernolákovo Bernolákovo 15 24 24 19
12 Dunajská Lužná Dunajská 14 18 27 14
13 Lokomotiva DNV Lokomotiva 15 13 38 12
14 Báhoň Báhoň 15 17 27 11
15 SFC Kalinkovo Kalinkovo 15 22 38 10
16 Rusovce Rusovce 15 15 34 9
TEMPORADA 2019/2020
TERCERA ESLOVAQUIA GRUPO 4
Equipo PJ GF GC Puntos
1 Dunajská Lužná Dunajská 15 44 11 37
2 Inter Bratislava Inter 15 46 16 35
3 FK Rača FK Rača 15 36 25 31
4 Slovan Most Slovan Most 15 24 14 29
5 FC Malacky FC Malacky 15 25 20 25
6 Rohoznik Rohoznik 15 35 18 24
7 MŠK Senec MŠK Senec 15 26 27 23
8 Rovinka Rovinka 15 23 31 20
9 Slovan Ivanka pri Dunaji Slovan 15 25 26 18
10 Bernolákovo Bernolákovo 15 17 29 17
11 Rusovce Rusovce 15 20 26 16
12 Lokomotiva DNV Lokomotiva 15 21 31 14
13 Báhoň Báhoň 15 12 27 13
14 SFC Kalinkovo Kalinkovo 15 18 36 12
15 Pezinok Pezinok 15 20 41 9
16 Tomášov Tomášov 15 12 26 8

  USO DE MEMORIA  
5,186,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4089
Total Execution Time  0.4101
  CADENA URL  
/historico/Sfc-Kalinkovo
  GET DATOS  
$_GET['/historico/Sfc-Kalinkovo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0134  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 = 'Sfc-Kalinkovo' 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.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=65854 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=65854 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65854 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1209 AND type_rel = 3
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 = '65854' 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 = '65854' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '65854' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132  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=65854 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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,70546) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 70546 AND teamId = 65854
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 65854
0.0129  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 = 72674 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0133  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 = '65854' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65854' and rp.type = 4
0.0138  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 = '65854' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 = 72674 WHERE rp.league_id = 72674 AND rp.teamId = 65854 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.0139  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 = 72674 WHERE rp.league_id = 72674 AND rp.teamId = 65854 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 72674 WHERE rp.league_id = 72674 AND rp.teamId = 65854 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 65854 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 70546 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.0146  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 = 63445 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.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 `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 = 57029 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 50486 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC