4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Malženice
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 50 19 59
3 FC Petržalka Petržalka 27 57 27 57
4 Považská Bystrica Považská 27 46 33 46
5 Humenné Humenné 27 39 30 44
6 Púchov Púchov 27 47 45 42
7 Žilina II Žilina II 27 54 54 39
8 Spartak Myjava Spartak 27 38 39 39
9 Pohronie Pohronie 27 40 46 35
10 Liptovsky Mikulas Liptovsky 27 45 47 33
11 Slovan Bratislava II Slovan 27 40 50 32
12 Slavoj Trebišov Slavoj 27 32 44 32
13 Šamorín Šamorín 27 43 53 31
14 Malženice Malženice 27 33 45 24
15 Dolný Kubín Dolný 27 22 60 17
16 Spišská Nová Ves Spišská 27 18 48 10
TEMPORADA 2022/2023
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Malženice Malženice 29 57 21 65
2 Sered Sered 29 55 22 57
3 Slovan Galanta Slovan 29 59 34 56
4 Beluša Beluša 29 65 29 55
5 OK Častkovce Častkovce 29 53 39 47
6 Nove Mesto Nad Vahom Nove Mesto. 29 42 43 42
7 Veľké Ludince Veľké 29 39 32 41
8 Podkonice Podkonice 29 39 31 39
9 Hamsik Academy Hamsik 29 34 32 38
10 Slovan Duslo Sala Slovan Duslo 29 45 49 38
11 Fomat Martin Fomat Martin 29 46 42 36
12 Bánová Bánová 29 48 48 35
13 Inter Bratislava Inter 29 34 44 31
14 Kalna nad Hronom Kalna Hronom 15 25 23 22
15 Nové Zámky Nové Zámky 29 20 92 10
16 Vrakuňa Vrakuňa 29 23 103 7
TEMPORADA 2021/2022
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Považská Bystrica Považská 34 90 27 85
2 Spartak Myjava Spartak 34 71 27 77
3 Beluša Beluša 34 60 28 72
4 Slovan Duslo Sala Slovan Duslo 34 76 35 61
5 Kalna nad Hronom Kalna Hronom 34 49 44 56
6 Malženice Malženice 34 62 44 53
7 OK Častkovce Častkovce 34 67 40 52
8 Slovan Galanta Slovan 34 52 45 50
9 Nove Mesto Nad Vahom Nove Mesto. 34 48 39 49
10 Veľké Ludince Veľké 34 52 51 46
11 Nové Zámky Nové Zámky 34 41 63 43
12 Marcelová Marcelová 34 40 45 40
13 Tj Imel Tj Imel 34 36 55 39
14 Lednické Rovne Lednické 34 31 53 34
15 Zlaté Moravce - Vrablé II Zlaté 34 35 84 29
16 Nitra II Nitra II 34 42 75 26
17 Slovan Levice Slovan 34 27 79 26
18 TEMPO Partizánske TEMPO 34 35 80 22
TEMPORADA 2020/2021
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Malženice Malženice 16 43 17 34
2 Spartak Myjava Spartak 15 27 11 33
3 Beluša Beluša 15 33 13 32
4 Zlaté Moravce - Vrablé II Zlaté 15 21 11 30
5 Považská Bystrica Považská 15 36 14 29
6 Slovan Duslo Sala Slovan Duslo 15 26 16 25
7 OK Častkovce Častkovce 15 20 19 23
8 Marcelová Marcelová 16 23 25 23
9 Nove Mesto Nad Vahom Nove Mesto. 15 17 20 20
10 Kalna nad Hronom Kalna Hronom 15 16 21 17
11 Tj Imel Tj Imel 15 11 17 14
12 Lednické Rovne Lednické 15 15 35 14
13 Nitra II Nitra II 15 24 35 12
14 Nové Zámky Nové Zámky 15 13 40 11
15 Slovan Galanta Slovan 15 12 25 10
16 Veľké Ludince Veľké 15 9 27 10
TEMPORADA 2019/2020
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Spartak Myjava Spartak 16 29 11 37
2 Považská Bystrica Považská 16 24 15 28
3 Marcelová Marcelová 16 20 15 27
4 Gabčíkovo Gabčíkovo 15 25 19 26
5 Lednické Rovne Lednické 16 25 25 26
6 Malženice Malženice 15 29 16 25
7 Beluša Beluša 16 22 15 23
8 Slovan Duslo Sala Slovan Duslo 16 23 21 22
9 Nitra II Nitra II 16 24 24 22
10 Zlaté Moravce - Vrablé II Zlaté 16 19 23 20
11 Veľké Ludince Veľké 16 19 20 19
12 Spartak Trnava II Spartak 16 20 23 19
13 Nove Mesto Nad Vahom Nove Mesto. 16 13 17 18
14 Slovan Galanta Slovan 16 20 22 17
15 Nové Zámky Nové Zámky 16 13 42 10
16 Kalna nad Hronom Kalna Hronom 16 15 32 9
TEMPORADA 2018/2019
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Beluša Beluša 28 48 21 57
2 MŠK Púchov MŠK Púchov 28 46 24 55
3 Malženice Malženice 29 64 30 52
4 Nitra II Nitra II 28 49 43 46
5 Gabčíkovo Gabčíkovo 28 50 36 43
6 Považská Bystrica Považská 28 51 41 42
7 Spartak Trnava II Spartak 28 47 46 41
8 Kalna nad Hronom Kalna Hronom 30 33 39 41
9 Slovan Duslo Sala Slovan Duslo 28 48 38 40
10 Lednické Rovne Lednické 29 34 33 39
11 Zlaté Moravce - Vrablé II Zlaté 28 37 41 34
12 Nove Mesto Nad Vahom Nove Mesto. 30 27 41 34
13 Veľké Ludince Veľké 28 29 41 31
14 Slovan Galanta Slovan 28 29 46 25
15 Nové Zámky Nové Zámky 28 23 95 10
16 Slovan Trenčianske T. Slovan 0 0 0 0

  USO DE MEMORIA  
5,764,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0890
Total Execution Time  0.0902
  CADENA URL  
/historico/Malzenice
  GET DATOS  
$_GET['/historico/Malzenice']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65825 AND type_rel = 2
0.0039  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 = '65825' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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.0034  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=65825 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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,68511) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 72189 AND teamId = 65825
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 68511 AND teamId = 65825
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 65825
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65825
0.0022  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 = '65825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65825' and rp.type = 4
0.0021  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 = '65825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0054  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 = 65825 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.0043  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 = 65825 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 65825 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 65825 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68511 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.0027  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 = 63446 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 57028 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.0024  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 = 50485 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 44373 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC