4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1925/1926
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 80 29 58
2 Standard de Liège Standard 26 77 48 47
3 Daring Molenbeek Daring 26 59 33 47
4 Union Saint-Gilloise Union 26 53 34 47
5 Cercle Brugge Cercle 26 59 27 45
6 Berchem Sport Berchem 26 68 45 41
7 Antwerp Antwerp 26 49 41 39
8 Racing Mechelen Racing 26 65 73 39
9 Club Brugge Club Brugge 26 49 52 36
10 KAA Gent KAA Gent 26 52 56 36
11 KRC Gent KRC Gent 26 63 71 32
12 Anderlecht Anderlecht 26 39 64 27
13 Verviers Verviers 26 34 102 14
14 Tilleur-Saint-Gilles Tilleur-Sain 26 29 101 11
TEMPORADA 1924/1925
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 55 22 58
2 Antwerp Antwerp 26 39 21 47
3 Union Saint-Gilloise Union 26 41 29 45
4 KRC Gent KRC Gent 26 36 38 39
5 Berchem Sport Berchem 26 46 35 38
6 Daring Molenbeek Daring 26 31 23 37
7 Cercle Brugge Cercle 26 25 24 37
8 Anderlecht Anderlecht 26 37 29 36
9 Standard de Liège Standard 26 36 39 35
10 Club Brugge Club Brugge 26 33 44 30
11 KAA Gent KAA Gent 26 24 38 30
12 Racing de Bruxelles Racing 26 25 37 27
13 KV Mechelen KV Mechelen 26 34 47 23
14 White Star Woluwé White Star. 26 17 53 19
TEMPORADA 1923/1924
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 52 21 53
2 Union Saint-Gilloise Union 26 43 20 51
3 Racing de Bruxelles Racing 26 47 30 47
4 Cercle Brugge Cercle 26 47 26 46
5 Standard de Liège Standard 26 43 32 45
6 KRC Gent KRC Gent 26 43 41 43
7 Antwerp Antwerp 26 43 32 33
8 Daring Molenbeek Daring 26 31 32 31
9 Club Brugge Club Brugge 26 38 37 30
10 KAA Gent KAA Gent 27 35 42 28
11 Berchem Sport Berchem 26 31 43 28
12 Racing Mechelen Racing 27 30 70 25
13 Verviers Verviers 26 28 59 20
14 RFC Liège RFC Liège 26 17 43 16
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 1921/1922
LIGA BELGA
Equipo PJ GF GC Puntos
1 K Beerschot VAC Beerschot 26 54 23 56
2 Union Saint-Gilloise Union 26 51 17 54
3 Antwerp Antwerp 26 52 31 52
4 Racing de Bruxelles Racing 26 45 28 43
5 Standard de Liège Standard 26 45 33 39
6 Cercle Brugge Cercle 26 43 39 39
7 Racing Mechelen Racing 26 41 43 36
8 Daring Molenbeek Daring 26 28 31 35
9 Club Brugge Club Brugge 26 39 42 34
10 KAA Gent KAA Gent 26 30 50 26
11 Verviers Verviers 26 27 47 25
12 Anderlecht Anderlecht 26 27 42 22
13 KRC Gent KRC Gent 26 27 47 22
14 KV Mechelen KV Mechelen 26 33 69 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 1912/1913
LIGA BELGA
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 23 84 19 59
2 Daring Molenbeek Daring 23 82 14 56
3 Racing de Bruxelles Racing 22 61 23 44
4 K Beerschot VAC Beerschot 22 52 32 37
5 Cercle Brugge Cercle 22 48 29 36
6 Verviers Verviers 22 49 47 28
7 Club Brugge Club Brugge 22 41 46 28
8 Antwerp Antwerp 22 39 57 27
9 KAA Gent KAA Gent 22 31 36 25
10 Standard de Liège Standard 22 26 64 23
11 RFC Liège RFC Liège 22 15 88 13
12 Royal Excelsior Royal 22 11 84 2
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 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  
5,953,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4475
Total Execution Time  0.4497
  CADENA URL  
/historico/Kaa-Gent/1926
  GET DATOS  
$_GET['/historico/Kaa-Gent/1926']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0134  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 = 'Kaa-Gent' AND l.year = 1926 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.0106  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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0218  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 = 25573
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1431 AND type_rel = 2
0.0111  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1431 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (8774,8790,11964,12268,12941) ORDER BY n.cover_points DESC, update_date DESC
0.0112  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 = '1431' AND l.year = 1926 ORDER BY l.year DESC,cat.coefficient DESC
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 = '1431' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 25573 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0117  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=1431 AND l.year in (1925,1926,1927) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (25577) 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.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 25577 AND teamId = 1431
0.0110  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1926` 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 = 25573 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0113  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 events1926 e ON e.player_id = p.id AND e.league_id = 25573 WHERE rp.league_id = 25573 AND rp.teamId = 1431 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.0114  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 events1926 e ON e.player_id = p.id AND e.league_id = 25573 WHERE rp.league_id = 25573 AND rp.teamId = 1431 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 events1926 e ON e.player_id = p.id AND e.league_id = 25573 WHERE rp.league_id = 25573 AND rp.teamId = 1431 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 = 1431 AND l.year <= 1926 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 `tables1926` 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 = 25573 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 `tables1925` 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 = 25577 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables1924` 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 = 25582 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116  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.0120  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 `tables1922` 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 = 25585 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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.0122  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.0122  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.0108  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 `tables1913` 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 = 25591 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  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.0109  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.0107  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 = 25573 ORDER BY nameShow LIMIT 100