4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nagykanizsai ULE
TEMPORADA 2022/2023
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Veszprém Veszprém 38 82 24 92
2 Tatabánya Tatabánya 38 77 35 90
3 Nagykanizsai ULE Nagykanizsai 38 105 41 87
4 Puskás Akadémia II Puskás 38 77 35 70
5 III. Kerületi TVE III. 38 82 40 68
6 Erdi VSE Erdi VSE 38 55 33 65
7 Bicskei Bicskei 38 59 41 63
8 Kaposvari Rakoczi Kaposvari 38 58 44 60
9 Budaörsi Budaörsi 38 56 43 60
10 Balatonfüredi Balatonfüre 38 50 52 56
11 Fehérvár II Fehérvár 38 48 56 55
12 Komaromi Komaromi 38 57 53 53
13 Győri ETO II Győri 38 61 60 52
14 Gyirmót II Gyirmót II 38 65 83 39
15 Zalaegerszegi TE II Zalaegerszeg 38 45 83 38
16 Kelen Kelen 38 42 60 32
17 Csornai SE Csornai SE 38 42 85 27
18 Teskánd Teskánd 38 50 111 25
19 Móri SE Móri SE 38 35 93 21
20 Zsámbéki Zsámbéki 38 33 107 13
TEMPORADA 2021/2022
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Mosonmagyaróvári TE Mosonmagyar 38 114 20 100
2 Budapest BVSC Budapest 38 93 32 88
3 Veszprém Veszprém 38 69 29 80
4 Győri ETO II Győri 38 68 45 67
5 Puskás Akadémia II Puskás 38 65 39 66
6 Bicskei Bicskei 38 50 44 62
7 Pápai Perutz Pápai 38 49 41 59
8 Tatabánya Tatabánya 38 52 43 57
9 Kaposvari Rakoczi Kaposvari 38 50 46 53
10 Nagykanizsai ULE Nagykanizsai 38 60 67 53
11 Fehérvár II Fehérvár 38 47 54 52
12 Zalaegerszegi TE II Zalaegerszeg 38 59 63 48
13 Balatonfüredi Balatonfüre 38 54 67 47
14 Erdi VSE Erdi VSE 38 56 69 46
15 Kelen Kelen 38 43 52 42
16 Gyirmót II Gyirmót II 38 61 71 40
17 Komaromi Komaromi 38 55 73 35
18 Sopron Sopron 38 37 81 28
19 Gárdony Gárdony 38 35 72 22
20 Andráshida Andráshida 38 26 135 11
TEMPORADA 2020/2021
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 III. Kerületi TVE III. 38 91 22 88
2 Mosonmagyaróvári TE Mosonmagyar 38 79 35 74
3 Veszprém Veszprém 37 61 44 67
4 Nagykanizsai ULE Nagykanizsai 38 77 50 66
5 Tatabánya Tatabánya 37 56 39 61
6 Lipot SK Lipot SK 38 66 58 60
7 Sopron Sopron 38 56 50 60
8 Puskás Akadémia II Puskás 38 67 51 58
9 Komaromi Komaromi 38 52 59 56
10 Erdi VSE Erdi VSE 38 51 54 54
11 Balatonfüredi Balatonfüre 38 69 58 52
12 Bicskei Bicskei 38 42 50 50
13 Zalaegerszegi TE II Zalaegerszeg 38 56 64 49
14 Lombard Pápa TFC Lombard 38 48 56 48
15 Fehérvár II Fehérvár 38 52 58 47
16 BKV Előre BKV Előre 38 46 60 44
17 Gárdony Gárdony 38 58 82 44
18 Szabadkikoto Szabadkikoto 38 63 82 37
19 Ménfőcsanak Ménfőcsana 38 37 72 29
20 Nagyatádi FC Nagyatádi 38 32 115 12
TEMPORADA 2019/2020
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Erdi VSE Erdi VSE 19 40 16 42
2 III. Kerületi TVE III. 19 43 21 41
3 Lipot SK Lipot SK 19 33 21 39
4 Ménfőcsanak Ménfőcsana 19 25 22 30
5 Pápai Perutz Pápai 19 25 22 30
6 Komaromi Komaromi 19 29 23 29
7 Nagykanizsai ULE Nagykanizsai 19 25 27 28
8 Veszprém Veszprém 19 22 16 25
9 Mosonmagyaróvári TE Mosonmagyar 19 30 29 25
10 Bicskei Bicskei 19 20 24 22
11 Puskás Akadémia II Puskás 19 29 27 21
12 BKV Előre BKV Előre 19 21 27 20
13 Sárvári FC Sárvári 19 15 22 20
14 Videoton II Videoton II 19 17 25 20
15 Héviz FC Héviz FC 19 22 40 13
16 Balatonlelle SE Balatonlelle 19 13 47 10
TEMPORADA 2018/2019
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 FC Ajka FC Ajka 30 85 20 71
2 Erdi VSE Erdi VSE 30 59 40 59
3 Puskás Akadémia II Puskás 30 53 40 50
4 Komaromi Komaromi 30 51 42 49
5 III. Kerületi TVE III. 30 49 46 49
6 Nagykanizsai ULE Nagykanizsai 30 45 41 42
7 Ménfőcsanak Ménfőcsana 30 45 47 41
8 Pápai Perutz Pápai 30 50 46 40
9 BKV Előre BKV Előre 30 49 56 38
10 Penzugyor Penzugyor 30 40 50 33
11 Szabadkikoto Szabadkikoto 30 41 60 33
12 Sárvári FC Sárvári 30 26 33 32
13 Dunaharaszti MTK Dunaharaszti 30 36 56 32
14 Videoton II Videoton II 30 42 49 31
15 Csepel FC Csepel FC 30 26 54 30
16 Andráshida Andráshida 30 29 46 27

  USO DE MEMORIA  
5,354,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0819
Total Execution Time  0.0834
  CADENA URL  
/historico/Nagykanizsai-Ule
  GET DATOS  
$_GET['/historico/Nagykanizsai-Ule']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0024  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 = 'Nagykanizsai-Ule' 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.0029  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 = 'Nagykanizsai-Ule' 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.0017  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=103528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=103528 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=583 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 583 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0018  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (100827) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '103528' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = '103528' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 68427 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032  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 = 103528 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68427 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 63556 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 57111 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 50574 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.0022  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 = 44612 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC