4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2016/2017
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 67 30 61
2 Club Brugge Club Brugge 30 56 24 59
3 Zulte-Waregem Zulte-Warege 30 49 38 54
4 KAA Gent KAA Gent 30 45 29 50
5 KV Oostende KV Oostende 30 52 37 50
6 Charleroi Charleroi 30 34 29 49
7 KV Mechelen KV Mechelen 30 41 36 48
8 Genk Genk 30 40 35 48
9 Standard de Liège Standard 30 47 38 39
10 Kortrijk Kortrijk 30 38 55 31
11 Lokeren Lokeren 30 24 34 31
12 Sint-Truidense V.V. Sint-Truiden 30 35 48 30
13 KAS Eupen KAS Eupen 30 40 64 30
14 SK Beveren SK Beveren 30 28 43 30
15 Mouscron Mouscron 30 29 53 24
16 KVC Westerlo Westerlo 30 33 65 23
TEMPORADA 2015/2016
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 10 25 9 54
2 Anderlecht Anderlecht 10 15 16 47
3 KAA Gent KAA Gent 10 10 15 42
4 Genk Genk 10 20 13 40
5 KV Oostende KV Oostende 10 14 19 36
6 Zulte-Waregem Zulte-Warege 10 11 23 27
TEMPORADA 2014/2015
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KV Mechelen KV Mechelen 6 14 3 15
2 Genk Genk 6 14 7 15
3 Zulte-Waregem Zulte-Warege 6 6 10 4
4 SK Beveren SK Beveren 6 5 19 1
5 Lokeren Lokeren 6 19 9 13
6 Mouscron Mouscron 6 9 8 10
7 KV Oostende KV Oostende 6 6 12 6
8 KVC Westerlo Westerlo 6 7 12 5
TEMPORADA 2013/2014
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Standard de Liège Standard 30 59 17 67
2 Club Brugge Club Brugge 30 54 28 63
3 Anderlecht Anderlecht 30 61 31 57
4 Zulte-Waregem Zulte-Warege 30 51 38 53
5 Lokeren Lokeren 30 48 31 51
6 Genk Genk 30 42 39 45
7 KAA Gent KAA Gent 30 39 37 44
8 Kortrijk Kortrijk 30 42 44 39
9 KV Oostende KV Oostende 30 28 46 34
10 Charleroi Charleroi 30 36 41 34
11 Cercle Brugge Cercle 30 29 55 33
12 Lierse SK Lierse SK 30 36 53 32
13 KV Mechelen KV Mechelen 30 34 51 31
14 SK Beveren SK Beveren 30 28 35 31
15 OH Leuven OH Leuven 30 30 47 27
16 Mons Mons 30 29 53 22
TEMPORADA 2012/2013
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 69 27 67
2 Zulte-Waregem Zulte-Warege 30 49 29 63
3 Genk Genk 30 63 40 55
4 Club Brugge Club Brugge 30 66 43 54
5 Lokeren Lokeren 30 53 38 51
6 Standard de Liège Standard 30 54 33 50
7 Mons Mons 30 48 53 44
8 KV Mechelen KV Mechelen 30 44 42 41
9 Kortrijk Kortrijk 30 31 30 39
10 OH Leuven OH Leuven 30 46 51 36
11 Charleroi Charleroi 30 30 49 34
12 KAA Gent KAA Gent 30 33 40 34
13 SK Beveren SK Beveren 30 28 49 30
14 Lierse SK Lierse SK 30 28 53 26
15 Beerschot Beerschot 30 31 61 23
16 Cercle Brugge Cercle 30 30 65 14
TEMPORADA 2011/2012
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 61 26 67
2 Club Brugge Club Brugge 30 51 32 61
3 KAA Gent KAA Gent 30 63 35 56
4 Standard de Liège Standard 30 43 33 51
5 Genk Genk 30 60 44 46
6 Kortrijk Kortrijk 30 39 36 46
7 Cercle Brugge Cercle 30 36 37 46
8 Lokeren Lokeren 30 48 40 44
9 KV Mechelen KV Mechelen 30 40 50 37
10 Mons Mons 30 50 55 36
11 Beerschot Beerschot 30 45 51 36
12 Lierse SK Lierse SK 30 24 36 31
13 Zulte-Waregem Zulte-Warege 30 32 38 30
14 OH Leuven OH Leuven 30 38 58 29
15 KVC Westerlo Westerlo 30 29 59 20
16 Sint-Truidense V.V. Sint-Truiden 30 32 61 19
TEMPORADA 2010/2011
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 58 20 65
2 Genk Genk 30 64 27 64
3 KAA Gent KAA Gent 30 59 42 57
4 Club Brugge Club Brugge 30 60 35 53
5 Lokeren Lokeren 30 43 36 50
6 Standard de Liège Standard 30 50 38 49
7 KV Mechelen KV Mechelen 30 34 30 48
8 KVC Westerlo Westerlo 30 41 40 41
9 Cercle Brugge Cercle 30 33 34 39
10 Kortrijk Kortrijk 30 36 39 38
11 Zulte-Waregem Zulte-Warege 30 39 41 33
12 Sint-Truidense V.V. Sint-Truiden 30 20 51 29
13 Germinal Beerschot Germinal 30 24 40 26
14 Lierse SK Lierse SK 30 26 58 24
15 Eupen Eupen 30 28 50 23
16 Charleroi Charleroi 30 20 54 19
TEMPORADA 2009/2010
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 28 62 20 69
2 Club Brugge Club Brugge 28 52 33 57
3 KAA Gent KAA Gent 28 49 30 49
4 Kortrijk Kortrijk 28 39 30 45
5 Sint-Truidense V.V. Sint-Truiden 28 35 35 42
6 Zulte-Waregem Zulte-Warege 28 39 32 41
7 KV Mechelen KV Mechelen 28 36 46 39
8 Standard de Liège Standard 28 38 34 39
9 Cercle Brugge Cercle 28 45 40 38
10 KVC Westerlo Westerlo 29 29 34 35
11 Germinal Beerschot Germinal 28 30 43 35
12 Genk Genk 28 33 31 34
13 Charleroi Charleroi 28 28 45 23
14 Lokeren Lokeren 28 22 54 18
15 KSV Roeselare Roeselare 28 29 58 18
16 Excelsior Mouscron Excelsior 1 0 1 0
TEMPORADA 2008/2009
LIGA BELGA
Equipo PJ GF GC Puntos
1 Standard de Liège Standard 34 66 26 77
2 Anderlecht Anderlecht 34 75 30 77
3 Club Brugge Club Brugge 34 59 50 59
4 KAA Gent KAA Gent 34 67 42 59
5 Zulte-Waregem Zulte-Warege 34 55 36 55
6 KVC Westerlo Westerlo 34 42 38 52
7 Lokeren Lokeren 34 40 32 51
8 Genk Genk 34 48 51 50
9 Cercle Brugge Cercle 34 48 53 47
10 KV Mechelen KV Mechelen 34 46 52 46
11 Excelsior Mouscron Excelsior 34 42 49 44
12 Charleroi Charleroi 34 43 48 43
13 Germinal Beerschot Germinal 34 44 42 42
14 Kortrijk Kortrijk 34 37 55 38
15 FCV Dender FCV Dender 34 44 58 35
16 KSV Roeselare Roeselare 34 33 59 30
17 Tubize Tubize 34 35 77 27
18 Mons Mons 34 31 57 19
TEMPORADA 2007/2008
LIGA BELGA
Equipo PJ GF GC Puntos
1 Standard de Liège Standard 34 61 19 77
2 Anderlecht Anderlecht 34 59 31 70
3 Club Brugge Club Brugge 34 45 30 67
4 Cercle Brugge Cercle 34 62 33 60
5 Germinal Beerschot Germinal 34 46 34 55
6 KAA Gent KAA Gent 34 57 46 52
7 Zulte-Waregem Zulte-Warege 34 47 54 47
8 Charleroi Charleroi 34 41 45 46
9 KVC Westerlo Westerlo 34 43 37 45
10 Genk Genk 34 54 55 45
11 Excelsior Mouscron Excelsior 34 38 43 42
12 Lokeren Lokeren 34 32 33 42
13 KV Mechelen KV Mechelen 34 45 52 40
14 KSV Roeselare Roeselare 34 36 55 38
15 FCV Dender FCV Dender 34 33 59 33
16 Mons Mons 34 37 45 33
17 Sint-Truidense V.V. Sint-Truiden 34 32 58 27
18 RWD Molenbeek Molenbeek 34 27 66 19
TEMPORADA 2006/2007
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 75 30 77
2 Genk Genk 34 71 37 72
3 Standard de Liège Standard 34 62 38 64
4 KAA Gent KAA Gent 34 56 40 60
5 Charleroi Charleroi 34 51 40 60
6 Club Brugge Club Brugge 34 58 40 51
7 Germinal Beerschot Germinal 34 52 46 51
8 KVC Westerlo Westerlo 34 41 44 46
9 Mons Mons 34 41 41 44
10 Excelsior Mouscron Excelsior 34 51 55 42
11 KSV Roeselare Roeselare 34 50 72 39
12 Cercle Brugge Cercle 34 31 36 38
13 RWD Molenbeek Molenbeek 34 39 50 38
14 Zulte-Waregem Zulte-Warege 34 40 54 37
15 Sint-Truidense V.V. Sint-Truiden 34 39 52 35
16 Lokeren Lokeren 34 32 48 30
17 Lierse SK Lierse SK 34 33 66 26
18 KSK Beveren KSK Beveren 34 31 64 25
TEMPORADA 2005/2006
LIGA BELGA
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 34 72 27 70
2 Standard de Liège Standard 34 51 28 65
3 Club Brugge Club Brugge 34 51 33 64
4 KAA Gent KAA Gent 34 48 34 61
5 Genk Genk 34 48 38 57
6 Zulte-Waregem Zulte-Warege 34 51 49 49
7 Germinal Beerschot Germinal 34 45 45 47
8 Lokeren Lokeren 34 48 49 47
9 KVC Westerlo Westerlo 34 42 48 46
10 RWD Molenbeek Molenbeek 34 30 30 46
11 Charleroi Charleroi 34 39 39 45
12 KSV Roeselare Roeselare 34 44 42 41
13 Cercle Brugge Cercle 34 38 56 38
14 Excelsior Mouscron Excelsior 34 43 43 37
15 Sint-Truidense V.V. Sint-Truiden 34 36 49 34
16 KSK Beveren KSK Beveren 34 35 55 33
17 Lierse SK Lierse SK 34 22 52 32
18 RAA Louvieroise Louvieroise 34 26 52 26
TEMPORADA 2004/2005
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 83 25 79
2 Anderlecht Anderlecht 34 75 34 76
3 Genk Genk 34 59 37 70
4 Standard de Liège Standard 34 64 30 70
5 Charleroi Charleroi 34 47 34 64
6 KAA Gent KAA Gent 34 46 36 59
7 RAA Louvieroise Louvieroise 34 43 43 44
8 Lokeren Lokeren 34 36 38 44
9 Germinal Beerschot Germinal 34 36 45 42
10 Lierse SK Lierse SK 34 57 60 41
11 Cercle Brugge Cercle 34 45 74 41
12 KVC Westerlo Westerlo 34 34 54 39
13 Excelsior Mouscron Excelsior 34 40 43 36
14 Sint-Truidense V.V. Sint-Truiden 34 40 58 36
15 RWD Molenbeek Molenbeek 34 32 60 33
16 KSK Beveren KSK Beveren 34 43 59 32
17 KV Oostende KV Oostende 34 31 62 27
18 Mons Mons 34 39 58 26

  USO DE MEMORIA  
7,467,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1998
Total Execution Time  0.2010
  CADENA URL  
/historico/Genk/2017
  GET DATOS  
$_GET['/historico/Genk/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (62)  
0.0039  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 = 'Genk' AND l.year = 2017 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=9785 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=9785 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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9785 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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=9785 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 34909
0.0025  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 = 37544
0.0023  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 = 33313
0.0023  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 = 38504
0.0025  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 = 33892
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 = 34126
0.0025  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 = 33404
0.0023  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 = 38081
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9785 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9785 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 (41287,366,4400,4705,9529) ORDER BY n.cover_points DESC, update_date DESC
0.0046  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 = '9785' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0046  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 = '9785' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 33404 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 34126 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 34909 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 38081 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 33313 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=9785 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (43513,38787,38427,38081,37544,34126) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 43513 AND teamId = 9785
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 37544 AND teamId = 9785
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 34126 AND teamId = 9785
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 38787 AND teamId = 9785
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 38081 AND teamId = 9785
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 9785
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 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 = 34909 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '9785' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9785' and rp.type = 4
0.0020  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 = '9785' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 events2017 e ON e.player_id = p.id AND e.league_id = 34909 WHERE rp.league_id = 34909 AND rp.teamId = 9785 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 events2017 e ON e.player_id = p.id AND e.league_id = 34909 WHERE rp.league_id = 34909 AND rp.teamId = 9785 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2017 e ON e.player_id = p.id AND e.league_id = 34909 WHERE rp.league_id = 34909 AND rp.teamId = 9785 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 9785 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 33313 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 = 15156 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 `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 = 21698 AND t.round = 10 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 `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 = 3814 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 `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 = 11090 AND t.round = 6 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 `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 = 10117 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 = 2409 AND t.round = 30 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 `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 = 10122 AND t.round = 10 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 `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 = 2015 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 `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 = 10127 AND t.round = 10 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 `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 = 1356 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 `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 = 10144 AND t.round = 10 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 `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 = 1077 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 10151 AND t.round = 6 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 `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 = 864 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 34909 ORDER BY nameShow LIMIT 100