4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
LIGA SUECA
Equipo PJ GF GC Puntos
1 IF Elfsborg IF Elfsborg 30 48 29 59
2 Häcken Häcken 30 67 36 57
3 Malmö FF Malmö FF 30 49 33 56
4 AIK Solna AIK Solna 30 41 27 55
5 IFK Norrköping Norrköping 30 50 43 52
6 Helsingborgs IF Helsingborgs 30 52 33 50
7 IFK Göteborg Göteborg 30 36 41 39
8 Åtvidabergs Åtvidabergs 30 48 48 37
9 Djurgårdens IF Djurgårdens 30 37 40 37
10 Kalmar FF Kalmar FF 30 36 45 37
11 Gefle Gefle 30 26 37 36
12 Mjällby AIF Mjällby 30 33 39 34
13 Syrianska FC Syrianska 30 35 45 34
14 GIF Sundsvall Sundsvall 30 35 46 29
15 Orebro SK Orebro SK 30 32 46 24
16 GAIS GAIS 30 24 61 12
TEMPORADA 2010/2011
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 30 55 27 63
2 AIK Solna AIK Solna 30 46 27 58
3 IF Elfsborg IF Elfsborg 30 52 32 57
4 Malmö FF Malmö FF 30 37 30 54
5 GAIS GAIS 30 47 34 51
6 Häcken Häcken 30 52 32 49
7 IFK Göteborg Göteborg 30 42 34 45
8 Kalmar FF Kalmar FF 30 39 34 44
9 Gefle Gefle 30 31 39 41
10 Mjällby AIF Mjällby 30 33 39 40
11 Djurgårdens IF Djurgårdens 30 36 40 36
12 Orebro SK Orebro SK 30 36 45 36
13 IFK Norrköping Norrköping 30 32 49 34
14 Syrianska FC Syrianska 30 27 44 28
15 Trelleborgs FF Trelleborgs 30 39 64 25
16 Halmstads Halmstads 30 24 58 14
TEMPORADA 2009/2010
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 59 24 67
2 Helsingborgs IF Helsingborgs 30 49 26 65
3 Orebro SK Orebro SK 30 40 30 52
4 IF Elfsborg IF Elfsborg 30 55 40 47
5 Trelleborgs FF Trelleborgs 30 39 42 44
6 Mjällby AIF Mjällby 30 36 29 43
7 IFK Göteborg Göteborg 30 42 29 40
8 Häcken Häcken 30 40 42 40
9 Kalmar FF Kalmar FF 30 36 38 40
10 Djurgårdens IF Djurgårdens 30 35 42 40
11 AIK Solna AIK Solna 30 29 36 35
12 Halmstads Halmstads 30 31 42 35
13 GAIS GAIS 30 24 35 32
14 Gefle Gefle 30 33 46 29
15 Åtvidabergs Åtvidabergs 30 32 51 29
16 Brommapojkarna Brommapojkar 30 20 48 25
TEMPORADA 2008/2009
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 30 36 20 61
2 IFK Göteborg Göteborg 30 53 24 57
3 IF Elfsborg IF Elfsborg 30 43 34 55
4 Kalmar FF Kalmar FF 30 53 39 50
5 Häcken Häcken 30 43 30 48
6 Orebro SK Orebro SK 30 33 32 45
7 Malmö FF Malmö FF 30 40 25 43
8 Helsingborgs IF Helsingborgs 30 39 39 43
9 Trelleborgs FF Trelleborgs 30 41 34 41
10 Gefle Gefle 30 28 38 39
11 GAIS GAIS 30 41 38 35
12 Brommapojkarna Brommapojkar 30 32 46 34
13 Halmstads Halmstads 30 29 43 32
14 Djurgårdens IF Djurgårdens 30 24 49 29
15 Örgryte Örgryte 30 27 49 25
16 Hammarby IF Hammarby IF 30 22 44 22
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
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 26 45 23 49
2 Kalmar FF Kalmar FF 26 43 32 48
3 Djurgårdens IF Djurgårdens 26 39 24 46
4 IF Elfsborg IF Elfsborg 26 39 30 40
5 AIK Solna AIK Solna 26 30 27 38
6 Hammarby IF Hammarby IF 26 35 31 36
7 Halmstads Halmstads 26 33 41 36
8 Helsingborgs IF Helsingborgs 26 49 37 35
9 Malmö FF Malmö FF 26 29 28 34
10 Gefle Gefle 26 29 30 34
11 GAIS GAIS 26 24 37 29
12 Orebro SK Orebro SK 26 28 45 25
13 Trelleborgs FF Trelleborgs 26 22 38 23
14 Brommapojkarna Brommapojkar 26 21 43 23
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
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
TEMPORADA 2003/2004
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 26 44 21 52
2 Halmstads Halmstads 26 53 27 50
3 IFK Göteborg Göteborg 26 33 20 47
4 Djurgårdens IF Djurgårdens 26 38 32 41
5 Kalmar FF Kalmar FF 26 27 18 40
6 Hammarby IF Hammarby IF 26 28 28 37
7 Orebro SK Orebro SK 26 32 45 33
8 GIF Sundsvall Sundsvall 26 28 30 32
9 IF Elfsborg IF Elfsborg 26 25 32 32
10 Helsingborgs IF Helsingborgs 26 41 33 30
11 Landskrona BoIS Landskrona 26 27 33 30
12 Örgryte Örgryte 26 25 33 28
13 AIK Solna AIK Solna 26 23 35 25
14 Trelleborgs FF Trelleborgs 26 18 55 13
TEMPORADA 2002/2003
LIGA SUECA
Equipo PJ GF GC Puntos
1 Djurgårdens IF Djurgårdens 26 62 26 58
2 Hammarby IF Hammarby IF 26 50 30 51
3 Malmö FF Malmö FF 26 50 23 48
4 Örgryte Örgryte 26 42 40 45
5 AIK Solna AIK Solna 26 39 34 39
6 Helsingborgs IF Helsingborgs 26 35 36 38
7 IFK Göteborg Göteborg 26 37 28 37
8 Orebro SK Orebro SK 26 29 33 37
9 Halmstads Halmstads 26 41 37 36
10 IF Elfsborg IF Elfsborg 26 29 34 34
11 Landskrona BoIS Landskrona 26 26 39 32
12 GIF Sundsvall Sundsvall 26 25 43 19
13 Osters IF Osters IF 26 31 56 17
14 Enköpings SK Enköpings 26 22 59 14
TEMPORADA 2001/2002
LIGA SUECA
Equipo PJ GF GC Puntos
1 Djurgårdens IF Djurgårdens 26 51 33 52
2 Malmö FF Malmö FF 26 52 32 46
3 Örgryte Örgryte 26 49 38 44
4 Helsingborgs IF Helsingborgs 26 38 38 38
5 AIK Solna AIK Solna 26 35 38 37
6 Halmstads Halmstads 26 35 28 36
7 Orebro SK Orebro SK 26 32 39 35
8 GIF Sundsvall Sundsvall 26 29 35 33
9 Hammarby IF Hammarby IF 26 43 42 32
10 IF Elfsborg IF Elfsborg 26 25 31 32
11 Landskrona BoIS Landskrona 26 41 39 30
12 IFK Göteborg Göteborg 26 25 39 28
13 IFK Norrköping Norrköping 26 37 40 27
14 Kalmar FF Kalmar FF 26 20 40 24
TEMPORADA 2000/2001
LIGA SUECA
Equipo PJ GF GC Puntos
1 Hammarby IF Hammarby IF 26 45 28 48
2 Djurgårdens IF Djurgårdens 26 36 24 47
3 AIK Solna AIK Solna 26 45 29 45
4 IFK Göteborg Göteborg 26 41 31 44
5 Helsingborgs IF Helsingborgs 26 47 29 42
6 Örgryte Örgryte 26 36 33 39
7 Halmstads Halmstads 26 50 31 38
8 Orebro SK Orebro SK 26 48 44 33
9 Malmö FF Malmö FF 26 39 46 32
10 IF Elfsborg IF Elfsborg 26 31 51 30
11 GIF Sundsvall Sundsvall 26 28 37 29
12 IFK Norrköping Norrköping 26 29 40 29
13 Häcken Häcken 26 35 50 24
14 Trelleborgs FF Trelleborgs 26 25 62 14
TEMPORADA 1999/2000
LIGA SUECA
Equipo PJ GF GC Puntos
1 Halmstads Halmstads 26 47 24 52
2 Helsingborgs IF Helsingborgs 26 51 30 46
3 AIK Solna AIK Solna 26 38 30 45
4 IFK Göteborg Göteborg 26 46 33 44
5 IF Elfsborg IF Elfsborg 26 43 37 43
6 Trelleborgs FF Trelleborgs 26 30 28 38
7 Örgryte Örgryte 26 32 32 37
8 Hammarby IF Hammarby IF 26 34 38 36
9 IFK Norrköping Norrköping 26 40 31 35
10 Orebro SK Orebro SK 26 44 40 33
11 GIF Sundsvall Sundsvall 26 34 42 29
12 Häcken Häcken 26 40 52 25
13 GAIS GAIS 26 26 43 20
14 Västra Frölunda Västra 26 17 62 15
TEMPORADA 1998/1999
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 26 44 24 54
2 AIK Solna AIK Solna 26 42 14 53
3 Halmstads Halmstads 26 43 22 48
4 Örgryte Örgryte 26 41 23 43
5 IFK Norrköping Norrköping 26 41 36 39
6 IFK Göteborg Göteborg 26 27 33 38
7 Västra Frölunda Västra 26 30 33 34
8 Trelleborgs FF Trelleborgs 26 39 47 33
9 IF Elfsborg IF Elfsborg 26 41 48 32
10 Hammarby IF Hammarby IF 26 32 42 29
11 Kalmar FF Kalmar FF 26 27 41 28
12 Orebro SK Orebro SK 26 24 36 27
13 Malmö FF Malmö FF 26 30 48 25
14 Djurgårdens IF Djurgårdens 26 27 41 24
TEMPORADA 1997/1998
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 26 25 15 46
2 Helsingborgs IF Helsingborgs 26 43 28 44
3 Hammarby IF Hammarby IF 26 39 34 42
4 Halmstads Halmstads 26 42 40 41
5 Västra Frölunda Västra 26 29 31 38
6 Orebro SK Orebro SK 26 35 38 36
7 IFK Norrköping Norrköping 26 43 35 35
8 IFK Göteborg Göteborg 26 27 29 35
9 Malmö FF Malmö FF 26 35 30 33
10 IF Elfsborg IF Elfsborg 26 36 33 33
11 Trelleborgs FF Trelleborgs 26 31 35 32
12 Örgryte Örgryte 26 35 36 28
13 Häcken Häcken 26 27 46 27
14 Osters IF Osters IF 26 26 43 22
TEMPORADA 1996/1997
LIGA SUECA
Equipo PJ GF GC Puntos
1 Halmstads Halmstads 26 49 27 52
2 IFK Göteborg Göteborg 26 50 32 49
3 Malmö FF Malmö FF 26 48 28 46
4 Orebro SK Orebro SK 26 43 34 46
5 Örgryte Örgryte 26 34 29 43
6 Helsingborgs IF Helsingborgs 26 40 28 41
7 IF Elfsborg IF Elfsborg 26 45 35 41
8 AIK Solna AIK Solna 26 38 26 37
9 IFK Norrköping Norrköping 26 27 36 28
10 Trelleborgs FF Trelleborgs 26 32 48 28
11 Osters IF Osters IF 26 28 44 23
12 Västerås SK Västerås 26 26 49 23
13 Degerfors IF Degerfors 26 29 47 20
14 Ljungskile Ljungskile 26 31 57 20
TEMPORADA 1986/1987
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 50 21 48
2 IFK Norrköping Norrköping 22 33 19 40
3 IFK Göteborg Göteborg 22 39 24 35
4 Osters IF Osters IF 22 25 26 34
5 IK Brage IK Brage 22 21 23 31
6 Hammarby IF Hammarby IF 22 37 27 28
7 Västra Frölunda Västra 22 21 29 27
8 Örgryte Örgryte 22 32 33 25
9 AIK Solna AIK Solna 22 15 17 25
10 GIF Sundsvall Sundsvall 22 25 31 21
11 Halmstads Halmstads 22 22 39 21
12 IF Elfsborg IF Elfsborg 22 18 49 13
TEMPORADA 1985/1986
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 49 11 53
2 IFK Göteborg Göteborg 22 44 17 44
3 AIK Solna AIK Solna 22 29 21 34
4 IFK Norrköping Norrköping 22 30 30 30
5 Halmstads Halmstads 22 25 32 29
6 Hammarby IF Hammarby IF 22 31 38 28
7 IK Brage IK Brage 22 19 27 28
8 Örgryte Örgryte 22 33 35 26
9 Osters IF Osters IF 22 20 28 26
10 IF Elfsborg IF Elfsborg 22 19 26 23
11 Kalmar FF Kalmar FF 22 22 36 22
12 Djurgårdens IF Djurgårdens 22 23 43 22
TEMPORADA 1983/1984
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 22 43 19 46
2 AIK Solna AIK Solna 22 28 12 43
3 Malmö FF Malmö FF 22 47 24 38
4 Hammarby IF Hammarby IF 22 42 30 37
5 IFK Norrköping Norrköping 22 33 30 32
6 IK Brage IK Brage 22 21 25 27
7 Halmstads Halmstads 22 18 26 26
8 Kalmar FF Kalmar FF 22 17 25 25
9 Örgryte Örgryte 22 24 36 22
10 Osters IF Osters IF 22 28 36 21
11 IF Elfsborg IF Elfsborg 22 24 39 21
12 Gefle Gefle 22 21 44 20

  USO DE MEMORIA  
7,622,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2314
Total Execution Time  0.2326
  CADENA URL  
/historico/If-Elfsborg-Boras/2013
  GET DATOS  
$_GET['/historico/If-Elfsborg-Boras/2013']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0044  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 = 'If-Elfsborg-Boras' AND l.year = 2013 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.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 2326
0.0028  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 = 41751
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1357 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1357 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (43778,57042,132514,1145240,1277727) ORDER BY n.cover_points DESC, update_date DESC
0.0040  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 = '1357' AND l.year = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0037  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 = '1357' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 2326 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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=1357 AND l.year in (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0021  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (42901,42835,21122,21120,3641,2844) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 3641 AND teamId = 1357
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 2844 AND teamId = 1357
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 42835 AND teamId = 1357
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 42901 AND teamId = 1357
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 21120 AND teamId = 1357
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 21122 AND teamId = 1357
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0044  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 events2013 e ON e.player_id = p.id AND e.league_id = 2326 WHERE rp.league_id = 2326 AND rp.teamId = 1357 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.0046  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 events2013 e ON e.player_id = p.id AND e.league_id = 2326 WHERE rp.league_id = 2326 AND rp.teamId = 1357 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 events2013 e ON e.player_id = p.id AND e.league_id = 2326 WHERE rp.league_id = 2326 AND rp.teamId = 1357 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0051  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 = 1357 AND l.year <= 2013 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 1554 AND t.round = 30 ORDER BY team.conference 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 `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 = 1310 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 1089 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 819 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 687 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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
0.0037  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 `tables2004` 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 = 690 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 691 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2002` 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 = 692 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 693 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 694 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 695 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 696 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` 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 = 13063 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1987` 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 = 23054 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1986` 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 = 23055 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0489  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 `tables1984` 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 = 23058 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 2326 ORDER BY nameShow LIMIT 100
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 22 AND l.year = 2013 ORDER BY l.group_code ASC