4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Elfsborg Sub 19

Elfsborg Sub 19

Entrenador: Mikael Johansson

Temporada 2019/2020
TEMPORADA 2019/2020
LIGA SUECA SUB 19 GRUPO 4
Equipo PJ GF GC Puntos
1 Häcken Sub 19 Häcken 2 5 1 6
2 Elfsborg Sub 19 Elfsborg 2 4 3 4
3 IFK Göteborg Sub 19 Göteborg 3 6 6 3
4 Halmstad Sub 19 Halmstad 3 3 7 3
5 Malmö FF Sub 19 Malmö 2 2 3 1
6 Örgryte Sub 19 Örgryte 2 3 0 6
7 Trelleborgs Sub 19 Trelleborgs 3 5 5 6
8 Öster Sub 19 Öster 2 5 2 4
9 Helsingborgs Sub 19 Helsingborgs 3 3 5 1
10 Kalmar Sub 19 Kalmar 2 1 5 0
11 Jönköpin Sub 19 Jönköpin 3 6 4 6
12 Mjallby Sub 19 Mjallby 3 4 3 5
13 Värnamo Sub 19 Värnamo 3 5 5 4
14 Norrby Sub 19 Norrby 3 4 7 1
TEMPORADA 2018/2019
LIGA SUECA SUB 19 GRUPO 5
Equipo PJ GF GC Puntos
1 Elfsborg Sub 19 Elfsborg 13 27 17 30
2 Brommapojkarna Sub 19 Brommapojkar 13 33 22 29
3 Malmö FF Sub 19 Malmö 13 57 29 28
4 Kalmar Sub 19 Kalmar 13 37 30 24
5 Hammarby Sub 19 Hammarby 13 34 18 22
6 Häcken Sub 19 Häcken 13 30 30 22
7 Djurgården Sub 19 Djurgården 13 26 24 21
8 AIK Sub 19 AIK Sub 19 13 25 25 18
9 Helsingborgs Sub 19 Helsingborgs 13 28 32 15
10 Norrköping Sub 19 Norrköping 13 28 34 12
11 GIF Sundsvall Sub 19 Sundsvall 13 23 32 11
12 IFK Göteborg Sub 19 Göteborg 13 14 26 8
13 Öster Sub 19 Öster 13 19 38 8
14 Sirius Sub 19 Sirius 13 15 39 7
TEMPORADA 2017/2018
LIGA SUECA SUB 19 GRUPO 1
Equipo PJ GF GC Puntos
1 Halmstad Sub 19 Halmstad 14 31 17 31
2 Malmö FF Sub 19 Malmö 14 47 18 30
3 Mjallby Sub 19 Mjallby 14 26 12 27
4 Häcken Sub 19 Häcken 13 32 20 27
5 Trelleborgs Sub 19 Trelleborgs 14 34 23 25
6 Elfsborg Sub 19 Elfsborg 15 25 28 25
7 IFK Göteborg Sub 19 Göteborg 13 22 12 24
8 Kalmar Sub 19 Kalmar 14 27 30 20
9 Örgryte Sub 19 Örgryte 13 21 23 18
10 Falkenberg Sub 19 Falkenberg 13 21 27 16
11 Öster Sub 19 Öster 13 21 33 13
12 Helsingborgs Sub 19 Helsingborgs 15 16 33 10
13 Ängelholms Sub 19 Ängelholms 13 15 37 9
14 GAIS Sub 19 GAIS Sub 19 14 14 39 3
TEMPORADA 2016/2017
LIGA SUECA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Elfsborg Sub 19 Elfsborg 26 65 23 59
2 IFK Göteborg Sub 19 Göteborg 26 63 30 51
3 Malmö FF Sub 19 Malmö 26 61 22 50
4 Kalmar Sub 19 Kalmar 26 61 32 50
5 Halmstad Sub 19 Halmstad 26 55 40 47
6 Häcken Sub 19 Häcken 26 80 47 46
7 Trelleborgs Sub 19 Trelleborgs 26 67 45 44
8 Mjallby Sub 19 Mjallby 26 51 48 43
9 Öster Sub 19 Öster 26 48 60 33
10 Ängelholms Sub 19 Ängelholms 26 42 61 28
11 Falkenberg Sub 19 Falkenberg 26 46 66 25
12 GAIS Sub 19 GAIS Sub 19 26 38 69 18
13 Lunds BK Sub 19 Lunds 26 24 76 11
14 Landskrona Sub 19 Landskrona 26 33 115 10
TEMPORADA 2015/2016
LIGA SUECA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Elfsborg Sub 19 Elfsborg 26 71 24 64
2 Malmö FF Sub 19 Malmö 26 82 29 57
3 Häcken Sub 19 Häcken 26 66 34 50
4 Kalmar Sub 19 Kalmar 26 66 40 46
5 IFK Göteborg Sub 19 Göteborg 26 55 35 40
6 Lunds BK Sub 19 Lunds 26 48 39 39
7 GAIS Sub 19 GAIS Sub 19 26 51 60 37
8 Halmstad Sub 19 Halmstad 26 55 55 34
9 Öster Sub 19 Öster 26 56 61 34
10 Landskrona Sub 19 Landskrona 26 45 66 32
11 Mjallby Sub 19 Mjallby 26 47 55 29
12 Ängelholms Sub 19 Ängelholms 26 39 56 28
13 Falkenberg Sub 19 Falkenberg 26 43 83 22
14 Trollhättan Sub 19 Trollhättan 26 16 103 8
TEMPORADA 2014/2015
LIGA SUECA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 IFK Göteborg Sub 19 Göteborg 26 76 37 55
2 Häcken Sub 19 Häcken 26 84 51 53
3 Elfsborg Sub 19 Elfsborg 26 71 37 51
4 Malmö FF Sub 19 Malmö 26 60 39 45
5 Halmstad Sub 19 Halmstad 26 54 39 44
6 Mjallby Sub 19 Mjallby 26 47 33 40
7 Öster Sub 19 Öster 26 46 45 38
8 GAIS Sub 19 GAIS Sub 19 26 46 44 35
9 Falkenberg Sub 19 Falkenberg 26 52 65 34
10 Landskrona Sub 19 Landskrona 26 50 59 31
11 Lunds BK Sub 19 Lunds 26 53 65 28
12 Trollhättan Sub 19 Trollhättan 26 37 62 24
13 Trelleborgs Sub 19 Trelleborgs 26 45 71 24
14 Kristianstad Sub 19 Kristianstad 26 29 103 11

  USO DE MEMORIA  
5,477,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.3766
Total Execution Time  0.3783
  CADENA URL  
/historico/Elfsborg-Sub19
  GET DATOS  
$_GET['/historico/Elfsborg-Sub19']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0285  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 = 51242
0.0153  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 = 55428
0.0152  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 = 59859
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62646 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 62646 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0125  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (41376) ORDER BY n.cover_points DESC, update_date DESC
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 = '62646' 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 = '62646' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 59859 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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 = 51242 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 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 = 51242 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0139  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 = 62646 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140  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 = 55428 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.0140  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 = 59859 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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.0132  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 = 51457 AND t.round = 13 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 = 44024 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 = 38231 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 = 20427 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 10871 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC