4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Angers SCO II
TEMPORADA 2014/2015
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Cholet Cholet 26 34 21 45
2 Saint-Pryve Saint-Pryve 26 40 25 41
3 La Roche VF La Roche VF 26 38 31 39
4 Le Mans Le Mans 26 34 28 39
5 Angers SCO II Angers 26 34 34 38
6 Bressuire Bressuire 26 28 29 38
7 Tours II Tours II 26 38 32 36
8 Avoine OCC Avoine OCC 26 26 31 36
9 Châteauroux II Châteauroux 26 42 35 35
10 Le Poiré sur Vie II Poiré 26 31 26 34
11 USSA Vertou USSA Vertou 26 25 35 34
12 Chatellerault Chatelleraul 26 34 46 31
13 Chauray Chauray 26 30 44 30
14 Thouars Thouars 26 27 44 23
TEMPORADA 2013/2014
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 US Fleury-Merogis Fleury-Merog 26 40 27 44
2 Tours II Tours II 26 37 26 43
3 Saint-Pryve Saint-Pryve 26 43 29 42
4 Châteauroux II Châteauroux 26 44 34 42
5 Le Poiré sur Vie II Poiré 26 33 27 40
6 Cholet Cholet 26 35 34 38
7 Chartres Chartres 26 42 37 36
8 St Geneviève Geneviève 26 27 27 36
9 La Roche VF La Roche VF 26 35 41 35
10 Chatellerault Chatelleraul 26 41 43 34
11 Thouars Thouars 26 27 43 31
12 Angers SCO II Angers 26 38 39 30
13 Saumur Saumur 26 21 29 29
14 Stade Poitevin Stade 26 21 48 14
TEMPORADA 2012/2013
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Nantes II Nantes II 26 53 20 55
2 Angers SCO II Angers 26 49 29 51
3 Châteauroux II Châteauroux 26 49 36 47
4 Sablé Sablé 26 44 35 39
5 Chauray Chauray 26 30 24 39
6 Cholet Cholet 26 41 27 37
7 Le Poiré sur Vie II Poiré 26 28 24 35
8 Limoges Limoges 26 31 42 33
9 Thouars Thouars 26 30 32 31
10 Stade Poitevin Stade 26 22 31 31
11 Chatellerault Chatelleraul 26 31 54 30
12 Avoine Beaumont Avoine 26 30 43 25
13 La Suze La Suze 26 40 57 20
14 RC La Flèche Flèche 26 23 47 17
TEMPORADA 2011/2012
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Chartres Chartres 9 23 7 23
2 Vertou Vertou 9 16 10 22
3 Cholet Cholet 9 18 7 20
4 Angers SCO II Angers 9 19 10 18
5 Trelissac Trelissac 9 12 8 17
6 Nantes II Nantes II 9 12 8 14
7 Chatellerault Chatelleraul 9 15 12 13
8 Stade Poitevin Stade 9 16 17 13
9 Tours II Tours II 9 15 18 10
10 Saint-Pryve Saint-Pryve 9 13 16 10
11 Le Poiré sur Vie II Poiré 9 8 12 9
12 Les Herbiers II Herbiers 9 7 12 9
13 Saint-Jean-Le-Blanc Saint-Jean-L 9 6 17 8
14 Limoges Limoges 9 13 18 7
15 Thouars Thouars 9 8 18 5
16 Cognac Cognac 9 10 21 5
TEMPORADA 2010/2011
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Saumur Saumur 28 55 20 60
2 Nantes II Nantes II 28 50 28 54
3 Angers SCO II Angers 28 51 30 54
4 Tours II Tours II 28 32 28 41
5 Stade Poitevin Stade 28 36 36 38
6 Cholet Cholet 28 38 40 37
7 Vierzon Vierzon 28 34 55 36
8 Châteauroux II Châteauroux 28 32 28 35
9 Cognac Cognac 28 37 41 35
10 Chatellerault Chatelleraul 28 40 50 35
11 Sablé Sablé 28 35 33 34
12 USSA Vertou USSA Vertou 28 33 33 34
13 Bourges 18 Bourges 18 28 33 33 33
14 La Chataigneraie Chataignerai 28 37 45 32
15 Bonchamp Bonchamp 28 23 66 10
16 Montluçon Montluçon 0 0 0 0
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Le Poiré-sur-Vie Poiré-sur-V 30 52 27 63
2 Saint-Pryve Saint-Pryve 30 54 34 61
3 Saumur Saumur 30 48 37 46
4 Angers SCO II Angers 30 51 44 44
5 Châteauroux II Châteauroux 30 40 34 43
6 Nantes II Nantes II 30 40 35 43
7 Cholet Cholet 30 39 36 40
8 Stade Poitevin Stade 30 36 36 39
9 Tours II Tours II 30 46 41 38
10 St Geneviève Geneviève 30 32 36 38
11 Chatellerault Chatelleraul 30 38 47 37
12 Bourges 18 Bourges 18 30 30 39 36
13 Niort II Niort II 30 34 38 35
14 Thouars Thouars 30 39 53 31
15 Blois Blois 30 31 49 29
16 Ararat Issy Ararat Issy 30 27 51 28
TEMPORADA 2008/2009
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Carquefou Carquefou 29 43 23 59
2 Avranches Avranches 30 45 32 52
3 Nantes II Nantes II 30 52 37 51
4 Stade Brestois II Stade 30 55 31 50
5 Concarneau Concarneau 30 36 31 48
6 Montagnarde Montagnarde 30 40 32 47
7 Stade Lavallois II Stade 30 47 36 46
8 Mondeville Mondeville 30 46 37 45
9 Lorient II Lorient II 29 40 36 43
10 Angers SCO II Angers 30 41 39 39
11 USSA Vertou USSA Vertou 30 32 29 38
12 Change Change 30 39 38 38
13 Dives Dives 30 45 58 38
14 RC Fléchois Fléchois 30 17 43 21
15 La Tour d'Auvergne Tour 30 29 60 21
16 Bonchamp Bonchamp 30 27 72 12
TEMPORADA 2007/2008
NATIONAL 3 GRUPO 6
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  
5,645,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0879
Total Execution Time  0.0891
  CADENA URL  
/historico/Angers-Ii/2015
  GET DATOS  
$_GET['/historico/Angers-Ii/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0038  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 = 'Angers-Ii' AND l.year = 2015 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.0018  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=6801 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=6801 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6801 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=221 AND type_rel = 3
0.0024  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 = '6801' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
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 = '6801' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=6801 AND l.year in (2014,2015,2016) 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 (15897) 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 = 15897 AND teamId = 6801
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 = '6801' 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 = '6801' 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 = '6801' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046  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 events2015 e ON e.player_id = p.id AND e.league_id = 4306 WHERE rp.league_id = 4306 AND rp.teamId = 6801 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.0036  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 events2015 e ON e.player_id = p.id AND e.league_id = 4306 WHERE rp.league_id = 4306 AND rp.teamId = 6801 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 events2015 e ON e.player_id = p.id AND e.league_id = 4306 WHERE rp.league_id = 4306 AND rp.teamId = 6801 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 6801 AND l.year <= 2015 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 `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 = 4306 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 = 2546 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 `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 = 2107 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 1689 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 20001 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 `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 = 20009 AND t.round = 30 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 = 20019 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