4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Stade Bordelais
TEMPORADA 2023/2024
NATIONAL 3 GRUPO 2
Equipo PJ GF GC Puntos
1 Anglet Genets Anglet 24 37 22 49
2 Blagnac Blagnac 24 37 8 48
3 Castanet Castanet 24 35 19 44
4 Pau FC II Pau FC II 24 39 25 41
5 Colomiers Colomiers 24 27 25 38
6 Lège-Cap-Ferret Lège-Cap-Fe 24 30 31 31
7 Canet Roussillon Canet 24 24 27 31
8 Stade Bordelais Stade 24 31 35 31
9 Bayonne Bayonne 24 33 31 30
10 Alberes Argelès Alberes 24 29 36 29
11 Onet Le Château Onet 24 30 36 27
12 Girondins Bordeaux II Girondins 24 30 31 26
13 Saint Paul Sport Saint Paul. 24 17 35 18
14 Saint-Estève Perpignan Saint-Estèv 24 20 58 10
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 3 GRUPO 9
Equipo PJ GF GC Puntos
1 Stade Bordelais Stade 26 57 28 62
2 Bayonne Bayonne 26 45 36 47
3 Anglet Genets Anglet 26 37 27 45
4 Girondins Bordeaux II Girondins 26 41 30 42
5 Stade Poitevin Stade 26 52 33 41
6 Chauvigny Chauvigny 26 36 31 38
7 FC Libourne FC Libourne 26 37 40 37
8 CA Neuville CA Neuville 26 44 40 35
9 Niort II Niort II 26 35 42 32
10 Lège-Cap-Ferret Lège-Cap-Fe 26 38 35 31
11 Chatellerault Chatelleraul 26 27 40 26
12 Bressuire Bressuire 26 34 52 25
13 Cognac Cognac 26 33 63 23
14 Tartas St-Yaguen Tartas 26 44 63 21
TEMPORADA 2020/2021
NATIONAL 3 GRUPO 10
Equipo PJ GF GC Puntos
TEMPORADA 2019/2020
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Sète Sète 21 33 15 49
2 Blois Blois 20 24 20 38
3 Les Herbiers Herbiers 20 29 19 35
4 Bergerac Bergerac 20 21 15 33
5 Colomiers Colomiers 20 28 19 31
6 Bourges Foot Bourges Foot 21 25 21 31
7 Saint-Pryve Saint-Pryve 21 25 26 31
8 Angouleme Angouleme 21 32 26 30
9 Nantes II Nantes II 21 23 19 28
10 Romorantin Romorantin 21 25 20 25
11 Andrézieux Andrézieux 21 26 25 23
12 Trelissac Trelissac 21 18 22 22
13 Montpellier II Montpellier 21 25 38 22
14 Chamalières Chamalières 19 18 25 21
15 Saint-Étienne II Saint-Étien 21 19 32 18
16 Stade Bordelais Stade 21 18 47 9
TEMPORADA 2018/2019
NATIONAL 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Le Puy Le Puy 30 34 19 52
2 Les Herbiers Herbiers 30 41 27 50
3 Andrézieux Andrézieux 30 39 33 48
4 Yzeure Yzeure 30 32 29 47
5 Sète Sète 30 37 28 46
6 Blois Blois 30 43 39 45
7 Saint-Pryve Saint-Pryve 30 33 27 44
8 Bergerac Bergerac 30 37 33 42
9 Saint-Étienne II Saint-Étien 30 41 36 41
10 Colomiers Colomiers 30 31 32 40
11 Stade Bordelais Stade 30 27 34 38
12 Romorantin Romorantin 30 28 25 37
13 Trelissac Trelissac 30 28 31 37
14 Nîmes II Nîmes II 30 26 41 33
15 Girondins Bordeaux II Girondins 30 21 38 26
16 Stade Montois Stade 30 26 52 25
TEMPORADA 2017/2018
NATIONAL 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Sporting Toulon Var Sporting 30 41 25 57
2 Marignane Gignac Marignane 30 39 25 57
3 Colomiers Colomiers 30 43 27 51
4 Bergerac Bergerac 30 43 28 49
5 Fréjus St-Raphaël Fréjus 30 41 32 49
6 FC Martigues Martigues 30 42 33 47
7 Sète Sète 30 39 26 43
8 Monaco II Monaco II 30 44 34 43
9 Grasse Grasse 30 32 31 39
10 Hyères Hyères 30 35 32 36
11 Stade Bordelais Stade 30 30 36 36
12 Nice II Nice II 30 31 48 35
13 Stade Montois Stade 30 32 46 32
14 Olympique Marseille II Olympique 30 31 46 28
15 Tarbes Tarbes 30 32 60 26
16 Paulhan/Pézenas Paulhan/Péz 30 19 45 23
TEMPORADA 2016/2017
NATIONAL 3 GRUPO 8
Equipo PJ GF GC Puntos
1 Stade Bordelais Stade 26 42 22 51
2 Limoges Limoges 26 45 18 49
3 Anglet Genets Anglet 26 37 21 45
4 Girondins Bordeaux II Girondins 26 44 30 44
5 Niort II Niort II 26 41 25 42
6 Angouleme Angouleme 26 39 38 40
7 Bressuire Bressuire 26 24 23 35
8 Pau FC II Pau FC II 26 26 31 32
9 Bayonne Bayonne 26 27 28 30
10 La Roche VF La Roche VF 26 29 44 26
11 Lège-Cap-Ferret Lège-Cap-Fe 26 27 43 22
12 Cozes Cozes 26 24 42 20
13 F.C. Marmande 47 F.C. 26 23 42 20
14 Les Herbiers II Herbiers 26 28 49 20
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 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Les Genêts d.A… Genêts 9 14 6 18
2 Nîmes II Nîmes II 9 12 4 17
3 AS Muretaine Muretaine 9 9 4 17
4 Balma Balma 9 9 5 17
5 Montpellier II Montpellier 9 17 11 15
6 Stade Bordelais Stade 9 13 8 14
7 Narbonne Narbonne 9 8 8 14
8 Toulouse II Toulouse II 9 12 13 14
9 SA Mérignac Mérignac 9 6 9 13
10 F.C. Marmande 47 F.C. 9 12 10 11
11 Bergerac Bergerac 9 12 13 10
12 Saint-Alban Saint-Alban 9 7 13 8
13 Blagnac Blagnac 9 11 18 8
14 SU Agen SU Agen 9 9 14 7
15 Lormont Lormont 9 11 18 7
16 Aurillac Arpajon Aurillac 9 9 17 7
TEMPORADA 2010/2011
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Stade Montois Stade 32 45 22 62
2 Girondins Bordeaux II Girondins 32 51 31 61
3 Stade Bordelais Stade 32 51 29 60
4 Trelissac Trelissac 32 44 29 57
5 Toulouse II Toulouse II 32 60 32 55
6 Balma Balma 32 38 27 55
7 Bergerac Bergerac 32 54 42 46
8 SA Mérignac Mérignac 32 39 36 45
9 SU Agen SU Agen 32 40 38 41
10 Saint-Alban Saint-Alban 32 37 48 41
11 Lormont Lormont 32 47 56 38
12 Blagnac Blagnac 32 42 45 36
13 Langon-Castets Langon-Caste 32 35 51 34
14 Revel Revel 32 30 50 34
15 Brive Brive 32 33 48 33
16 FC Libourne FC Libourne 32 24 49 29
17 Toulouse Fontaines Toulouse 32 28 65 18
TEMPORADA 2009/2010
NATIONAL 3 GRUPO 6
Equipo PJ GF GC Puntos
1 Béziers Béziers 30 63 36 65
2 Tarbes Tarbes 30 53 33 58
3 Toulouse II Toulouse II 30 44 28 51
4 Trelissac Trelissac 30 51 38 49
5 Bergerac Bergerac 30 45 34 44
6 SU Agen SU Agen 30 33 27 43
7 Cognac Cognac 30 50 48 40
8 Stade Montois Stade 30 36 37 40
9 Stade Bordelais Stade 30 35 28 39
10 Blagnac Blagnac 30 42 41 39
11 SA Mérignac Mérignac 30 29 46 36
12 Saint-Alban Saint-Alban 30 37 49 35
13 Cugnaux Cugnaux 30 27 45 34
14 Tournefeuille Tournefeuill 30 35 51 30
15 Bayonne II Bayonne II 30 41 58 28
16 Bassin d'Arcachon Sud Bassin 30 38 60 24
TEMPORADA 2008/2009
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Luzenac Luzenac 34 59 26 69
2 Moulins Moulins 34 56 41 62
3 Pau FC Pau FC 34 42 25 60
4 Fontenay Fontenay 34 37 32 57
5 Yzeure Yzeure 34 60 43 54
6 Girondins Bordeaux II Girondins 34 41 35 52
7 Romorantin Romorantin 34 49 49 49
8 Le Mans II Le Mans II 34 35 33 48
9 Luçon Luçon 34 39 37 47
10 Aurillac Arpajon Aurillac 34 48 44 44
11 Colomiers Colomiers 34 33 32 41
12 Montluçon Montluçon 34 43 54 39
13 Balma Balma 34 47 54 36
14 Albi Albi 34 27 42 36
15 Anglet Genets Anglet 34 35 53 35
16 Chatellerault Chatelleraul 34 50 66 34
17 Stade Bordelais Stade 34 27 47 32
18 Bergerac Bergerac 34 32 47 28
TEMPORADA 2007/2008
NATIONAL 2 GRUPO 4
Equipo PJ GF GC Puntos
1 Girondins Bordeaux II Girondins 34 56 28 63
2 Bayonne Bayonne 34 47 30 58
3 Fontenay Fontenay 34 40 33 54
4 Moulins Moulins 34 44 34 53
5 Orléans Orléans 34 44 35 50
6 Le Mans II Le Mans II 34 55 49 50
7 Anglet Genets Anglet 34 42 37 48
8 PSG II PSG II 34 28 26 48
9 St Geneviève Geneviève 34 43 50 46
10 Chatellerault Chatelleraul 33 43 49 45
11 Montluçon Montluçon 34 44 37 42
12 Stade Bordelais Stade 34 40 48 41
13 Yzeure Yzeure 33 35 44 41
14 Sénart Moissy Sénart 34 43 54 38
15 Aurillac Arpajon Aurillac 34 34 46 35
16 Nantes II Nantes II 34 27 41 35
17 Les Sables D`olonne Sables 34 29 45 34
18 Poissy Poissy 34 40 48 32
TEMPORADA 2006/2007
NATIONAL 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Rodez Rodez 34 47 23 66
2 Albi Albi 34 47 33 59
3 Bayonne Bayonne 34 38 30 56
4 Girondins Bordeaux II Girondins 34 40 28 54
5 Moulins Moulins 34 40 29 54
6 Orléans Orléans 34 45 35 53
7 Le Mans II Le Mans II 34 45 33 50
8 Aurillac Arpajon Aurillac 34 46 45 49
9 Anglet Genets Anglet 33 45 43 46
10 Montluçon Montluçon 34 37 33 45
11 Toulouse II Toulouse II 34 47 41 43
12 Luzenac Luzenac 34 40 43 42
13 Nantes II Nantes II 34 44 42 40
14 Stade Bordelais Stade 33 40 57 39
15 Balma Balma 34 29 49 37
16 Les Herbiers Herbiers 34 40 49 36
17 Saint-Georges Saint-George 34 22 46 32
18 Brive Brive 34 28 61 17

  USO DE MEMORIA  
7,030,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  8.0100
Total Execution Time  8.0112
  CADENA URL  
/historico/Stade-Bordelais
  GET DATOS  
$_GET['/historico/Stade-Bordelais']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
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 = 73237
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6780 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=221 AND type_rel = 3
0.3288  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 221 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.1022  SELECT /*53 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 (1115226,1099907,1026668,943823,937135) ORDER BY n.cover_points DESC, update_date DESC
0.2337  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 = '6780' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0328  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 = 73237 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.4472  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=6780 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0541  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 (73237,70208,68294) 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.3799  SELECT count(id) as num_players from rel_players WHERE league_id = 68294 AND teamId = 6780
0.4728  SELECT count(id) as num_players from rel_players WHERE league_id = 73237 AND teamId = 6780
1.1355  SELECT count(id) as num_players from rel_players WHERE league_id = 70208 AND teamId = 6780
0.1138  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 = 73237 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
1.2955  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 = 73237 WHERE rp.league_id = 73237 AND rp.teamId = 6780 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.6324  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 = 73237 WHERE rp.league_id = 73237 AND rp.teamId = 6780 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.2508  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 = 73237 WHERE rp.league_id = 73237 AND rp.teamId = 6780 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.3454  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 = 6780 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1630  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 = 73237 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.0463  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.0828  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 = 63491 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.0019  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 = 57750 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.0895  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 = 50569 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.0990  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 = 44573 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1243  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 = 34014 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0952  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.1871  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.2452  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.0915  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.1242  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 = 1688 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0801  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 = 20000 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2843  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 = 20008 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2292  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 = 19933 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1920  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 = 19941 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC