4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del AB Tårnby
TEMPORADA 2023/2024
SERIES DINAMARCA GRUPO 7
Equipo PJ GF GC Puntos
1 Ledøje-Smørum Fodbold Ledøje-Smø 18 37 33 25
2 Ringsted Ringsted 18 30 34 22
3 Herlev Herlev 18 28 31 21
4 Greve IF Greve IF 18 24 31 19
5 Næstved II Næstved II 18 34 40 19
6 AB Tårnby AB Tårnby 18 15 19 18
7 B 1908 B 1908 18 20 29 18
8 Slagelse B&I Slagelse 18 24 36 18
9 VB 1968 VB 1968 18 22 45 11
10 KFUM Roskilde KFUM 18 13 48 10
TEMPORADA 2022/2023
TERCERA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Young Boys FD Young Boys 32 60 29 59
2 Holstebro Holstebro 32 46 42 42
3 IF Lyseng IF Lyseng 32 53 55 41
4 SfB-Oure SfB-Oure 32 49 71 38
5 AB Tårnby AB Tårnby 32 41 74 28
6 Dalum Dalum 32 12 110 3
TEMPORADA 2021/2022
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 AB Tårnby AB Tårnby 27 58 31 60
2 Tårnby FF Tårnby FF 27 52 30 51
3 Holbæk Holbæk 27 58 36 45
4 KFUM KFUM 27 41 40 43
5 B 1908 B 1908 27 40 38 34
6 GVI GVI 27 41 44 34
7 Ledøje-Smørum Fodbold Ledøje-Smø 27 34 39 34
8 Køge Nord Køge Nord 27 36 62 29
9 Skovshoved Skovshoved 27 28 40 26
10 Ringsted Ringsted 27 32 60 17
TEMPORADA 2020/2021
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Nykøbing FC Nykøbing 26 60 22 62
2 Hellerup IK Hellerup IK 26 39 25 53
3 Akademisk Boldklub Akademisk 26 44 31 51
4 Næstved Næstved 26 48 31 43
5 Hillerød Hillerød 26 33 31 43
6 FA 2000 FA 2000 26 29 24 41
7 Roskilde Roskilde 26 39 33 39
8 Vanløse Vanløse 26 31 29 34
9 Slagelse B&I Slagelse 26 29 33 32
10 KFUM Roskilde KFUM 26 31 44 26
11 Skovshoved Skovshoved 26 30 43 24
12 Avarta Avarta 26 25 43 24
13 Brønshøj Brønshøj 26 34 50 23
14 AB Tårnby AB Tårnby 26 23 56 12
TEMPORADA 2019/2020
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 AB Tårnby AB Tårnby 14 31 14 32
2 Karlslunde Karlslunde 14 28 12 31
3 B 1908 B 1908 14 24 14 29
4 Ishøj Ishøj 14 37 21 28
5 GVI GVI 14 15 21 18
6 KFUM KFUM 14 17 25 17
7 Frederikssund IK Frederikssun 14 17 23 14
8 Avedøre Avedøre 14 15 32 12
9 BK Union BK Union 14 23 33 10
10 Greve IF Greve IF 14 14 26 8
TEMPORADA 2018/2019
SERIES DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Holbæk Holbæk 27 81 24 66
2 Herlev Herlev 27 70 39 50
3 Karlslunde Karlslunde 27 61 39 45
4 Avedøre Avedøre 27 38 38 43
5 GVI GVI 27 31 38 37
6 Ballerup-Skovlunde Ballerup-Sko 27 34 49 33
7 Skjold Birkerød Skjold 27 40 59 31
8 AB Tårnby AB Tårnby 27 30 51 28
9 Greve IF Greve IF 27 32 42 27
10 Taastrup FC Taastrup FC 27 26 64 18
TEMPORADA 2017/2018
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 GVI GVI 27 47 24 52
2 B 1908 B 1908 27 54 28 51
3 Vanløse Vanløse 27 47 19 49
4 AB Tårnby AB Tårnby 27 52 49 48
5 Fremad Valby Fremad Valby 27 43 30 44
6 Odsherred Odsherred 27 37 35 33
7 Skjold Birkerød Skjold 27 24 45 29
8 Avedøre Avedøre 27 32 57 26
9 KFUM Roskilde KFUM 27 30 50 23
10 Virum Sorgenfri Virum 27 26 55 22
TEMPORADA 2016/2017
SERIES DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Skovshoved Skovshoved 27 67 25 57
2 Ledoeje-Smoerum Ledoeje-Smoe 27 68 38 52
3 GVI GVI 27 47 28 47
4 AB Tårnby AB Tårnby 27 61 39 46
5 B 1908 B 1908 27 40 39 36
6 Avedøre Avedøre 27 35 47 31
7 Fremad Valby Fremad Valby 27 42 63 30
8 Karlslunde Karlslunde 27 28 54 29
9 Rishøj Rishøj 27 34 55 24
10 Herlufsholm Herlufsholm 27 27 61 20
TEMPORADA 2015/2016
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 HIK HIK 14 27 14 30
2 Hvidovre IF Hvidovre IF 14 19 12 23
3 Akademisk Boldklub Akademisk 14 17 13 23
4 Brønshøj Brønshøj 14 15 15 21
5 Avarta Avarta 14 19 16 20
6 Holbæk Holbæk 14 19 22 18
7 AB Tårnby AB Tårnby 14 16 30 11
8 B 1908 B 1908 14 18 28 10
TEMPORADA 2014/2015
SERIES DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 AB Tårnby AB Tårnby 26 51 19 64
2 Greve IF Greve IF 26 59 32 54
3 KFUM Roskilde KFUM 26 67 40 52
4 Jaegersborg BK Jaegersborg 26 50 26 50
5 Taastrup FC Taastrup FC 26 52 43 37
6 Vanløse Vanløse 26 39 35 37
7 Kastrup Kastrup 26 49 48 34
8 Fredensborg BI Fredensborg 26 45 40 32
9 Ballerup-Skovlunde Ballerup-Sko 26 37 37 31
10 Skjold Birkerød Skjold 26 39 51 30
11 SC Egedal SC Egedal 26 34 53 30
12 B 1903 B 1903 26 27 65 21
13 NB Bornholm NB Bornholm 26 24 55 17
14 Fremad Valby Fremad Valby 26 34 63 14
TEMPORADA 2013/2014
SERIES DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Avedøre Avedøre 26 64 34 51
2 Herlev Herlev 26 46 33 51
3 FA 2000 FA 2000 26 53 30 46
4 Fredensborg BI Fredensborg 26 41 28 44
5 AB Tårnby AB Tårnby 26 51 47 41
6 Ledøje-Smørum Fodbold Ledøje-Smø 26 52 40 40
7 B 1903 B 1903 26 40 45 37
8 Jaegersborg BK Jaegersborg 26 40 27 34
9 Ballerup-Skovlunde Ballerup-Sko 26 33 36 31
10 NB Bornholm NB Bornholm 26 28 37 31
11 BGA BGA 26 38 41 29
12 Virum Sorgenfri Virum 26 32 43 25
13 FC Oresund FC Oresund 26 33 60 21
14 Frederikssund IK Frederikssun 26 25 75 12
TEMPORADA 2010/2011
SERIES DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Skjold Birkerød Skjold 26 44 18 53
2 Fremad Amager Fremad 26 50 28 51
3 Svebølle Svebølle 26 45 29 50
4 Avedøre Avedøre 26 56 36 48
5 FC Oresund FC Oresund 26 52 27 41
6 Frederiksberg Boldklub Frederiksber 26 41 35 39
7 NB Bornholm NB Bornholm 26 40 42 39
8 B 1903 B 1903 26 52 45 37
9 GVI GVI 26 35 36 33
10 AB Tårnby AB Tårnby 26 35 40 27
11 Ledoeje-Smoerum Ledoeje-Smoe 26 36 52 27
12 Værløse Værløse 26 50 56 25
13 Jaegersborg BK Jaegersborg 26 24 50 20
14 Brøndby IF II Brøndby 26 12 78 8
TEMPORADA 2009/2010
SERIES DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Helsingør Helsingør 26 94 25 69
2 Frederikssund IK Frederikssun 26 52 30 45
3 Lyngby BK II Lyngby 26 55 35 43
4 Ballerup-Skovlunde Ballerup-Sko 26 32 25 41
5 Frederiksberg Boldklub Frederiksber 26 39 54 36
6 NB Bornholm NB Bornholm 26 42 37 35
7 GVI GVI 26 33 37 35
8 Værløse Værløse 26 45 49 33
9 B 1903 B 1903 26 27 40 33
10 AB Tårnby AB Tårnby 26 46 62 32
11 B 1921 B 1921 26 36 50 31
12 BK Frem 1886 II Frem 1886 26 39 41 28
13 Herfølge BK II Herfølge 26 40 57 24
14 Døllefjelde-Musse Døllefjelde 26 22 60 19

  USO DE MEMORIA  
