4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Binche Binche 23 52 21 61
2 Solre-sur-Sambre Solre-sur-Sa 23 46 27 41
3 Le Roeulx Le Roeulx 23 38 27 41
4 RAS Monceau RAS Monceau 23 34 18 40
5 Hornu Hornu 23 41 27 38
6 Molenbaix Molenbaix 23 41 31 36
7 Soignies Sports Soignies 23 38 36 34
8 Belœil Belœil 23 44 27 33
9 Peruwelz Peruwelz 23 32 32 30
10 Snef-Tyber Snef-Tyber 23 29 41 26
11 Montignies Montignies 23 26 34 25
12 Houdeng Houdeng 23 20 34 25
13 Antoing Antoing 23 30 39 24
14 Gilly Gilly 23 19 41 19
15 SC Paturages Paturages 23 22 46 18
16 Olympic Warcoing Olympic 23 26 57 15
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Habay-la-Neuve Habay-la-Neu 26 56 22 66
2 Marloie Sport Marloie 26 46 24 51
3 Saint-Hubert Saint-Hubert 26 55 32 46
4 Ethe Belmont Ethe Belmont 26 46 22 45
5 Libramontois Libramontois 26 45 24 45
6 La Roche La Roche 26 31 22 42
7 Lorraine Arlon Lorraine 26 42 36 37
8 Gouvy Gouvy 26 41 36 36
9 Chaumont Chaumont 26 35 34 33
10 Saint-Louis-Saint-Léger Saint-Louis- 26 28 41 27
11 Jeunesse Freylangeoise Jeunesse 26 32 55 25
12 Sartoise Sartoise 26 28 53 23
13 Champlon Champlon 26 23 55 21
14 Rossignol Rossignol 26 20 72 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Meix-Devant-Virton Meix-Devant- 26 66 19 60
2 Oppagne-Wéris Oppagne-Wér 26 52 27 57
3 Ethe Belmont Ethe Belmont 26 39 21 50
4 Marloie Sport Marloie 26 42 32 40
5 Libramontois Libramontois 26 45 40 40
6 Saint-Louis-Saint-Léger Saint-Louis- 26 27 27 37
7 Chaumont Chaumont 26 33 36 36
8 La Roche La Roche 26 41 35 35
9 Rossignol Rossignol 26 30 33 33
10 Champlon Champlon 26 29 37 29
11 Lorraine Arlon Lorraine 26 34 51 28
12 Érezée Érezée 26 23 41 27
13 Nothomb-Post Nothomb-Post 26 33 67 17
14 Wellin Wellin 26 28 56 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Wépion Wépion 30 70 25 66
2 Spy Spy 30 77 40 66
3 Nismes Nismes 30 61 40 54
4 Union Rochefortoise Union 30 60 42 50
5 Assesse Assesse 30 53 41 49
6 Flavion Sport Flavion 30 61 51 48
7 Grand-Leez Grand-Leez 30 56 51 42
8 Es de la Moligneé Moligneé 30 53 66 42
9 Pesche Pesche 30 46 52 38
10 Loyers Loyers 30 55 58 37
11 Ligny Ligny 30 50 60 36
12 Andennais Andennais 30 49 61 35
13 Arquet Arquet 30 41 54 34
14 Fosses Fosses 30 55 80 34
15 Meux II Meux II 30 48 66 25
16 Anhée Anhée 30 22 70 11
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Onhaye Onhaye 30 88 33 69
2 Aische Aische 30 67 37 55
3 Profondeville Profondevill 30 52 48 50
4 Fosses Fosses 30 65 53 48
5 Wépion Wépion 30 63 46 47
6 Assesse Assesse 30 67 58 47
7 Nismes Nismes 30 70 55 46
8 Grand-Leez Grand-Leez 30 64 59 45
9 Ligny Ligny 30 49 53 45
10 Union Rochefortoise Union 30 51 55 44
11 Meux II Meux II 30 57 67 38
12 Arquet Arquet 30 52 57 36
13 Pesche Pesche 30 44 63 31
14 Condruzien Condruzien 30 45 68 25
15 Bièvre Bièvre 30 53 98 25
16 Beauraing Beauraing 30 34 71 20
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Loyers Loyers 30 71 32 70
2 Nismes Nismes 30 72 36 64
3 Fosses Fosses 30 76 50 62
4 Aische Aische 30 72 42 54
5 Pesche Pesche 30 63 46 52
6 Arquet Arquet 30 63 48 49
7 Union Rochefortoise Union 30 66 57 47
8 Bièvre Bièvre 30 68 62 42
9 Grand-Leez Grand-Leez 30 46 46 42
10 Beauraing Beauraing 30 45 45 40
11 Condruzien Condruzien 30 62 66 36
12 Ligny Ligny 30 46 53 33
13 Chevetogne Chevetogne 30 46 65 31
14 Spy Spy 30 38 64 25
15 Gesvoise Gesvoise 30 34 79 17
16 Jemeppe Jemeppe 30 23 100 12
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Mormont Mormont 30 69 32 68
2 Bomal Bomal 30 78 51 60
3 La Roche La Roche 30 63 34 59
4 Meix-Devant-Virton Meix-Devant- 30 52 37 54
5 Champlon Champlon 30 52 48 46
6 Vaux-Noville Vaux-Noville 30 52 56 44
7 Bastogne Bastogne 30 39 41 41
8 Oppagne-Wéris Oppagne-Wér 30 54 42 40
9 Gouvy Gouvy 30 49 51 40
10 Rossignol Rossignol 30 37 53 38
11 Messancy Messancy 30 45 56 35
12 Marloie Sport Marloie 30 35 42 33
13 Sartoise Sartoise 30 27 45 32
14 Wellin Wellin 30 48 51 31
15 Saint-Louis-Saint-Léger Saint-Louis- 30 34 51 29
16 Montleban Montleban 30 31 75 17

  USO DE MEMORIA  
5,638,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0979
Total Execution Time  0.1001
  CADENA URL  
/provincial2020/grupo3/historico
  GET DATOS  
$_GET['/provincial2020/grupo3/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0018  SELECT type FROM routes WHERE alias = 'provincial2020'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'provincial' AND (l.group_code = 3 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=3 DESC LIMIT 1
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=570 ORDER BY order_id ASC
0.0028  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 51057 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 570 AND group_code = 3 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 51057 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 44840 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 39117 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 34018 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 15948 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 4187 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0054  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 = 3521 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 12:34:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-07 12:34:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-07 12:34:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-07 12:34:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'provincial' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 51057 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51057 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 51057 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51057 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 51057 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51057 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0043  SELECT *,(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 = 51057 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC