4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Landskrona BoIS Landskrona 6 11 3 14
2 Utsiktens BK Utsiktens 6 8 4 11
3 IK Brage IK Brage 6 7 5 11
4 IK Oddevold IK Oddevold 6 6 4 11
5 Osters IF Osters IF 6 7 5 9
6 Degerfors IF Degerfors 6 9 8 9
7 Skovde AIK Skovde AIK 6 4 7 8
8 GIF Sundsvall Sundsvall 6 5 6 7
9 Sandvikens IF Sandvikens 6 5 9 7
10 Helsingborgs IF Helsingborgs 5 6 6 6
11 Orebro SK Orebro SK 5 6 7 6
12 Östersunds FK Östersunds 5 2 4 5
13 Gefle Gefle 6 7 9 4
14 Varbergs BoIS Varbergs 5 5 7 4
15 Trelleborgs FF Trelleborgs 5 3 5 4
16 Örgryte Örgryte 5 5 7 3
TEMPORADA 2022/2023
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 62 27 64
2 IF Elfsborg IF Elfsborg 30 59 26 64
3 Häcken Häcken 30 69 39 57
4 Djurgårdens IF Djurgårdens 30 41 36 50
5 IFK Varnamo IFK Varnamo 30 37 34 45
6 Kalmar FF Kalmar FF 30 35 40 45
7 Hammarby IF Hammarby IF 30 41 39 44
8 IK Sirius IK Sirius 30 51 44 42
9 IFK Norrköping Norrköping 30 45 45 41
10 Mjällby AIF Mjällby 30 32 34 41
11 AIK Solna AIK Solna 30 34 38 36
12 Halmstads Halmstads 30 30 44 36
13 IFK Göteborg Göteborg 30 33 37 34
14 Brommapojkarna Brommapojkar 30 40 53 33
15 Degerfors IF Degerfors 30 30 62 26
16 Varbergs BoIS Varbergs 30 26 67 15
TEMPORADA 2021/2022
LIGA SUECA
Equipo PJ GF GC Puntos
1 Häcken Häcken 30 69 37 64
2 Djurgårdens IF Djurgårdens 30 55 25 57
3 Hammarby IF Hammarby IF 30 60 27 56
4 Kalmar FF Kalmar FF 30 41 27 51
5 AIK Solna AIK Solna 30 45 36 50
6 IF Elfsborg IF Elfsborg 30 55 35 49
7 Malmö FF Malmö FF 30 44 34 46
8 IFK Göteborg Göteborg 30 42 39 45
9 Mjällby AIF Mjällby 30 33 33 43
10 IFK Varnamo IFK Varnamo 30 34 47 37
11 IK Sirius IK Sirius 30 31 42 35
12 IFK Norrköping Norrköping 30 40 42 34
13 Degerfors IF Degerfors 30 32 49 31
14 Varbergs BoIS Varbergs 30 31 57 31
15 Helsingborgs IF Helsingborgs 30 22 52 17
16 GIF Sundsvall Sundsvall 30 28 80 14
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
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Halmstads Halmstads 30 61 18 68
2 Degerfors IF Degerfors 30 64 30 63
3 Jönköpings Södra Jönköpings 30 52 34 59
4 Osters IF Osters IF 30 41 36 51
5 Akropolis Akropolis 30 44 39 45
6 GIF Sundsvall Sundsvall 30 53 48 43
7 Västerås SK Västerås 30 40 44 39
8 IK Brage IK Brage 30 38 44 39
9 AFC Eskilstuna Eskilstuna 30 36 49 37
10 GAIS GAIS 30 30 41 36
11 Norrby Norrby 30 39 41 34
12 Örgryte Örgryte 30 34 43 33
13 Trelleborgs FF Trelleborgs 30 33 41 32
14 Dalkurd FF Dalkurd FF 30 33 42 29
15 Umeå Umeå 30 25 47 27
16 Ljungskile Ljungskile 30 24 50 23
TEMPORADA 2018/2019
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Mjällby AIF Mjällby 30 44 31 57
2 Varbergs BoIS Varbergs 30 49 27 55
3 IK Brage IK Brage 30 54 33 54
4 Jönköpings Södra Jönköpings 30 52 31 52
5 Degerfors IF Degerfors 30 46 34 51
6 Halmstads Halmstads 30 45 34 46
7 Örgryte Örgryte 30 43 37 46
8 Dalkurd FF Dalkurd FF 30 43 47 44
9 Norrby Norrby 30 43 43 42
10 Västerås SK Västerås 30 41 40 34
11 Trelleborgs FF Trelleborgs 30 34 47 32
12 GAIS GAIS 30 23 40 32
13 Osters IF Osters IF 30 32 43 29
14 IK Frej IK Frej 30 35 55 29
15 Brommapojkarna Brommapojkar 30 38 49 28
16 Syrianska FC Syrianska 30 29 60 25
TEMPORADA 2017/2018
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 30 59 30 63
2 Falkenbergs Falkenbergs 30 61 34 59
3 AFC Eskilstuna Eskilstuna 30 40 16 54
4 Örgryte Örgryte 30 56 37 52
5 Halmstads Halmstads 30 49 38 51
6 IK Brage IK Brage 30 46 45 45
7 Degerfors IF Degerfors 30 45 46 42
8 Osters IF Osters IF 30 48 43 41
9 IK Frej IK Frej 30 46 56 37
10 GAIS GAIS 30 40 41 35
11 Jönköpings Södra Jönköpings 30 31 38 35
12 Norrby Norrby 30 31 50 34
13 IFK Varnamo IFK Varnamo 30 31 48 32
14 Varbergs BoIS Varbergs 30 43 54 29
15 Gefle Gefle 30 31 60 25
16 Landskrona BoIS Landskrona 30 35 56 22
TEMPORADA 2016/2017
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Brommapojkarna Brommapojkar 30 59 26 62
2 Dalkurd FF Dalkurd FF 30 57 27 58
3 Trelleborgs FF Trelleborgs 30 54 32 52
4 Falkenbergs Falkenbergs 30 50 39 48
5 Osters IF Osters IF 30 46 35 48
6 IFK Varnamo IFK Varnamo 30 53 44 47
7 Helsingborgs IF Helsingborgs 30 40 41 45
8 Degerfors IF Degerfors 30 43 37 44
9 GAIS GAIS 30 28 37 37
10 Norrby Norrby 30 44 56 37
11 Varbergs BoIS Varbergs 30 42 42 36
12 Gefle Gefle 30 40 48 36
13 Örgryte Örgryte 30 29 45 36
14 IK Frej IK Frej 30 39 51 29
15 Syrianska FC Syrianska 30 39 67 24
16 Åtvidabergs Åtvidabergs 30 22 58 23
TEMPORADA 2015/2016
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 IK Sirius IK Sirius 30 54 23 61
2 AFC Eskilstuna Eskilstuna 30 50 20 61
3 Halmstads Halmstads 30 43 28 54
4 Dalkurd FF Dalkurd FF 30 41 24 53
5 Varbergs BoIS Varbergs 30 33 37 48
6 Åtvidabergs Åtvidabergs 30 53 53 44
7 Trelleborgs FF Trelleborgs 30 39 35 40
8 GAIS GAIS 30 45 36 39
9 Örgryte Örgryte 30 42 44 39
10 IK Frej IK Frej 30 38 42 38
11 IFK Varnamo IFK Varnamo 30 35 40 35
12 Degerfors IF Degerfors 30 34 54 33
13 Syrianska FC Syrianska 30 26 37 32
14 Assyriska FF Assyriska 30 36 47 28
15 Ljungskile Ljungskile 30 34 48 26
16 Ängelholm Ängelholm 30 22 57 20
TEMPORADA 2014/2015
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Jönköpings Södra Jönköpings 30 54 28 63
2 Östersunds FK Östersunds 30 56 25 62
3 IK Sirius IK Sirius 30 53 25 58
4 Assyriska FF Assyriska 30 46 37 47
5 Varbergs BoIS Varbergs 30 34 27 47
6 Ljungskile Ljungskile 30 44 37 43
7 Syrianska FC Syrianska 30 37 30 43
8 AFC Eskilstuna Eskilstuna 30 43 44 40
9 Degerfors IF Degerfors 30 36 38 38
10 IFK Varnamo IFK Varnamo 30 37 40 38
11 GAIS GAIS 30 37 44 35
12 Ängelholm Ängelholm 30 31 47 33
13 Mjällby AIF Mjällby 30 23 43 30
14 IK Frej IK Frej 30 22 44 29
15 Utsiktens BK Utsiktens 30 28 56 26
16 Brommapojkarna Brommapojkar 30 30 46 23
TEMPORADA 2013/2014
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Hammarby IF Hammarby IF 30 68 27 61
2 GIF Sundsvall Sundsvall 30 55 34 61
3 Ljungskile Ljungskile 30 60 25 60
4 Jönköpings Södra Jönköpings 30 60 42 52
5 Östersunds FK Östersunds 30 40 40 45
6 IK Sirius IK Sirius 30 47 36 43
7 Degerfors IF Degerfors 30 47 46 40
8 Varbergs BoIS Varbergs 30 38 43 39
9 IFK Varnamo IFK Varnamo 30 43 52 39
10 Syrianska FC Syrianska 30 37 55 37
11 GAIS GAIS 30 31 38 35
12 Ängelholm Ängelholm 30 30 51 35
13 Osters IF Osters IF 30 39 48 32
14 Assyriska FF Assyriska 30 28 44 27
15 Landskrona BoIS Landskrona 30 35 55 26
16 Husqvarna Husqvarna 30 27 49 22
TEMPORADA 2012/2013
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Falkenbergs Falkenbergs 30 63 31 62
2 Orebro SK Orebro SK 30 52 21 61
3 GIF Sundsvall Sundsvall 30 54 35 58
4 Degerfors IF Degerfors 30 52 41 52
5 Hammarby IF Hammarby IF 30 34 28 47
6 Ängelholm Ängelholm 30 55 47 43
7 GAIS GAIS 30 45 47 43
8 Assyriska FF Assyriska 30 42 44 42
9 Ljungskile Ljungskile 30 34 31 39
10 Östersunds FK Östersunds 30 39 38 39
11 Jönköpings Södra Jönköpings 30 39 44 38
12 Landskrona BoIS Landskrona 30 40 48 32
13 Varbergs BoIS Varbergs 30 47 65 32
14 IFK Varnamo IFK Varnamo 30 30 51 31
15 Örgryte Örgryte 30 23 40 28
16 IK Brage IK Brage 30 21 59 12
TEMPORADA 2011/2012
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Osters IF Osters IF 30 57 28 66
2 Brommapojkarna Brommapojkar 30 61 40 61
3 Halmstads Halmstads 30 61 33 56
4 Hammarby IF Hammarby IF 30 40 33 49
5 Ljungskile Ljungskile 30 36 36 42
6 Landskrona BoIS Landskrona 30 35 43 41
7 Jönköpings Södra Jönköpings 30 52 47 40
8 Assyriska FF Assyriska 30 44 49 39
9 Ängelholm Ängelholm 30 40 46 39
10 IK Brage IK Brage 30 35 45 39
11 Varbergs BoIS Varbergs 30 49 52 37
12 Degerfors IF Degerfors 30 46 53 35
13 Falkenbergs Falkenbergs 30 45 47 34
14 IFK Varnamo IFK Varnamo 30 47 54 30
15 Trelleborgs FF Trelleborgs 30 40 55 29
16 Umeå Umeå 30 34 61 23
TEMPORADA 2010/2011
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Åtvidabergs Åtvidabergs 30 58 31 57
2 GIF Sundsvall Sundsvall 30 61 29 55
3 Ängelholm Ängelholm 30 47 40 53
4 Osters IF Osters IF 30 40 28 50
5 Degerfors IF Degerfors 30 53 44 48
6 Brommapojkarna Brommapojkar 30 50 38 47
7 Falkenbergs Falkenbergs 30 50 43 45
8 Ljungskile Ljungskile 30 48 39 42
9 Assyriska FF Assyriska 30 39 41 41
10 Landskrona BoIS Landskrona 30 36 39 41
11 Hammarby IF Hammarby IF 30 37 40 40
12 Jönköpings Södra Jönköpings 30 47 53 40
13 IFK Varnamo IFK Varnamo 30 43 51 39
14 IK Brage IK Brage 30 30 50 31
15 Västerås SK Västerås 30 39 66 28
16 Qviding FIF Qviding FIF 30 17 63 11
TEMPORADA 2009/2010
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Syrianska FC Syrianska 30 46 27 56
2 IFK Norrköping Norrköping 30 51 33 56
3 GIF Sundsvall Sundsvall 30 56 39 51
4 Assyriska FF Assyriska 30 48 42 46
5 Landskrona BoIS Landskrona 30 40 39 45
6 Ljungskile Ljungskile 30 47 35 44
7 Falkenbergs Falkenbergs 30 46 34 44
8 Hammarby IF Hammarby IF 30 45 40 43
9 Örgryte Örgryte 30 43 35 42
10 Degerfors IF Degerfors 30 43 45 42
11 IK Brage IK Brage 30 36 38 41
12 Ängelholm Ängelholm 30 39 39 37
13 Jönköpings Södra Jönköpings 30 40 47 36
14 Osters IF Osters IF 30 30 54 29
15 Trollhattan FC Trollhattan 30 32 66 23
16 AFC Eskilstuna Eskilstuna 30 31 60 18
TEMPORADA 2008/2009
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Degerfors IF Degerfors 26 58 25 60
2 IK Brage IK Brage 26 47 31 52
3 Valsta Syrianska Valsta 26 53 36 48
4 Umeå Umeå 26 51 37 48
5 Västerås SK Västerås 26 49 37 37
6 Grondals IK Grondals IK 26 37 43 35
7 Carlstad United Carlstad 26 30 31 33
8 Arameiska / Syrianska Arameiska 26 30 38 32
9 BK Forward BK Forward 26 41 45 31
10 Syrianska IF Syrianska 26 42 48 31
11 Östersunds FK Östersunds 26 37 39 30
12 Karlslund Karlslund 26 34 42 29
13 Enköpings SK Enköpings 26 35 55 25
14 Skellefteå Skellefteå 26 27 64 15
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
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Trelleborgs FF Trelleborgs 30 48 13 66
2 Orebro SK Orebro SK 30 56 28 58
3 Brommapojkarna Brommapojkar 30 53 43 57
4 IFK Norrköping Norrköping 30 55 30 54
5 Landskrona BoIS Landskrona 30 53 39 50
6 Ljungskile Ljungskile 30 34 33 46
7 Mjällby AIF Mjällby 30 51 49 43
8 GIF Sundsvall Sundsvall 30 42 33 40
9 Falkenbergs Falkenbergs 30 42 39 40
10 Jönköpings Södra Jönköpings 30 37 59 37
11 Degerfors IF Degerfors 30 39 41 35
12 Åtvidabergs Åtvidabergs 30 40 47 35
13 Assyriska FF Assyriska 30 30 40 34
14 AFC Eskilstuna Eskilstuna 30 34 47 32
15 Qviding FIF Qviding FIF 30 30 62 18
16 Umeå Umeå 30 30 71 16
TEMPORADA 2004/2005
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 30 56 27 64
2 Osters IF Osters IF 30 48 36 55
3 GAIS GAIS 30 52 35 52
4 Ljungskile Ljungskile 30 41 29 50
5 Orebro SK Orebro SK 30 40 32 45
6 Brommapojkarna Brommapojkar 30 48 42 44
7 IFK Norrköping Norrköping 30 44 40 44
8 Falkenbergs Falkenbergs 30 38 43 41
9 AFC Eskilstuna Eskilstuna 30 32 40 39
10 Åtvidabergs Åtvidabergs 30 36 32 38
11 Trelleborgs FF Trelleborgs 30 34 34 36
12 Mjällby AIF Mjällby 30 44 49 35
13 Degerfors IF Degerfors 30 31 36 34
14 Bodens Bodens 30 28 48 32
15 Västerås SK Västerås 30 35 62 27
16 Västra Frölunda Västra 30 32 54 25

  USO DE MEMORIA  
7,833,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1898
Total Execution Time  0.1912
  CADENA URL  
/historico/Degerfors
  GET DATOS  
$_GET['/historico/Degerfors']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0058  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 = 'Degerfors' AND l.year = 2024 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.0018  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12823 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 71781
0.0027  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 = 74728
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12823 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12823 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (619387) ORDER BY n.cover_points DESC, update_date DESC
0.0041  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 = '12823' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '12823' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026  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 = 71781 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 74951 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  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=12823 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (75538,74951,71432,70735) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 70735 AND teamId = 12823
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 74951 AND teamId = 12823
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 75538 AND teamId = 12823
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12823
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 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 = 74951 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '12823' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12823' 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 = '12823' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0052  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 = 74951 WHERE rp.league_id = 74951 AND rp.teamId = 12823 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.0064  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 = 74951 WHERE rp.league_id = 74951 AND rp.teamId = 12823 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 74951 WHERE rp.league_id = 74951 AND rp.teamId = 12823 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 = 12823 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  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 = 70735 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.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 `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 = 66452 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.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 `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.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 `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 = 53503 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.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 `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 = 48540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 42103 AND t.round = 30 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 `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 = 37609 AND t.round = 30 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 `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 = 20091 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 9517 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 3466 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 2796 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 10188 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 10192 AND t.round = 30 ORDER BY team.conference 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 `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 = 10194 AND t.round = 30 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 `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 = 10457 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 `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.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 `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.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 `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 = 10200 AND t.round = 30 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 `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 = 10201 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC