Escudo del Chambly
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 2 GRUPO 1
Equipo PJ GF GC Puntos
1 FC Rouen 1899 Rouen 1899 30 58 29 69
2 Chambly Chambly 30 52 25 57
3 Racing Paris Racing Paris 29 64 29 56
4 Voltigeurs Châteaubriant Voltigeurs 30 33 29 48
5 Saint-Malo Saint-Malo 30 41 37 43
6 Poissy Poissy 29 43 37 41
7 Blois Blois 30 46 42 39
8 Beauvais Oise Beauvais 30 41 37 39
9 Saint-Pryve Saint-Pryve 29 28 31 39
10 Granville Granville 30 42 47 37
11 Guingamp II Guingamp II 29 34 47 34
12 Evreux 27 Evreux 27 29 46 56 31
13 Stade Rennais II Stade 29 37 63 25
14 Vannes Vannes 30 47 58 24
15 Caen II Caen II 30 37 62 24
16 Chartres Chartres 30 33 53 23
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
LIGUE 2
Equipo PJ GF GC Puntos
1 Troyes Troyes 38 60 36 77
2 Clermont Clermont 38 61 25 72
3 Toulouse Toulouse 38 71 42 70
4 Grenoble Grenoble 38 51 35 65
5 Paris FC Paris FC 38 53 37 64
6 Auxerre Auxerre 38 64 43 62
7 Sochaux Sochaux 38 45 37 51
8 Nancy Nancy 38 53 53 47
9 Guingamp Guingamp 38 41 43 47
10 Amiens SC Amiens SC 38 34 40 47
11 Valenciennes Valenciennes 38 50 59 47
12 Le Havre Le Havre 38 38 48 47
13 Ajaccio Ajaccio 38 34 43 46
14 Pau FC Pau FC 38 42 49 44
15 Rodez Rodez 38 38 44 43
16 Dunkerque Dunkerque 38 34 47 41
17 Caen Caen 38 34 49 41
18 Niort Niort 38 34 58 41
19 Chambly Chambly 38 41 64 38
20 Chateauroux Chateauroux 38 32 58 23
TEMPORADA 2019/2020
LIGUE 2
Equipo PJ GF GC Puntos
1 Lorient Lorient 28 45 25 54
2 Lens Lens 28 39 24 53
3 Ajaccio Ajaccio 28 38 22 52
4 Troyes Troyes 28 34 25 51
5 Clermont Clermont 28 35 25 50
6 Le Havre Le Havre 28 38 25 44
7 Valenciennes Valenciennes 28 24 20 42
8 Guingamp Guingamp 28 40 33 39
9 Grenoble Grenoble 28 27 29 35
10 Chambly Chambly 28 26 32 35
11 Auxerre Auxerre 28 31 30 34
12 Nancy Nancy 28 27 26 34
13 Caen Caen 28 33 34 34
14 Sochaux Sochaux 28 28 30 34
15 Chateauroux Chateauroux 28 22 38 34
16 Rodez Rodez 28 31 34 32
17 Paris FC Paris FC 28 22 40 28
18 Niort Niort 28 30 41 26
19 Le Mans Le Mans 28 30 45 26
20 Orléans Orléans 28 21 43 19
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
Equipo PJ GF GC Puntos
1 Strasbourg Strasbourg 34 35 19 58
2 Orléans Orléans 34 50 37 56
3 Amiens SC Amiens SC 34 44 35 55
4 Athlético Marseille Athlético 34 50 43 54
5 Chateauroux Chateauroux 34 52 45 52
6 Dunkerque Dunkerque 34 42 42 47
7 Avranches Avranches 34 44 36 46
8 US Boulogne US Boulogne 34 50 45 46
9 Chambly Chambly 34 46 40 44
10 Béziers Béziers 34 35 38 44
11 Luçon Luçon 34 45 50 44
12 CS Sedan CS Sedan 34 31 34 43
13 CA Bastia CA Bastia 34 29 33 43
14 Belfort Belfort 34 26 32 41
15 Les Herbiers Herbiers 34 44 51 39
16 Colmar Colmar 34 39 46 37
17 Épinal Épinal 34 39 53 30
18 Fréjus St-Raphaël Fréjus 34 22 44 27
TEMPORADA 2014/2015
NATIONAL
Equipo PJ GF GC Puntos
1 Red Star Red Star 34 68 30 70
2 Bourg-Péronnas Bourg-Péron 34 57 25 66
3 Paris FC Paris FC 34 50 28 66
4 Strasbourg Strasbourg 34 50 29 65
5 Luçon Luçon 34 40 25 58
6 Dunkerque Dunkerque 34 38 31 52
7 US Boulogne US Boulogne 34 49 39 50
8 Fréjus St-Raphaël Fréjus 34 42 38 49
9 Avranches Avranches 34 42 38 46
10 Colmar Colmar 34 40 44 45
11 Amiens SC Amiens SC 34 45 48 41
12 Le Poiré-sur-Vie Poiré-sur-V 34 36 44 41
13 Athlético Marseille Athlético 34 40 58 40
14 Chambly Chambly 34 42 54 37
15 CA Bastia CA Bastia 34 32 43 32
16 Colomiers Colomiers 34 30 50 32
17 Istres Istres 34 27 61 22
18 Épinal Épinal 34 30 73 15
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 3 GRUPO 1
Equipo PJ GF GC Puntos
1 Chambly Chambly 9 15 9 20
2 Sannois Gratien Sannois 9 13 7 16
3 Calais Calais 9 14 11 16
4 Dieppe Dieppe 9 15 10 15
5 US Boulogne II Boulogne 9 18 10 14
6 Amiens SC II Amiens 9 11 10 14
7 Beauvais II Beauvais II 9 12 14 12
8 Saint-Omer Saint-Omer 9 17 19 11
9 Oissel Oissel 9 10 14 11
10 FC Rouen 1899 II Rouen 1899 9 12 17 11
11 Gravelines Gravelines 9 15 14 10
12 Noisy-le-Sec Noisy-le-Sec 9 14 14 10
13 Grande-Synthe Grande-Synth 9 12 11 9
14 Olympique Marcquois Olympique 9 12 17 9
15 FC EU FC EU 9 10 16 9
16 Issy Issy 9 11 18 8
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
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,055,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5249
Total Execution Time  0.5261
  CADENA URL  
/historico/Chambly
  GET DATOS  
$_GET['/historico/Chambly']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0120  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Chambly' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6722 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6722 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6722 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=6722 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6722 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6722 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (31571,82745,171281,366324,386863) ORDER BY n.cover_points DESC, update_date DESC
0.0111  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 = '6722' ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '6722' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '6722' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108  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=6722 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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,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.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 72964 AND teamId = 6722
0.0123  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6722
0.0123  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6722
0.0126  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 = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0116  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 = '6722' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0110  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6722' and rp.type = 4
0.0118  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 = '6722' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0162  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 = 6722 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.0119  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 = 6722 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 6722 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 6722 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108  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.0108  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 = 68291 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.0111  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.0112  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 = 56826 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 49879 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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.0109  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.0113  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.0111  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 = 15088 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 3828 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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.0109  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.0108  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 = 1683 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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