4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Temse
TEMPORADA 2019/2020
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Knokke Knokke 24 57 15 63
2 Mandel United Mandel 24 51 31 45
3 Ronse Ronse 24 42 26 45
4 Oudenaarde Oudenaarde 24 54 46 42
5 KRC Gent KRC Gent 24 36 29 41
6 Sparta Petegem Sparta 24 51 39 39
7 Gullegem Gullegem 24 36 32 39
8 Voorwaarts Zwevezele Voorwaarts 24 41 28 38
9 Racing Club Harelbeke Racing Club 24 30 35 35
10 Dikkelvenne Dikkelvenne 24 35 37 31
11 Westhoek Westhoek 24 29 48 28
12 Temse Temse 24 22 38 24
13 KSCT Menen KSCT Menen 24 28 47 20
14 Merelbeke Merelbeke 24 25 41 19
15 Sint-Niklaas Sint-Niklaas 24 22 49 16
16 VW Hamme VW Hamme 24 34 52 15
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Patro Eisden Patro Eisden 30 59 26 66
2 Sporting Hasselt Sporting 30 53 29 60
3 Bocholt Bocholt 31 56 39 52
4 Temse Temse 30 60 48 51
5 Hades Hades 30 50 40 43
6 Berchem Sport Berchem 31 55 51 43
7 KFC Duffel KFC Duffel 30 47 40 41
8 Cappellen Cappellen 30 41 41 41
9 Sint-Niklaas Sint-Niklaas 30 48 47 40
10 Vosselaar Vosselaar 30 45 59 38
11 Hoogstraten Hoogstraten 30 30 33 37
12 VW Hamme VW Hamme 30 44 48 36
13 Belisia Bilzen Belisia 30 48 56 35
14 KSC City Pirates City Pirates 30 35 42 34
15 KFC Turnhout Turnhout 30 38 58 29
16 Heur Tongeren Heur 30 30 82 14
TEMPORADA 2017/2018
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Rupel Boom Rupel Boom 30 74 49 61
2 Izegem Izegem 30 59 33 57
3 KVC Winkel Sport Winkel Sport 30 60 41 55
4 Sparta Petegem Sparta 30 64 40 53
5 Westhoek Westhoek 30 61 56 51
6 Sint-Niklaas Sint-Niklaas 30 55 43 50
7 Temse Temse 30 51 42 48
8 Racing Club Harelbeke Racing Club 30 45 42 43
9 Olsa Brakel Olsa Brakel 30 41 49 41
10 Gullegem Gullegem 30 51 52 40
11 KRC Gent KRC Gent 30 47 59 37
12 Londerzeel Londerzeel 30 55 51 36
13 Ronse Ronse 30 33 44 33
14 Pepingen-Halle Pepingen-Hal 30 30 56 28
15 Torhout Torhout 30 36 67 26
16 Bornem Bornem 30 28 66 17
TEMPORADA 2016/2017
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Knokke Knokke 30 73 25 72
2 Sparta Petegem Sparta 30 60 44 58
3 Eendracht Aalst Eendracht 30 55 37 56
4 KVC Winkel Sport Winkel Sport 30 55 30 53
5 Izegem Izegem 30 53 42 53
6 Olsa Brakel Olsa Brakel 30 59 51 43
7 Temse Temse 30 38 45 42
8 KRC Gent KRC Gent 30 46 43 41
9 Torhout Torhout 30 36 45 39
10 Gullegem Gullegem 30 46 52 37
11 Sint-Niklaas Sint-Niklaas 30 45 49 35
12 Bornem Bornem 30 31 39 34
13 Racing Club Harelbeke Racing Club 30 36 45 34
14 Westhoek Westhoek 30 40 56 34
15 Halle Halle 30 27 55 23
16 KSCT Menen KSCT Menen 30 35 77 16
TEMPORADA 2015/2016
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 VW Hamme VW Hamme 34 66 31 68
2 KVC Winkel Sport Winkel Sport 34 61 43 63
3 Oudenaarde Oudenaarde 34 70 45 60
4 FCV Dender FCV Dender 34 69 43 59
5 Londerzeel Londerzeel 34 58 37 59
6 Sparta Petegem Sparta 34 66 54 56
7 Eendracht Aalst Eendracht 34 66 55 54
8 Temse Temse 34 60 48 53
9 La Louvière Centre Louvière 34 54 44 50
10 Olsa Brakel Olsa Brakel 34 56 46 46
11 Gullegem Gullegem 34 50 45 45
12 KRC Gent KRC Gent 34 50 56 43
13 Sint-Niklaas Sint-Niklaas 34 51 57 42
14 Bornem Bornem 34 54 56 38
15 Izegem Izegem 34 51 73 28
16 Torhout Torhout 34 29 75 28
17 Acren Lessines Acren 34 37 91 23
18 Racing Mechelen Racing 34 33 82 22
TEMPORADA 2014/2015
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Coxyde Coxyde 34 75 42 71
2 Deinze Deinze 34 72 29 65
3 Temse Temse 34 64 33 61
4 Olsa Brakel Olsa Brakel 34 52 44 55
5 Oudenaarde Oudenaarde 34 54 42 54
6 Rupel Boom Rupel Boom 34 55 51 54
7 KVC Winkel Sport Winkel Sport 34 57 53 52
8 VW Hamme VW Hamme 34 55 50 50
9 FCV Dender FCV Dender 34 46 39 49
10 KRC Gent KRC Gent 34 41 48 47
11 Londerzeel Londerzeel 34 46 43 44
12 Gullegem Gullegem 34 35 34 43
13 Bornem Bornem 34 46 53 42
14 Torhout Torhout 34 33 42 40
15 Izegem Izegem 34 45 57 40
16 Géants Athois Géants 34 39 68 35
17 Eendracht Zele Eendracht 34 43 65 30
18 Tournai Tournai 34 27 92 14
TEMPORADA 2013/2014
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Mechelen Racing 35 77 37 75
2 Oudenaarde Oudenaarde 35 64 39 67
3 Deinze Deinze 35 55 39 60
4 Londerzeel Londerzeel 34 55 41 57
5 Coxyde Coxyde 34 66 46 56
6 Géants Athois Géants 35 49 39 53
7 Olsa Brakel Olsa Brakel 35 60 59 51
8 KRC Gent KRC Gent 35 53 48 49
9 Tournai Tournai 35 54 56 47
10 VW Hamme VW Hamme 35 62 67 41
11 Torhout Torhout 34 39 55 41
12 FCV Dender FCV Dender 34 45 59 40
13 Izegem Izegem 35 46 60 39
14 Rupel Boom Rupel Boom 34 41 63 39
15 Temse Temse 34 46 56 37
16 Bornem Bornem 35 55 62 36
17 Sint-Niklaas Sint-Niklaas 34 40 50 33
18 Standaard Wetteren Standaard 34 35 66 32
TEMPORADA 2012/2013
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Hoogstraten Hoogstraten 34 73 31 74
2 Racing Mechelen Racing 34 55 37 64
3 Geel-Meerhout Geel-Meerhou 34 65 37 61
4 Rupel Boom Rupel Boom 34 56 45 56
5 Berchem Sport Berchem 34 50 46 52
6 Cappellen Cappellen 34 57 38 51
7 Torhout Torhout 34 42 37 51
8 VW Hamme VW Hamme 34 49 44 48
9 Coxyde Coxyde 34 54 42 46
10 Bornem Bornem 34 51 53 45
11 Temse Temse 34 39 51 43
12 Standaard Wetteren Standaard 34 46 56 42
13 Deinze Deinze 34 51 60 39
14 Olsa Brakel Olsa Brakel 34 44 56 39
15 KFC Turnhout Turnhout 34 53 66 34
16 Izegem Izegem 34 49 67 34
17 Ronse Ronse 34 47 73 31
18 Racing Waregem Racing 34 42 84 28
TEMPORADA 2011/2012
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Dessel Sport Dessel Sport 34 61 32 69
2 Hoogstraten Hoogstraten 34 77 49 65
3 Bocholt Bocholt 34 64 43 65
4 Woluwe Woluwe 34 63 46 59
5 Rupel Boom Rupel Boom 34 62 42 58
6 VW Hamme VW Hamme 34 62 52 56
7 Bornem Bornem 34 69 59 54
8 Racing Mechelen Racing 34 60 44 51
9 Geel-Meerhout Geel-Meerhou 34 48 52 48
10 La Calamine La Calamine 34 47 47 47
11 KFC Turnhout Turnhout 34 51 55 46
12 Union Saint-Gilloise Union 34 42 58 42
13 Diegem Sport Diegem Sport 34 40 37 41
14 Patro Eisden Patro Eisden 34 43 53 35
15 Grimbergen Grimbergen 34 29 51 32
16 Temse Temse 34 39 65 32
17 Olympia Wijgmaal Olympia 34 37 72 28
18 Sporting Hasselt Sporting 34 29 66 24
TEMPORADA 2010/2011
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Eendracht Aalst Eendracht 34 71 29 74
2 Hoogstraten Hoogstraten 34 74 39 62
3 Deinze Deinze 34 62 54 59
4 Coxyde Coxyde 34 70 54 58
5 Dessel Sport Dessel Sport 34 56 38 57
6 Oudenaarde Oudenaarde 34 57 49 55
7 Sint-Niklaas Sint-Niklaas 34 47 36 54
8 Geel-Meerhout Geel-Meerhou 34 51 45 53
9 Ronse Ronse 34 42 39 45
10 VW Hamme VW Hamme 34 40 49 43
11 Torhout Torhout 34 43 57 42
12 Temse Temse 34 45 61 42
13 Olsa Brakel Olsa Brakel 34 53 64 38
14 Racing Waregem Racing 34 31 50 38
15 Bornem Bornem 34 44 48 37
16 Cappellen Cappellen 34 45 51 35
17 Izegem Izegem 34 44 57 34
18 Wielsbeke Wielsbeke 34 31 86 18
TEMPORADA 2009/2010
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Heist Heist 36 73 34 76
2 Rupel Boom Rupel Boom 36 82 46 72
3 Eendracht Aalst Eendracht 36 82 44 67
4 Deinze Deinze 36 50 38 60
5 Temse Temse 36 61 61 56
6 Coxyde Coxyde 36 67 43 55
7 VW Hamme VW Hamme 36 59 51 55
8 Hoogstraten Hoogstraten 36 59 55 50
9 Sint-Niklaas Sint-Niklaas 36 62 55 49
10 Oudenaarde Oudenaarde 36 62 62 48
11 Racing Waregem Racing 36 43 51 48
12 Torhout Torhout 36 49 51 45
13 Wielsbeke Wielsbeke 36 50 62 45
14 Ternat Ternat 36 53 72 41
15 Cappellen Cappellen 36 40 62 39
16 Sottegem Sottegem 36 32 65 38
17 Westhoek Westhoek 36 53 70 37
18 Racing Mechelen Racing 36 52 71 37
19 Willebroek-Meerhof Willebroek-M 36 40 76 30
TEMPORADA 2008/2009
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Temse Temse 30 63 37 59
2 Bornem Bornem 30 49 25 56
3 VC Groot Dilbeek Groot 30 56 31 55
4 TK Meldert TK Meldert 30 56 37 51
5 Ternat Ternat 30 64 48 49
6 Opwijk Opwijk 30 42 31 49
7 KFC Duffel KFC Duffel 30 48 38 49
8 Berchem Sport Berchem 30 43 37 44
9 Grimbergen Grimbergen 30 57 44 42
10 Beerschot VA Beerschot 30 55 52 42
11 Berlare Berlare 30 48 38 40
12 Eendracht Zele Eendracht 30 42 60 33
13 Londerzeel Londerzeel 30 41 44 32
14 Eendracht Buggenhout Eendracht 30 29 65 23
15 Tubantia Borgerhout Tubantia 30 24 65 20
16 Schoten Schoten 30 18 83 10
TEMPORADA 2007/2008
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Woluwe Woluwe 30 60 21 66
2 KRC Gent KRC Gent 29 60 26 66
3 Rupel Boom Rupel Boom 30 66 34 64
4 Temse Temse 30 67 31 62
5 Schoten Schoten 30 51 40 47
6 Heist Heist 30 56 45 46
7 Lyra Lyra 30 42 45 42
8 Bornem Bornem 30 51 54 41
9 Tubantia Borgerhout Tubantia 30 37 58 38
10 Eendracht Zele Eendracht 29 36 43 32
11 Berchem Sport Berchem 30 34 43 32
12 Grimbergen Grimbergen 30 43 58 32
13 Olympia Wijgmaal Olympia 30 37 52 32
14 Léopold Uccle-Woluwé Léopold 30 30 59 29
15 Evergem-Center Evergem-Cent 30 34 62 22
16 Tempo Overijse Tempo 30 31 64 21

  USO DE MEMORIA  
6,667,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.8804
Total Execution Time  0.8817
  CADENA URL  
/historico/Temse
  GET DATOS  
$_GET['/historico/Temse']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
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 = 'Temse' 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.0158  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 = 'Temse' 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 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=7552 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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 = 50975
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7552 AND type_rel = 2
0.0130  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 = '7552' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '7552' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '7552' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138  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 = '7552' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 50975 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  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=7552 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (50975,50389,43475) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 50975 AND teamId = 7552
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 50389 AND teamId = 7552
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 7552
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 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 = 50975 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '7552' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7552' and rp.type = 4
0.0127  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 = '7552' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 50975 WHERE rp.league_id = 50975 AND rp.teamId = 7552 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.0126  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 = 50975 WHERE rp.league_id = 50975 AND rp.teamId = 7552 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 50975 WHERE rp.league_id = 50975 AND rp.teamId = 7552 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 7552 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 50975 AND t.round = 24 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 = 45033 AND t.round = 30 ORDER BY team.conference 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 `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 = 39090 AND t.round = 30 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 `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 = 33882 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 15755 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 4221 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 2737 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 2018 AND t.round = 34 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 `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 = 1743 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 24294 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 24297 AND t.round = 38 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 `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 = 27981 AND t.round = 30 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 `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 = 27985 AND t.round = 30 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 = 50975 ORDER BY nameShow LIMIT 100