4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Aalborg Sub 15
TEMPORADA 2023/2024
LIGA DANESA SUB 15
Equipo PJ GF GC Puntos
1 Brøndby Sub 15 Brøndby 17 72 20 40
2 Odense Sub 15 Odense 19 41 21 39
3 Randers Freja Sub 15 Randers 19 46 32 33
4 Aalborg Sub 15 Aalborg 18 40 30 33
5 Lyngby Sub 15 Lyngby 19 41 39 32
6 København Sub 15 København 18 57 39 31
7 Vejle Sub 15 Vejle 18 45 41 28
8 Esbjerg Sub 15 Esbjerg 19 38 34 28
9 Farum Sub 15 Farum 18 39 32 27
10 SønderjyskE Sub 15 SønderjyskE 19 39 54 21
11 Midtjylland Sub 15 Midtjylland 19 29 46 18
12 AGF Sub 15 AGF Sub 15 19 32 57 18
13 Horsens Sub 15 Horsens 19 36 77 11
14 Silkeborg Sub 15 Silkeborg 19 35 68 8
TEMPORADA 2022/2023
LIGA DANESA SUB 15
Equipo PJ GF GC Puntos
1 København Sub 15 København 25 76 38 61
2 Odense Sub 15 Odense 26 81 40 60
3 Brøndby Sub 15 Brøndby 26 70 49 54
4 Farum Sub 15 Farum 26 70 45 52
5 Aalborg Sub 15 Aalborg 26 81 57 49
6 Vejle Sub 15 Vejle 26 55 48 39
7 AGF Sub 15 AGF Sub 15 26 49 53 39
8 Lyngby Sub 15 Lyngby 26 62 67 39
9 Silkeborg Sub 15 Silkeborg 26 55 62 33
10 Randers Freja Sub 15 Randers 26 45 65 33
11 Midtjylland Sub 15 Midtjylland 25 57 73 28
12 Esbjerg Sub 15 Esbjerg 26 47 65 21
13 Horsens Sub 15 Horsens 26 42 96 18
14 SønderjyskE Sub 15 SønderjyskE 26 46 78 15
TEMPORADA 2021/2022
LIGA DANESA SUB 15
Equipo PJ GF GC Puntos
1 Farum Sub 15 Farum 26 71 22 60
2 Odense Sub 15 Odense 26 77 29 54
3 Brøndby Sub 15 Brøndby 26 70 37 49
4 Midtjylland Sub 15 Midtjylland 26 76 57 46
5 Silkeborg Sub 15 Silkeborg 25 67 52 44
6 Randers Freja Sub 15 Randers 26 45 55 43
7 København Sub 15 København 26 60 50 40
8 Lyngby Sub 15 Lyngby 25 62 50 30
9 AGF Sub 15 AGF Sub 15 26 44 62 29
10 Aalborg Sub 15 Aalborg 26 49 60 28
11 Vejle Sub 15 Vejle 25 41 60 27
12 Esbjerg Sub 15 Esbjerg 25 40 60 27
13 SønderjyskE Sub 15 SønderjyskE 26 46 91 22
14 Horsens Sub 15 Horsens 26 28 91 17
TEMPORADA 2020/2021
LIGA DANESA SUB 15
Equipo PJ GF GC Puntos
1 Odense Sub 15 Odense 26 102 31 65
2 Brøndby Sub 15 Brøndby 26 82 26 64
3 København Sub 15 København 26 67 40 56
4 Farum Sub 15 Farum 26 83 42 52
5 AGF Sub 15 AGF Sub 15 26 63 47 45
6 Midtjylland Sub 15 Midtjylland 26 70 48 41
7 Aalborg Sub 15 Aalborg 26 48 56 34
8 SønderjyskE Sub 15 SønderjyskE 26 48 60 33
9 Lyngby Sub 15 Lyngby 26 46 60 33
10 Silkeborg Sub 15 Silkeborg 26 63 76 29
11 Esbjerg Sub 15 Esbjerg 26 45 88 20
12 Horsens Sub 15 Horsens 26 28 76 20
13 Randers Freja Sub 15 Randers 26 27 65 16
14 Vejle Sub 15 Vejle 26 31 88 10
TEMPORADA 2019/2020
LIGA DANESA SUB 15
Equipo PJ GF GC Puntos
1 Farum Sub 15 Farum 12 42 11 34
2 Brøndby Sub 15 Brøndby 13 38 15 26
3 København Sub 15 København 13 47 28 25
4 Midtjylland Sub 15 Midtjylland 14 38 30 24
5 Lyngby Sub 15 Lyngby 14 34 26 24
6 Vejle Sub 15 Vejle 12 35 20 21
7 Odense Sub 15 Odense 13 33 26 20
8 Randers Freja Sub 15 Randers 14 25 33 18
9 AGF Sub 15 AGF Sub 15 14 34 40 15
10 Aalborg Sub 15 Aalborg 14 20 27 14
11 Esbjerg Sub 15 Esbjerg 14 24 49 9
12 Silkeborg Sub 15 Silkeborg 13 24 55 9
13 SønderjyskE Sub 15 SønderjyskE 14 20 54 7

  USO DE MEMORIA  
5,164,992 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0912
Total Execution Time  0.0925
  CADENA URL  
/historico/Aalborg-Sub15
  GET DATOS  
$_GET['/historico/Aalborg-Sub15']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0041  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 = 72841
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=122581 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2168 AND type_rel = 3
0.0024  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 = '122581' 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 = 72841 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=122581 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 (72841) 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.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 72841 AND teamId = 122581
0.0040  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 = 72841 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '122581' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '122581' 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 = '122581' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0050  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 = 72841 WHERE rp.league_id = 72841 AND rp.teamId = 122581 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.0044  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 = 72841 WHERE rp.league_id = 72841 AND rp.teamId = 122581 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72841 WHERE rp.league_id = 72841 AND rp.teamId = 122581 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 = 122581 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 `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 = 72841 AND t.round = 19 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 `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 = 68374 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.0033  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 = 63900 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.0035  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 = 57442 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.0029  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 = 51573 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