4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Léopold Uccle-Woluwé
TEMPORADA 2019/2020
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Ganshoren Ganshoren 24 56 27 53
2 Jette Jette 24 45 27 48
3 RAEC Mons RAEC Mons 24 53 27 43
4 Rapid Symphorinois Rapid 24 35 27 40
5 Walhain Walhain 24 42 37 40
6 Braine Braine 24 40 38 38
7 Tournai Tournai 24 35 25 37
8 SG-Tertre-Hautrage SG-Tertre-Ha 24 47 41 36
9 Stade Brainois Stade 24 35 36 34
10 Entité Manageoise Entité 24 33 41 31
11 Gosselies Sports Gosselies 24 35 44 31
12 Ostiches Ostiches 24 38 45 29
13 PAC Buzet PAC Buzet 24 28 42 28
14 Kosova Schaerbeek Kosova 24 36 55 24
15 Léopold Uccle-Woluwé Léopold 24 29 44 18
16 Wavre Wavre 24 17 48 13
TEMPORADA 2018/2019
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Union Namur Union Namur 30 68 29 60
2 Braine Braine 30 58 31 60
3 Aische Aische 30 59 47 54
4 Tournai Tournai 30 46 25 52
5 Léopold Uccle-Woluwé Léopold 30 53 36 48
6 Entité Manageoise Entité 30 50 38 47
7 Ostiches Ostiches 30 55 47 47
8 RAEC Mons RAEC Mons 30 45 45 44
9 Rapid Symphorinois Rapid 30 50 50 43
10 Stade Brainois Stade 30 37 36 39
11 Jette Jette 30 48 56 34
12 Racing Jet Wavre Racing Wavre 30 42 63 32
13 Ganshoren Ganshoren 30 44 61 31
14 Jeunesse Tamines Jeunesse 30 45 65 29
15 Stockel Stockel 30 38 69 23
16 Binche Binche 30 33 73 20
TEMPORADA 2017/2018
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 RAAL La Louviere RAAL 30 74 24 69
2 Francs Borains Francs 30 78 32 66
3 Onhaye Onhaye 30 66 47 56
4 Tournai Tournai 30 45 27 55
5 Couvin-Mariembourg Couvin-Marie 30 62 41 54
6 Racing Jet Wavre Racing Wavre 30 58 47 52
7 Binche Binche 30 56 53 52
8 Entité Manageoise Entité 30 52 50 41
9 RAEC Mons RAEC Mons 30 44 40 39
10 Jeunesse Tamines Jeunesse 30 46 56 37
11 Ganshoren Ganshoren 30 40 54 36
12 Léopold Uccle-Woluwé Léopold 30 47 50 32
13 Stade Brainois Stade 30 35 52 29
14 Spy Spy 30 39 83 22
15 Solre-sur-Sambre Solre-sur-Sa 30 35 67 20
16 Waterloo Waterloo 30 34 88 14
TEMPORADA 2016/2017
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 RWD Molenbeek Molenbeek 26 72 31 61
2 Rebecq Rebecq 26 58 24 61
3 Francs Borains Francs 26 60 21 58
4 RAEC Mons RAEC Mons 26 54 28 47
5 Tournai Tournai 26 55 46 40
6 Onhaye Onhaye 26 34 44 37
7 Léopold Uccle-Woluwé Léopold 26 44 29 35
8 Entité Manageoise Entité 26 34 35 35
9 Racing Jet Wavre Racing Wavre 26 40 33 31
10 Solre-sur-Sambre Solre-sur-Sa 26 32 59 27
11 Waterloo Waterloo 26 30 49 26
12 Ganshoren Ganshoren 26 36 65 23
13 Jeunesse Tamines Jeunesse 26 29 51 20
14 Profondeville Profondevill 26 18 81 2
TEMPORADA 2015/2016
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympic Charleroi Olympic 27 52 23 62
2 KFC Duffel KFC Duffel 28 59 34 52
3 Châtelet Châtelet 28 47 40 50
4 Sterrebeek Sterrebeek 28 50 39 49
5 Charleroi Fleurus Charleroi 28 47 45 48
6 Rebecq Rebecq 28 44 35 43
7 Halle Halle 28 46 28 42
8 RWD Molenbeek Molenbeek 28 43 34 39
9 Léopold Uccle-Woluwé Léopold 28 46 52 39
10 Wolvertem Wolvertem 28 44 49 35
11 Betekom Betekom 28 42 39 34
12 Francs Borains Francs 27 41 52 30
13 Ganshoren Ganshoren 28 34 59 24
14 Tournai Tournai 28 32 57 24
15 Waterloo Waterloo 28 22 63 14
16 Géants Athois Géants 0 0 0 0
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 4
Equipo PJ GF GC Puntos
1 La Calamine La Calamine 30 67 43 64
2 Walhain Walhain 30 65 29 62
3 Faymonville Faymonville 30 70 49 53
4 Sprimont-Comblain Sprimont-Com 30 45 26 53
5 Ciney Ciney 30 63 56 51
6 Givry Givry 30 50 44 44
7 Hamoir Hamoir 30 48 46 44
8 RFC Seraing RFC Seraing 30 48 50 44
9 Habay-la-Vieille Habay-la-Vie 30 51 46 39
10 Elsautoise Elsautoise 30 43 46 39
11 Aywaille Aywaille 30 38 45 35
12 Léopold Uccle-Woluwé Léopold 30 45 55 33
13 Wanze / Bas-Oha Wanze 30 39 52 32
14 Couvin-Mariembourg Couvin-Marie 30 43 62 28
15 R.R.F.C. Montegnée R.R.F.C. 30 32 56 28
16 Hannutois Hannutois 30 30 72 15
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
TEMPORADA 1947/1948
LIGA BELGA
Equipo PJ GF GC Puntos
1 KV Mechelen KV Mechelen 30 70 39 61
2 Anderlecht Anderlecht 30 72 50 55
3 RFC Liège RFC Liège 30 73 62 52
4 Antwerp Antwerp 30 61 37 50
5 Olympic Charleroi Olympic 30 56 40 43
6 KAA Gent KAA Gent 30 50 55 43
7 Rupel Boom Rupel Boom 30 47 53 42
8 K Beerschot VAC Beerschot 30 59 67 42
9 Union Saint-Gilloise Union 30 65 76 42
10 Berchem Sport Berchem 30 53 59 40
11 Lyra Lyra 30 55 49 38
12 Charleroi Charleroi 30 60 73 37
13 Standard de Liège Standard 30 66 59 36
14 Racing de Bruxelles Racing 30 41 60 35
15 Léopold Uccle-Woluwé Léopold 30 52 67 33
16 Lierse SK Lierse SK 30 47 81 33
TEMPORADA 1922/1923
LIGA BELGA
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 26 55 19 60
2 K Beerschot VAC Beerschot 27 67 28 56
3 Cercle Brugge Cercle 26 42 21 52
4 Antwerp Antwerp 26 54 37 50
5 Daring Molenbeek Daring 26 46 23 48
6 Racing de Bruxelles Racing 26 58 52 41
7 Standard de Liège Standard 26 47 48 35
8 Club Brugge Club Brugge 27 47 56 32
9 KAA Gent KAA Gent 26 42 53 28
10 Racing Mechelen Racing 26 30 56 26
11 Berchem Sport Berchem 26 36 67 26
12 Verviers Verviers 26 40 57 23
13 Anderlecht Anderlecht 26 31 49 20
14 Léopold Uccle-Woluwé Léopold 26 30 59 17
TEMPORADA 1920/1921
LIGA BELGA
Equipo PJ GF GC Puntos
1 Daring Molenbeek Daring 22 40 10 50
2 Union Saint-Gilloise Union 22 46 18 43
3 K Beerschot VAC Beerschot 22 51 28 40
4 Club Brugge Club Brugge 22 47 29 37
5 Cercle Brugge Cercle 22 41 32 37
6 Racing de Bruxelles Racing 22 43 40 30
7 KAA Gent KAA Gent 22 28 33 30
8 KRC Gent KRC Gent 22 30 45 28
9 Antwerp Antwerp 22 29 37 26
10 Racing Mechelen Racing 22 22 42 19
11 Verviers Verviers 22 34 51 16
12 Léopold Uccle-Woluwé Léopold 22 17 63 9
TEMPORADA 1919/1920
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 22 61 27 49
2 Union Saint-Gilloise Union 22 71 22 46
3 Daring Molenbeek Daring 22 45 28 44
4 Antwerp Antwerp 22 52 35 38
5 K Beerschot VAC Beerschot 22 44 35 36
6 Racing Mechelen Racing 22 37 40 34
7 KRC Gent KRC Gent 22 34 45 31
8 Cercle Brugge Cercle 22 38 38 26
9 Verviers Verviers 22 40 64 22
10 Léopold Uccle-Woluwé Léopold 22 28 58 17
11 Racing de Bruxelles Racing 22 40 59 15
12 KAA Gent KAA Gent 22 28 67 13
TEMPORADA 1913/1914
LIGA BELGA
Equipo PJ GF GC Puntos
1 Daring Molenbeek Daring 22 69 16 52
2 Union Saint-Gilloise Union 22 60 28 48
3 Cercle Brugge Cercle 22 48 27 43
4 Club Brugge Club Brugge 22 42 31 40
5 Racing de Bruxelles Racing 22 53 33 39
6 Verviers Verviers 22 38 39 30
7 K Beerschot VAC Beerschot 22 34 42 27
8 KRC Gent KRC Gent 22 31 44 27
9 Antwerp Antwerp 22 37 54 24
10 KAA Gent KAA Gent 23 29 53 21
11 Standard de Liège Standard 23 21 57 19
12 Léopold Uccle-Woluwé Léopold 22 32 70 13
TEMPORADA 1911/1912
LIGA BELGA
Equipo PJ GF GC Puntos
1 Daring Molenbeek Daring 22 79 15 56
2 Union Saint-Gilloise Union 22 83 24 53
3 Racing de Bruxelles Racing 22 72 27 42
4 Club Brugge Club Brugge 22 47 25 40
5 Cercle Brugge Cercle 22 56 29 38
6 Antwerp Antwerp 22 33 57 29
7 KAA Gent KAA Gent 22 26 45 22
8 Royal Excelsior Royal 22 23 61 21
9 Standard de Liège Standard 22 29 85 21
10 K Beerschot VAC Beerschot 22 20 60 19
11 Racing Mechelen Racing 22 24 42 16
12 Léopold Uccle-Woluwé Léopold 22 24 46 13
TEMPORADA 1910/1911
LIGA BELGA
Equipo PJ GF GC Puntos
1 Cercle Brugge Cercle 22 76 24 51
2 Club Brugge Club Brugge 22 70 27 50
3 Union Saint-Gilloise Union 22 55 36 39
4 Daring Molenbeek Daring 22 52 33 39
5 Racing de Bruxelles Racing 22 52 43 35
6 K Beerschot VAC Beerschot 22 55 45 32
7 Antwerp Antwerp 22 44 46 30
8 Racing Mechelen Racing 22 39 56 26
9 Léopold Uccle-Woluwé Léopold 22 36 62 24
10 Royal Excelsior Royal 22 36 60 22
11 Standard de Liège Standard 22 32 48 19
12 Kortrijk Kortrijk 22 20 87 8
TEMPORADA 1909/1910
LIGA BELGA
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 23 91 15 60
2 Club Brugge Club Brugge 23 81 26 56
3 Cercle Brugge Cercle 22 66 21 54
4 Daring Molenbeek Daring 22 47 33 36
5 K Beerschot VAC Beerschot 22 47 56 32
6 Racing de Bruxelles Racing 22 47 45 30
7 Standard de Liège Standard 22 29 27 30
8 Royal Excelsior Royal 22 48 43 27
9 Antwerp Antwerp 22 25 66 20
10 Léopold Uccle-Woluwé Léopold 22 26 63 17
11 Kortrijk Kortrijk 22 17 61 14
12 RFC Liège RFC Liège 22 11 79 7
TEMPORADA 1908/1909
LIGA BELGA
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 22 101 13 60
2 Daring Molenbeek Daring 22 63 27 49
3 Club Brugge Club Brugge 22 63 26 48
4 Racing de Bruxelles Racing 22 59 21 44
5 K Beerschot VAC Beerschot 22 62 45 33
6 Royal Excelsior Royal 22 41 40 31
7 Cercle Brugge Cercle 22 57 45 30
8 Antwerp Antwerp 22 48 57 28
9 Kortrijk Kortrijk 22 27 86 18
10 RFC Liège RFC Liège 22 22 84 16
11 Léopold Uccle-Woluwé Léopold 22 30 70 12
12 KAA Gent KAA Gent 22 19 78 10

  USO DE MEMORIA  
7,188,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1717
Total Execution Time  0.1732
  CADENA URL  
/historico/Leopold-Uccle-Woluwe/2020
  GET DATOS  
$_GET['/historico/Leopold-Uccle-Woluwe/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0032  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 = 'Leopold-Uccle-Woluwe' AND l.year = 2020 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=16838 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=16838 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=16838 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 51109
0.0029  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 = 50389
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16838 AND type_rel = 2
0.0065  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 = '16838' ORDER BY l.year DESC,cat.coefficient DESC
0.0050  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 = '16838' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '16838' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 51109 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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 = 50389 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=16838 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (58302,57008,51109) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 51109 AND teamId = 16838
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 58302 AND teamId = 16838
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 57008 AND teamId = 16838
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 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 = 51109 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '16838' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16838' and rp.type = 4
0.0023  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 = '16838' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 51109 WHERE rp.league_id = 51109 AND rp.teamId = 16838 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.0020  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 = 51109 WHERE rp.league_id = 51109 AND rp.teamId = 16838 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 51109 WHERE rp.league_id = 51109 AND rp.teamId = 16838 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 16838 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 = 51109 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.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 `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 = 44694 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 `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 = 38981 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 `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 = 34028 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051  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.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 `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.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 = 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.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 `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.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 `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 = 27972 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 `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.0024  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 `tables1948` 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 = 25505 AND t.round = 30 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 `tables1923` 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 = 25584 AND t.round = 27 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 `tables1921` 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 = 25587 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0078  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 `tables1920` 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 = 25588 AND t.round = 22 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 `tables1914` 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 = 25590 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1912` 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 = 25598 AND t.round = 22 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 `tables1911` 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 = 25599 AND t.round = 22 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 `tables1910` 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 = 25602 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1909` 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 = 25603 AND t.round = 22 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 = 51109 ORDER BY nameShow LIMIT 100