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

Feignies

Entrenador: Jean Antunes

Temporada 2023/2024
TEMPORADA 2023/2024
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Bourg-Péronnas Bourg-Péron 24 43 20 50
2 US Fleury-Merogis Fleury-Merog 24 42 20 42
3 Furiani Agliani Furiani 24 30 16 42
4 Bobigny Bobigny 24 36 28 38
5 Creteil Creteil 24 28 26 34
6 Biesheim Biesheim 24 28 32 34
7 Feignies Feignies 24 27 31 31
8 Colmar Colmar 24 33 39 28
9 ES Wasquehal Wasquehal 24 30 37 28
10 FCSR Haguenau FCSR 24 29 45 28
11 Auxerre II Auxerre II 24 30 31 27
12 Mâcon Mâcon 24 33 35 27
13 Besancon RC Besancon RC 24 25 32 24
14 Olympique St Quentin Olympique 24 33 55 23
TEMPORADA 2022/2023
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Feignies Feignies 26 60 29 60
2 Lens II Lens II 26 64 30 47
3 Valenciennes II Valenciennes 26 45 29 47
4 Olympique Marcquois Olympique 26 41 29 44
5 Iris Club de Croix Iris Club C. 26 37 29 41
6 Lille II Lille II 26 41 30 40
7 Compiègne Compiègne 26 39 40 39
8 Vimy Vimy 26 34 40 39
9 Chantilly Chantilly 26 48 46 38
10 US Maubeuge US Maubeuge 26 40 44 37
11 Amiens SC II Amiens 26 43 46 32
12 Amiens AC Amiens AC 26 30 52 19
13 ES Lambres ES Lambres 26 19 61 18
14 Longueau Longueau 26 18 54 12
TEMPORADA 2021/2022
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 ES Wasquehal Wasquehal 26 46 23 53
2 Feignies Feignies 26 37 21 51
3 Olympique Marcquois Olympique 26 42 27 43
4 Lille II Lille II 26 43 29 42
5 Amiens AC Amiens AC 26 32 25 40
6 US Maubeuge US Maubeuge 26 40 32 39
7 Valenciennes II Valenciennes 26 39 40 36
8 Amiens SC II Amiens 26 39 40 35
9 Iris Club de Croix Iris Club C. 26 34 37 31
10 Vimy Vimy 26 33 38 31
11 Chantilly Chantilly 26 29 44 30
12 Saint-Omer Saint-Omer 26 20 33 29
13 US Boulogne II Boulogne 26 17 37 23
14 Touquet Touquet 26 31 56 22
TEMPORADA 2020/2021
NATIONAL 3 GRUPO 5
Equipo PJ GF GC Puntos
1 Valenciennes II Valenciennes 0 0 0 0
2 Amiens AC Amiens AC 0 0 0 0
3 Amiens SC II Amiens 0 0 0 0
4 Olympique Marcquois Olympique 0 0 0 0
5 US Boulogne II Boulogne 0 0 0 0
6 Chantilly Chantilly 0 0 0 0
7 US Maubeuge US Maubeuge 0 0 0 0
8 ES Wasquehal Wasquehal 0 0 0 0
9 Lille II Lille II 0 0 0 0
10 Vimy Vimy 0 0 0 0
11 Touquet Touquet 0 0 0 0
12 Feignies Feignies 0 0 0 0
13 Iris Club de Croix Iris Club C. 0 0 0 0
14 Saint-Omer Saint-Omer 0 0 0 0
TEMPORADA 2019/2020
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Beauvais Oise Beauvais 16 30 16 30
2 Feignies Feignies 17 20 10 28
3 US Maubeuge US Maubeuge 17 26 16 27
4 Olympique Marcquois Olympique 16 19 12 26
5 Vimy Vimy 15 17 16 25
6 Valenciennes II Valenciennes 17 21 21 23
7 Amiens AC Amiens AC 16 23 22 22
8 Touquet Touquet 16 14 21 22
9 Amiens SC II Amiens 16 22 24 19
10 US Boulogne II Boulogne 16 18 26 19
11 Grande-Synthe Grande-Synth 16 19 22 16
12 Portelois Portelois 15 21 28 15
13 Chambly II Chambly II 16 13 21 14
14 Arras Arras 15 12 20 14
TEMPORADA 2018/2019
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Creteil Creteil 30 55 21 59
2 Lille II Lille II 30 53 33 56
3 CS Sedan CS Sedan 30 39 29 47
4 Maur Lusitanos Maur 30 53 39 46
5 St Geneviève Geneviève 30 38 39 45
6 Iris Club de Croix Iris Club C. 30 38 44 43
7 Schiltigheim Schiltigheim 30 40 38 42
8 Épinal Épinal 30 33 37 42
9 Stade de Reims II Stade Reims 30 34 36 41
10 US Fleury-Merogis Fleury-Merog 30 48 50 39
11 Belfort Belfort 30 24 31 35
12 Bobigny Bobigny 30 33 44 35
13 Lens II Lens II 30 45 47 34
14 FCSR Haguenau FCSR 30 35 42 31
15 Feignies Feignies 30 33 43 31
16 Arras Arras 30 35 63 21
TEMPORADA 2017/2018
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Feignies Feignies 26 41 15 62
2 Grande-Synthe Grande-Synth 26 30 19 48
3 Olympique St Quentin Olympique 26 45 26 45
4 Senlis Senlis 26 28 26 39
5 Dunkerque II Dunkerque 26 32 31 38
6 Amiens SC II Amiens 26 37 33 36
7 Tourcoing Tourcoing 26 38 34 34
8 Chambly II Chambly II 26 26 34 32
9 US Maubeuge US Maubeuge 26 24 31 31
10 US Boulogne II Boulogne 26 25 33 31
11 ES Wasquehal Wasquehal 26 29 30 30
12 Saint-Amand Saint-Amand 26 24 31 30
13 Roye-Noyon Roye-Noyon 26 24 41 21
14 Ailly Sur Somme Ailly Somme 26 20 39 17
TEMPORADA 2016/2017
NATIONAL 3 GRUPO 3
Equipo PJ GF GC Puntos
1 Beauvais Oise Beauvais 26 39 21 48
2 Saint-Ouen-l'Aumône Saint-Ouen-l 26 31 17 47
3 Amiens SC II Amiens 26 34 30 44
4 Feignies Feignies 26 36 28 42
5 Olympique St Quentin Olympique 26 35 29 39
6 Tourcoing Tourcoing 26 25 24 38
7 Grande-Synthe Grande-Synth 26 32 32 38
8 US Maubeuge US Maubeuge 26 36 32 35
9 US Boulogne II Boulogne 26 35 41 33
10 Roye-Noyon Roye-Noyon 26 25 26 32
11 Ailly Sur Somme Ailly Somme 26 30 36 28
12 Paris II Paris II 26 34 44 27
13 Marck Marck 26 24 38 25
14 Senlis Senlis 26 23 41 25
TEMPORADA 2015/2016
NATIONAL 3 GRUPO 7
Equipo PJ GF GC Puntos
1 Lille II Lille II 26 45 26 50
2 Maur Lusitanos Maur 26 45 28 50
3 Grande-Synthe Grande-Synth 26 45 31 47
4 Noisy-le-Sec Noisy-le-Sec 26 45 36 45
5 Ivry Ivry 26 33 27 40
6 US Boulogne II Boulogne 26 42 34 38
7 Ailly Sur Somme Ailly Somme 26 27 29 37
8 Feignies Feignies 26 33 37 34
9 Amiens SC II Amiens 26 31 38 31
10 Olympique St Quentin Olympique 26 37 44 29
11 Marck Marck 26 25 31 28
12 Tourcoing Tourcoing 26 36 54 26
13 Aulnoye Aulnoye 26 39 46 23
14 Valenciennes II Valenciennes 26 26 48 16
TEMPORADA 2014/2015
NATIONAL 3 GRUPO 4
Equipo PJ GF GC Puntos
1 ES Wasquehal Wasquehal 26 29 16 48
2 Paris II Paris II 26 45 29 43
3 Valenciennes II Valenciennes 26 37 23 41
4 Grande-Synthe Grande-Synth 26 40 29 40
5 Feignies Feignies 26 33 31 40
6 Sénart Moissy Sénart 26 33 35 40
7 Olympique St Quentin Olympique 26 33 33 33
8 Noisy-le-Sec Noisy-le-Sec 26 26 26 33
9 Aulnoye Aulnoye 26 29 33 33
10 Tourcoing Tourcoing 26 35 34 32
11 UJA Maccabi UJA Maccabi 26 27 28 32
12 Marck Marck 26 23 31 30
13 Villemomble Sports Villemomble 26 25 34 29
14 Choisy au Bac Choisy 26 25 58 13
TEMPORADA 2013/2014
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Iris Club de Croix Iris Club C. 28 63 13 69
2 CS Sedan CS Sedan 26 52 19 58
3 Poissy Poissy 28 37 27 45
4 Feignies Feignies 27 42 33 36
5 ES Wasquehal Wasquehal 27 36 37 35
6 Olympique St Quentin Olympique 28 26 37 35
7 Sénart Moissy Sénart 28 36 41 33
8 Valenciennes II Valenciennes 28 33 39 33
9 Evry Evry 27 35 44 33
10 Paris II Paris II 27 41 44 32
11 Aulnoye Aulnoye 28 38 62 32
12 RC Épernay Champagne Épernay 27 18 32 29
13 Stade de Reims II Stade Reims 27 36 46 26
14 Compiègne Compiègne 28 16 61 12
TEMPORADA 2012/2013
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Dieppe Dieppe 26 67 18 65
2 Sedan II Sedan II 26 39 26 48
3 Grande-Synthe Grande-Synth 26 31 29 45
4 Iris Club de Croix Iris Club C. 26 35 18 44
5 Arras Arras 26 40 25 41
6 Calais Calais 26 37 30 39
7 Feignies Feignies 26 31 29 37
8 Amiens SC II Amiens 26 37 36 36
9 ES Wasquehal Wasquehal 26 32 43 32
10 Aulnoye Aulnoye 26 35 41 31
11 Gravelines Gravelines 26 33 44 30
12 Avion Avion 26 27 41 25
13 US Boulogne II Boulogne 26 22 54 19
14 Ailly Sur Somme Ailly Somme 26 20 52 14
TEMPORADA 2011/2012
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Iris Club de Croix Iris Club C. 9 13 3 20
2 ES Wasquehal Wasquehal 9 21 11 19
3 US Fleury-Merogis Fleury-Merog 9 15 12 17
4 Sedan II Sedan II 9 19 12 16
5 Roye-Noyon Roye-Noyon 9 14 10 16
6 Feignies Feignies 9 12 6 15
7 Stade de Reims II Stade Reims 9 10 8 15
8 Sézanne Sézanne 9 17 16 14
9 Troyes II Troyes II 9 16 14 13
10 Arras Arras 9 11 14 11
11 Racing Colombes 92 Racing 9 9 15 11
12 St Geneviève Geneviève 9 10 14 9
13 Fresnoy-Saint-Quentin Fresnoy-Sain 9 6 10 8
14 Paris II Paris II 9 9 16 8
15 Saint-Dizier Saint-Dizier 9 5 11 5
16 Créteil II Créteil II 9 7 22 2
TEMPORADA 2010/2011
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Calais Calais 30 45 26 58
2 Valenciennes II Valenciennes 30 44 28 53
3 Racing Colombes 92 Racing 30 43 29 50
4 Sedan II Sedan II 30 53 27 48
5 Roye-Noyon Roye-Noyon 30 40 34 48
6 Feignies Feignies 30 44 29 47
7 ES Wasquehal Wasquehal 30 40 26 45
8 Arras Arras 30 40 29 45
9 Chambly Chambly 30 32 35 44
10 St Geneviève Geneviève 30 40 31 42
11 Stade de Reims II Stade Reims 30 39 46 42
12 Créteil II Créteil II 30 35 41 39
13 Lesquin Lesquin 30 30 37 39
14 Les Lilas Les Lilas 30 41 57 33
15 Douai Douai 30 24 58 21
16 Prix lès Mézières Prix lès Mé. 30 19 76 7
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Aubervilliers Aubervillier 30 55 21 66
2 Avion Avion 30 63 24 58
3 Feignies Feignies 30 45 30 51
4 Arras Arras 30 36 24 50
5 Roye-Noyon Roye-Noyon 30 41 30 46
6 Valenciennes II Valenciennes 30 33 23 46
7 Sedan II Sedan II 30 44 36 45
8 Stade de Reims II Stade Reims 30 46 38 44
9 Beauvais II Beauvais II 30 38 34 39
10 Lesquin Lesquin 30 34 43 39
11 Saint-Dizier Saint-Dizier 30 28 37 39
12 Créteil II Créteil II 30 39 46 37
13 Les Lilas Les Lilas 30 39 43 36
14 FC Sens FC Sens 30 37 53 35
15 Tinqueux Tinqueux 29 18 55 17
16 Marnaval Marnaval 29 22 81 11
TEMPORADA 2008/2009
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Drancy Drancy 30 39 24 59
2 Ivry Ivry 30 44 16 54
3 Stade de Reims II Stade Reims 30 50 37 45
4 Arras Arras 30 34 26 45
5 Troyes II Troyes II 30 43 37 45
6 Feignies Feignies 30 45 35 44
7 FC Sens FC Sens 30 33 33 40
8 Sedan II Sedan II 30 41 42 39
9 Roye-Noyon Roye-Noyon 30 33 39 39
10 Les Lilas Les Lilas 30 36 39 38
11 Lesquin Lesquin 30 24 31 38
12 Valenciennes II Valenciennes 30 37 39 37
13 Reims Sainte-Anne Reims 30 32 41 37
14 Avion Avion 30 40 53 37
15 Leval Leval 30 32 40 35
16 Chauny Chauny 30 26 57 23
TEMPORADA 2007/2008
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Noisy-le-Sec Noisy-le-Sec 30 55 23 60
2 Sedan II Sedan II 30 39 25 51
3 Amiens AC Amiens AC 30 47 39 51
4 Marck Marck 30 46 28 50
5 Feignies Feignies 29 43 30 50
6 Les Lilas Les Lilas 30 44 34 49
7 JA Armentières Armentières 30 29 24 49
8 Hazebrouck Hazebrouck 30 35 38 46
9 Amiens SC II Amiens 30 49 39 44
10 Arras Arras 30 37 38 39
11 Stade de Reims II Stade Reims 30 39 38 38
12 Roye-Noyon Roye-Noyon 30 32 40 36
13 Olympique St Quentin Olympique 29 31 38 31
14 SC Abbeville Abbeville 30 42 54 27
15 US Laon US Laon 30 25 44 27
16 Taissy Taissy 30 20 81 8
TEMPORADA 2005/2006
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Beauvais Oise Beauvais 34 67 33 68
2 Dunkerque Dunkerque 34 55 37 63
3 Auxerre II Auxerre II 34 51 32 58
4 Roye-Noyon Roye-Noyon 34 47 37 51
5 Calais Calais 34 41 30 50
6 Compiègne Compiègne 34 43 34 50
7 Lens II Lens II 34 50 44 49
8 Lesquin Lesquin 34 35 41 46
9 Lille II Lille II 34 45 39 45
10 FC Mulhouse FC Mulhouse 34 40 48 43
11 Metz II Metz II 33 36 33 42
12 Strasbourg II Strasbourg 34 35 43 42
13 Nancy II Nancy II 34 38 40 39
14 Vauban Strasbourg Vauban 34 47 59 37
15 Schiltigheim Schiltigheim 34 35 48 37
16 Épinal Épinal 34 32 54 37
17 Feignies Feignies 33 36 47 36
18 ES Wasquehal Wasquehal 34 32 66 21

  USO DE MEMORIA  
7,118,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0969
Total Execution Time  0.0981
  CADENA URL  
/historico/Feignies
  GET DATOS  
$_GET['/historico/Feignies']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
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 = 72965
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6736 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6736 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (142497,1082424,1082242,1082301,1298995) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '6736' 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 = 72965 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 6736 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 = 72965 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.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 `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 = 68300 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 63489 AND t.round = 26 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 `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 = 57386 AND t.round = 26 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 `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 = 50961 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 44575 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39134 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 34009 AND t.round = 26 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 `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 = 15904 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 4310 AND t.round = 26 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 `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 = 2541 AND t.round = 26 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 `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 = 2101 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 1684 AND t.round = 9 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 `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 = 19996 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 `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 = 20004 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 `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 = 20013 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 `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 = 20020 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 `tables2006` 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 = 19943 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 72965 ORDER BY nameShow LIMIT 100