4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Albi
TEMPORADA 2013/2014
NATIONAL 3 GRUPO 6
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
TEMPORADA 2012/2013
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Colomiers Colomiers 34 42 17 65
2 Cannes Cannes 34 50 24 59
3 Hyères Hyères 34 39 27 57
4 FC Martigues Martigues 34 46 31 55
5 Olympique Lyonnais II Olympique 34 52 34 52
6 Marignane Marignane 34 40 34 49
7 Athlético Marseille Athlético 34 55 52 49
8 Rodez Rodez 34 38 50 48
9 Béziers Béziers 34 37 37 46
10 Monaco II Monaco II 34 46 40 45
11 US Le Pontet Pontet 34 46 47 44
12 Tarbes Tarbes 34 38 53 44
13 Valence Valence 34 35 44 42
14 Pau FC Pau FC 34 41 45 41
15 Albi Albi 34 41 57 35
16 Stade Montois Stade 34 42 61 35
17 Bayonne Bayonne 34 21 36 33
18 Saint-Étienne II Saint-Étien 34 24 44 25
TEMPORADA 2011/2012
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Uzès Pont du Gard Uzès Pont G. 34 55 29 70
2 Rodez Rodez 34 43 26 60
3 Monaco II Monaco II 34 56 46 56
4 Cannes Cannes 33 53 36 54
5 Colomiers Colomiers 34 45 30 53
6 Hyères Hyères 34 40 43 53
7 Saint-Étienne II Saint-Étien 34 57 35 52
8 Girondins Bordeaux II Girondins 34 34 32 49
9 Stade Montois Stade 34 39 35 46
10 Tarbes Tarbes 34 44 41 46
11 Agde Agde 34 38 35 44
12 Athlético Marseille Athlético 33 35 47 43
13 Pau FC Pau FC 34 33 35 42
14 Marignane Marignane 34 40 53 41
15 Béziers Béziers 34 39 50 40
16 US Le Pontet Pontet 34 45 57 36
17 Albi Albi 34 34 51 31
18 Gap Gap 34 22 71 10
TEMPORADA 2010/2011
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Gazélec Ajaccio Gazélec 34 51 32 68
2 FC Martigues Martigues 34 57 28 64
3 Pau FC Pau FC 34 56 33 61
4 Olympique Lyonnais II Olympique 34 53 41 53
5 Monaco II Monaco II 34 49 41 50
6 Sporting Toulon Var Sporting 34 41 40 49
7 Colomiers Colomiers 34 46 40 45
8 Saint-Étienne II Saint-Étien 34 50 49 45
9 Albi Albi 34 44 49 45
10 Hyères Hyères 34 47 47 44
11 US Le Pontet Pontet 34 61 63 44
12 Uzès Pont du Gard Uzès Pont G. 34 38 40 42
13 Agde Agde 34 37 46 41
14 Marignane Marignane 34 28 36 40
15 Tarbes Tarbes 34 38 42 39
16 Béziers Béziers 34 42 51 39
17 Aurillac Arpajon Aurillac 34 33 57 29
18 Anglet Genets Anglet 34 32 68 27
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Niort Niort 34 53 23 65
2 Yzeure Yzeure 34 39 29 58
3 Luçon Luçon 34 45 39 56
4 PSG II PSG II 34 37 28 54
5 Albi Albi 34 42 40 54
6 Montluçon Montluçon 34 45 36 52
7 Les Herbiers Herbiers 34 48 44 49
8 Colomiers Colomiers 34 33 29 48
9 Le Mans II Le Mans II 34 42 35 44
10 FC Libourne FC Libourne 34 35 31 44
11 Red Star Red Star 34 38 44 42
12 Pau FC Pau FC 34 30 35 39
13 Girondins Bordeaux II Girondins 34 23 32 38
14 Aurillac Arpajon Aurillac 34 26 40 38
15 Fontenay Fontenay 34 31 41 36
16 Anglet Genets Anglet 34 29 42 36
17 Balma Balma 34 28 42 30
18 Toulouse Fontaines Toulouse 34 25 39 28
TEMPORADA 2008/2009
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Luzenac Luzenac 34 59 26 69
2 Moulins Moulins 34 56 41 62
3 Pau FC Pau FC 34 42 25 60
4 Fontenay Fontenay 34 37 32 57
5 Yzeure Yzeure 34 60 43 54
6 Girondins Bordeaux II Girondins 34 41 35 52
7 Romorantin Romorantin 34 49 49 49
8 Le Mans II Le Mans II 34 35 33 48
9 Luçon Luçon 34 39 37 47
10 Aurillac Arpajon Aurillac 34 48 44 44
11 Colomiers Colomiers 34 33 32 41
12 Montluçon Montluçon 34 43 54 39
13 Balma Balma 34 47 54 36
14 Albi Albi 34 27 42 36
15 Anglet Genets Anglet 34 35 53 35
16 Chatellerault Chatelleraul 34 50 66 34
17 Stade Bordelais Stade 34 27 47 32
18 Bergerac Bergerac 34 32 47 28
TEMPORADA 2007/2008
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Cassis-Carnoux Cassis-Carno 34 49 31 69
2 Gap Gap 34 58 28 63
3 Gazélec Ajaccio Gazélec 34 37 32 57
4 Monaco II Monaco II 34 47 33 52
5 Marignane Marignane 34 41 32 51
6 Albi Albi 34 45 32 50
7 Saint-Étienne II Saint-Étien 34 33 35 47
8 Hyères Hyères 34 33 26 46
9 Sporting Toulon Var Sporting 34 36 36 46
10 Fréjus St-Raphaël Fréjus 34 41 43 46
11 CA Bastia CA Bastia 34 35 48 44
12 Luzenac Luzenac 34 49 51 43
13 Andrézieux Andrézieux 34 31 33 41
14 Balma Balma 34 34 44 39
15 Montpellier II Montpellier 34 33 43 39
16 Nice II Nice II 34 36 41 37
17 Toulouse II Toulouse II 34 31 49 29
18 Manosque Manosque 34 33 65 28
TEMPORADA 2006/2007
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Rodez Rodez 34 47 23 66
2 Albi Albi 34 47 33 59
3 Bayonne Bayonne 34 38 30 56
4 Girondins Bordeaux II Girondins 34 40 28 54
5 Moulins Moulins 34 40 29 54
6 Orléans Orléans 34 45 35 53
7 Le Mans II Le Mans II 34 45 33 50
8 Aurillac Arpajon Aurillac 34 46 45 49
9 Anglet Genets Anglet 33 45 43 46
10 Montluçon Montluçon 34 37 33 45
11 Toulouse II Toulouse II 34 47 41 43
12 Luzenac Luzenac 34 40 43 42
13 Nantes II Nantes II 34 44 42 40
14 Stade Bordelais Stade 33 40 57 39
15 Balma Balma 34 29 49 37
16 Les Herbiers Herbiers 34 40 49 36
17 Saint-Georges Saint-George 34 22 46 32
18 Brive Brive 34 28 61 17
TEMPORADA 2005/2006
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Yzeure Yzeure 34 56 35 61
2 Rodez Rodez 34 58 46 59
3 Saint-Étienne II Saint-Étien 34 54 36 57
4 Toulouse II Toulouse II 34 48 30 57
5 Le Mans II Le Mans II 34 54 41 55
6 Brive Brive 34 40 30 47
7 Montluçon Montluçon 34 37 43 47
8 Albi Albi 34 49 41 45
9 Orléans Orléans 33 34 34 45
10 Aurillac Arpajon Aurillac 33 37 40 45
11 Nantes II Nantes II 34 46 48 43
12 Luzenac Luzenac 34 33 42 43
13 Girondins Bordeaux II Girondins 34 31 40 40
14 Balma Balma 34 34 64 40
15 Anglet Genets Anglet 34 40 38 39
16 Andrézieux Andrézieux 34 30 35 39
17 Stade Poitevin Stade 34 29 45 35
18 Blois Blois 34 38 60 28

  USO DE MEMORIA  
5,990,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.0959
Total Execution Time  0.0970
  CADENA URL  
/historico/Albi
  GET DATOS  
$_GET['/historico/Albi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0041  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 = 2545
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6828 AND type_rel = 2
0.0022  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 = '6828' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = '6828' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 2545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=6828 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (2545,2099) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 2099 AND teamId = 6828
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 2545 AND teamId = 6828
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 `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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '6828' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6828' and rp.type = 4
0.0021  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 = '6828' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0026  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 events2014 e ON e.player_id = p.id AND e.league_id = 2545 WHERE rp.league_id = 2545 AND rp.teamId = 6828 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.0025  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 events2014 e ON e.player_id = p.id AND e.league_id = 2545 WHERE rp.league_id = 2545 AND rp.teamId = 6828 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 events2014 e ON e.player_id = p.id AND e.league_id = 2545 WHERE rp.league_id = 2545 AND rp.teamId = 6828 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 6828 AND l.year <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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.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 `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 = 2099 AND t.round = 34 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 `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 = 1681 AND t.round = 34 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 `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 = 19925 AND t.round = 34 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 `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 = 19929 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 `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 = 19933 AND t.round = 34 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 = 19937 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 `tables2007` 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 = 19941 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 `tables2006` 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 = 19945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 2545 ORDER BY nameShow LIMIT 100