4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rudes Sub 19
TEMPORADA 2023/2024
LIGA CROATA SUB 19
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Sub 19 Dinamo 22 59 21 57
2 Lokomotiva Zagreb Sub 19 Lokomotiva 24 52 30 49
3 Hajduk Split Sub 19 Hajduk Split 23 44 25 49
4 Osijek Sub 19 Osijek 24 47 30 46
5 NK Varazdin Sub 19 Varazdin 25 51 40 36
6 Rijeka Sub 19 Rijeka 24 50 35 34
7 Rudes Sub 19 Rudes 25 42 39 34
8 Mladost Zdralovi Sub 19 Mladost 25 31 39 34
9 Istra 1961 Sub 19 Istra 1961 24 35 38 31
10 NK Kustošija Sub 19 Kustošija 24 38 49 31
11 NK Sesvete Sub 19 Sesvete 24 37 39 30
12 NK Slaven Belupo Sub 19 Slaven 24 44 46 29
13 HNK Gorica Sub 19 Gorica 24 27 38 26
14 HNK Sibenik Sub 19 Sibenik 24 28 49 21
15 NK Dugopolje Sub 19 Dugopolje 24 25 52 19
16 HNK Cibalia Sub 19 Cibalia 24 20 60 14
TEMPORADA 2022/2023
LIGA CROATA SUB 19
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Sub 19 Dinamo 30 87 24 74
2 Hajduk Split Sub 19 Hajduk Split 30 70 22 72
3 Rijeka Sub 19 Rijeka 30 50 31 61
4 HNK Gorica Sub 19 Gorica 30 50 37 49
5 Lokomotiva Zagreb Sub 19 Lokomotiva 30 54 37 48
6 Rudes Sub 19 Rudes 30 51 44 45
7 NK Varazdin Sub 19 Varazdin 30 53 49 44
8 Osijek Sub 19 Osijek 30 44 40 44
9 Istra 1961 Sub 19 Istra 1961 30 48 56 41
10 NK Slaven Belupo Sub 19 Slaven 30 37 39 35
11 Mladost Zdralovi Sub 19 Mladost 30 31 54 35
12 NK Dugopolje Sub 19 Dugopolje 30 36 59 34
13 HNK Sibenik Sub 19 Sibenik 30 41 52 31
14 NK Sesvete Sub 19 Sesvete 30 31 49 30
15 HNK Cibalia Sub 19 Cibalia 30 28 65 19
16 Inker Sub 19 Inker 30 21 74 14
TEMPORADA 2021/2022
LIGA CROATA SUB 19
Equipo PJ GF GC Puntos
1 Hajduk Split Sub 19 Hajduk Split 30 76 16 73
2 Dinamo Zagreb Sub 19 Dinamo 30 62 20 71
3 HNK Gorica Sub 19 Gorica 30 63 28 62
4 Lokomotiva Zagreb Sub 19 Lokomotiva 30 64 33 62
5 Rijeka Sub 19 Rijeka 30 56 37 52
6 Rudes Sub 19 Rudes 30 47 45 44
7 NK Varazdin Sub 19 Varazdin 30 49 47 43
8 Istra 1961 Sub 19 Istra 1961 30 49 47 37
9 Osijek Sub 19 Osijek 30 56 55 37
10 NK Dugopolje Sub 19 Dugopolje 30 40 47 34
11 NK Sesvete Sub 19 Sesvete 30 41 61 33
12 NK Slaven Belupo Sub 19 Slaven 30 31 46 30
13 Inker Sub 19 Inker 30 30 50 30
14 HNK Sibenik Sub 19 Sibenik 30 30 55 28
15 Orijent Rijeka Sub 19 Orijent 30 21 52 28
16 Bjelovar Sub 19 Bjelovar 30 17 93 8
TEMPORADA 2020/2021
LIGA CROATA SUB 19
Equipo PJ GF GC Puntos
1 Hajduk Split Sub 19 Hajduk Split 26 81 13 73
2 Dinamo Zagreb Sub 19 Dinamo 26 63 25 58
3 Lokomotiva Zagreb Sub 19 Lokomotiva 26 57 31 54
4 Osijek Sub 19 Osijek 26 47 38 41
5 Rijeka Sub 19 Rijeka 26 40 30 41
6 NK Varazdin Sub 19 Varazdin 26 49 58 34
7 NK Dugopolje Sub 19 Dugopolje 26 35 36 31
8 NK Slaven Belupo Sub 19 Slaven 26 34 41 31
9 NK Sesvete Sub 19 Sesvete 26 46 67 29
10 Rudes Sub 19 Rudes 26 26 38 29
11 Istra 1961 Sub 19 Istra 1961 26 33 44 27
12 Inker Sub 19 Inker 26 36 63 26
13 Orijent Rijeka Sub 19 Orijent 26 23 57 23
14 Hrvatski Dragovoljac Sub 19 Hrvatski 26 23 52 19
TEMPORADA 2019/2020
LIGA CROATA SUB 19
Equipo PJ GF GC Puntos
1 Hajduk Split Sub 19 Hajduk Split 16 49 12 41
2 Dinamo Zagreb Sub 19 Dinamo 15 31 9 37
3 Lokomotiva Zagreb Sub 19 Lokomotiva 16 41 16 34
4 Rijeka Sub 19 Rijeka 16 34 24 26
5 NK Varazdin Sub 19 Varazdin 16 20 14 26
6 Osijek Sub 19 Osijek 16 32 24 24
7 NK Slaven Belupo Sub 19 Slaven 16 30 30 23
8 Rudes Sub 19 Rudes 16 22 26 23
9 Inker Sub 19 Inker 16 24 39 20
10 NK Sesvete Sub 19 Sesvete 16 18 32 18
11 Istra 1961 Sub 19 Istra 1961 16 21 32 15
12 Hrvatski Dragovoljac Sub 19 Hrvatski 16 22 33 13
13 NK Dugopolje Sub 19 Dugopolje 15 9 35 9
14 Orijent Rijeka Sub 19 Orijent 16 9 36 8
TEMPORADA 2018/2019
LIGA CROATA SUB 19
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Sub 19 Dinamo 26 55 23 62
2 Lokomotiva Zagreb Sub 19 Lokomotiva 26 50 24 56
3 Hajduk Split Sub 19 Hajduk Split 26 77 22 55
4 Rijeka Sub 19 Rijeka 26 58 27 53
5 Inker Sub 19 Inker 26 44 42 38
6 NK Varazdin Sub 19 Varazdin 26 39 45 38
7 Osijek Sub 19 Osijek 26 40 33 36
8 Istra 1961 Sub 19 Istra 1961 26 24 36 31
9 NK Slaven Belupo Sub 19 Slaven 26 38 47 30
10 NK Sesvete Sub 19 Sesvete 26 35 44 30
11 Hrvatski Dragovoljac Sub 19 Hrvatski 26 39 60 30
12 NK Dugopolje Sub 19 Dugopolje 26 20 38 21
13 Rudes Sub 19 Rudes 26 23 51 21
14 NK Zagreb Sub 19 Zagreb 26 11 61 7
TEMPORADA 2017/2018
LIGA CROATA SUB 19
Equipo PJ GF GC Puntos
1 Dinamo Zagreb Sub 19 Dinamo 22 51 19 51
2 Hajduk Split Sub 19 Hajduk Split 22 62 29 50
3 Rijeka Sub 19 Rijeka 22 59 29 45
4 Inker Sub 19 Inker 22 48 34 40
5 Osijek Sub 19 Osijek 22 42 29 40
6 NK Slaven Belupo Sub 19 Slaven 22 47 39 33
7 Lokomotiva Zagreb Sub 19 Lokomotiva 22 36 43 26
8 NK Sesvete Sub 19 Sesvete 22 30 42 22
9 Hrvatski Dragovoljac Sub 19 Hrvatski 22 18 61 19
10 Rudes Sub 19 Rudes 22 24 45 18
11 Istra 1961 Sub 19 Istra 1961 22 28 49 17
12 HNK Cibalia Sub 19 Cibalia 22 12 38 14

  USO DE MEMORIA  
5,529,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0842
Total Execution Time  0.0854
  CADENA URL  
/historico/Rudes-Sub19
  GET DATOS  
$_GET['/historico/Rudes-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0040  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 = 73455
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138804 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 3
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 = '138804' 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 = 73455 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=138804 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73455) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73455 AND teamId = 138804
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 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 = 73455 AND t.round = 26 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 = '138804' 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 = '138804' 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 = '138804' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 73455 WHERE rp.league_id = 73455 AND rp.teamId = 138804 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.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 = 73455 WHERE rp.league_id = 73455 AND rp.teamId = 138804 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 73455 WHERE rp.league_id = 73455 AND rp.teamId = 138804 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 138804 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73455 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.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 `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 = 68694 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.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 `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 = 63914 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.0030  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 = 59194 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.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 `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 = 59199 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.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 `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 = 59200 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 `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 = 59201 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC