4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lorient II
TEMPORADA 2023/2024
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 US Boulogne US Boulogne 24 46 22 51
2 Chambly Chambly 24 38 21 42
3 Granville Granville 24 32 29 40
4 Saint-Malo Saint-Malo 24 32 21 38
5 Stade Briochin Stade 24 30 24 36
6 Dinan-Léhon Dinan-Léhon 24 38 42 34
7 Beauvais Oise Beauvais 24 31 28 33
8 Aubervilliers Aubervillier 24 28 37 33
9 Voltigeurs Châteaubriant Voltigeurs 24 27 31 30
10 Racing Paris Racing Paris 24 24 32 28
11 Lorient II Lorient II 24 31 36 28
12 AF Virois AF Virois 24 31 34 27
13 Bastia-Borgo Bastia-Borgo 24 31 43 27
14 Guingamp II Guingamp II 24 26 45 20
TEMPORADA 2022/2023
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 GOAL FC GOAL FC 30 44 25 54
2 Les Herbiers Herbiers 30 54 35 52
3 Bergerac Bergerac 30 48 30 50
4 Angouleme Angouleme 30 28 19 45
5 Trelissac Trelissac 30 33 28 45
6 Chamalières Chamalières 30 36 30 44
7 Romorantin Romorantin 30 40 40 43
8 Saumur Saumur 30 36 35 41
9 Bourges Foot 18 Bourges Foot 30 32 35 41
10 Angers SCO II Angers 30 37 44 41
11 Andrézieux Andrézieux 30 29 27 40
12 Lorient II Lorient II 30 39 33 39
13 Nantes II Nantes II 30 31 41 34
14 Stade Bordelais Stade 30 32 48 29
15 Yzeure Yzeure 30 26 44 27
16 Vierzon Vierzon 30 22 53 23
TEMPORADA 2021/2022
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Versailles Versailles 30 47 16 64
2 Lorient II Lorient II 30 49 22 56
3 Chartres Chartres 30 53 49 50
4 FC Rouen 1899 Rouen 1899 30 38 28 47
5 Blois Blois 30 52 56 43
6 Saint-Pryve Saint-Pryve 30 37 38 42
7 Vannes Vannes 30 42 43 39
8 Voltigeurs Châteaubriant Voltigeurs 30 29 33 38
9 Granville Granville 30 38 32 38
10 Guingamp II Guingamp II 30 41 48 38
11 Saint-Malo Saint-Malo 30 33 38 36
12 Poissy Poissy 30 33 40 36
13 Romorantin Romorantin 30 37 40 35
14 Caen II Caen II 30 29 41 35
15 Plabennec Plabennec 30 29 45 27
16 Vitré Vitré 30 35 53 25
TEMPORADA 2020/2021
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Saint-Pryve Saint-Pryve 8 12 3 20
2 Voltigeurs Châteaubriant Voltigeurs 9 12 8 16
3 St Geneviève Geneviève 9 10 6 16
4 Caen II Caen II 9 10 7 15
5 Granville Granville 9 8 6 15
6 US Fleury-Merogis Fleury-Merog 9 7 6 13
7 Chartres Chartres 9 13 11 12
8 Plabennec Plabennec 9 11 13 12
9 FC Rouen 1899 Rouen 1899 8 4 4 10
10 Versailles Versailles 9 11 13 10
11 Guingamp II Guingamp II 9 7 9 9
12 Lorient II Lorient II 9 5 8 9
13 Vannes Vannes 8 9 10 8
14 Saint-Malo Saint-Malo 9 8 10 8
15 Blois Blois 8 11 15 8
16 Poissy Poissy 9 6 15 2
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 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Stade Rennais II Stade 30 44 34 56
2 Cholet Cholet 30 46 32 52
3 Bergerac Bergerac 30 35 34 49
4 Granville Granville 30 40 41 47
5 Trelissac Trelissac 30 44 31 46
6 Vitré Vitré 30 36 34 45
7 Romorantin Romorantin 30 35 31 44
8 PSG II PSG II 30 44 36 42
9 Saint-Malo Saint-Malo 30 32 32 42
10 Fontenay Fontenay 30 47 49 42
11 Lorient II Lorient II 30 41 35 39
12 Chartres Chartres 30 33 41 33
13 Plabennec Plabennec 30 30 37 29
14 Mantes Mantes 30 23 41 29
15 Nantes II Nantes II 30 40 40 28
16 Voltigeurs Châteaubriant Voltigeurs 30 26 48 26
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 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 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 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

  USO DE MEMORIA  
7,093,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5129
Total Execution Time  0.5141
  CADENA URL  
/historico/Lorient-Ii
  GET DATOS  
$_GET['/historico/Lorient-Ii']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6699 AND type_rel = 2
0.0128  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 = '6699' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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.0136  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=6699 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 (72964,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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 72964 AND teamId = 6699
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6699
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 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 = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '6699' 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 = '6699' and rp.type = 4
0.0127  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 = '6699' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72964 WHERE rp.league_id = 72964 AND rp.teamId = 6699 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.0138  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 = 72964 WHERE rp.league_id = 72964 AND rp.teamId = 6699 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 72964 WHERE rp.league_id = 72964 AND rp.teamId = 6699 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 6699 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 24 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 `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 = 68294 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.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 `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 = 63479 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.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 = 57113 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.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 `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.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 = 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.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 `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.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 = 33905 AND t.round = 30 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 `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.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 `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 = 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.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 `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.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 `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.0146  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.0149  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.0140  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