4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Halmia
TEMPORADA 2019/2020
CUARTA SUECIA GRUPO 6
Equipo PJ GF GC Puntos
1 IFK Malmö IFK Malmö 13 25 7 29
2 Västra Frölunda Västra 13 31 14 27
3 Ängelholm Ängelholm 13 20 9 26
4 Varbergs GIF Varbergs 13 28 23 21
5 Vinbergs Vinbergs 13 22 25 18
6 Rosengård Rosengård 13 23 21 17
7 BK Olympic BK Olympic 13 21 20 17
8 Onsala Onsala 13 27 29 17
9 Assyriska BK Assyriska 13 20 33 16
10 Ullared Ullared 13 16 25 15
11 Eslövs Eslövs 13 20 30 15
12 Prespa Birlik Prespa 13 22 34 15
13 Halmia Halmia 13 18 21 12
14 Limhamn Bunkeflo IF Limhamn 13 16 18 11
TEMPORADA 2018/2019
CUARTA SUECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Qviding FIF Qviding FIF 26 92 34 57
2 BK Olympic BK Olympic 26 63 35 56
3 Ängelholm Ängelholm 26 62 27 55
4 Onsala Onsala 26 64 57 42
5 Vinbergs Vinbergs 26 49 45 39
6 Rosengård Rosengård 26 50 50 38
7 Halmia Halmia 26 48 51 37
8 Ullared Ullared 26 39 52 32
9 Assyriska BK Assyriska 26 35 44 31
10 Prespa Birlik Prespa 26 39 50 30
11 Eslövs Eslövs 26 32 63 28
12 IFK Malmö IFK Malmö 26 36 54 27
13 Hittarps Hittarps 26 37 57 26
14 Stafsinge Stafsinge 26 34 61 20
TEMPORADA 2017/2018
CUARTA SUECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Lindome Lindome 26 73 17 62
2 Halmia Halmia 26 65 21 57
3 IFK Malmö IFK Malmö 26 52 25 56
4 Hittarps Hittarps 26 60 28 50
5 Sävedalen Sävedalen 26 60 36 50
6 Rosengård Rosengård 26 53 39 45
7 Assyriska BK Assyriska 26 42 57 37
8 Vinbergs Vinbergs 26 43 35 35
9 BK Olympic BK Olympic 26 35 55 26
10 Prespa Birlik Prespa 26 28 58 26
11 Ullared Ullared 26 29 52 23
12 Kvarnby Kvarnby 26 24 58 20
13 Varbergs GIF Varbergs 26 33 77 18
14 Högaborg Högaborg 26 30 69 13
TEMPORADA 2016/2017
CUARTA SUECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Tvååker Tvååker 26 51 24 53
2 Eskilsminne Eskilsminne 26 63 35 51
3 Sävedalen Sävedalen 26 48 27 51
4 Dalstorps Dalstorps 26 43 33 49
5 Vinbergs Vinbergs 26 48 37 45
6 Hittarps Hittarps 26 49 41 38
7 Halmia Halmia 26 59 43 37
8 Lindome Lindome 26 58 56 36
9 Assyriska IK Assyriska 26 42 51 33
10 Torslanda IK Torslanda 26 47 46 31
11 Ullared Ullared 26 42 60 25
12 Varbergs GIF Varbergs 26 30 55 22
13 Tenhult Tenhult 26 27 68 22
14 Höganäs Höganäs 26 28 59 21
TEMPORADA 2015/2016
CUARTA SUECIA GRUPO 6
Equipo PJ GF GC Puntos
1 Assyriska BK Assyriska 26 52 38 52
2 Halmia Halmia 26 44 42 45
3 Eskilsminne Eskilsminne 26 49 37 43
4 Vinbergs Vinbergs 26 47 42 43
5 Lindome Lindome 26 57 43 41
6 Höganäs Höganäs 26 54 44 39
7 Sävedalen Sävedalen 26 38 41 39
8 Ullared Ullared 26 41 42 36
9 Tenhult Tenhult 26 41 40 35
10 Torslanda IK Torslanda 26 44 50 34
11 Akademi HIF Akademi HIF 26 35 34 33
12 Dalstorps Dalstorps 26 33 45 31
13 Högaborg Högaborg 26 31 40 30
14 Laholms FK Laholms FK 26 27 55 15
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
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Utsiktens BK Utsiktens 26 47 26 55
2 Örgryte Örgryte 26 45 33 48
3 Lunds Lunds 26 66 45 44
4 Motala Motala 26 53 37 44
5 IK Oddevold IK Oddevold 26 43 44 41
6 Norrby Norrby 26 51 45 36
7 Halmia Halmia 26 39 37 36
8 Qviding FIF Qviding FIF 26 35 38 35
9 Oskarshamns AIK Oskarshamns 26 39 45 34
10 Kristianstad FC Kristianstad 26 33 44 34
11 Trelleborgs FF Trelleborgs 26 36 34 32
12 Trollhattan FC Trollhattan 26 42 44 32
13 Skovde AIK Skovde AIK 26 29 50 19
14 Uddevalla Uddevalla 26 23 59 15
TEMPORADA 2012/2013
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Husqvarna Husqvarna 26 42 17 56
2 IK Oddevold IK Oddevold 26 49 29 49
3 Trelleborgs FF Trelleborgs 26 41 38 45
4 Halmia Halmia 26 40 30 43
5 Utsiktens BK Utsiktens 26 33 29 41
6 Trollhattan FC Trollhattan 26 39 36 41
7 Sylvia Sylvia 26 44 41 38
8 Qviding FIF Qviding FIF 26 34 36 34
9 Skovde AIK Skovde AIK 26 34 36 33
10 Lunds Lunds 26 46 41 32
11 Kristianstad FC Kristianstad 26 38 43 31
12 Torslanda IK Torslanda 26 24 39 23
13 Limhamn Bunkeflo IF Limhamn 26 30 56 23
14 Karlstad BK Karlstad BK 26 25 48 17
TEMPORADA 2011/2012
CUARTA SUECIA GRUPO 3
Equipo PJ GF GC Puntos
1 Halmia Halmia 22 67 20 51
2 Tvååker Tvååker 22 59 20 51
3 Högaborg Högaborg 22 43 33 44
4 Torns Torns 22 56 32 39
5 Rosengård Rosengård 22 52 39 35
6 Eskilsminne Eskilsminne 22 46 38 33
7 Nike Nike 22 34 38 28
8 Kvarnby Kvarnby 22 53 46 24
9 Akademi HIF Akademi HIF 22 40 46 24
10 Sölvesborg Sölvesborg 22 33 48 23
11 BK Olympic BK Olympic 22 37 43 21
12 Klagshamn Klagshamn 22 10 127 1
TEMPORADA 2010/2011
CUARTA SUECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Utsiktens BK Utsiktens 22 49 23 49
2 Vimmerby Vimmerby 22 47 32 37
3 Torslanda IK Torslanda 22 24 22 35
4 Lindome Lindome 22 44 35 34
5 Halmia Halmia 22 43 32 32
6 IK Tord IK Tord 22 26 29 30
7 Tvååker Tvååker 22 34 35 29
8 Tenhult Tenhult 22 30 40 28
9 Västra Frölunda Västra 22 33 38 26
10 Kållered Kållered 22 23 43 24
11 Kinna Kinna 22 23 35 21
12 Gislaved Gislaved 22 27 39 19
TEMPORADA 2009/2010
CUARTA SUECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Varbergs BoIS Varbergs 22 58 24 51
2 Halmia Halmia 22 43 29 44
3 Lindome Lindome 22 34 21 38
4 Kvarnby Kvarnby 22 36 29 37
5 Klagshamn Klagshamn 22 44 38 32
6 Höllviken Höllviken 22 41 38 32
7 Högaborg Högaborg 22 34 34 28
8 Akademi HIF Akademi HIF 22 33 36 27
9 Assyriska BK Assyriska 22 28 34 27
10 Nike Nike 22 25 38 25
11 Lilla Torg Lilla Torg 22 25 45 22
12 Fässberg Fässberg 22 21 56 10
TEMPORADA 2008/2009
CUARTA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ytterby Ytterby 22 70 21 55
2 Akademi HIF Akademi HIF 22 48 24 44
3 Jonsered Jonsered 22 58 35 41
4 Utsiktens BK Utsiktens 22 45 22 41
5 Gunnilse Gunnilse 22 62 36 36
6 Halmia Halmia 22 46 42 34
7 Varbergs BoIS Varbergs 22 48 38 31
8 Högaborg Högaborg 22 50 45 29
9 Fässberg Fässberg 22 40 43 25
10 Skarhamn IK Skarhamn IK 22 39 45 25
11 Ahlafors Ahlafors 22 32 38 23
12 Asmundtorp Asmundtorp 22 10 159 0
TEMPORADA 1997/1998
SEGUNDA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Kalmar FF Kalmar FF 26 49 23 51
2 Landskrona BoIS Landskrona 26 64 37 50
3 Sylvia Sylvia 26 37 26 47
4 Åtvidabergs Åtvidabergs 26 49 38 46
5 Stenungsund Stenungsund 26 40 34 45
6 Ljungskile Ljungskile 26 37 34 40
7 Falkenbergs Falkenbergs 26 35 47 38
8 Gunnilse Gunnilse 26 41 42 36
9 Mjällby AIF Mjällby 26 45 52 34
10 Motala Motala 26 31 29 33
11 Norrby Norrby 26 34 46 31
12 IFK Hässleholm Hässleholm 26 34 42 26
13 Lundby Lundby 26 25 47 19
14 Halmia Halmia 26 24 48 18
TEMPORADA 1978/1979
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 26 44 24 48
2 Halmstads Halmstads 26 38 21 48
3 IF Elfsborg IF Elfsborg 26 35 24 47
4 Malmö FF Malmö FF 26 30 24 44
5 IFK Norrköping Norrköping 26 44 28 42
6 Hammarby IF Hammarby IF 26 46 36 39
7 Osters IF Osters IF 26 32 28 37
8 Kalmar FF Kalmar FF 26 42 39 32
9 GIF Sundsvall Sundsvall 26 31 41 31
10 Djurgårdens IF Djurgårdens 26 28 35 29
11 Åtvidabergs Åtvidabergs 26 20 27 29
12 Landskrona BoIS Landskrona 26 32 41 29
13 AIK Solna AIK Solna 26 24 35 25
14 Halmia Halmia 26 15 58 11
TEMPORADA 1962/1963
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 47 30 43
2 Degerfors IF Degerfors 22 48 32 43
3 AIK Solna AIK Solna 22 42 28 38
4 Malmö FF Malmö FF 22 43 31 38
5 IFK Göteborg Göteborg 22 52 31 37
6 Djurgårdens IF Djurgårdens 22 37 34 36
7 Örgryte Örgryte 22 36 34 31
8 Orebro SK Orebro SK 22 31 33 26
9 Helsingborgs IF Helsingborgs 22 33 47 26
10 IF Elfsborg IF Elfsborg 22 29 42 25
11 Hammarby IF Hammarby IF 22 43 60 19
12 Halmia Halmia 22 28 67 6
TEMPORADA 1949/1950
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 82 21 62
2 Jönköpings Södra Jönköpings 22 50 37 39
3 Helsingborgs IF Helsingborgs 22 45 38 36
4 AIK Solna AIK Solna 22 34 31 36
5 IFK Norrköping Norrköping 22 36 45 29
6 GAIS GAIS 22 34 42 28
7 Djurgårdens IF Djurgårdens 22 34 39 26
8 IF Elfsborg IF Elfsborg 22 34 45 25
9 Degerfors IF Degerfors 22 26 35 24
10 Kalmar FF Kalmar FF 22 25 33 23
11 IFK Göteborg Göteborg 22 33 49 20
12 Halmia Halmia 22 28 46 20
TEMPORADA 1948/1949
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 72 29 41
2 Helsingborgs IF Helsingborgs 22 48 30 40
3 GAIS GAIS 22 41 29 39
4 AIK Solna AIK Solna 22 42 38 36
5 Degerfors IF Degerfors 22 45 33 35
6 IFK Göteborg Göteborg 22 36 33 32
7 IFK Norrköping Norrköping 22 38 33 30
8 Jönköpings Södra Jönköpings 22 34 52 28
9 Halmia Halmia 22 33 39 25
10 IF Elfsborg IF Elfsborg 22 28 47 25
11 Orebro SK Orebro SK 22 30 50 19
12 Landskrona BoIS Landskrona 22 26 60 14
TEMPORADA 1947/1948
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 56 32 48
2 Malmö FF Malmö FF 22 60 33 41
3 AIK Solna AIK Solna 22 51 34 39
4 Helsingborgs IF Helsingborgs 22 46 46 33
5 IFK Göteborg Göteborg 22 40 33 31
6 GAIS GAIS 22 36 41 27
7 Halmia Halmia 22 34 41 25
8 Degerfors IF Degerfors 22 30 39 25
9 IF Elfsborg IF Elfsborg 22 40 51 25
10 Jönköpings Södra Jönköpings 22 31 53 25
11 Djurgårdens IF Djurgårdens 22 32 35 23
12 Halmstads Halmstads 22 38 56 23
TEMPORADA 1946/1947
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 73 23 52
2 AIK Solna AIK Solna 22 59 32 43
3 Malmö FF Malmö FF 22 51 30 38
4 IF Elfsborg IF Elfsborg 22 55 42 38
5 IFK Göteborg Göteborg 22 52 48 33
6 Helsingborgs IF Helsingborgs 22 44 50 33
7 Degerfors IF Degerfors 22 35 33 30
8 Halmia Halmia 22 38 43 30
9 Djurgårdens IF Djurgårdens 22 40 46 28
10 GAIS GAIS 22 30 40 23
11 Orebro SK Orebro SK 22 40 74 18
12 Billingsfors IK Billingsfors 22 28 84 3
TEMPORADA 1945/1946
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 67 22 51
2 Malmö FF Malmö FF 22 48 27 43
3 IFK Göteborg Göteborg 22 48 29 42
4 GAIS GAIS 22 36 28 39
5 Degerfors IF Degerfors 22 31 23 32
6 AIK Solna AIK Solna 22 44 45 30
7 IF Elfsborg IF Elfsborg 22 43 44 27
8 Helsingborgs IF Helsingborgs 22 45 57 24
9 Djurgårdens IF Djurgårdens 22 42 64 23
10 Halmia Halmia 22 40 49 22
11 Jönköpings Södra Jönköpings 22 31 60 21
12 Halmstads Halmstads 22 24 51 13

  USO DE MEMORIA  
