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

Concarneau

Entrenador: Stéphane Le Mignan

Temporada 2023/2024
TEMPORADA 2023/2024
LIGUE 2
Equipo PJ GF GC Puntos
1 Auxerre Auxerre 35 66 35 67
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 35 32 49 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
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 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Concarneau Concarneau 30 41 24 56
2 Saint-Malo Saint-Malo 30 57 32 55
3 Romorantin Romorantin 30 54 44 54
4 Bergerac Bergerac 30 36 33 52
5 Lorient II Lorient II 30 40 31 44
6 Cholet Cholet 30 36 28 44
7 Voltigeurs Châteaubriant Voltigeurs 30 46 41 43
8 US Fleury-Merogis Fleury-Merog 30 32 35 41
9 Trelissac Trelissac 30 38 32 39
10 Nantes II Nantes II 30 37 38 35
11 Fontenay Fontenay 30 40 45 35
12 Plabennec Plabennec 30 34 49 34
13 V.Châtillon V.Châtillon 30 26 34 31
14 Vitré Vitré 30 33 46 30
15 Stade Bordelais Stade 30 22 37 25
16 Girondins Bordeaux II Girondins 30 23 46 22
TEMPORADA 2014/2015
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Les Herbiers Herbiers 30 50 26 56
2 Lorient II Lorient II 30 44 29 56
3 Stade Bordelais Stade 30 39 32 52
4 Concarneau Concarneau 30 46 32 49
5 Trelissac Trelissac 30 46 34 49
6 Pau FC Pau FC 30 49 36 45
7 Vitré Vitré 30 45 48 45
8 Nantes II Nantes II 30 42 42 42
9 Girondins Bordeaux II Girondins 30 47 48 37
10 Stade Montois Stade 30 34 40 37
11 Plabennec Plabennec 30 29 41 35
12 Saint-Malo Saint-Malo 30 39 46 34
13 Tarbes Tarbes 30 32 40 34
14 Fontenay Fontenay 30 33 40 33
15 Pontivy Pontivy 30 23 40 25
16 Limoges Limoges 30 33 57 21
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 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Pontivy Pontivy 30 55 29 57
2 Concarneau Concarneau 30 35 25 50
3 Guingamp II Guingamp II 30 63 33 49
4 FC Rouen 1899 II Rouen 1899 30 51 37 48
5 Granville Granville 30 39 36 45
6 Saint-Malo Saint-Malo 30 41 44 45
7 Stade Brestois II Stade 30 40 40 44
8 Dinan-Léhon Dinan-Léhon 30 35 37 43
9 Vitré Vitré 30 37 30 41
10 Montagnarde Montagnarde 30 39 38 41
11 Mondeville Mondeville 30 39 31 39
12 Stade Lavallois II Stade 30 34 44 38
13 Lannion Lannion 30 37 43 37
14 Alençon Alençon 30 43 50 34
15 Change Change 30 26 55 30
16 Quimper Cornouaille Quimper 30 29 71 17
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Lorient II Lorient II 30 70 32 59
2 Guingamp II Guingamp II 30 44 24 57
3 Concarneau Concarneau 30 43 28 51
4 Dives Dives 30 44 40 46
5 Alençon Alençon 30 33 29 43
6 Change Change 30 41 48 43
7 Montagnarde Montagnarde 30 39 34 42
8 USSA Vertou USSA Vertou 30 32 32 42
9 Stade Brestois II Stade 30 45 37 41
10 Saint-Malo Saint-Malo 30 34 31 40
11 Mondeville Mondeville 30 47 46 38
12 Stade Lavallois II Stade 30 36 39 38
13 Vitré Vitré 30 41 35 36
14 Chapelle Marais Chapelle 30 33 39 36
15 Saint-Lô Manche Saint-Lô 30 48 55 33
16 Écommoy FC Écommoy FC 30 17 98 14
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
TEMPORADA 2006/2007
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Villemomble Sports Villemomble 34 41 29 63
2 Stade Rennais II Stade 34 57 36 57
3 Auxerre II Auxerre II 34 48 37 54
4 Guingamp II Guingamp II 34 41 38 52
5 FUSC Bois Guillaume FUSC Bois G. 34 38 27 51
6 Poissy Poissy 34 47 43 50
7 FC Rouen 1899 Rouen 1899 34 32 29 50
8 St Geneviève Geneviève 34 48 38 49
9 Pacy Vallée-d.Eure Pacy 34 35 28 49
10 Red Star Red Star 34 39 33 47
11 Sénart Moissy Sénart 34 34 29 45
12 QRM QRM 34 47 48 41
13 PSG II PSG II 33 40 42 41
14 Vitré Vitré 33 35 37 39
15 Plabennec Plabennec 34 30 38 37
16 Pontivy Pontivy 34 35 64 34
17 Dieppe Dieppe 33 27 47 28
18 Concarneau Concarneau 33 25 56 21

  USO DE MEMORIA  
7,696,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6023
Total Execution Time  0.6035
  CADENA URL  
/historico/Concarneau
  GET DATOS  
$_GET['/historico/Concarneau']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0269  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 = 74470
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6709 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6709 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (27142,490709) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '6709' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=6709 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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,68050) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72082 AND teamId = 6709
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 68050 AND teamId = 6709
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6709
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6709
0.0128  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 = '6709' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6709' and rp.type = 4
0.0137  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 = '6709' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0235  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 = 6709 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.0201  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 = 6709 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0182  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 = 6709 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 = 6709 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72082 AND t.round = 36 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 `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.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 `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 = 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.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 `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.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 `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.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 `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.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 `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 = 15748 AND t.round = 30 ORDER BY team.conference 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 `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 = 4380 AND t.round = 30 ORDER BY team.conference 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 `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.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 `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.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 `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.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 `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 = 20002 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 20011 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 `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.0136  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.0135  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 = 19942 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC