4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ljungskile
TEMPORADA 2020/2021
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Utsiktens BK Utsiktens 30 60 32 58
2 Skovde AIK Skovde AIK 30 52 31 57
3 Oskarshamns AIK Oskarshamns 30 59 32 54
4 Trollhattan FC Trollhattan 30 52 33 54
5 Tvååker Tvååker 30 51 31 49
6 Ljungskile Ljungskile 30 52 36 46
7 Lunds Lunds 30 52 50 44
8 Qviding FIF Qviding FIF 30 41 44 39
9 Vänersborgs IF Vänersborgs 30 46 52 38
10 Torns Torns 30 44 59 38
11 IFK Malmö IFK Malmö 30 35 45 37
12 Lindome Lindome 30 44 46 36
13 Åtvidabergs Åtvidabergs 30 40 43 34
14 Assyriska IK Assyriska 30 42 60 33
15 Österlen Österlen 30 47 63 31
16 Linköping City Linköping 30 28 88 16
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
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
TERCERA SUECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Mjällby AIF Mjällby 30 73 29 69
2 Oskarshamns AIK Oskarshamns 30 59 36 57
3 Tvååker Tvååker 30 46 34 55
4 Eskilsminne Eskilsminne 30 51 35 53
5 Torns Torns 30 41 31 50
6 Ljungskile Ljungskile 30 50 30 46
7 Lunds Lunds 30 53 49 42
8 Utsiktens BK Utsiktens 30 47 47 37
9 IK Oddevold IK Oddevold 30 35 52 37
10 Skovde AIK Skovde AIK 30 33 41 33
11 Åtvidabergs Åtvidabergs 30 42 52 33
12 Kristianstad FC Kristianstad 30 38 51 33
13 Karlskrona Karlskrona 30 39 60 33
14 Grebbestad Grebbestad 30 45 54 32
15 Ängelholm Ängelholm 30 28 61 29
16 Husqvarna Husqvarna 30 44 62 23
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
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
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
LIGA SUECA
Equipo PJ GF GC Puntos
1 Kalmar FF Kalmar FF 30 70 32 64
2 IF Elfsborg IF Elfsborg 30 49 18 63
3 IFK Göteborg Göteborg 30 50 26 54
4 Helsingborgs IF Helsingborgs 30 54 41 54
5 AIK Solna AIK Solna 30 36 32 45
6 Malmö FF Malmö FF 30 51 46 44
7 Orebro SK Orebro SK 30 36 39 42
8 Halmstads Halmstads 30 41 38 41
9 Hammarby IF Hammarby IF 30 44 51 41
10 Trelleborgs FF Trelleborgs 30 33 31 40
11 GAIS GAIS 30 30 36 38
12 Djurgårdens IF Djurgårdens 30 30 41 36
13 Gefle Gefle 30 33 42 28
14 Ljungskile Ljungskile 30 23 52 24
15 GIF Sundsvall Sundsvall 30 26 54 22
16 IFK Norrköping Norrköping 30 31 58 20
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
TEMPORADA 1999/2000
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Djurgårdens IF Djurgårdens 30 68 32 63
2 Malmö FF Malmö FF 30 48 32 60
3 Mjällby AIF Mjällby 30 56 31 53
4 Landskrona BoIS Landskrona 30 59 37 52
5 Västerås SK Västerås 30 50 39 51
6 Cafe Opera Cafe Opera 30 52 45 46
7 Enköpings SK Enköpings 30 23 31 40
8 IK Brage IK Brage 30 36 41 39
9 Sylvia Sylvia 30 47 54 37
10 Kalmar FF Kalmar FF 30 40 42 35
11 Assyriska FF Assyriska 30 36 40 35
12 Osters IF Osters IF 30 39 51 33
13 Umeå Umeå 30 30 48 33
14 Åtvidabergs Åtvidabergs 30 37 46 32
15 Ljungskile Ljungskile 30 31 55 27
16 Gunnilse Gunnilse 30 26 54 26
TEMPORADA 1998/1999
SEGUNDA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Häcken Häcken 26 62 28 51
2 GAIS GAIS 26 35 27 49
3 Mjällby AIF Mjällby 26 51 33 47
4 Ljungskile Ljungskile 26 38 26 46
5 Landskrona BoIS Landskrona 26 52 30 45
6 Gunnilse Gunnilse 26 39 30 42
7 Åtvidabergs Åtvidabergs 26 38 32 41
8 Osters IF Osters IF 26 32 30 39
9 Kristianstad FC Kristianstad 26 34 46 31
10 Kongahälla Kongahälla 26 31 40 28
11 Husqvarna Husqvarna 26 32 50 27
12 Falkenbergs Falkenbergs 26 36 59 26
13 Motala Motala 26 28 47 23
14 Stenungsund Stenungsund 26 28 58 15
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

  USO DE MEMORIA  
7,661,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8983
Total Execution Time  0.8995
  CADENA URL  
/historico/Ljungskile/2021
  GET DATOS  
$_GET['/historico/Ljungskile/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0162  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 = 'Ljungskile' AND l.year = 2021 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=12825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0167  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=12825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0300  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 = 61097
0.0151  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 57296
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12825 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=354 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 354 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (956447,813606,198845,188570,152854) ORDER BY n.cover_points DESC, update_date DESC
0.0155  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 = '12825' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0153  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 = '12825' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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 = 57296 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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 = 61097 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155  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=12825 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (66534,62807,57296,53503) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 53503 AND teamId = 12825
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 66534 AND teamId = 12825
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 57296 AND teamId = 12825
0.0223  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 12825
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 61097 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '12825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  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 = '12825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 61097 WHERE rp.league_id = 61097 AND rp.teamId = 12825 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.0162  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 61097 WHERE rp.league_id = 61097 AND rp.teamId = 12825 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 61097 WHERE rp.league_id = 61097 AND rp.teamId = 12825 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 12825 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 61097 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.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0150  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.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 `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 = 42430 AND t.round = 30 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 `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.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0150  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.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0162  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0165  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0171  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.0170  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 = 77 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2007` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 10199 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0168  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
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` 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 = 13938 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 13941 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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.0146  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 = 61097 ORDER BY nameShow LIMIT 100