Escudo del Avranches

Avranches

Entrenador: Michel Audrain

Temporada 2023/2024
TEMPORADA 2023/2024
NATIONAL
Equipo PJ GF GC Puntos
1 Red Star Red Star 29 49 25 62
2 Niort Niort 29 49 32 52
3 FC Martigues Martigues 29 34 22 49
4 Nancy Nancy 29 40 33 44
5 Le Mans Le Mans 29 37 34 44
6 FC Rouen 1899 Rouen 1899 29 33 24 43
7 Dijon FCO Dijon FCO 29 37 39 41
8 Sochaux Sochaux 29 44 37 40
9 Versailles Versailles 29 37 30 39
10 Orléans Orléans 29 33 34 38
11 Chateauroux Chateauroux 29 35 36 36
12 Villefranche Villefranche 29 31 38 34
13 Marignane Gignac Marignane 29 32 41 34
14 Nîmes Nîmes 29 28 39 32
15 GOAL FC GOAL FC 29 37 41 31
16 Épinal Épinal 29 32 43 29
17 Avranches Avranches 29 32 53 29
18 Cholet Cholet 29 26 45 27
TEMPORADA 2022/2023
NATIONAL
Equipo PJ GF GC Puntos
1 Concarneau Concarneau 34 60 37 62
2 Dunkerque Dunkerque 34 50 32 62
3 Red Star Red Star 34 51 30 60
4 FC Martigues Martigues 34 54 40 60
5 Versailles Versailles 34 41 41 51
6 Villefranche Villefranche 34 49 40 46
7 CS Sedan CS Sedan 34 41 47 46
8 Cholet Cholet 34 38 41 45
9 Avranches Avranches 34 44 46 45
10 Orléans Orléans 34 38 37 44
11 Chateauroux Chateauroux 34 41 46 44
12 Le Mans Le Mans 34 50 42 43
13 Nancy Nancy 34 37 42 41
14 Bourg-Péronnas Bourg-Péron 34 42 46 40
15 Stade Briochin Stade 34 36 46 38
16 Le Puy Le Puy 34 34 50 35
17 Paris 13 Atletico Paris 34 28 42 31
18 Bastia-Borgo Bastia-Borgo 34 32 61 26
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
Equipo PJ GF GC Puntos
1 Pau FC Pau FC 25 43 20 48
2 Dunkerque Dunkerque 25 42 26 47
3 US Boulogne US Boulogne 25 32 17 46
4 Red Star Red Star 25 30 22 42
5 Bourg-Péronnas Bourg-Péron 25 38 30 42
6 Avranches Avranches 24 30 26 42
7 Villefranche Villefranche 25 34 24 41
8 Lyon-Duchère Lyon-Duchèr 25 37 32 40
9 Creteil Creteil 25 33 27 35
10 Stade Lavallois Stade 25 26 24 35
11 Concarneau Concarneau 25 21 25 31
12 Cholet Cholet 25 32 40 28
13 Bastia-Borgo Bastia-Borgo 23 22 32 24
14 QRM QRM 24 26 34 24
15 Le Puy Le Puy 25 27 40 23
16 Béziers Béziers 25 26 43 23
17 Gazélec Ajaccio Gazélec 25 15 35 19
18 Sporting Toulon Var Sporting 25 17 34 13
TEMPORADA 2018/2019
NATIONAL
Equipo PJ GF GC Puntos
1 Rodez Rodez 34 54 21 76
2 Chambly Chambly 34 48 31 62
3 Le Mans Le Mans 34 38 29 59
4 Stade Lavallois Stade 34 51 43 54
5 Lyon-Duchère Lyon-Duchèr 34 43 42 50
6 US Boulogne US Boulogne 34 38 33 49
7 Pau FC Pau FC 34 45 35 48
8 Cholet Cholet 34 41 38 46
9 Avranches Avranches 34 37 40 45
10 QRM QRM 34 37 37 45
11 Dunkerque Dunkerque 34 37 39 43
12 Villefranche Villefranche 34 34 34 42
13 Concarneau Concarneau 34 30 43 40
14 Tours Tours 34 21 29 37
15 Bourg-Péronnas Bourg-Péron 34 32 42 36
16 Marignane Gignac Marignane 34 31 43 34
17 Sannois Gratien Sannois 34 27 46 29
18 Drancy Drancy 34 21 40 26
TEMPORADA 2017/2018
NATIONAL
Equipo PJ GF GC Puntos
1 Red Star Red Star 32 41 25 56
2 Béziers Béziers 32 41 29 52
3 Grenoble Grenoble 32 33 23 51
4 Rodez Rodez 32 33 33 45
5 Avranches Avranches 32 39 42 43
6 Lyon-Duchère Lyon-Duchèr 32 30 33 42
7 US Boulogne US Boulogne 32 36 34 42
8 Stade Lavallois Stade 32 37 36 42
9 Dunkerque Dunkerque 32 39 39 41
10 Concarneau Concarneau 32 38 38 40
11 Chambly Chambly 32 36 32 40
12 Sannois Gratien Sannois 32 41 46 40
13 Pau FC Pau FC 32 43 37 40
14 Cholet Cholet 32 49 53 39
15 Les Herbiers Herbiers 32 37 45 39
16 Athlético Marseille Athlético 32 37 46 37
17 Creteil Creteil 32 29 48 26
TEMPORADA 2016/2017
NATIONAL
Equipo PJ GF GC Puntos
1 Chateauroux Chateauroux 34 43 35 59
2 QRM QRM 34 50 37 58
3 Paris FC Paris FC 34 30 18 54
4 Athlético Marseille Athlético 34 52 44 54
5 Chambly Chambly 34 42 34 54
6 Dunkerque Dunkerque 34 51 37 53
7 Béziers Béziers 34 44 41 50
8 Lyon-Duchère Lyon-Duchèr 34 40 37 50
9 US Boulogne US Boulogne 34 47 38 49
10 Avranches Avranches 34 47 46 46
11 Concarneau Concarneau 34 38 43 46
12 Creteil Creteil 34 40 49 42
13 Les Herbiers Herbiers 34 38 42 39
14 Pau FC Pau FC 34 28 37 38
15 Épinal Épinal 34 33 39 37
16 CA Bastia CA Bastia 34 34 53 36
17 CS Sedan CS Sedan 34 39 52 35
18 Belfort Belfort 34 32 46 31
TEMPORADA 2015/2016
NATIONAL
Equipo PJ GF GC Puntos
1 Strasbourg Strasbourg 34 35 19 58
2 Orléans Orléans 34 50 37 56
3 Amiens SC Amiens SC 34 44 35 55
4 Athlético Marseille Athlético 34 50 43 54
5 Chateauroux Chateauroux 34 52 45 52
6 Dunkerque Dunkerque 34 42 42 47
7 Avranches Avranches 34 44 36 46
8 US Boulogne US Boulogne 34 50 45 46
9 Chambly Chambly 34 46 40 44
10 Béziers Béziers 34 35 38 44
11 Luçon Luçon 34 45 50 44
12 CS Sedan CS Sedan 34 31 34 43
13 CA Bastia CA Bastia 34 29 33 43
14 Belfort Belfort 34 26 32 41
15 Les Herbiers Herbiers 34 44 51 39
16 Colmar Colmar 34 39 46 37
17 Épinal Épinal 34 39 53 30
18 Fréjus St-Raphaël Fréjus 34 22 44 27
TEMPORADA 2014/2015
NATIONAL
Equipo PJ GF GC Puntos
1 Red Star Red Star 34 68 30 70
2 Bourg-Péronnas Bourg-Péron 34 57 25 66
3 Paris FC Paris FC 34 50 28 66
4 Strasbourg Strasbourg 34 50 29 65
5 Luçon Luçon 34 40 25 58
6 Dunkerque Dunkerque 34 38 31 52
7 US Boulogne US Boulogne 34 49 39 50
8 Fréjus St-Raphaël Fréjus 34 42 38 49
9 Avranches Avranches 34 42 38 46
10 Colmar Colmar 34 40 44 45
11 Amiens SC Amiens SC 34 45 48 41
12 Le Poiré-sur-Vie Poiré-sur-V 34 36 44 41
13 Athlético Marseille Athlético 34 40 58 40
14 Chambly Chambly 34 42 54 37
15 CA Bastia CA Bastia 34 32 43 32
16 Colomiers Colomiers 34 30 50 32
17 Istres Istres 34 27 61 22
18 Épinal Épinal 34 30 73 15
TEMPORADA 2013/2014
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Avranches Avranches 30 56 22 63
2 Saint-Malo Saint-Malo 30 45 29 56
3 Les Herbiers Herbiers 30 46 26 50
4 Nantes II Nantes II 30 31 23 47
5 Trelissac Trelissac 30 29 26 44
6 Vitré Vitré 30 36 39 42
7 Concarneau Concarneau 30 33 34 41
8 Stade Bordelais Stade 30 29 36 40
9 Girondins Bordeaux II Girondins 30 33 25 39
10 Pontivy Pontivy 30 36 39 36
11 V.Châtillon V.Châtillon 30 27 34 35
12 Romorantin Romorantin 30 33 36 34
13 Fontenay Fontenay 30 36 48 33
14 Cherbourg Cherbourg 30 27 43 33
15 Plabennec Plabennec 30 28 42 28
16 Villenave Villenave 30 28 51 26
TEMPORADA 2012/2013
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Luçon Luçon 34 68 45 63
2 Trelissac Trelissac 34 58 39 61
3 Les Herbiers Herbiers 34 51 30 57
4 Saint-Malo Saint-Malo 34 50 31 54
5 Romorantin Romorantin 34 39 31 52
6 Girondins Bordeaux II Girondins 34 51 44 52
7 Avranches Avranches 34 50 35 51
8 Pontivy Pontivy 34 40 36 50
9 Concarneau Concarneau 34 44 44 49
10 Fontenay Fontenay 34 41 38 48
11 Le Mans II Le Mans II 34 44 53 44
12 V.Châtillon V.Châtillon 34 36 51 44
13 Stade Bordelais Stade 34 49 53 42
14 Plabennec Plabennec 34 37 46 42
15 Caen II Caen II 34 45 51 41
16 Lorient II Lorient II 34 40 57 37
17 Le Havre II Le Havre II 34 31 47 34
18 Saumur Saumur 34 33 76 19
TEMPORADA 2011/2012
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Carquefou Carquefou 34 53 23 71
2 Luçon Luçon 34 63 38 71
3 Avranches Avranches 34 53 33 63
4 Plabennec Plabennec 34 55 40 56
5 Romorantin Romorantin 34 58 33 55
6 Les Herbiers Herbiers 34 39 40 51
7 Concarneau Concarneau 34 49 44 46
8 Mantes Mantes 34 45 45 45
9 Saumur Saumur 34 39 43 43
10 Le Havre II Le Havre II 34 46 55 43
11 V.Châtillon V.Châtillon 34 43 45 41
12 Le Mans II Le Mans II 34 41 47 41
13 Fontenay Fontenay 34 30 43 39
14 Pacy Vallée-d.Eure Pacy 34 34 50 39
15 Caen II Caen II 34 34 42 38
16 Pontivy Pontivy 34 29 37 37
17 Lorient II Lorient II 34 38 55 36
18 La Vitréenne Vitréenne 34 24 60 24
TEMPORADA 2010/2011
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Le Poiré-sur-Vie Poiré-sur-V 32 47 24 59
2 Cherbourg Cherbourg 32 42 37 49
3 La Vitréenne Vitréenne 32 39 26 48
4 Les Herbiers Herbiers 32 48 36 46
5 Carquefou Carquefou 32 42 36 46
6 Yzeure Yzeure 32 30 26 44
7 Moulins Moulins 32 42 43 44
8 Le Mans II Le Mans II 32 44 38 42
9 Avranches Avranches 32 32 31 42
10 V.Châtillon V.Châtillon 32 36 39 42
11 Romorantin Romorantin 32 43 44 41
12 Luçon Luçon 32 36 43 40
13 Lorient II Lorient II 32 39 42 39
14 Fontenay Fontenay 32 34 43 39
15 Caen II Caen II 32 40 55 38
16 Saint-Pryve Saint-Pryve 32 40 53 36
17 Stade Rennais II Stade 32 27 45 29
TEMPORADA 2009/2010
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Orléans Orléans 34 43 21 69
2 La Vitréenne Vitréenne 34 49 33 61
3 Le Havre II Le Havre II 34 59 39 59
4 Cherbourg Cherbourg 34 45 33 59
5 Racing Colombes 92 Racing 34 46 36 50
6 QRM QRM 34 52 46 48
7 Romorantin Romorantin 34 59 57 47
8 V.Châtillon V.Châtillon 34 50 58 47
9 Ivry Ivry 34 40 37 46
10 Sénart Moissy Sénart 34 49 47 45
11 Carquefou Carquefou 34 37 42 45
12 Auxerre II Auxerre II 34 47 44 44
13 Stade Rennais II Stade 34 33 41 42
14 Avranches Avranches 34 37 44 41
15 Caen II Caen II 34 46 45 39
16 Mantes Mantes 34 35 49 37
17 Pontivy Pontivy 34 36 57 25
18 Quimper Cornouaille Quimper 34 23 57 25
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 7
Equipo PJ GF GC Puntos
1 Quimper Cornouaille Quimper 30 37 26 57
2 Stade Brestois II Stade 30 47 24 52
3 Pontivy Pontivy 30 35 29 48
4 Change Change 30 34 23 45
5 Lorient II Lorient II 30 38 27 44
6 Stade Lavallois II Stade 30 33 24 43
7 Le Poiré-sur-Vie Poiré-sur-V 30 41 37 43
8 Alençon Alençon 30 30 26 39
9 Carquefou Carquefou 30 27 29 38
10 Avranches Avranches 30 35 42 38
11 Concarneau Concarneau 30 34 46 37
12 Montagnarde Montagnarde 30 34 54 37
13 Saint-Colomban Locminé Saint-Colomb 30 40 46 35
14 Voltigeurs Châteaubriant Voltigeurs 30 41 49 35
15 Saint-Lô Manche Saint-Lô 30 36 47 35
16 Stade Briochin Stade 30 34 47 30

  USO DE MEMORIA  
7,578,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5378
Total Execution Time  0.5390
  CADENA URL  
/historico/Avranches
  GET DATOS  
$_GET['/historico/Avranches']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0121  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 = 'Avranches' 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.0106  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=6710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=6710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=6710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=6710 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0218  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 = 72083
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6710 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6710 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108  SELECT /*35 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 (57895,171757,203454,694676,701801) ORDER BY n.cover_points DESC, update_date DESC
0.0113  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 = '6710' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0112  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 = '6710' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 72083 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111  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=6710 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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,72083,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.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 72083 AND teamId = 6710
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6710
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6710
0.0106  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 = '6710' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6710' and rp.type = 4
0.0106  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 = '6710' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0119  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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 6710 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.0117  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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 6710 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112  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 = 72083 WHERE rp.league_id = 72083 AND rp.teamId = 6710 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110  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 = 6710 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 `tables2024` 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 = 72083 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0109  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 = 50111 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 44443 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 38779 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 33315 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 15088 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 3828 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 2539 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2100 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 1682 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 19926 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 19930 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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.0108  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 = 20026 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC