4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Amiens AC
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 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Olympique St Quentin Olympique 26 48 20 54
2 Beauvais Oise Beauvais 26 47 23 51
3 Amiens AC Amiens AC 26 34 20 47
4 Grande-Synthe Grande-Synth 26 42 36 40
5 Amiens SC II Amiens 26 39 31 39
6 Chambly II Chambly II 26 33 27 39
7 US Boulogne II Boulogne 26 32 31 36
8 US Maubeuge US Maubeuge 26 24 21 34
9 Touquet Touquet 26 30 40 34
10 Olympique Marcquois Olympique 26 32 39 32
11 Senlis Senlis 26 28 41 30
12 Dunkerque II Dunkerque 26 33 42 28
13 Tourcoing Tourcoing 26 29 37 26
14 Chantilly Chantilly 26 25 68 8
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Drancy Drancy 30 41 17 59
2 CS Sedan CS Sedan 30 52 30 56
3 St Geneviève Geneviève 30 41 31 54
4 US Fleury-Merogis Fleury-Merog 30 45 34 51
5 Arras Arras 30 46 37 48
6 Maur Lusitanos Maur 30 37 33 46
7 Bastia-Borgo Bastia-Borgo 30 33 24 44
8 Poissy Poissy 30 34 36 40
9 Iris Club de Croix Iris Club C. 30 26 32 36
10 Lille II Lille II 30 39 48 34
11 Lens II Lens II 30 46 48 34
12 Stade de Reims II Stade Reims 30 41 43 32
13 Furiani Agliani Furiani 30 31 48 32
14 Amiens AC Amiens AC 30 18 28 30
15 V.Châtillon V.Châtillon 30 28 50 29
16 Beauvais Oise Beauvais 30 31 50 24
TEMPORADA 2016/2017
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Sannois Gratien Sannois 30 52 20 58
2 US Fleury-Merogis Fleury-Merog 30 36 22 57
3 Maur Lusitanos Maur 30 36 20 54
4 Boulogne-Billancourt Boulogne-Bil 30 48 42 49
5 Arras Arras 30 47 34 46
6 Lens II Lens II 30 36 37 44
7 Drancy Drancy 30 28 22 39
8 Lille II Lille II 30 36 35 39
9 Iris Club de Croix Iris Club C. 30 34 36 38
10 V.Châtillon V.Châtillon 30 37 40 36
11 Le Havre II Le Havre II 30 36 43 36
12 Amiens AC Amiens AC 30 30 40 33
13 Poissy Poissy 30 37 44 32
14 Calais Calais 30 38 57 31
15 ES Wasquehal Wasquehal 30 23 36 29
16 Dieppe Dieppe 30 21 47 28
TEMPORADA 2015/2016
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 QRM QRM 30 50 22 62
2 Iris Club de Croix Iris Club C. 30 55 37 55
3 Poissy Poissy 30 55 42 52
4 Sannois Gratien Sannois 30 46 39 46
5 ES Wasquehal Wasquehal 30 44 41 46
6 Arras Arras 30 43 43 41
7 Amiens AC Amiens AC 30 35 34 40
8 PSG II PSG II 30 35 40 40
9 Mantes Mantes 30 31 38 39
10 Boulogne-Billancourt Boulogne-Bil 30 43 40 38
11 Calais Calais 30 32 37 38
12 Dieppe Dieppe 30 31 24 37
13 Troyes II Troyes II 30 41 47 36
14 Lens II Lens II 30 37 45 36
15 Aubervilliers Aubervillier 30 27 47 24
16 Roye-Noyon Roye-Noyon 30 38 67 22
TEMPORADA 2014/2015
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 CS Sedan CS Sedan 30 61 25 75
2 QRM QRM 30 41 32 48
3 Iris Club de Croix Iris Club C. 30 37 32 43
4 PSG II PSG II 30 35 36 43
5 Dieppe Dieppe 30 33 29 41
6 Calais Calais 30 26 35 39
7 Amiens AC Amiens AC 30 34 26 38
8 Romorantin Romorantin 30 29 35 38
9 Sannois Gratien Sannois 30 29 29 37
10 Roye-Noyon Roye-Noyon 30 24 29 37
11 Lens II Lens II 30 35 37 36
12 Arras Arras 30 37 44 36
13 Mantes Mantes 30 31 45 36
14 Lille II Lille II 30 33 36 35
15 Beauvais Oise Beauvais 30 26 28 34
16 Ivry Ivry 30 31 44 34
TEMPORADA 2013/2014
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Chambly Chambly 28 38 19 51
2 Lille II Lille II 28 46 26 50
3 Aubervilliers Aubervillier 29 37 35 48
4 Beauvais Oise Beauvais 28 33 27 45
5 Roye-Noyon Roye-Noyon 28 31 24 43
6 Sannois Gratien Sannois 28 34 28 41
7 Ivry Ivry 28 37 37 41
8 QRM QRM 28 32 28 38
9 Amiens AC Amiens AC 28 29 28 38
10 PSG II PSG II 28 34 35 38
11 Lens II Lens II 28 33 33 37
12 Dieppe Dieppe 28 30 32 36
13 Mantes Mantes 28 24 30 36
14 Drancy Drancy 29 20 41 22
15 Villemomble Sports Villemomble 28 16 51 14
16 Le Mans Le Mans 0 0 0 0
TEMPORADA 2012/2013
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Dunkerque Dunkerque 34 47 22 69
2 Chambly Chambly 34 39 14 65
3 Beauvais Oise Beauvais 34 42 38 56
4 Roye-Noyon Roye-Noyon 34 39 35 50
5 Amnéville Amnéville 34 50 42 47
6 Lille II Lille II 34 39 43 47
7 Aubervilliers Aubervillier 34 35 44 47
8 FC Calvi FC Calvi 34 60 45 46
9 Ivry Ivry 34 33 31 46
10 Mantes Mantes 34 38 40 44
11 Villemomble Sports Villemomble 34 37 39 44
12 Amiens AC Amiens AC 34 38 44 44
13 Drancy Drancy 34 30 28 43
14 Lens II Lens II 34 42 46 43
15 Poissy Poissy 34 40 45 40
16 Compiègne Compiègne 34 30 42 33
17 Metz II Metz II 34 33 47 32
18 Valenciennes II Valenciennes 34 29 56 25
TEMPORADA 2011/2012
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 CA Bastia CA Bastia 34 53 33 67
2 Aubervilliers Aubervillier 34 53 34 64
3 Dunkerque Dunkerque 34 50 31 63
4 Auxerre II Auxerre II 34 60 36 62
5 Drancy Drancy 34 35 32 55
6 Lens II Lens II 34 48 39 50
7 FC Calvi FC Calvi 34 58 51 50
8 Amiens AC Amiens AC 34 41 40 50
9 Ivry Ivry 34 50 40 49
10 Lille II Lille II 34 44 42 48
11 Compiègne Compiègne 34 44 52 43
12 Poissy Poissy 34 43 47 38
13 Valenciennes II Valenciennes 34 44 52 38
14 PSG II PSG II 34 32 38 35
15 Alfortville Alfortville 34 36 55 32
16 Sénart Moissy Sénart 34 22 45 31
17 Villemomble Sports Villemomble 34 24 47 30
18 Avion Avion 34 34 57 25
TEMPORADA 2010/2011
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Amiens AC Amiens AC 30 39 18 59
2 Dunkerque Dunkerque 30 38 18 56
3 Oissel Oissel 30 39 25 49
4 Saint-Omer Saint-Omer 30 46 47 43
5 Dieppe Dieppe 30 40 28 41
6 Chartres Chartres 30 39 38 41
7 Bastia II Bastia II 30 39 40 41
8 Paris II Paris II 30 34 36 38
9 Marck Marck 30 33 35 38
10 Grande-Synthe Grande-Synth 30 25 30 38
11 Gravelines Gravelines 30 32 39 38
12 Evreux 27 Evreux 27 30 31 33 37
13 Beauvais II Beauvais II 30 30 33 37
14 Pacy Vallée-d'Eure II Pacy 30 30 41 33
15 Hazebrouck Hazebrouck 30 35 37 32
16 Dives Dives 30 33 65 26
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Calais Calais 30 46 21 56
2 Oissel Oissel 30 41 35 52
3 Evreux 27 Evreux 27 31 32 33 50
4 Poissy Poissy 30 48 35 49
5 Dieppe Dieppe 30 43 36 44
6 Hazebrouck Hazebrouck 31 41 36 44
7 Saint-Omer Saint-Omer 30 35 34 44
8 ES Wasquehal Wasquehal 30 32 28 41
9 Bastia II Bastia II 30 40 33 40
10 Gravelines Gravelines 30 36 36 40
11 Amiens AC Amiens AC 30 39 38 39
12 Drouais Drouais 30 31 30 38
13 Pacy Vallée-d'Eure II Pacy 29 30 32 38
14 Amiens SC II Amiens 30 25 38 30
15 Gonfreville Gonfreville 30 25 49 29
16 Entente S.S.G. II Entente 29 25 55 19
TEMPORADA 2008/2009
NATIONAL 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Marck Marck 32 45 26 59
2 Mantes Mantes 32 43 28 56
3 Hazebrouck Hazebrouck 32 52 37 54
4 Poissy Poissy 32 40 30 51
5 Amiens AC Amiens AC 32 53 36 50
6 Oissel Oissel 32 40 35 50
7 Dieppe Dieppe 32 45 42 47
8 Créteil II Créteil II 32 46 43 46
9 Entente S.S.G. II Entente 32 29 25 44
10 ES Wasquehal Wasquehal 32 38 32 42
11 Gravelines Gravelines 32 28 34 42
12 Amiens SC II Amiens 32 44 38 41
13 Drouais Drouais 31 23 31 41
14 Pacy Vallée-d'Eure II Pacy 32 38 47 39
15 Trouville Deauville Trouville 31 45 54 31
16 JA Armentières Armentières 32 23 38 30
17 AS Ifs AS Ifs 32 30 86 9
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

  USO DE MEMORIA  
6,775,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6778
Total Execution Time  0.6790
  CADENA URL  
/historico/Amiens-Ac
  GET DATOS  
$_GET['/historico/Amiens-Ac']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0302  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 = 68300
0.0150  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6822 AND type_rel = 2
0.0150  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6822 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151  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 (69785) ORDER BY n.cover_points DESC, update_date DESC
0.0153  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 = '6822' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '6822' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = '6822' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 68300 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=6822 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (68300,65709) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 68300 AND teamId = 6822
0.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 65709 AND teamId = 6822
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '6822' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0150  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6822' and rp.type = 4
0.0155  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 = '6822' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0192  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 events2023 e ON e.player_id = p.id AND e.league_id = 68300 WHERE rp.league_id = 68300 AND rp.teamId = 6822 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.0198  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 events2023 e ON e.player_id = p.id AND e.league_id = 68300 WHERE rp.league_id = 68300 AND rp.teamId = 6822 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0185  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 events2023 e ON e.player_id = p.id AND e.league_id = 68300 WHERE rp.league_id = 68300 AND rp.teamId = 6822 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 = 6822 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0163  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.0163  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.0163  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.0158  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.0151  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 = 39110 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 `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 = 33906 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 `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 = 4044 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 `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 = 2536 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 `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 = 2097 AND t.round = 34 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 `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 = 1679 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 19995 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 20003 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 = 20012 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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.0152  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 = 68300 ORDER BY nameShow LIMIT 100