4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Annecy

Annecy

Entrenador: Laurent Guyot

Temporada 2023/2024
TEMPORADA 2023/2024
LIGUE 2
Equipo PJ GF GC Puntos
1 Auxerre Auxerre 34 63 34 64
2 Saint-Étienne Saint-Étien 35 44 26 63
3 Angers SCO Angers SCO 35 52 40 61
4 Rodez Rodez 35 58 47 56
5 Paris FC Paris FC 35 46 38 55
6 Stade Lavallois Stade 35 38 42 52
7 Pau FC Pau FC 35 56 50 51
8 Caen Caen 35 45 43 51
9 Guingamp Guingamp 35 41 35 50
10 Amiens SC Amiens SC 35 31 34 46
11 Bastia Bastia 35 40 44 46
12 Ajaccio Ajaccio 35 34 38 46
13 Grenoble Grenoble 35 38 39 45
14 Girondins Bordeaux Girondins 35 41 46 44
15 Annecy Annecy 35 44 46 42
16 Dunkerque Dunkerque 34 31 46 41
17 Troyes Troyes 35 39 47 37
18 QRM QRM 35 47 50 35
19 Concarneau Concarneau 35 33 49 35
20 Valenciennes Valenciennes 35 23 50 23
TEMPORADA 2022/2023
LIGUE 2
Equipo PJ GF GC Puntos
1 Le Havre Le Havre 38 46 19 75
2 Metz Metz 38 61 33 72
3 Girondins Bordeaux Girondins 38 51 28 69
4 Bastia Bastia 38 52 45 60
5 Caen Caen 38 52 43 59
6 Guingamp Guingamp 38 51 46 55
7 Paris FC Paris FC 38 45 43 55
8 Saint-Étienne Saint-Étien 38 63 57 53
9 Sochaux Sochaux 38 54 41 52
10 Grenoble Grenoble 38 33 36 51
11 QRM QRM 38 47 49 50
12 Amiens SC Amiens SC 38 40 52 47
13 Pau FC Pau FC 38 40 52 47
14 Rodez Rodez 38 39 44 46
15 Stade Lavallois Stade 38 44 56 46
16 Valenciennes Valenciennes 38 42 49 45
17 Annecy Annecy 38 39 51 45
18 Dijon FCO Dijon FCO 38 38 43 42
19 Nîmes Nîmes 38 44 62 36
20 Niort Niort 38 35 67 29
TEMPORADA 2021/2022
NATIONAL
Equipo PJ GF GC Puntos
1 Stade Lavallois Stade 34 50 31 67
2 Annecy Annecy 34 55 30 66
3 Villefranche Villefranche 34 47 29 65
4 Concarneau Concarneau 34 48 31 58
5 Chateauroux Chateauroux 34 41 28 55
6 Bourg-Péronnas Bourg-Péron 34 55 37 54
7 Stade Briochin Stade 34 47 35 52
8 CS Sedan CS Sedan 34 37 37 50
9 Orléans Orléans 34 37 35 47
10 Le Mans Le Mans 34 35 35 46
11 Red Star Red Star 34 55 50 44
12 Avranches Avranches 34 37 58 42
13 Cholet Cholet 34 49 62 41
14 Sète Sète 34 35 42 37
15 Bastia-Borgo Bastia-Borgo 34 40 58 31
16 Chambly Chambly 34 35 62 29
17 US Boulogne US Boulogne 34 28 48 26
18 Creteil Creteil 34 35 58 26
TEMPORADA 2020/2021
NATIONAL
Equipo PJ GF GC Puntos
1 Bastia Bastia 34 57 28 66
2 QRM QRM 34 48 31 58
3 Villefranche Villefranche 34 40 29 55
4 Le Mans Le Mans 34 46 36 52
5 Concarneau Concarneau 34 38 32 48
6 Red Star Red Star 34 39 33 47
7 Orléans Orléans 34 49 41 47
8 Sète Sète 34 31 32 43
9 Cholet Cholet 34 36 48 43
10 Stade Briochin Stade 34 32 33 43
11 Bourg-Péronnas Bourg-Péron 34 29 33 43
12 Stade Lavallois Stade 34 33 32 42
13 Avranches Avranches 34 36 42 41
14 Annecy Annecy 34 42 47 40
15 US Boulogne US Boulogne 34 29 38 38
16 Bastia-Borgo Bastia-Borgo 34 37 49 35
17 Creteil Creteil 34 29 48 35
18 Lyon-Duchère Lyon-Duchèr 34 33 52 31
TEMPORADA 2019/2020
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Annecy Annecy 21 30 16 42
2 Grasse Grasse 21 28 17 40
3 GOAL FC GOAL FC 21 32 19 39
4 Yzeure Yzeure 21 30 21 39
5 FC Martigues Martigues 21 27 20 37
6 CS Louhans Cuiseaux Louhans 21 40 26 33
7 Fréjus St-Raphaël Fréjus 21 21 22 27
8 Olympique Lyonnais II Olympique 21 28 31 25
9 Hyères Hyères 21 13 21 25
10 Olympique Marseille II Olympique 21 27 38 24
11 Jura Sud Jura Sud 21 24 37 23
12 Marignane Gignac Marignane 21 19 23 22
13 Monaco II Monaco II 21 26 34 22
14 Saint-Priest Saint-Priest 21 24 27 21
15 Marseille Endoume Marseille 21 23 33 19
16 Nîmes II Nîmes II 21 21 28 17
TEMPORADA 2018/2019
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Toulon Var Sporting 30 43 25 59
2 Fréjus St-Raphaël Fréjus 30 51 38 57
3 Annecy Annecy 30 50 34 54
4 Jura Sud Jura Sud 30 43 30 50
5 Athlético Marseille Athlético 30 57 46 47
6 Marseille Endoume Marseille 30 42 34 44
7 FC Martigues Martigues 30 40 30 41
8 Hyères Hyères 30 29 33 41
9 Saint-Priest Saint-Priest 30 39 42 40
10 Grasse Grasse 30 35 42 39
11 GOAL FC GOAL FC 30 32 39 39
12 Olympique Lyonnais II Olympique 30 56 47 37
13 Olympique Marseille II Olympique 30 50 57 35
14 Monaco II Monaco II 30 44 52 33
15 Pontarlier Pontarlier 30 20 53 22
16 Nice II Nice II 30 41 70 20
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Villefranche Villefranche 30 50 32 58
2 Annecy Annecy 30 51 33 57
3 Andrézieux Andrézieux 30 48 36 52
4 Jura Sud Jura Sud 30 49 41 51
5 Schiltigheim Schiltigheim 30 47 35 50
6 Yzeure Yzeure 30 33 29 46
7 Épinal Épinal 30 42 36 41
8 PSG II PSG II 30 42 39 40
9 Belfort Belfort 30 43 42 39
10 Le Puy Le Puy 30 35 35 39
11 Olympique Lyonnais II Olympique 30 42 45 37
12 GOAL FC GOAL FC 30 34 39 37
13 Saint-Priest Saint-Priest 30 35 43 35
14 Saint-Louis Neuweg Saint-Louis 30 28 43 34
15 Montceau Montceau 30 34 44 33
16 Raon-l'Etape Raon-l'Etape 30 23 64 13
TEMPORADA 2016/2017
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Grenoble Grenoble 28 47 15 66
2 Le Puy Le Puy 28 40 15 57
3 Annecy Annecy 28 50 32 50
4 Olympique Lyonnais II Olympique 28 54 44 46
5 Jura Sud Jura Sud 28 44 38 44
6 Villefranche Villefranche 28 34 34 40
7 Stade de Reims II Stade Reims 28 43 41 36
8 Andrézieux Andrézieux 28 37 44 33
9 Raon-l'Etape Raon-l'Etape 28 37 49 32
10 GOAL FC GOAL FC 28 29 37 31
11 Saint-Louis Neuweg Saint-Louis 28 30 44 31
12 Yzeure Yzeure 28 28 38 29
13 Montceau Montceau 28 35 48 28
14 FC Mulhouse FC Mulhouse 28 30 43 26
15 Auxerre II Auxerre II 28 35 51 25
16 Evian Thonon Gaillard Evian Thonon 0 0 0 0
TEMPORADA 2015/2016
NATIONAL 3 GRUPO 4
Equipo PJ GF GC Puntos
1 Sporting Toulon Var Sporting 24 48 23 51
2 Annecy Annecy 24 31 22 41
3 Nîmes II Nîmes II 24 42 29 40
4 FC Borgo FC Borgo 24 40 32 37
5 Cannet Rocheville Cannet 24 44 38 35
6 Bastia II Bastia II 24 36 36 32
7 Olympique Alès Olympique 24 41 46 31
8 Evian Thonon Gaillard II Evian Thonon 24 35 36 30
9 Agde Agde 24 33 42 27
10 Île-Rousse Monticello Île-Rousse 24 24 37 27
11 Fabrègues Fabrègues 24 28 39 26
12 Aix les Bains Bains 24 27 36 25
13 Aubagne Aubagne 24 38 51 25
14 Arles II Arles II 0 0 0 0

  USO DE MEMORIA  
6,346,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5184
Total Execution Time  0.5196
  CADENA URL  
/historico/Annecy
  GET DATOS  
$_GET['/historico/Annecy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0177  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 = 'Annecy' AND l.year = 2024 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.0125  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=80351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=80351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=80351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=80351 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80351 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92 AND type_rel = 3
0.0174  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 92 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0140  SELECT /*53 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 (1312722,1312228,1310326,1308398,1306185) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '80351' ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '80351' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '80351' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 72082 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=80351 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74470,72082,71432) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 72082 AND teamId = 80351
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 80351
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 80351
0.0152  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 events2024 e ON e.player_id = p.id AND e.league_id = 72082 WHERE rp.league_id = 72082 AND rp.teamId = 80351 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.0140  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 events2024 e ON e.player_id = p.id AND e.league_id = 72082 WHERE rp.league_id = 72082 AND rp.teamId = 80351 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 events2024 e ON e.player_id = p.id AND e.league_id = 72082 WHERE rp.league_id = 72082 AND rp.teamId = 80351 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 80351 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0252  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 `tables2022` 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 = 63266 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `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 = 57035 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 50570 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 44572 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 39109 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 33907 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 15900 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 72082 ORDER BY nameShow LIMIT 100