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 Orebro SK Orebro SK 6 7 8 7
9 GIF Sundsvall Sundsvall 6 5 6 7
10 Sandvikens IF Sandvikens 6 5 9 7
11 Helsingborgs IF Helsingborgs 5 6 6 6
12 Östersunds FK Östersunds 6 3 5 6
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
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Västerås SK Västerås 30 48 24 63
2 GAIS GAIS 30 61 23 57
3 Utsiktens BK Utsiktens 30 50 31 55
4 Osters IF Osters IF 30 57 35 54
5 Östersunds FK Östersunds 30 44 39 42
6 IK Brage IK Brage 30 39 42 41
7 Landskrona BoIS Landskrona 30 40 49 39
8 Trelleborgs FF Trelleborgs 30 40 52 39
9 Gefle Gefle 30 36 45 37
10 GIF Sundsvall Sundsvall 30 37 53 35
11 Orebro SK Orebro SK 30 43 45 34
12 Helsingborgs IF Helsingborgs 30 32 37 33
13 Skovde AIK Skovde AIK 30 42 52 33
14 Örgryte Örgryte 30 33 47 32
15 Jönköpings Södra Jönköpings 30 43 57 31
16 AFC Eskilstuna Eskilstuna 30 28 42 31
TEMPORADA 2021/2022
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Brommapojkarna Brommapojkar 30 64 40 62
2 Halmstads Halmstads 30 57 32 56
3 Osters IF Osters IF 30 47 35 48
4 Trelleborgs FF Trelleborgs 30 46 49 45
5 Skovde AIK Skovde AIK 30 40 39 44
6 Landskrona BoIS Landskrona 30 40 42 44
7 IK Brage IK Brage 30 44 40 42
8 AFC Eskilstuna Eskilstuna 30 48 46 40
9 Västerås SK Västerås 30 50 49 40
10 Orebro SK Orebro SK 30 33 38 37
11 Utsiktens BK Utsiktens 30 40 46 37
12 Jönköpings Södra Jönköpings 30 41 51 36
13 Örgryte Örgryte 30 45 44 35
14 Östersunds FK Östersunds 30 32 44 31
15 Norrby Norrby 30 33 47 31
16 Dalkurd FF Dalkurd FF 30 37 55 29
TEMPORADA 2020/2021
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 IFK Varnamo IFK Varnamo 30 44 29 59
2 GIF Sundsvall Sundsvall 30 46 29 53
3 Helsingborgs IF Helsingborgs 30 47 29 48
4 Norrby Norrby 30 41 33 48
5 Osters IF Osters IF 30 33 26 46
6 Landskrona BoIS Landskrona 30 41 37 44
7 Trelleborgs FF Trelleborgs 30 42 39 43
8 Örgryte Örgryte 30 39 39 41
9 AFC Eskilstuna Eskilstuna 30 41 41 40
10 IK Brage IK Brage 30 40 42 39
11 Jönköpings Södra Jönköpings 30 34 37 38
12 Västerås SK Västerås 30 36 40 36
13 Akropolis Akropolis 30 28 44 35
14 GAIS GAIS 30 31 40 34
15 Vasalunds IF Vasalunds 30 35 52 26
16 Falkenbergs Falkenbergs 30 34 55 25
TEMPORADA 2019/2020
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 IFK Varnamo IFK Varnamo 30 60 26 63
2 Landskrona BoIS Landskrona 29 53 28 59
3 Utsiktens BK Utsiktens 30 59 36 53
4 Assyriska IK Assyriska 30 52 45 46
5 Lindome Lindome 29 48 34 45
6 Skovde AIK Skovde AIK 30 61 54 43
7 Trollhattan FC Trollhattan 30 47 52 43
8 Torns Torns 30 40 33 42
9 Linköping City Linköping 30 54 47 41
10 Oskarshamns AIK Oskarshamns 30 50 56 40
11 Tvååker Tvååker 30 40 50 39
12 Qviding FIF Qviding FIF 30 31 46 39
13 Lunds Lunds 30 39 46 35
14 Eskilsminne Eskilsminne 30 42 55 35
15 Motala Motala 30 36 60 22
16 Karlskrona Karlskrona 30 36 80 18
TEMPORADA 2018/2019
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ljungskile Ljungskile 30 63 25 66
2 Landskrona BoIS Landskrona 30 47 19 58
3 Utsiktens BK Utsiktens 30 49 36 51
4 Skovde AIK Skovde AIK 30 44 33 49
5 Trollhattan FC Trollhattan 30 40 38 46
6 Tvååker Tvååker 30 41 37 44
7 IFK Varnamo IFK Varnamo 30 45 45 43
8 Lunds Lunds 30 45 45 40
9 Eskilsminne Eskilsminne 30 39 41 37
10 Lindome Lindome 30 33 36 37
11 Assyriska IK Assyriska 30 33 41 37
12 Torns Torns 30 35 41 36
13 Oskarshamns AIK Oskarshamns 30 44 56 33
14 Åtvidabergs Åtvidabergs 30 35 51 31
15 Kristianstad FC Kristianstad 30 29 63 28
16 IK Oddevold IK Oddevold 30 30 45 23
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
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Landskrona BoIS Landskrona 26 51 18 58
2 Mjällby AIF Mjällby 26 60 29 53
3 Utsiktens BK Utsiktens 26 51 42 47
4 Kristianstad FC Kristianstad 26 48 32 39
5 Oskarshamns AIK Oskarshamns 26 42 44 39
6 Karlskrona Karlskrona 26 43 39 38
7 Ljungskile Ljungskile 26 36 37 38
8 Ängelholm Ängelholm 26 35 36 36
9 IK Oddevold IK Oddevold 26 42 42 35
10 Husqvarna Husqvarna 26 49 42 32
11 Skovde AIK Skovde AIK 26 30 36 31
12 Assyriska BK Assyriska 26 34 58 28
13 Qviding FIF Qviding FIF 26 19 52 20
14 Rosengård Rosengård 26 32 65 15
TEMPORADA 2015/2016
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Osters IF Osters IF 26 45 15 58
2 Norrby Norrby 26 54 33 51
3 Landskrona BoIS Landskrona 26 50 25 46
4 Utsiktens BK Utsiktens 26 40 28 42
5 Kristianstad FC Kristianstad 26 35 35 37
6 Husqvarna Husqvarna 26 39 32 35
7 IK Oddevold IK Oddevold 26 39 42 33
8 Mjällby AIF Mjällby 26 35 39 31
9 Qviding FIF Qviding FIF 26 27 32 31
10 Oskarshamns AIK Oskarshamns 26 34 46 30
11 Trollhattan FC Trollhattan 26 29 39 29
12 Tvååker Tvååker 26 30 48 28
13 Prespa Birlik Prespa 26 35 50 27
14 Höllviken Höllviken 26 23 51 19
TEMPORADA 2014/2015
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Trelleborgs FF Trelleborgs 26 65 25 64
2 Örgryte Örgryte 26 70 26 57
3 Osters IF Osters IF 26 39 19 50
4 IK Oddevold IK Oddevold 26 46 35 40
5 Kristianstad FC Kristianstad 26 38 51 38
6 Landskrona BoIS Landskrona 26 37 32 37
7 Höllviken Höllviken 26 38 33 35
8 Oskarshamns AIK Oskarshamns 26 41 42 35
9 Qviding FIF Qviding FIF 26 30 41 29
10 Norrby Norrby 26 45 57 29
11 Husqvarna Husqvarna 26 36 51 29
12 Halmia Halmia 26 41 54 25
13 Eskilsminne Eskilsminne 26 35 51 25
14 Lunds Lunds 26 21 65 15
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
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Mjällby AIF Mjällby 30 60 19 65
2 Åtvidabergs Åtvidabergs 30 53 36 57
3 Assyriska FF Assyriska 30 46 38 51
4 Syrianska FC Syrianska 30 50 38 50
5 GIF Sundsvall Sundsvall 30 54 48 47
6 Falkenbergs Falkenbergs 30 44 41 45
7 Ängelholm Ängelholm 30 43 45 44
8 Landskrona BoIS Landskrona 30 51 46 40
9 Ljungskile Ljungskile 30 48 43 40
10 Jönköpings Södra Jönköpings 30 46 54 36
11 IFK Norrköping Norrköping 30 45 44 35
12 AFC Eskilstuna Eskilstuna 30 28 41 33
13 Trollhattan FC Trollhattan 30 30 46 32
14 Qviding FIF Qviding FIF 30 31 45 31
15 IK Sirius IK Sirius 30 37 53 31
16 Vasalunds IF Vasalunds 30 35 64 29
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
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

  USO DE MEMORIA  
