4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Häcken

Häcken

Entrenador: Pal Arne Johansen

Temporada 2020/2021
TEMPORADA 2020/2021
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 58 30 59
2 AIK Solna AIK Solna 30 45 25 59
3 Djurgårdens IF Djurgårdens 30 46 30 57
4 IF Elfsborg IF Elfsborg 30 51 35 55
5 Hammarby IF Hammarby IF 30 54 41 53
6 Kalmar FF Kalmar FF 30 41 39 47
7 IFK Norrköping Norrköping 30 45 41 44
8 IFK Göteborg Göteborg 30 42 39 41
9 Mjällby AIF Mjällby 30 34 27 38
10 Varbergs BoIS Varbergs 30 35 38 37
11 IK Sirius IK Sirius 30 39 53 37
12 Häcken Häcken 30 46 46 36
13 Degerfors IF Degerfors 30 34 51 34
14 Halmstads Halmstads 30 21 26 32
15 Orebro SK Orebro SK 30 23 58 18
16 Östersunds FK Östersunds 30 24 59 14
TEMPORADA 2019/2020
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 64 30 60
2 IF Elfsborg IF Elfsborg 30 49 38 51
3 Häcken Häcken 30 45 29 49
4 Djurgårdens IF Djurgårdens 30 48 33 48
5 Mjällby AIF Mjällby 30 48 44 47
6 IFK Norrköping Norrköping 30 60 46 46
7 Orebro SK Orebro SK 30 37 41 42
8 Hammarby IF Hammarby IF 30 47 47 41
9 AIK Solna AIK Solna 30 30 33 39
10 IK Sirius IK Sirius 30 43 51 38
11 Varbergs BoIS Varbergs 30 45 44 37
12 IFK Göteborg Göteborg 30 35 41 34
13 Östersunds FK Östersunds 30 27 46 33
14 Kalmar FF Kalmar FF 30 30 49 28
15 Helsingborgs IF Helsingborgs 30 33 48 26
16 Falkenbergs Falkenbergs 30 33 54 24
TEMPORADA 2018/2019
LIGA SUECA
Equipo PJ GF GC Puntos
1 Djurgårdens IF Djurgårdens 30 53 19 66
2 Malmö FF Malmö FF 30 56 16 65
3 Hammarby IF Hammarby IF 30 75 38 65
4 AIK Solna AIK Solna 30 47 24 62
5 IFK Norrköping Norrköping 30 54 26 57
6 Häcken Häcken 30 44 29 49
7 IFK Göteborg Göteborg 30 46 31 48
8 IF Elfsborg IF Elfsborg 30 44 45 43
9 Orebro SK Orebro SK 30 40 56 33
10 Helsingborgs IF Helsingborgs 30 29 49 30
11 IK Sirius IK Sirius 30 34 51 29
12 Östersunds FK Östersunds 30 27 52 25
13 Falkenbergs Falkenbergs 30 25 62 25
14 Kalmar FF Kalmar FF 30 22 47 23
15 GIF Sundsvall Sundsvall 30 31 50 20
16 AFC Eskilstuna Eskilstuna 30 23 55 20
TEMPORADA 2017/2018
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 30 50 16 67
2 IFK Norrköping Norrköping 30 51 27 65
3 Malmö FF Malmö FF 30 57 29 58
4 Hammarby IF Hammarby IF 30 56 35 58
5 Häcken Häcken 30 58 27 53
6 Östersunds FK Östersunds 30 51 39 49
7 Djurgårdens IF Djurgårdens 30 40 31 48
8 GIF Sundsvall Sundsvall 30 47 35 44
9 Orebro SK Orebro SK 30 34 40 35
10 Kalmar FF Kalmar FF 30 27 35 34
11 IFK Göteborg Göteborg 30 38 53 31
12 IF Elfsborg IF Elfsborg 30 29 41 30
13 IK Sirius IK Sirius 30 37 61 30
14 Brommapojkarna Brommapojkar 30 25 64 26
15 Dalkurd FF Dalkurd FF 30 30 57 24
16 Trelleborgs FF Trelleborgs 30 24 64 15
TEMPORADA 2016/2017
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 63 27 64
2 AIK Solna AIK Solna 30 47 22 57
3 Djurgårdens IF Djurgårdens 30 54 30 53
4 Häcken Häcken 30 42 28 52
5 Östersunds FK Östersunds 30 48 32 50
6 IFK Norrköping Norrköping 30 45 40 48
7 IK Sirius IK Sirius 30 46 51 40
8 IF Elfsborg IF Elfsborg 30 53 59 39
9 Hammarby IF Hammarby IF 30 42 43 38
10 IFK Göteborg Göteborg 30 42 40 37
11 Orebro SK Orebro SK 30 38 54 36
12 Kalmar FF Kalmar FF 30 30 49 32
13 GIF Sundsvall Sundsvall 30 29 46 31
14 Jönköpings Södra Jönköpings 30 31 46 30
15 Halmstads Halmstads 30 29 45 24
16 AFC Eskilstuna Eskilstuna 30 28 55 20
TEMPORADA 2015/2016
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 60 26 66
2 AIK Solna AIK Solna 30 52 26 60
3 IFK Norrköping Norrköping 30 59 37 60
4 IFK Göteborg Göteborg 30 56 47 50
5 IF Elfsborg IF Elfsborg 30 58 38 48
6 Kalmar FF Kalmar FF 30 45 40 44
7 Djurgårdens IF Djurgårdens 30 48 47 43
8 Östersunds FK Östersunds 30 44 46 42
9 Orebro SK Orebro SK 30 48 51 41
10 Häcken Häcken 30 58 45 40
11 Hammarby IF Hammarby IF 30 46 49 39
12 Jönköpings Södra Jönköpings 30 32 39 35
13 GIF Sundsvall Sundsvall 30 38 54 30
14 Helsingborgs IF Helsingborgs 30 34 52 29
15 Gefle Gefle 30 34 56 27
16 Falkenbergs Falkenbergs 30 25 84 10
TEMPORADA 2014/2015
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 30 60 33 66
2 IFK Göteborg Göteborg 30 52 22 63
3 AIK Solna AIK Solna 30 54 34 61
4 IF Elfsborg IF Elfsborg 30 59 42 55
5 Malmö FF Malmö FF 30 54 34 54
6 Djurgårdens IF Djurgårdens 30 52 37 51
7 Häcken Häcken 30 45 39 45
8 Helsingborgs IF Helsingborgs 30 43 45 37
9 Orebro SK Orebro SK 30 36 50 37
10 Gefle Gefle 30 35 50 36
11 Hammarby IF Hammarby IF 30 35 39 33
12 GIF Sundsvall Sundsvall 30 34 52 32
13 Kalmar FF Kalmar FF 30 31 42 31
14 Falkenbergs Falkenbergs 30 38 56 25
15 Halmstads Halmstads 30 21 44 21
16 Åtvidabergs Åtvidabergs 30 25 55 15
TEMPORADA 2013/2014
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 59 31 62
2 IFK Göteborg Göteborg 30 58 34 56
3 AIK Solna AIK Solna 30 59 42 52
4 IF Elfsborg IF Elfsborg 30 40 31 52
5 Häcken Häcken 30 58 45 46
6 Orebro SK Orebro SK 30 54 44 46
7 Djurgårdens IF Djurgårdens 30 47 33 43
8 Åtvidabergs Åtvidabergs 30 39 46 43
9 Helsingborgs IF Helsingborgs 30 41 44 39
10 Halmstads Halmstads 30 44 50 39
11 Kalmar FF Kalmar FF 30 36 45 39
12 IFK Norrköping Norrköping 30 39 50 36
13 Falkenbergs Falkenbergs 30 37 49 33
14 Gefle Gefle 30 34 42 32
15 Mjällby AIF Mjällby 30 29 47 29
16 Brommapojkarna Brommapojkar 30 28 69 12
TEMPORADA 2012/2013
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 56 30 63
2 AIK Solna AIK Solna 30 54 32 58
3 IFK Göteborg Göteborg 30 49 31 54
4 Kalmar FF Kalmar FF 30 35 26 52
5 Helsingborgs IF Helsingborgs 30 61 41 49
6 IF Elfsborg IF Elfsborg 30 49 34 46
7 Djurgårdens IF Djurgårdens 30 38 44 44
8 Åtvidabergs Åtvidabergs 30 37 37 40
9 IFK Norrköping Norrköping 30 45 47 39
10 Häcken Häcken 30 37 41 37
11 Mjällby AIF Mjällby 30 46 47 36
12 Gefle Gefle 30 34 42 34
13 Brommapojkarna Brommapojkar 30 33 54 32
14 Halmstads Halmstads 30 32 46 31
15 Osters IF Osters IF 30 27 43 28
16 Syrianska FC Syrianska 30 26 64 14
TEMPORADA 2011/2012
LIGA SUECA
Equipo PJ GF GC Puntos
1 IF Elfsborg IF Elfsborg 30 48 29 59
2 Häcken Häcken 30 67 36 57
3 Malmö FF Malmö FF 30 49 33 56
4 AIK Solna AIK Solna 30 41 27 55
5 IFK Norrköping Norrköping 30 50 43 52
6 Helsingborgs IF Helsingborgs 30 52 33 50
7 IFK Göteborg Göteborg 30 36 41 39
8 Åtvidabergs Åtvidabergs 30 48 48 37
9 Djurgårdens IF Djurgårdens 30 37 40 37
10 Kalmar FF Kalmar FF 30 36 45 37
11 Gefle Gefle 30 26 37 36
12 Mjällby AIF Mjällby 30 33 39 34
13 Syrianska FC Syrianska 30 35 45 34
14 GIF Sundsvall Sundsvall 30 35 46 29
15 Orebro SK Orebro SK 30 32 46 24
16 GAIS GAIS 30 24 61 12
TEMPORADA 2010/2011
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 30 55 27 63
2 AIK Solna AIK Solna 30 46 27 58
3 IF Elfsborg IF Elfsborg 30 52 32 57
4 Malmö FF Malmö FF 30 37 30 54
5 GAIS GAIS 30 47 34 51
6 Häcken Häcken 30 52 32 49
7 IFK Göteborg Göteborg 30 42 34 45
8 Kalmar FF Kalmar FF 30 39 34 44
9 Gefle Gefle 30 31 39 41
10 Mjällby AIF Mjällby 30 33 39 40
11 Djurgårdens IF Djurgårdens 30 36 40 36
12 Orebro SK Orebro SK 30 36 45 36
13 IFK Norrköping Norrköping 30 32 49 34
14 Syrianska FC Syrianska 30 27 44 28
15 Trelleborgs FF Trelleborgs 30 39 64 25
16 Halmstads Halmstads 30 24 58 14
TEMPORADA 2009/2010
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 59 24 67
2 Helsingborgs IF Helsingborgs 30 49 26 65
3 Orebro SK Orebro SK 30 40 30 52
4 IF Elfsborg IF Elfsborg 30 55 40 47
5 Trelleborgs FF Trelleborgs 30 39 42 44
6 Mjällby AIF Mjällby 30 36 29 43
7 IFK Göteborg Göteborg 30 42 29 40
8 Häcken Häcken 30 40 42 40
9 Kalmar FF Kalmar FF 30 36 38 40
10 Djurgårdens IF Djurgårdens 30 35 42 40
11 AIK Solna AIK Solna 30 29 36 35
12 Halmstads Halmstads 30 31 42 35
13 GAIS GAIS 30 24 35 32
14 Gefle Gefle 30 33 46 29
15 Åtvidabergs Åtvidabergs 30 32 51 29
16 Brommapojkarna Brommapojkar 30 20 48 25
TEMPORADA 2008/2009
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 30 36 20 61
2 IFK Göteborg Göteborg 30 53 24 57
3 IF Elfsborg IF Elfsborg 30 43 34 55
4 Kalmar FF Kalmar FF 30 53 39 50
5 Häcken Häcken 30 43 30 48
6 Orebro SK Orebro SK 30 33 32 45
7 Malmö FF Malmö FF 30 40 25 43
8 Helsingborgs IF Helsingborgs 30 39 39 43
9 Trelleborgs FF Trelleborgs 30 41 34 41
10 Gefle Gefle 30 28 38 39
11 GAIS GAIS 30 41 38 35
12 Brommapojkarna Brommapojkar 30 32 46 34
13 Halmstads Halmstads 30 29 43 32
14 Djurgårdens IF Djurgårdens 30 24 49 29
15 Örgryte Örgryte 30 27 49 25
16 Hammarby IF Hammarby IF 30 22 44 22
TEMPORADA 2007/2008
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Örgryte Örgryte 30 57 32 57
2 Häcken Häcken 30 58 28 55
3 Brommapojkarna Brommapojkar 30 45 29 54
4 Assyriska FF Assyriska 30 49 34 54
5 Ängelholm Ängelholm 30 51 33 51
6 Åtvidabergs Åtvidabergs 30 43 37 50
7 Falkenbergs Falkenbergs 30 43 38 44
8 Mjällby AIF Mjällby 30 43 36 42
9 AFC Eskilstuna Eskilstuna 30 38 36 39
10 Qviding FIF Qviding FIF 30 39 41 38
11 Landskrona BoIS Landskrona 30 36 44 38
12 IK Sirius IK Sirius 30 38 53 33
13 Limhamn Bunkeflo IF Limhamn 30 26 48 26
14 Jönköpings Södra Jönköpings 30 26 50 26
15 Enköpings SK Enköpings 30 37 70 26
16 Degerfors IF Degerfors 30 27 47 24
TEMPORADA 2006/2007
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 30 62 29 63
2 Ljungskile Ljungskile 30 42 35 55
3 GIF Sundsvall Sundsvall 30 48 32 54
4 Häcken Häcken 30 51 30 53
5 Limhamn Bunkeflo IF Limhamn 30 49 49 48
6 Åtvidabergs Åtvidabergs 30 44 35 47
7 IK Sirius IK Sirius 30 53 50 43
8 Degerfors IF Degerfors 30 34 41 38
9 Mjällby AIF Mjällby 30 39 40 36
10 Örgryte Örgryte 30 40 52 36
11 Landskrona BoIS Landskrona 30 40 45 35
12 Enköpings SK Enköpings 30 25 38 35
13 Jönköpings Södra Jönköpings 30 35 47 34
14 Falkenbergs Falkenbergs 30 35 52 34
15 Osters IF Osters IF 30 28 35 32
16 Sylvia Sylvia 30 36 51 27
TEMPORADA 2005/2006
LIGA SUECA
Equipo PJ GF GC Puntos
1 IF Elfsborg IF Elfsborg 26 41 19 50
2 AIK Solna AIK Solna 26 46 23 49
3 Hammarby IF Hammarby IF 26 40 31 43
4 Helsingborgs IF Helsingborgs 26 44 34 42
5 Kalmar FF Kalmar FF 26 39 30 41
6 Djurgårdens IF Djurgårdens 26 31 25 40
7 Malmö FF Malmö FF 26 43 39 38
8 IFK Göteborg Göteborg 26 39 36 36
9 Gefle Gefle 26 28 39 31
10 GAIS GAIS 26 25 33 27
11 Halmstads Halmstads 26 22 30 27
12 Häcken Häcken 26 29 41 22
13 Osters IF Osters IF 26 19 46 19
14 Örgryte Örgryte 26 24 44 17
TEMPORADA 2004/2005
LIGA SUECA
Equipo PJ GF GC Puntos
1 Djurgårdens IF Djurgårdens 26 60 26 53
2 IFK Göteborg Göteborg 26 38 22 49
3 Kalmar FF Kalmar FF 26 36 21 43
4 Hammarby IF Hammarby IF 26 43 30 43
5 Malmö FF Malmö FF 26 38 27 41
6 Helsingborgs IF Helsingborgs 26 32 38 39
7 IF Elfsborg IF Elfsborg 26 35 43 37
8 Häcken Häcken 26 29 29 36
9 Örgryte Örgryte 26 37 38 35
10 Halmstads Halmstads 26 38 38 32
11 Gefle Gefle 26 27 33 31
12 Landskrona BoIS Landskrona 26 26 44 30
13 GIF Sundsvall Sundsvall 26 31 46 25
14 Assyriska FF Assyriska 26 17 52 14
TEMPORADA 2003/2004
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Häcken Häcken 30 60 31 65
2 Gefle Gefle 30 50 28 58
3 Assyriska FF Assyriska 30 48 39 54
4 IFK Norrköping Norrköping 30 58 37 50
5 Osters IF Osters IF 30 51 36 50
6 GAIS GAIS 30 45 40 49
7 Åtvidabergs Åtvidabergs 30 55 47 48
8 Västerås SK Västerås 30 47 47 44
9 Cafe Opera Cafe Opera 30 45 39 40
10 Brommapojkarna Brommapojkar 30 43 42 36
11 Västra Frölunda Västra 30 40 48 36
12 Falkenbergs Falkenbergs 30 30 52 29
13 Bodens Bodens 30 32 40 28
14 Enköpings SK Enköpings 30 31 44 26
15 IK Brage IK Brage 30 41 62 25
16 Friska Viljor Friska 30 30 74 20
TEMPORADA 2002/2003
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Kalmar FF Kalmar FF 30 51 28 67
2 Trelleborgs FF Trelleborgs 30 63 33 60
3 Häcken Häcken 30 56 40 57
4 Åtvidabergs Åtvidabergs 30 47 37 48
5 Västra Frölunda Västra 30 47 40 48
6 Brommapojkarna Brommapojkar 30 41 41 45
7 Cafe Opera Cafe Opera 30 53 48 41
8 Gefle Gefle 30 46 51 40
9 IFK Norrköping Norrköping 30 47 49 39
10 Assyriska FF Assyriska 30 47 53 39
11 Bodens Bodens 30 43 50 39
12 Västerås SK Västerås 30 44 48 37
13 Falkenbergs Falkenbergs 30 37 44 34
14 IFK Malmö IFK Malmö 30 42 58 33
15 BK Forward BK Forward 30 45 63 26
16 Sylvia Sylvia 30 34 60 19
TEMPORADA 2001/2002
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Osters IF Osters IF 30 61 35 54
2 Enköpings SK Enköpings 30 55 43 52
3 Västra Frölunda Västra 30 54 33 51
4 Häcken Häcken 30 52 33 51
5 Assyriska FF Assyriska 30 36 27 45
6 Cafe Opera Cafe Opera 30 48 45 44
7 IFK Malmö IFK Malmö 30 34 34 42
8 Västerås SK Västerås 30 49 49 41
9 Trelleborgs FF Trelleborgs 30 42 41 39
10 Åtvidabergs Åtvidabergs 30 31 50 37
11 Gefle Gefle 30 45 47 35
12 Brommapojkarna Brommapojkar 30 40 52 35
13 Sylvia Sylvia 30 37 55 35
14 IK Brage IK Brage 30 49 55 34
15 Ängelholm Ängelholm 30 29 45 34
16 Mjällby AIF Mjällby 30 42 60 29

  USO DE MEMORIA  
7,843,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.0342
Total Execution Time  1.0353
  CADENA URL  
/historico/Hacken/2021
  GET DATOS  
$_GET['/historico/Hacken/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (56)  
0.0230  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Hacken' AND l.year = 2021 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0152  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0153  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0164  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 = 60908
0.0163  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 = 57296
0.0171  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 = 57880
0.0172  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 = 61674
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3046 AND type_rel = 2
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3046 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0168  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 (98654,546476,850956,877681,1168462) ORDER BY n.cover_points DESC, update_date DESC
0.0174  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '3046' ORDER BY l.year DESC,cat.coefficient DESC
0.0154  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '3046' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0158  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 = '3046' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 57880 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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 = 60908 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160  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=3046 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0149  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 (66452,66149,62807,62615,55372,50143) 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.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 66452 AND teamId = 3046
0.0168  SELECT count(id) as num_players from rel_players WHERE league_id = 50143 AND teamId = 3046
0.0208  SELECT count(id) as num_players from rel_players WHERE league_id = 62615 AND teamId = 3046
0.0167  SELECT count(id) as num_players from rel_players WHERE league_id = 66149 AND teamId = 3046
0.0262  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 3046
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 55372 AND teamId = 3046
0.0148  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 = 60908 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '3046' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3046' and rp.type = 4
0.0150  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 = '3046' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164  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 = 60908 WHERE rp.league_id = 60908 AND rp.teamId = 3046 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.0176  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 = 60908 WHERE rp.league_id = 60908 AND rp.teamId = 3046 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0187  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 = 60908 WHERE rp.league_id = 60908 AND rp.teamId = 3046 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0200  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 = 3046 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0165  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 = 60908 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.0164  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 = 53502 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.0158  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 = 48539 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 42069 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 37608 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 20090 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 9516 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0178  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 = 3641 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 `tables2013` 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 = 2326 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables2012` 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 = 1554 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 1310 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 1089 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2009` 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 = 819 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables2008` 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 = 10197 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 `tables2007` 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 = 10199 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables2006` 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 = 688 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables2005` 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 = 689 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables2004` 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 = 13931 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables2003` 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 = 13933 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2002` 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 = 13935 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 60908 ORDER BY nameShow LIMIT 100