Escudo del Stade Briochin
TEMPORADA 2023/2024
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 US Boulogne US Boulogne 20 38 18 44
2 Granville Granville 20 29 20 39
3 Chambly Chambly 20 25 17 32
4 Aubervilliers Aubervillier 20 25 28 32
5 Beauvais Oise Beauvais 20 23 23 29
6 Saint-Malo Saint-Malo 20 26 18 29
7 Stade Briochin Stade 20 23 21 29
8 Racing Paris Racing Paris 20 22 25 27
9 Voltigeurs Châteaubriant Voltigeurs 20 22 24 26
10 Dinan-Léhon Dinan-Léhon 20 31 33 25
11 Bastia-Borgo Bastia-Borgo 20 27 36 21
12 Lorient II Lorient II 20 23 30 20
13 AF Virois AF Virois 20 24 28 20
14 Guingamp II Guingamp II 20 20 37 16
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 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Stade Briochin Stade 21 38 22 46
2 Chartres Chartres 21 42 19 44
3 FC Rouen 1899 Rouen 1899 20 23 15 39
4 Granville Granville 21 22 21 38
5 Vannes Vannes 21 35 24 35
6 Paris 13 Atletico Paris 21 32 29 30
7 Lorient II Lorient II 21 19 19 30
8 US Fleury-Merogis Fleury-Merog 21 24 23 29
9 Saint-Malo Saint-Malo 20 23 22 28
10 Angers SCO II Angers 21 21 19 27
11 Guingamp II Guingamp II 21 30 34 23
12 Sannois Gratien Sannois 21 20 24 23
13 Poissy Poissy 21 28 32 22
14 Vitré Vitré 21 19 26 18
15 Oissel Oissel 21 18 38 13
16 Mantes Mantes 21 7 34 6
TEMPORADA 2018/2019
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Nantes II Nantes II 30 45 24 55
2 Bastia-Borgo Bastia-Borgo 30 57 35 54
3 Chartres Chartres 30 50 38 52
4 Stade Briochin Stade 30 53 33 50
5 Lorient II Lorient II 30 38 24 47
6 Oissel Oissel 30 39 37 41
7 Vannes Vannes 30 47 49 40
8 Poissy Poissy 30 35 36 39
9 Mantes Mantes 30 29 39 39
10 Granville Granville 30 47 58 38
11 Saint-Malo Saint-Malo 30 40 42 37
12 Vitré Vitré 30 34 45 36
13 PSG II PSG II 30 39 47 33
14 Furiani Agliani Furiani 30 31 43 33
15 Boulogne-Billancourt Boulogne-Bil 30 36 51 29
16 Le Havre II Le Havre II 30 29 48 29
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Le Mans Le Mans 30 59 27 60
2 Stade Briochin Stade 30 50 32 57
3 Saint-Malo Saint-Malo 30 44 34 48
4 Lorient II Lorient II 30 31 24 45
5 Romorantin Romorantin 30 45 40 41
6 Saint-Pryve Saint-Pryve 30 29 31 41
7 Chartres Chartres 30 49 42 39
8 Boulogne-Billancourt Boulogne-Bil 30 45 55 38
9 Le Havre II Le Havre II 30 43 55 38
10 Granville Granville 30 38 36 37
11 Mantes Mantes 30 32 39 37
12 Limoges Limoges 30 31 38 37
13 Vitré Vitré 30 43 44 36
14 Trelissac Trelissac 30 26 43 33
15 Stade Rennais II Stade 30 33 42 32
16 Fontenay Fontenay 30 25 41 25
TEMPORADA 2016/2017
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Stade Briochin Stade 26 42 11 56
2 Angers SCO II Angers 26 38 23 47
3 Guingamp II Guingamp II 26 41 30 42
4 Dinan-Léhon Dinan-Léhon 26 28 24 41
5 Vannes Vannes 26 45 44 40
6 USSA Vertou USSA Vertou 26 37 32 39
7 Stade Lavallois II Stade 26 38 34 35
8 Stade Brestois II Stade 26 32 27 32
9 Sablé Sablé 26 31 34 31
10 La Tour d'Auvergne Tour 26 24 38 30
11 Lannion Lannion 26 28 40 28
12 Change Change 26 31 54 28
13 RC La Flèche Flèche 26 23 37 23
14 Union Sportive Fougères Union 26 31 41 20
TEMPORADA 2015/2016
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Stade Rennais II Stade 26 56 25 56
2 Granville Granville 26 47 29 48
3 Union Sportive Fougères Union 26 43 42 40
4 Stade Briochin Stade 26 30 21 39
5 La Tour d'Auvergne Tour 26 43 45 38
6 Stade Brestois II Stade 26 35 36 36
7 Sablé Sablé 26 36 36 34
8 Guingamp II Guingamp II 26 43 44 33
9 Stade Lavallois II Stade 26 40 43 31
10 Dinan-Léhon Dinan-Léhon 26 33 36 30
11 Pontivy Pontivy 26 32 41 27
12 Lannion Lannion 26 28 38 27
13 Change Change 26 26 45 27
14 Saint-Lô Manche Saint-Lô 26 26 37 26
TEMPORADA 2014/2015
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Voltigeurs Châteaubriant Voltigeurs 26 52 27 49
2 Granville Granville 26 48 17 47
3 Guingamp II Guingamp II 26 52 34 46
4 Stade Rennais II Stade 26 55 34 44
5 Stade Briochin Stade 26 32 25 40
6 Stade Lavallois II Stade 26 46 44 36
7 Dinan-Léhon Dinan-Léhon 26 39 40 36
8 Sablé Sablé 26 41 40 35
9 Lannion Lannion 26 31 37 35
10 Stade Brestois II Stade 26 31 30 34
11 Saint-Lô Manche Saint-Lô 26 42 46 31
12 La Tour d'Auvergne Tour 26 29 40 31
13 Saint-Colomban Locminé Saint-Colomb 26 21 62 13
14 Hérouville Hérouville 26 18 61 12
TEMPORADA 2013/2014
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Lorient II Lorient II 26 44 23 46
2 Sablé Sablé 26 33 24 44
3 Stade Briochin Stade 26 34 25 41
4 Dinan-Léhon Dinan-Léhon 26 33 23 40
5 Stade Rennais II Stade 26 40 32 40
6 Stade Lavallois II Stade 26 45 37 38
7 Lannion Lannion 26 36 39 37
8 USSA Vertou USSA Vertou 26 32 43 37
9 Saint-Lô Manche Saint-Lô 26 30 43 37
10 Guingamp II Guingamp II 26 44 34 35
11 Stade Brestois II Stade 26 19 17 30
12 Saint-Colomban Locminé Saint-Colomb 26 39 42 25
13 Hérouville Hérouville 26 35 52 25
14 La Vitréenne Vitréenne 26 23 53 17
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
TEMPORADA 1996/1997
LIGUE 2
Equipo PJ GF GC Puntos
1 Chateauroux Chateauroux 42 54 27 76
2 Toulouse Toulouse 42 61 32 75
3 FC Martigues Martigues 42 54 33 67
4 FC Gueugnon FC Gueugnon 42 54 47 67
5 Niort Niort 42 44 36 65
6 Le Mans Le Mans 42 49 41 62
7 Beauvais Oise Beauvais 42 43 43 61
8 Stade Lavallois Stade 42 48 39 58
9 Lorient Lorient 42 50 50 58
10 Valence Valence 42 48 53 58
11 Sochaux Sochaux 42 54 47 57
12 FC Mulhouse FC Mulhouse 42 51 49 54
13 Red Star Red Star 42 50 48 54
14 Sporting Toulon Var Sporting 42 50 57 54
15 Amiens SC Amiens SC 42 44 47 52
16 Perpignan Perpignan 42 38 42 51
17 Saint-Étienne Saint-Étien 42 48 56 51
18 CS Louhans Cuiseaux Louhans 42 39 52 51
19 Charleville Charleville 42 37 48 49
20 Troyes Troyes 42 36 42 48
21 Stade Briochin Stade 42 32 46 38
22 Épinal Épinal 42 26 75 26
TEMPORADA 1994/1995
LIGUE 2
Equipo PJ GF GC Puntos
1 Olympique Marseille Olympique 42 72 34 84
2 Guingamp Guingamp 42 50 32 79
3 FC Gueugnon FC Gueugnon 42 62 40 78
4 Toulouse Toulouse 42 69 43 77
5 Chateauroux Chateauroux 42 56 34 71
6 Red Star Red Star 42 55 44 70
7 Nancy Nancy 42 46 39 63
8 Dunkerque Dunkerque 42 42 38 60
9 Amiens SC Amiens SC 42 59 61 58
10 Olympique Alès Olympique 42 44 44 53
11 Charleville Charleville 42 45 49 52
12 Le Mans Le Mans 42 46 48 50
13 FC Mulhouse FC Mulhouse 42 49 58 49
14 Valence Valence 42 46 52 47
15 Stade Lavallois Stade 42 42 56 44
16 Perpignan Perpignan 42 35 51 44
17 Angers SCO Angers SCO 42 38 50 43
18 Stade Briochin Stade 42 38 52 43
19 Niort Niort 42 34 49 43
20 Beauvais Oise Beauvais 42 50 66 42
21 CS Sedan CS Sedan 42 34 60 41
22 Nîmes Nîmes 42 48 60 38
TEMPORADA 1993/1994
LIGUE 2
Equipo PJ GF GC Puntos
1 Bastia Bastia 42 44 29 74
2 Stade Rennais Stade 42 57 38 73
3 Nice Nice 42 47 25 72
4 Nîmes Nîmes 42 59 41 69
5 Red Star Red Star 42 61 45 69
6 Stade Briochin Stade 42 53 52 65
7 Stade Lavallois Stade 42 56 47 62
8 Charleville Charleville 42 41 48 56
9 Nancy Nancy 42 49 48 55
10 Dunkerque Dunkerque 42 44 51 55
11 CS Sedan CS Sedan 42 44 42 54
12 Olympique Alès Olympique 42 47 50 54
13 Valence Valence 42 47 47 53
14 FC Mulhouse FC Mulhouse 42 49 52 53
15 Le Mans Le Mans 42 43 50 53
16 Niort Niort 42 34 41 52
17 FC Rouen 1899 Rouen 1899 42 45 53 52
18 FC Gueugnon FC Gueugnon 42 43 43 51
19 Beauvais Oise Beauvais 42 45 51 49
20 Valenciennes Valenciennes 42 45 59 49
21 Bourges 18 Bourges 18 42 46 60 42
22 Istres Istres 42 35 62 33
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,174,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1010
Total Execution Time  0.1023
  CADENA URL  
/historico/Stade-Briochin
  GET DATOS  
$_GET['/historico/Stade-Briochin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
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 = 72964
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2836 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=220 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 220 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1303338,1286561,1233296,1230274,1161224) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '2836' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72964 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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 = 2836 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72964 AND t.round = 20 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 68050 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.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 `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.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 `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 = 50568 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.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 `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 = 44574 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 `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 = 39111 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 `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 = 34007 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 `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 = 15896 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 = 4305 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 `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 = 2547 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 `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
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 `tables1997` 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 = 528 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables1995` 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 = 30916 AND t.round = 42 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 `tables1994` 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 = 30942 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 220 AND l.group_code = 3 ORDER BY l.year DESC