7,689,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7478
Total Execution Time  0.7490
  CADENA URL  
/historico/Landskrona
  GET DATOS  
$_GET['/historico/Landskrona']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0140  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 = 'Landskrona' 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.0125  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=3047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=3047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=3047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=3047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=3047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 74951
0.0132  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.0132  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 = 74729
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3047 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=353 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 353 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1238866,1199318,1175002,919661,672477) ORDER BY n.cover_points DESC, update_date DESC
0.0140  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 = '3047' ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '3047' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '3047' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0133  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.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 = 74951 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138  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=3047 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74951,74729,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.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 74951 AND teamId = 3047
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 74729 AND teamId = 3047
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 3047
0.0126  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 = '3047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '3047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138  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 = 3047 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 events2024 e ON e.player_id = p.id AND e.league_id = 74951 WHERE rp.league_id = 74951 AND rp.teamId = 3047 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 3047 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 3047 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 74951 AND t.round = 6 ORDER BY team.conference ASC,t.position 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 `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 = 70736 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.0131  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 = 66453 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.0130  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 = 61095 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.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 `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 = 55398 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 = 48619 AND t.round = 30 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 = 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.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 = 37775 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 20223 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 = 9523 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 `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.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 `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.0131  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.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 `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.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 `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.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 `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 = 10196 AND t.round = 30 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 `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.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 `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.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 `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.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 `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