4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Brinje-Grosuplje
TEMPORADA 2023/2024
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Nafta Lendava Nafta 28 55 27 58
2 Primorje Primorje 28 45 25 56
3 ND Gorica ND Gorica 28 50 25 52
4 Brinje-Grosuplje Brinje-Grosu 28 50 30 51
5 Beltinci Beltinci 28 40 21 50
6 Triglav Kranj Triglav 28 43 29 48
7 Bistrica iz Slovenske Bistrica 28 41 42 41
8 Rudar Velenje Rudar 28 33 44 36
9 NK Tolmin NK Tolmin 28 33 44 32
10 ND Bilje ND Bilje 28 41 50 31
11 Dekani Dekani 28 30 36 30
12 ND Dravinja Kostroj Dravinja 28 27 42 30
13 Ilirija 1911 Ilirija 1911 28 29 42 28
14 NK Krka NK Krka 28 34 49 27
15 Tabor Sežana Tabor 28 36 58 26
16 Fužinar Fužinar 28 30 53 24
TEMPORADA 2022/2023
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 NK Rogaška NK Rogaška 30 52 23 68
2 Aluminij Aluminij 30 58 23 64
3 Ilirija 1911 Ilirija 1911 30 55 30 54
4 NK Krka NK Krka 30 46 28 53
5 Beltinci Beltinci 30 47 45 44
6 Nafta Lendava Nafta 30 50 43 41
7 Primorje Primorje 30 42 40 41
8 Brinje-Grosuplje Brinje-Grosu 30 30 37 38
9 Bistrica iz Slovenske Bistrica 30 39 40 37
10 ND Bilje ND Bilje 30 40 53 37
11 Dekani Dekani 30 27 29 35
12 Triglav Kranj Triglav 30 33 52 35
13 Rudar Velenje Rudar 30 41 51 32
14 Fužinar Fužinar 30 39 56 31
15 NK Krsko NK Krsko 30 36 59 24
16 Roltek Dob Roltek Dob 30 37 63 21
TEMPORADA 2021/2022
TERCERA ESLOVENIA 3. SNL GRUPO 2
Equipo PJ GF GC Puntos
1 Brinje-Grosuplje Brinje-Grosu 26 74 9 65
2 Šencur Šencur 26 72 21 57
3 Fama Vipava Fama Vipava 26 42 20 52
4 NK Tolmin NK Tolmin 26 57 25 51
5 MNK Izola MNK Izola 26 52 26 47
6 Šobec Lesce Šobec Lesce 26 36 28 39
7 ND Slovan Ljubljana Slovan 26 62 55 36
8 Škofja Loka Škofja Loka 26 25 38 31
9 Sava Kranj Sava Kranj 26 40 62 31
10 ND Adria Miren Adria Miren 26 34 47 27
11 NK Žiri NK Žiri 26 30 50 25
12 Brda Dobrovo Brda Dobrovo 26 27 59 22
13 Svoboda Ljubljana Svoboda 26 20 55 16
14 Postojna Postojna 26 25 101 10
TEMPORADA 2020/2021
TERCERA ESLOVENIA 3. SNL GRUPO 3
Equipo PJ GF GC Puntos
1 MNK Izola MNK Izola 6 11 3 16
2 Ilirija 1911 Ilirija 1911 6 16 4 15
3 Šencur Šencur 6 11 8 10
4 Brinje-Grosuplje Brinje-Grosu 6 12 10 7
5 Fama Vipava Fama Vipava 6 4 4 7
6 Postojna Postojna 6 5 14 3
7 Svoboda Ljubljana Svoboda 6 5 21 1
TEMPORADA 2019/2020
TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo PJ GF GC Puntos
1 Bled Hirter Bled Hirter 0 0 0 0
2 Arne Tabor 69 Arne Tabor 0 0 0 0
3 Kočevje Kočevje 0 0 0 0
4 Fama Vipava Fama Vipava 0 0 0 0
5 NK Tolmin NK Tolmin 0 0 0 0
6 MNK Izola MNK Izola 0 0 0 0
7 Brinje-Grosuplje Brinje-Grosu 0 0 0 0
8 Svoboda Ljubljana Svoboda 0 0 0 0
9 Ilirija 1911 Ilirija 1911 0 0 0 0
10 Šencur Šencur 0 0 0 0
11 Primorje Primorje 0 0 0 0
12 ND Adria Miren Adria Miren 0 0 0 0
13 NK Žiri NK Žiri 0 0 0 0
14 Sava Kranj Sava Kranj 0 0 0 0
TEMPORADA 2018/2019
TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo PJ GF GC Puntos
1 Bled Hirter Bled Hirter 27 62 21 63
2 Zagorje Zagorje 27 47 40 48
3 Ivančna Gorica Ivančna 27 48 40 44
4 Brinje-Grosuplje Brinje-Grosu 27 51 35 43
5 Arne Tabor 69 Arne Tabor 27 38 39 34
6 Svoboda Ljubljana Svoboda 27 44 52 32
7 Šencur Šencur 27 38 55 31
8 Zarica Kranj Zarica Kranj 27 44 49 29
9 Sava Kranj Sava Kranj 27 37 49 26
10 Komenda Komenda 27 32 61 20
TEMPORADA 2017/2018
TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo PJ GF GC Puntos
1 Bled Hirter Bled Hirter 26 61 22 60
2 Brinje-Grosuplje Brinje-Grosu 26 70 27 58
3 Arne Tabor 69 Arne Tabor 26 54 24 51
4 Zagorje Zagorje 26 56 26 49
5 Ivančna Gorica Ivančna 26 57 48 48
6 Šencur Šencur 26 60 35 42
7 Komenda Komenda 26 56 38 37
8 Sava Kranj Sava Kranj 26 40 41 36
9 SIJ Acroni Jesenice Acroni 26 51 42 35
10 Kolpa Kolpa 26 41 35 34
11 Kočevje Kočevje 26 34 63 22
12 Rudar Trbovlje Rudar 26 20 72 19
13 Šobec Lesce Šobec Lesce 26 25 83 14
14 Bohinj Bohinj 26 32 101 13
TEMPORADA 2016/2017
TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo PJ GF GC Puntos
1 NK Bravo NK Bravo 26 105 19 66
2 Ilirija 1911 Ilirija 1911 26 71 23 61
3 Bled Hirter Bled Hirter 26 58 27 56
4 Ivančna Gorica Ivančna 26 66 47 48
5 Zagorje Zagorje 26 39 23 43
6 Šencur Šencur 26 39 39 38
7 Komenda Komenda 26 39 38 34
8 Sava Kranj Sava Kranj 26 33 48 30
9 Brinje-Grosuplje Brinje-Grosu 26 35 46 29
10 Kolpa Kolpa 26 40 53 25
11 Rudar Trbovlje Rudar 26 40 59 24
12 Šobec Lesce Šobec Lesce 26 32 85 22
13 Velesovo Velesovo 26 26 51 18
14 Jevnica Jevnica 26 21 86 14
TEMPORADA 2015/2016
TERCERA ESLOVENIA 3. SNL GRUPO 1
Equipo PJ GF GC Puntos
1 Ilirija 1911 Ilirija 1911 26 73 19 59
2 NK Bravo NK Bravo 26 79 28 58
3 Ivančna Gorica Ivančna 26 45 13 55
4 Komenda Komenda 26 47 37 43
5 Sava Kranj Sava Kranj 26 45 40 43
6 Zagorje Zagorje 26 52 37 38
7 Kolpa Kolpa 26 36 39 38
8 Brinje-Grosuplje Brinje-Grosu 26 31 39 33
9 Bled Hirter Bled Hirter 26 36 37 32
10 Rudar Trbovlje Rudar 26 36 52 31
11 Šobec Lesce Šobec Lesce 26 28 45 29
12 NK Žiri NK Žiri 26 27 59 23
13 Jesenice Jesenice 26 19 52 19
14 Jezero Medvode Jezero 26 18 75 10
TEMPORADA 2002/2003
SEGUNDA ESLOVENIA 2. SNL
Equipo PJ GF GC Puntos
1 Domžale Domžale 30 81 28 74
2 NK Drava Ptuj Drava Ptuj 30 63 24 61
3 Aluminij Aluminij 30 67 37 57
4 Brinje-Grosuplje Brinje-Grosu 30 59 44 56
5 Bela Krajina Bela Krajina 30 52 39 47
6 Zagorje Zagorje 30 49 47 39
7 ND Dravinja Kostroj Dravinja 30 31 42 39
8 Triglav Kranj Triglav 30 40 42 38
9 MNK Izola MNK Izola 30 43 52 38
10 Dekani Dekani 30 38 43 37
11 Ivančna Gorica Ivančna 30 31 44 36
12 Brda Dobrovo Brda Dobrovo 30 36 51 35
13 NK Krsko NK Krsko 30 35 53 35
14 Nafta Lendava Nafta 30 40 61 30
15 Lesoplast Križevci Lesoplast 30 43 55 27
16 Železničar Maribor Železničar 30 23 69 18

  USO DE MEMORIA  
6,106,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1217
Total Execution Time  0.1229
  CADENA URL  
/historico/Brinje-Grosuplje
  GET DATOS  
$_GET['/historico/Brinje-Grosuplje']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0031  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 = 'Brinje-Grosuplje' 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.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=65958 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=65958 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=65958 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=65958 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73730
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65958 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=389 AND type_rel = 3
0.0027  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 = '65958' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '65958' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '65958' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72187 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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 = 73730 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=65958 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73730,72187,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72187 AND teamId = 65958
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73730 AND teamId = 65958
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65958
0.0031  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 = 72187 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '65958' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65958' and rp.type = 4
0.0020  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 = '65958' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 65958 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.0033  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 65958 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72187 WHERE rp.league_id = 72187 AND rp.teamId = 65958 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 65958 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72187 AND t.round = 28 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 `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 = 68064 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.0021  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 = 63891 AND t.round = 26 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 = 58348 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 62533 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 44613 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 38916 AND t.round = 26 ORDER BY team.conference 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 `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 = 33919 AND t.round = 26 ORDER BY team.conference 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 `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 = 15891 AND t.round = 26 ORDER BY team.conference 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 `tables2003` 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 = 23722 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 72187 ORDER BY nameShow LIMIT 100