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
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
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
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
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
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 2
Equipo PJ GF GC Puntos
1 Osters IF Osters IF 26 47 35 46
2 Skovde AIK Skovde AIK 26 44 37 46
3 Sleipner Sleipner 26 44 29 45
4 Kristianstad FC Kristianstad 26 52 41 45
5 Limhamn Bunkeflo IF Limhamn 26 41 33 40
6 Husqvarna Husqvarna 26 41 34 40
7 IFK Varnamo IFK Varnamo 26 38 35 38
8 Rosengård Rosengård 26 39 36 35
9 Sylvia Sylvia 26 38 48 34
10 Västra Frölunda Västra 26 39 37 33
11 Torslanda IK Torslanda 26 32 37 29
12 Motala Motala 26 28 47 29
13 IK Oddevold IK Oddevold 26 32 44 25
14 Lindome Lindome 26 25 47 20
TEMPORADA 2007/2008
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Trollhattan FC Trollhattan 26 41 26 49
2 Osters IF Osters IF 26 54 33 45
3 Carlstad United Carlstad 26 43 37 45
4 Rosengård Rosengård 26 53 38 44
5 Skovde AIK Skovde AIK 26 54 39 42
6 Motala Motala 26 41 46 39
7 IFK Varnamo IFK Varnamo 26 31 31 38
8 Västra Frölunda Västra 26 45 41 35
9 Lindome Lindome 26 36 33 32
10 Torslanda IK Torslanda 26 40 45 32
11 Husqvarna Husqvarna 26 29 35 28
12 IFK Malmö IFK Malmö 26 38 63 27
13 Norrby Norrby 26 38 52 26
14 Skarhamn IK Skarhamn IK 26 37 61 25
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
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,576,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1684
Total Execution Time  0.1696
  CADENA URL  
/historico/Osters-If
  GET DATOS  
$_GET['/historico/Osters-If']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0057  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 = 'Osters-If' 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.0025  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=62407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=62407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=62407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=62407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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=62407 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0061  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.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62407 AND type_rel = 2
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 62407 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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.0074  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 = '62407' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0083  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 = '62407' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74727 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.0040  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=62407 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,74727,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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 74951 AND teamId = 62407
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 74727 AND teamId = 62407
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 62407
0.0026  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.0030  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 = 62407 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.0031  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 = 62407 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 62407 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 62407 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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.0022  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.0022  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.0022  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.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 `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.0036  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.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 `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.0025  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.0021  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.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 `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.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 `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.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 `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.0022  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.0022  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.0021  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 = 10466 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 16475 AND t.round = 26 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.0022  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.0025  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