4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atvidaberg Sub 19
TEMPORADA 2020/2021
LIGA SUECA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 IFK Göteborg Sub 19 Göteborg 28 68 24 64
2 Halmstad Sub 19 Halmstad 28 63 23 63
3 Malmö FF Sub 19 Malmö 28 75 34 62
4 Häcken Sub 19 Häcken 28 69 39 53
5 Helsingborgs Sub 19 Helsingborgs 28 65 37 52
6 Öster Sub 19 Öster 28 57 39 51
7 Elfsborg Sub 19 Elfsborg 28 58 32 49
8 Örgryte Sub 19 Örgryte 28 53 53 36
9 Mjallby Sub 19 Mjallby 28 41 47 33
10 Kalmar Sub 19 Kalmar 28 51 58 31
11 Jönköpin Sub 19 Jönköpin 28 34 64 28
12 Trelleborgs Sub 19 Trelleborgs 28 39 69 26
13 Ängelholms Sub 19 Ängelholms 28 31 84 23
14 GAIS Sub 19 GAIS Sub 19 28 25 64 14
15 Atvidaberg Sub 19 Atvidaberg 28 20 82 13
TEMPORADA 2018/2019
LIGA SUECA SUB 19 GRUPO 3
Equipo PJ GF GC Puntos
1 Mjallby Sub 19 Mjallby 12 24 10 23
2 Halmstad Sub 19 Halmstad 12 23 15 22
3 Örgryte Sub 19 Örgryte 12 36 23 21
4 Trelleborgs Sub 19 Trelleborgs 12 25 24 16
5 Värnamo Sub 19 Värnamo 12 16 21 14
6 Atvidaberg Sub 19 Atvidaberg 12 20 24 13
7 Ängelholms Sub 19 Ängelholms 12 16 43 9
TEMPORADA 2017/2018
LIGA SUECA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Hammarby Sub 19 Hammarby 13 55 12 34
2 Brommapojkarna Sub 19 Brommapojkar 13 40 17 29
3 Djurgården Sub 19 Djurgården 13 32 20 26
4 AIK Sub 19 AIK Sub 19 13 27 22 22
5 Täby Sub 19 Täby 13 28 20 19
6 Örebro Sub 19 Örebro 13 23 24 19
7 Vasalund Sub 19 Vasalund 13 24 28 19
8 Sirius Sub 19 Sirius 13 26 29 17
9 GIF Sundsvall Sub 19 Sundsvall 13 22 28 14
10 Skovde AIK Sub 19 Skovde 13 27 40 14
11 Lidingö Sub 19 Lidingö 13 19 29 13
12 Djursholm Sub 19 Djursholm 13 22 38 10
13 Sollentuna Sub 19 Sollentuna 13 14 38 10
14 Atvidaberg Sub 19 Atvidaberg 13 22 36 9
TEMPORADA 2016/2017
LIGA SUECA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Brommapojkarna Sub 19 Brommapojkar 26 82 27 66
2 Täby Sub 19 Täby 26 58 32 51
3 AIK Sub 19 AIK Sub 19 26 51 39 46
4 Hammarby Sub 19 Hammarby 26 54 40 42
5 Djursholm Sub 19 Djursholm 26 57 49 37
6 Djurgården Sub 19 Djurgården 26 51 45 36
7 Vasalund Sub 19 Vasalund 26 54 60 35
8 Lidingö Sub 19 Lidingö 26 37 47 32
9 Örebro Sub 19 Örebro 26 60 56 31
10 GIF Sundsvall Sub 19 Sundsvall 26 40 55 31
11 Atvidaberg Sub 19 Atvidaberg 26 52 74 28
12 Sollentuna Sub 19 Sollentuna 26 51 48 27
13 Gefle Sub 19 Gefle 26 35 72 22
14 Assyriska Sub 19 Assyriska 26 38 76 21
TEMPORADA 2015/2016
LIGA SUECA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Brommapojkarna Sub 19 Brommapojkar 26 76 22 63
2 Hammarby Sub 19 Hammarby 26 75 27 62
3 Djurgården Sub 19 Djurgården 26 59 33 54
4 Jönköpin Sub 19 Jönköpin 26 62 46 50
5 AIK Sub 19 AIK Sub 19 26 57 53 44
6 Täby Sub 19 Täby 26 65 55 38
7 Sollentuna Sub 19 Sollentuna 26 47 50 38
8 GIF Sundsvall Sub 19 Sundsvall 26 58 42 36
9 Örebro Sub 19 Örebro 26 63 56 36
10 Vasalund Sub 19 Vasalund 26 56 66 32
11 Gefle Sub 19 Gefle 26 38 53 30
12 Atvidaberg Sub 19 Atvidaberg 26 47 74 26
13 Degerfos Sub 19 Degerfos 26 36 89 11
14 Älvsjö Sub 19 Älvsjö 26 21 94 7
TEMPORADA 2014/2015
LIGA SUECA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Djurgården Sub 19 Djurgården 26 80 17 66
2 Kalmar Sub 19 Kalmar 26 63 20 61
3 Brommapojkarna Sub 19 Brommapojkar 26 82 27 59
4 Hammarby Sub 19 Hammarby 26 65 25 51
5 AIK Sub 19 AIK Sub 19 26 61 42 41
6 Örebro Sub 19 Örebro 26 68 51 40
7 GIF Sundsvall Sub 19 Sundsvall 26 52 65 35
8 Täby Sub 19 Täby 26 60 55 34
9 Gefle Sub 19 Gefle 26 42 49 32
10 Älvsjö Sub 19 Älvsjö 26 39 56 26
11 Atvidaberg Sub 19 Atvidaberg 26 37 76 26
12 Vasalund Sub 19 Vasalund 26 49 75 25
13 Assyriska Sub 19 Assyriska 26 35 65 23
14 Syrianska FC Sub 19 Syrianska 26 10 120 3

  USO DE MEMORIA  
5,276,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.4299
Total Execution Time  0.4316
  CADENA URL  
/historico/Atvidaberg-Sub19
  GET DATOS  
$_GET['/historico/Atvidaberg-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0255  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 = 61226
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62644 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1712 AND type_rel = 3
0.0127  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 = '62644' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = '62644' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 61226 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=62644 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0129  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 (61226) 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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 61226 AND teamId = 62644
0.0135  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 61226 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '62644' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62644' and rp.type = 4
0.0127  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 = '62644' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0133  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 events2021 e ON e.player_id = p.id AND e.league_id = 61226 WHERE rp.league_id = 61226 AND rp.teamId = 62644 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.0137  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 events2021 e ON e.player_id = p.id AND e.league_id = 61226 WHERE rp.league_id = 61226 AND rp.teamId = 62644 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 events2021 e ON e.player_id = p.id AND e.league_id = 61226 WHERE rp.league_id = 61226 AND rp.teamId = 62644 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 62644 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 61226 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.0128  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 = 49530 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 51455 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 44025 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 38230 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 20426 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 10870 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 61226 ORDER BY nameShow LIMIT 100