6,842,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  1.1058
Total Execution Time  1.1071
  CADENA URL  
/historico/Halmia
  GET DATOS  
$_GET['/historico/Halmia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (75)  
0.0132  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 = 'Halmia' 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.0287  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 = 'Halmia' 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=12811 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=12811 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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=12811 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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=12811 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=12811 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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=12811 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=12811 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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12811 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 55395
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12811 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1652 AND type_rel = 3
0.0141  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 = '12811' ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '12811' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '12811' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = '12811' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 55395 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=12811 AND l.year in (2019,2020,2021) 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 (57296,55395,49506) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 55395 AND teamId = 12811
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 57296 AND teamId = 12811
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 12811
0.0135  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 55395 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131  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 = '12811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0134  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 = '12811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2020 e ON e.player_id = p.id AND e.league_id = 55395 WHERE rp.league_id = 55395 AND rp.teamId = 12811 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 events2020 e ON e.player_id = p.id AND e.league_id = 55395 WHERE rp.league_id = 55395 AND rp.teamId = 12811 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2020 e ON e.player_id = p.id AND e.league_id = 55395 WHERE rp.league_id = 55395 AND rp.teamId = 12811 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 12811 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 55395 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 `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 = 49287 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 `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 = 43097 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 37781 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 20365 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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.0144  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 = 3647 AND t.round = 26 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 `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 = 2795 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 25198 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 25214 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 25226 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 25231 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 13943 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1979` 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 = 22987 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 `tables1963` 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 = 23003 AND t.round = 22 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 `tables1950` 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 = 23013 AND t.round = 22 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 `tables1949` 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 = 23014 AND t.round = 22 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 `tables1948` 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 = 23015 AND t.round = 22 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 `tables1947` 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 = 23016 AND t.round = 22 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 `tables1946` 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 = 23020 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 55395 ORDER BY nameShow LIMIT 100