6,096,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1130
Total Execution Time  0.1145
  CADENA URL  
/historico/Ab-Tarnby
  GET DATOS  
$_GET['/historico/Ab-Tarnby']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
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 = 72495
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12537 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=340 AND type_rel = 3
0.0025  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 = '12537' 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 = 75828 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=12537 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 (75828,72646,71482,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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71482 AND teamId = 12537
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75828 AND teamId = 12537
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 12537
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12537
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 = 75828 AND t.round = 4 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 = '12537' 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 = '12537' 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 = '12537' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 75828 WHERE rp.league_id = 75828 AND rp.teamId = 12537 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.0021  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 = 75828 WHERE rp.league_id = 75828 AND rp.teamId = 12537 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75828 WHERE rp.league_id = 75828 AND rp.teamId = 12537 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 12537 AND l.year <= 2024 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 `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 = 72495 AND t.round = 18 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 `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 = 68165 AND t.round = 22 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 = 71482 AND t.round = 10 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 = 63284 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 58310 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 `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 = 50402 AND t.round = 14 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 `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 = 44326 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 39095 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 34073 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 20329 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 16250 AND t.round = 14 ORDER BY team.conference 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 `tables2015` 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 = 4226 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables2014` 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 = 2772 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2011` 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 = 24326 AND t.round = 26 ORDER BY team.conference 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 `tables2010` 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 = 24330 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC