4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tempo Overijse
TEMPORADA 2023/2024
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Belisia Bilzen Belisia 34 71 37 71
2 Sporting Hasselt Sporting 34 67 37 67
3 Lyra-Lierse Lyra-Lierse 34 61 47 60
4 Rupel Boom Rupel Boom 34 62 58 60
5 Racing Mechelen Racing 34 61 46 55
6 KFC Houtvenne Houtvenne 34 48 43 55
7 Bocholter Bocholter 34 59 46 54
8 Tongeren Tongeren 34 50 48 48
9 FC Lebbeke FC Lebbeke 34 49 53 47
10 Mechelen Sub 21 Mechelen 34 57 49 46
11 Berchem Sport Berchem 34 44 43 46
12 Diegem Sport Diegem Sport 34 62 63 45
13 Wezel Wezel 34 59 67 43
14 Hades Hades 34 54 60 42
15 KFC Lille KFC Lille 34 48 60 40
16 Tempo Overijse Tempo 34 33 59 28
17 KSC City Pirates City Pirates 34 41 86 25
18 Londerzeel Londerzeel 34 34 58 25
TEMPORADA 2022/2023
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 Tempo Overijse Tempo 29 68 33 64
2 VW Hamme VW Hamme 29 54 36 55
3 Voorde Appelterre Voorde 29 56 39 53
4 HO Kalken HO Kalken 28 47 33 46
5 Jong Lede Jong Lede 28 46 36 42
6 Wielsbeke Wielsbeke 28 56 50 41
7 Avanti Avanti 28 45 39 38
8 Eendracht Wervik Eendracht 29 51 53 36
9 Roeselare Daisel Roeselare 29 38 41 35
10 Wolvertem Merchtem Wolvertem 29 35 47 35
11 Elene-Grotenberge Elene-Groten 28 44 47 34
12 Anzegem Anzegem 21 30 34 33
13 Drongen Drongen 28 27 35 32
14 Eendracht Aalter Eendracht 29 41 64 32
15 Rumbeke Rumbeke 28 31 54 25
16 Eppegem Eppegem 28 19 47 18
TEMPORADA 2021/2022
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 Oostkamp Oostkamp 30 83 37 74
2 FC Lebbeke FC Lebbeke 30 60 30 63
3 Tempo Overijse Tempo 30 55 37 54
4 Torhout Torhout 30 52 45 54
5 Lochristi Lochristi 30 60 47 48
6 Erpe-Mere United Erpe-Mere 30 45 39 44
7 VW Hamme VW Hamme 30 49 45 44
8 Avanti Avanti 30 48 38 42
9 Wolvertem Merchtem Wolvertem 30 42 39 36
10 Voorde Appelterre Voorde 30 47 52 36
11 Anzegem Anzegem 30 47 60 35
12 Jong Lede Jong Lede 30 47 61 34
13 Eppegem Eppegem 30 36 39 32
14 Svelta Melsele Svelta 30 47 75 27
15 Sint-Niklaas Sint-Niklaas 30 32 66 25
16 Rhodienne-De Hoek Rhodienne-De 30 26 66 23
TEMPORADA 2020/2021
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Avanti Avanti 4 7 2 10
2 FC Lebbeke FC Lebbeke 4 9 5 8
3 Tempo Overijse Tempo 3 7 3 7
4 Oostkamp Oostkamp 4 10 8 7
5 Lochristi Lochristi 3 8 6 6
6 Bambrugge Bambrugge 4 3 4 6
7 Torhout Torhout 4 8 8 4
8 VW Hamme VW Hamme 3 4 4 4
9 Anzegem Anzegem 4 3 5 4
10 Wolvertem Merchtem Wolvertem 4 6 9 4
11 Voorde Appelterre Voorde 3 5 5 3
12 Sint-Niklaas Sint-Niklaas 2 3 5 3
13 Eppegem Eppegem 2 3 3 2
14 Jong Lede Jong Lede 3 1 2 2
15 Rhodienne-De Hoek Rhodienne-De 3 4 6 1
16 Svelta Melsele Svelta 4 4 10 1
TEMPORADA 2019/2020
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 Zelzate Zelzate 24 57 21 58
2 Ninove Ninove 24 52 20 47
3 Olsa Brakel Olsa Brakel 24 47 22 46
4 Wetteren Wetteren 24 54 30 42
5 FC Lebbeke FC Lebbeke 24 30 20 42
6 Avanti Avanti 24 33 20 38
7 Lochristi Lochristi 24 40 33 36
8 Jong Lede Jong Lede 24 41 40 35
9 Eppegem Eppegem 24 38 28 33
10 Wolvertem Merchtem Wolvertem 24 25 28 28
11 Wingene Wingene 24 24 32 28
12 Torhout Torhout 24 34 43 28
13 Tempo Overijse Tempo 24 32 42 26
14 Svelta Melsele Svelta 24 25 47 24
15 Oostnieuwkerke Oostnieuwker 24 17 46 21
16 Bornem Bornem 24 17 94 8
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 KVC Winkel Sport Winkel Sport 30 60 24 69
2 Mandel United Mandel 30 58 30 60
3 Sparta Petegem Sparta 30 55 44 49
4 KRC Gent KRC Gent 30 56 39 48
5 Olympia Wijgmaal Olympia 30 52 46 47
6 Ronse Ronse 30 41 35 43
7 KSCT Menen KSCT Menen 30 51 56 42
8 Londerzeel Londerzeel 30 37 35 40
9 Diegem Sport Diegem Sport 30 37 51 39
10 Westhoek Westhoek 30 48 56 37
11 Dikkelvenne Dikkelvenne 30 28 42 36
12 Racing Club Harelbeke Racing Club 30 37 38 35
13 Gullegem Gullegem 30 40 52 35
14 Eppegem Eppegem 30 36 66 34
15 Tempo Overijse Tempo 30 36 50 29
16 Olsa Brakel Olsa Brakel 30 39 47 28
TEMPORADA 2017/2018
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 30 63 30 65
2 Bocholt Bocholt 30 57 42 57
3 Belisia Bilzen Belisia 30 56 46 52
4 KSC City Pirates City Pirates 30 52 44 47
5 Olympia Wijgmaal Olympia 30 53 49 46
6 Vosselaar Vosselaar 30 49 35 44
7 Hades Hades 30 46 42 43
8 Cappellen Cappellen 30 43 37 41
9 Tempo Overijse Tempo 30 39 51 41
10 KFC Duffel KFC Duffel 30 46 46 40
11 KFC Turnhout Turnhout 30 30 34 37
12 Hoogstraten Hoogstraten 30 39 47 36
13 Sporting Hasselt Sporting 30 34 45 35
14 Zwarte Leeuw Zwarte Leeuw 30 43 47 30
15 Tienen Tienen 30 39 61 28
16 Sint-Lenaarts Sint-Lenaart 30 33 66 22
TEMPORADA 2016/2017
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Berchem Sport Berchem 30 65 24 68
2 Thes Sport Thes Sport 30 61 38 66
3 Rupel Boom Rupel Boom 30 55 38 52
4 Belisia Bilzen Belisia 30 54 58 47
5 Olympia Wijgmaal Olympia 30 45 42 44
6 Bocholt Bocholt 30 44 39 41
7 Zwarte Leeuw Zwarte Leeuw 30 39 56 40
8 Londerzeel Londerzeel 30 46 39 38
9 Hoogstraten Hoogstraten 30 51 60 37
10 Hades Hades 30 45 60 37
11 Cappellen Cappellen 30 41 42 36
12 Tempo Overijse Tempo 30 53 59 36
13 KFC Duffel KFC Duffel 30 53 58 32
14 Grimbergen Grimbergen 30 37 46 32
15 Woluwe Woluwe 30 48 62 32
16 Tienen Tienen 30 29 45 30
TEMPORADA 2015/2016
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Oosterwijk Oosterwijk 36 68 38 71
2 Beerschot VA Beerschot 36 64 39 71
3 Bocholt Bocholt 36 52 41 64
4 Sporting Hasselt Sporting 36 64 41 60
5 Ciney Ciney 36 57 42 57
6 Sprimont-Comblain Sprimont-Com 36 56 43 56
7 RFC Liège RFC Liège 36 58 56 53
8 Hamoir Hamoir 36 70 74 52
9 Rupel Boom Rupel Boom 36 65 55 51
10 Berchem Sport Berchem 36 51 55 50
11 Cappellen Cappellen 36 51 56 49
12 Hoogstraten Hoogstraten 36 60 60 48
13 Walhain Walhain 36 48 57 47
14 Tempo Overijse Tempo 36 47 56 45
15 Tienen Tienen 36 52 56 40
16 La Calamine La Calamine 37 44 61 40
17 Grimbergen Grimbergen 36 38 55 34
18 Diegem Sport Diegem Sport 37 35 68 34
19 Woluwe Woluwe 36 34 61 33
TEMPORADA 2014/2015
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Tempo Overijse Tempo 30 64 24 67
2 Francs Borains Francs 30 64 33 60
3 Acren Lessines Acren 30 44 40 50
4 Rebecq Rebecq 30 61 48 45
5 Châtelet Châtelet 30 40 31 45
6 Olympia Wijgmaal Olympia 30 59 45 44
7 Pepingen-Halle Pepingen-Hal 30 48 54 42
8 Waterloo Waterloo 30 49 44 41
9 Léopold Uccle-Woluwé Léopold 30 43 50 41
10 Sterrebeek Sterrebeek 30 44 44 40
11 Wolvertem Wolvertem 30 37 38 37
12 Ganshoren Ganshoren 30 39 46 37
13 Solre-sur-Sambre Solre-sur-Sa 30 45 59 36
14 Racing Schaerbeek Racing 30 43 59 31
15 Assesse Assesse 30 45 74 25
16 Binche Binche 30 26 62 22
TEMPORADA 2013/2014
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 KFC Duffel KFC Duffel 30 62 35 55
2 Eendracht Zele Eendracht 30 54 31 55
3 Léopold Uccle-Woluwé Léopold 30 49 40 54
4 Olympia Wijgmaal Olympia 30 46 38 49
5 Terjoden-Welle Terjoden-Wel 30 44 42 45
6 Pepingen-Halle Pepingen-Hal 30 57 50 45
7 Tempo Overijse Tempo 30 40 35 44
8 Sterrebeek Sterrebeek 30 52 44 42
9 Sint-Gillis Waas Sint-Gillis 30 52 51 40
10 Wolvertem Wolvertem 30 34 40 40
11 Berlare Berlare 30 46 52 38
12 Wetteren-Kwatrecht Wetteren-Kwa 30 38 46 36
13 Ganshoren Ganshoren 30 42 52 33
14 TK Meldert TK Meldert 30 32 49 30
15 BX Brussels BX Brussels 30 35 52 27
16 Halle Halle 30 24 50 26
TEMPORADA 2012/2013
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Londerzeel Londerzeel 28 66 21 66
2 Tempo Overijse Tempo 28 61 31 57
3 Olympia Wijgmaal Olympia 28 49 29 57
4 Walhain Walhain 28 51 25 53
5 Sterrebeek Sterrebeek 28 45 42 48
6 Léopold Uccle-Woluwé Léopold 28 43 29 45
7 RAEC Mons RAEC Mons 28 45 48 41
8 Acren Lessines Acren 28 62 53 35
9 Ganshoren Ganshoren 28 39 42 35
10 Halle Halle 28 33 39 34
11 Templeuve Templeuve 28 39 49 29
12 Ternat Ternat 28 35 53 29
13 SG-Tertre-Hautrage SG-Tertre-Ha 28 31 50 29
14 Kampenhout Kampenhout 28 33 56 26
15 VC Groot Dilbeek Groot 28 31 96 8
TEMPORADA 2011/2012
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Berchem Sport Berchem 30 64 26 68
2 Tempo Overijse Tempo 30 58 23 64
3 Charleroi Fleurus Charleroi 30 61 34 57
4 VC Groot Dilbeek Groot 30 61 54 49
5 Ternat Ternat 30 51 47 47
6 Ganshoren Ganshoren 30 46 39 45
7 Londerzeel Londerzeel 30 47 42 45
8 Acren Lessines Acren 30 42 44 44
9 KFC Duffel KFC Duffel 30 56 59 38
10 Léopold Uccle-Woluwé Léopold 30 42 50 34
11 Lyra Lyra 30 42 44 33
12 SG-Tertre-Hautrage SG-Tertre-Ha 30 42 59 33
13 Kampenhout Kampenhout 30 33 53 33
14 Katelijne-Waver Katelijne-Wa 30 33 60 31
15 Mariekerke Mariekerke 30 33 55 26
16 Sint-Gillis Waas Sint-Gillis 30 29 51 23
TEMPORADA 2010/2011
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Racing Mechelen Racing 30 62 20 68
2 Londerzeel Londerzeel 30 66 30 58
3 Olympia Wijgmaal Olympia 30 61 42 54
4 TK Meldert TK Meldert 30 62 37 51
5 Lyra Lyra 30 40 35 46
6 Katelijne-Waver Katelijne-Wa 30 55 53 41
7 KFC Duffel KFC Duffel 30 60 57 40
8 Berchem Sport Berchem 30 35 32 40
9 VC Groot Dilbeek Groot 30 46 44 40
10 Tempo Overijse Tempo 30 37 39 40
11 Sint-Gillis Waas Sint-Gillis 30 48 46 39
12 Averbode Okselaar Averbode 30 40 42 39
13 Berlare Berlare 30 47 43 38
14 Eendracht Zele Eendracht 30 33 44 32
15 Opwijk Opwijk 30 40 76 23
16 Willebroek-Meerhof Willebroek-M 30 21 113 6
TEMPORADA 2009/2010
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Bornem Bornem 30 60 32 60
2 Grimbergen Grimbergen 30 57 31 52
3 Oosterwijk Oosterwijk 30 39 30 49
4 TK Meldert TK Meldert 30 48 34 48
5 Olympia Wijgmaal Olympia 30 46 44 48
6 KFC Duffel KFC Duffel 30 44 38 46
7 Sint-Gillis Waas Sint-Gillis 30 51 39 44
8 Lyra Lyra 30 33 32 41
9 Tempo Overijse Tempo 30 35 36 38
10 VC Groot Dilbeek Groot 30 42 45 38
11 Londerzeel Londerzeel 30 37 40 37
12 Berchem Sport Berchem 30 44 47 36
13 Opwijk Opwijk 30 44 53 35
14 Vilvoorde Vilvoorde 30 44 55 34
15 Beerschot VA Beerschot 30 41 60 31
16 Vrasene Vrasene 30 24 73 18
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  
7,176,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7188
Total Execution Time  0.7200
  CADENA URL  
/historico/Tempo-Overijse
  GET DATOS  
$_GET['/historico/Tempo-Overijse']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0140  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 = 'Tempo-Overijse' 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.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=16843 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=16843 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=16843 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=16843 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0266  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 = 72696
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16843 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=241 AND type_rel = 3
0.0132  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 241 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (900137,520396,273795,255821,104680) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '16843' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '16843' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '16843' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 72696 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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=16843 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (73206,72696,71432,68885) 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.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 72696 AND teamId = 16843
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 68885 AND teamId = 16843
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 16843
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16843
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 `tables2024` 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 = 72696 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135  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 = '16843' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16843' and rp.type = 4
0.0136  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 = '16843' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0173  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 events2024 e ON e.player_id = p.id AND e.league_id = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 16843 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.0175  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 events2024 e ON e.player_id = p.id AND e.league_id = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 16843 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164  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 events2024 e ON e.player_id = p.id AND e.league_id = 72696 WHERE rp.league_id = 72696 AND rp.teamId = 16843 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 16843 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 72696 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 68885 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.0143  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 `tables2022` 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 = 63441 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.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 `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 = 58299 AND t.round = 15 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 `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 = 51111 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.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 `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 = 45034 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 39091 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 33883 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 `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 = 15756 AND t.round = 38 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 `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 = 13374 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 `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 = 3516 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 `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 = 27953 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 27960 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 `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 = 27970 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 `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 = 27976 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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