4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Nîmes II Nîmes II 0 0 0 0
2 Toulouse II Toulouse II 0 0 0 0
3 Stade Beaucairois Stade 0 0 0 0
4 Castanet Castanet 0 0 0 0
5 Fabrègues Fabrègues 0 0 0 0
6 Blagnac Blagnac 0 0 0 0
7 Agde Agde 0 0 0 0
8 Narbonne Narbonne 0 0 0 0
9 Montpellier II Montpellier 0 0 0 0
10 Rodez II Rodez II 0 0 0 0
11 Alberes Argelès Alberes 0 0 0 0
12 AS Muretaine Muretaine 0 0 0 0
13 Balma Balma 0 0 0 0
14 Olympique Alès Olympique 0 0 0 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Sarre-Union Sarre-Union 15 25 16 29
2 Metz II Metz II 15 27 16 28
3 Thaon Thaon 14 28 19 23
4 Strasbourg II Strasbourg 15 16 17 22
5 Raon-l'Etape Raon-l'Etape 14 19 18 22
6 Troyes II Troyes II 15 26 21 21
7 Prix lès Mézières Prix lès Mé. 15 16 15 21
8 Saint-Louis Neuweg Saint-Louis 15 16 20 19
9 Biesheim Biesheim 15 24 24 18
10 Illkirch Graffenstaden Illkirch 15 19 20 17
11 Métropole Troyenne Métropole 14 16 18 17
12 Vauban Strasbourg Vauban 14 25 27 16
13 Amnéville Amnéville 15 20 27 14
14 Sarreguemines Sarreguemine 15 21 40 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 FC Mulhouse FC Mulhouse 26 40 21 48
2 Strasbourg II Strasbourg 26 48 32 47
3 Sarre-Union Sarre-Union 26 37 28 43
4 Thaon Thaon 26 42 40 38
5 Troyes II Troyes II 26 38 26 36
6 Saint-Louis Neuweg Saint-Louis 26 32 34 35
7 FCA Troyes FCA Troyes 26 24 21 34
8 Vauban Strasbourg Vauban 26 34 41 33
9 Biesheim Biesheim 26 32 38 33
10 Raon-l'Etape Raon-l'Etape 26 38 44 33
11 Amnéville Amnéville 26 36 41 32
12 Sarreguemines Sarreguemine 26 44 48 31
13 Nancy II Nancy II 26 31 43 29
14 RC Épernay Champagne Épernay 26 28 47 20
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Feignies Feignies 26 41 15 62
2 Grande-Synthe Grande-Synth 26 30 19 48
3 Olympique St Quentin Olympique 26 45 26 45
4 Senlis Senlis 26 28 26 39
5 Dunkerque II Dunkerque 26 32 31 38
6 Amiens SC II Amiens 26 37 33 36
7 Tourcoing Tourcoing 26 38 34 34
8 Chambly II Chambly II 26 26 34 32
9 US Maubeuge US Maubeuge 26 24 31 31
10 US Boulogne II Boulogne 26 25 33 31
11 ES Wasquehal Wasquehal 26 29 30 30
12 Saint-Amand Saint-Amand 26 24 31 30
13 Roye-Noyon Roye-Noyon 26 24 41 21
14 Ailly Sur Somme Ailly Somme 26 20 39 17
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Saint-Priest Saint-Priest 26 47 23 49
2 Saint-Étienne II Saint-Étien 26 43 37 47
3 Avenir Foot Lozère Avenir Foot 26 49 38 46
4 FC Borgo FC Borgo 26 48 34 44
5 Bourgoin-Jallieu Bourgoin-Jal 26 52 41 44
6 Aurillac Arpajon Aurillac 26 43 24 43
7 Limonest Limonest 26 35 28 43
8 CS Louhans Cuiseaux Louhans 26 44 42 41
9 Clermont II Clermont II 26 37 26 36
10 Bastia II Bastia II 26 35 46 33
11 Dives Dives 26 35 41 27
12 Chamalières Chamalières 26 24 49 16
13 Île-Rousse Monticello Île-Rousse 26 21 54 16
14 Cournon Cournon 26 30 60 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Stade de Reims II Stade Reims 26 66 26 56
2 Raon-l'Etape Raon-l'Etape 26 60 37 46
3 Sarreguemines Sarreguemine 26 42 37 44
4 Nancy II Nancy II 26 46 40 40
5 Metz II Metz II 26 59 54 40
6 Schiltigheim Schiltigheim 26 37 33 36
7 Illzach Modenheim Illzach 26 41 44 35
8 Strasbourg II Strasbourg 26 46 46 34
9 FCSR Haguenau FCSR 26 34 35 33
10 Pagny Sur Moselle Pagny 26 26 38 33
11 Forbach Forbach 26 35 44 31
12 Biesheim Biesheim 26 38 50 28
13 RC Épernay Champagne Épernay 26 31 44 24
14 Thaon Thaon 26 25 58 17
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Le Puy Le Puy 26 41 21 48
2 Clermont II Clermont II 26 47 28 43
3 Bourgoin-Jallieu Bourgoin-Jal 26 31 29 43
4 Pontarlier Pontarlier 26 36 26 38
5 Bourges 18 Bourges 18 26 39 30 37
6 Evian Thonon Gaillard II Evian Thonon 26 33 28 35
7 Dijon II Dijon II 26 25 25 35
8 Andrézieux Andrézieux 26 30 31 33
9 FC Gueugnon FC Gueugnon 26 23 27 33
10 Besancon RC Besancon RC 26 27 36 32
11 Selongey Selongey 26 31 47 31
12 Cournon Cournon 26 27 35 30
13 CS Louhans Cuiseaux Louhans 26 25 27 27
14 Vaulx Vaulx 26 19 44 19
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Montpellier II Montpellier 26 50 24 52
2 Limoges Limoges 26 41 27 48
3 Les Genêts d.A… Genêts 26 44 33 47
4 Toulouse II Toulouse II 26 36 30 44
5 Bergerac Bergerac 26 38 31 43
6 Aurillac Arpajon Aurillac 26 39 26 40
7 Rodéo FC Toulouse Rodéo 26 27 33 36
8 Lège-Cap-Ferret Lège-Cap-Fe 26 33 28 35
9 Angouleme Angouleme 26 44 44 31
10 Balma Balma 26 30 31 31
11 Chauray Chauray 26 27 30 31
12 Bayonne Bayonne 26 24 41 27
13 Albi Albi 26 31 47 17
14 Saint-Alban Saint-Alban 26 37 76 13
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Villenave Villenave 26 40 32 47
2 Balma Balma 26 32 20 44
3 Victoria Setebul Victoria 26 36 26 44
4 Aurillac Arpajon Aurillac 26 34 19 43
5 Les Genêts d.A… Genêts 26 36 22 43
6 Bergerac Bergerac 26 25 23 36
7 Toulouse II Toulouse II 26 35 29 34
8 Saint-Alban Saint-Alban 26 32 34 34
9 Montpellier II Montpellier 26 24 22 32
10 Narbonne Narbonne 26 39 37 31
11 AS Muretaine Muretaine 26 31 42 30
12 Nîmes II Nîmes II 26 25 34 29
13 Auch Football Auch 26 34 50 24
14 Lormont Lormont 26 25 58 19
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Les Genêts d.A… Genêts 9 14 6 18
2 Nîmes II Nîmes II 9 12 4 17
3 AS Muretaine Muretaine 9 9 4 17
4 Balma Balma 9 9 5 17
5 Montpellier II Montpellier 9 17 11 15
6 Stade Bordelais Stade 9 13 8 14
7 Narbonne Narbonne 9 8 8 14
8 Toulouse II Toulouse II 9 12 13 14
9 SA Mérignac Mérignac 9 6 9 13
10 F.C. Marmande 47 F.C. 9 12 10 11
11 Bergerac Bergerac 9 12 13 10
12 Saint-Alban Saint-Alban 9 7 13 8
13 Blagnac Blagnac 9 11 18 8
14 SU Agen SU Agen 9 9 14 7
15 Lormont Lormont 9 11 18 7
16 Aurillac Arpajon Aurillac 9 9 17 7
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Stade Montois Stade 32 45 22 62
2 Girondins Bordeaux II Girondins 32 51 31 61
3 Stade Bordelais Stade 32 51 29 60
4 Trelissac Trelissac 32 44 29 57
5 Toulouse II Toulouse II 32 60 32 55
6 Balma Balma 32 38 27 55
7 Bergerac Bergerac 32 54 42 46
8 SA Mérignac Mérignac 32 39 36 45
9 SU Agen SU Agen 32 40 38 41
10 Saint-Alban Saint-Alban 32 37 48 41
11 Lormont Lormont 32 47 56 38
12 Blagnac Blagnac 32 42 45 36
13 Langon-Castets Langon-Caste 32 35 51 34
14 Revel Revel 32 30 50 34
15 Brive Brive 32 33 48 33
16 FC Libourne FC Libourne 32 24 49 29
17 Toulouse Fontaines Toulouse 32 28 65 18
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Béziers Béziers 30 63 36 65
2 Tarbes Tarbes 30 53 33 58
3 Toulouse II Toulouse II 30 44 28 51
4 Trelissac Trelissac 30 51 38 49
5 Bergerac Bergerac 30 45 34 44
6 SU Agen SU Agen 30 33 27 43
7 Cognac Cognac 30 50 48 40
8 Stade Montois Stade 30 36 37 40
9 Stade Bordelais Stade 30 35 28 39
10 Blagnac Blagnac 30 42 41 39
11 SA Mérignac Mérignac 30 29 46 36
12 Saint-Alban Saint-Alban 30 37 49 35
13 Cugnaux Cugnaux 30 27 45 34
14 Tournefeuille Tournefeuill 30 35 51 30
15 Bayonne II Bayonne II 30 41 58 28
16 Bassin d'Arcachon Sud Bassin 30 38 60 24
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Toulouse Fontaines Toulouse 30 43 23 58
2 Rodéo FC Toulouse Rodéo 30 36 17 58
3 Toulouse II Toulouse II 30 46 22 55
4 Trelissac Trelissac 30 38 18 51
5 Blagnac Blagnac 30 36 32 41
6 Stade Montois Stade 30 38 34 40
7 Saint-Alban Saint-Alban 30 20 21 40
8 SU Agen SU Agen 30 35 30 39
9 Tarbes Tarbes 30 32 38 39
10 Bassin d'Arcachon Sud Bassin 30 23 33 38
11 Sète II Sète II 30 38 38 37
12 Brive Brive 30 31 33 34
13 Bayonne II Bayonne II 30 25 32 34
14 Pointe Courte Pointe 30 28 47 29
15 Libourne Saint Seurin II Libourne 30 19 40 29
16 Aurillac Arpajon II Aurillac 30 26 56 20
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Luçon Luçon 30 46 16 65
2 Saint-Pryve Saint-Pryve 30 50 31 53
3 Saumur Saumur 30 52 36 51
4 Angers SCO II Angers 30 38 32 48
5 Arménienne Arménienne 30 45 33 47
6 Auxerre III Auxerre III 30 40 34 47
7 Châteauroux II Châteauroux 30 38 25 46
8 Les Herbiers Herbiers 30 43 28 45
9 Thouars Thouars 30 31 26 42
10 Malesherbes Malesherbes 30 34 41 38
11 Blois Blois 30 33 31 36
12 Sud Nivernais Nivernais 30 29 39 35
13 RC La Flèche Flèche 30 26 30 32
14 Créteil II Créteil II 30 32 41 29
15 Chatellerault II Chatelleraul 30 26 60 22
16 Écommoy FC Écommoy FC 30 17 77 14

  USO DE MEMORIA  
6,566,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.1012
Total Execution Time  0.1038
  CADENA URL  
/ligue_cfa_22021/grupo6/historico
  GET DATOS  
$_GET['/ligue_cfa_22021/grupo6/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT type FROM routes WHERE alias = 'ligue_cfa_22021'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa_2' AND (l.group_code = 6 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=6 DESC LIMIT 1
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 221 AND group_code = 6 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0021  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 = 50959 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.0021  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 = 44565 AND t.round = 26 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 `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 = 39134 AND t.round = 26 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 `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 = 34012 AND t.round = 26 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 `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 = 15903 AND t.round = 26 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 `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 = 4313 AND t.round = 26 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 = 2545 AND t.round = 26 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 `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 = 2105 AND t.round = 26 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 `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 = 1688 AND t.round = 9 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 `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 = 20000 AND t.round = 34 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 `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 = 20008 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 `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 = 20017 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 `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 = 20025 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:57:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:57:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:57:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:57:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa_2' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0054  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 events2021 e ON e.player_id = p.id AND e.league_id = 57387 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57387 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.0062  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 events2021 e ON e.player_id = p.id AND e.league_id = 57387 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57387 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0022  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 events2021 e ON e.player_id = p.id AND e.league_id = 57387 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 57387 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  SELECT *,(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 = 57387 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC