4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Matoury
TEMPORADA 2023/2024
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Etoile Matoury Etoile 20 71 14 54
2 Le Geldar Le Geldar 18 48 18 39
3 SC Kourou SC Kourou 18 36 14 39
4 Matoury Matoury 20 26 12 39
5 Remire Remire 19 37 29 34
6 Grand Santi Grand Santi 18 40 18 33
7 Saint-Georges Saint-George 20 38 32 25
8 USC Montsinéry Montsinéry 19 29 35 25
9 Loyola Loyola 20 24 35 22
10 CSC Cayenne CSC Cayenne 19 20 34 21
11 ASC Karib ASC Karib 20 19 45 18
12 Olympique Cayenne Olympique 20 23 43 17
13 ASL Sport Guyanais Sport 20 17 64 12
14 Balata-Abriba Balata-Abrib 19 13 48 4
TEMPORADA 2022/2023
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Le Geldar Le Geldar 16 50 22 38
2 USC Montsinéry Montsinéry 16 27 14 28
3 Grand Santi Grand Santi 16 31 11 36
4 ASC Karib ASC Karib 16 27 20 31
5 Sinnamary Sinnamary 16 34 28 23
6 Remire Remire 16 26 34 16
7 Olympique Cayenne Olympique 16 22 36 16
8 Charvein Charvein 16 17 41 12
9 Dynamo de Soula Dynamo Soula 16 13 41 5
10 Etoile Matoury Etoile 18 52 12 50
11 SC Kourou SC Kourou 18 28 21 34
12 CSC Cayenne CSC Cayenne 18 48 26 33
13 Agouado Agouado 18 37 37 28
14 Loyola Loyola 18 37 22 27
15 ASC Ouest ASC Ouest 18 33 29 22
16 Saint-Georges Saint-George 17 28 28 22
17 Matoury Matoury 17 25 25 22
18 EF Iracoubo EF Iracoubo 18 22 62 10
19 Montjoly Montjoly 18 18 66 3
TEMPORADA 2021/2022
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Etoile Matoury Etoile 10 25 8 26
2 Le Geldar Le Geldar 10 41 14 25
3 Matoury Matoury 10 22 16 24
4 ASC Karib ASC Karib 9 19 10 21
5 Remire Remire 10 21 15 17
6 Grand Santi Grand Santi 10 25 15 14
7 Oyapock Oyapock 10 26 19 13
8 Agouado Agouado 6 16 9 13
9 CSC Cayenne CSC Cayenne 10 17 13 13
10 Sinnamary Sinnamary 11 13 17 13
11 Olympique Cayenne Olympique 10 9 14 12
12 ASC Ouest ASC Ouest 10 15 29 10
13 SC Kourou SC Kourou 11 19 20 9
14 USC Montsinéry Montsinéry 9 10 13 8
15 Saint-Georges Saint-George 8 9 19 8
16 Loyola Loyola 10 10 34 2
17 EF Iracoubo EF Iracoubo 10 9 41 1
TEMPORADA 2020/2021
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Loyola Loyola 2 6 2 6
2 Olympique Cayenne Olympique 4 7 8 6
3 Etoile Matoury Etoile 2 7 4 4
4 Agouado Agouado 3 9 12 4
5 Sinnamary Sinnamary 2 5 3 3
6 Saint-Georges Saint-George 2 4 4 3
7 Oyapock Oyapock 1 1 3 0
8 SC Kourou SC Kourou 2 5 8 0
9 Le Geldar Le Geldar 2 4 0 6
10 CSC Cayenne CSC Cayenne 3 3 4 4
11 Matoury Matoury 2 6 1 3
12 Grand Santi Grand Santi 1 1 0 3
13 ASC Ouest ASC Ouest 2 3 3 3
14 Remire Remire 1 1 1 1
15 Arc en Ciel Arc en Ciel 3 2 11 0
TEMPORADA 2019/2020
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Olympique Cayenne Olympique 15 36 15 36
2 Le Geldar Le Geldar 15 32 14 30
3 Matoury Matoury 15 22 13 27
4 Oyapock Oyapock 15 29 20 25
5 Grand Santi Grand Santi 15 21 18 24
6 Etoile Matoury Etoile 15 36 23 23
7 Agouado Agouado 14 27 22 23
8 CSC Cayenne CSC Cayenne 15 19 28 19
9 Remire Remire 15 15 21 13
10 SC Kourou SC Kourou 15 18 39 13
11 Saint-Georges Saint-George 14 23 39 10
12 Kourou FC Kourou FC 15 13 39 5
TEMPORADA 2018/2019
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Agouado Agouado 22 51 25 51
2 Le Geldar Le Geldar 22 53 22 47
3 Etoile Matoury Etoile 22 43 19 43
4 Matoury Matoury 22 46 28 43
5 CSC Cayenne CSC Cayenne 22 44 48 27
6 Oyapock Oyapock 22 34 41 27
7 Remire Remire 22 28 37 25
8 Kourou FC Kourou FC 22 29 42 25
9 Grand Santi Grand Santi 21 20 27 23
10 Saint-Georges Saint-George 21 31 49 22
11 Sinnamary Sinnamary 22 26 38 17
12 ASC Ouest ASC Ouest 22 15 44 10
TEMPORADA 2017/2018
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Le Geldar Le Geldar 24 61 24 56
2 Etoile Matoury Etoile 24 49 24 55
3 Matoury Matoury 24 40 19 46
4 Grand Santi Grand Santi 24 42 31 40
5 Sinnamary Sinnamary 24 40 33 37
6 Agouado Agouado 24 51 44 35
7 Saint-Georges Saint-George 24 41 42 32
8 CSC Cayenne CSC Cayenne 24 27 35 30
9 Kourou FC Kourou FC 24 29 38 29
10 Remire Remire 24 45 39 27
11 Olympique Cayenne Olympique 24 24 43 23
12 EF Iracoubo EF Iracoubo 24 15 60 15
13 SC Kourou SC Kourou 24 18 50 11
TEMPORADA 2016/2017
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Matoury Matoury 22 67 21 51
2 Remire Remire 22 48 31 45
3 Le Geldar Le Geldar 22 52 21 40
4 CSC Cayenne CSC Cayenne 23 44 42 40
5 Agouado Agouado 22 49 35 37
6 Etoile Matoury Etoile 23 39 26 36
7 Kourou FC Kourou FC 22 43 32 34
8 Grand Santi Grand Santi 22 32 29 33
9 SC Kourou SC Kourou 22 37 54 21
10 Olympique Cayenne Olympique 22 30 68 14
11 Macouria Macouria 22 23 78 14
12 Cosma Cosma 22 15 42 8
TEMPORADA 2015/2016
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Matoury Matoury 22 46 17 53
2 Le Geldar Le Geldar 22 43 24 44
3 CSC Cayenne CSC Cayenne 22 35 27 39
4 Agouado Agouado 22 45 40 38
5 Etoile Matoury Etoile 22 36 34 32
6 Macouria Macouria 22 39 36 27
7 Grand Santi Grand Santi 22 31 37 27
8 Remire Remire 22 36 38 26
9 SC Kourou SC Kourou 22 28 29 25
10 EF Iracoubo EF Iracoubo 22 32 45 23
11 Montjoly Montjoly 22 23 53 17
12 Cosma Cosma 22 24 38 16
TEMPORADA 2014/2015
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 CSC Cayenne CSC Cayenne 23 40 15 53
2 Matoury Matoury 22 41 19 47
3 Le Geldar Le Geldar 22 38 23 38
4 Kourou FC Kourou FC 22 27 25 31
5 SC Kourou SC Kourou 22 34 35 29
6 Remire Remire 22 34 36 28
7 EF Iracoubo EF Iracoubo 22 25 29 28
8 Cosma Cosma 21 24 26 26
9 Grand Santi Grand Santi 22 26 32 26
10 Macouria Macouria 21 25 32 23
11 Montjoly Montjoly 22 33 52 18
12 Sinnamary Sinnamary 21 15 38 17
TEMPORADA 2013/2014
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Matoury Matoury 22 37 12 47
2 Le Geldar Le Geldar 22 39 15 43
3 Grand Santi Grand Santi 22 38 23 37
4 Agouado Agouado 22 25 32 36
5 CSC Cayenne CSC Cayenne 22 24 22 32
6 Macouria Macouria 22 32 27 30
7 Montjoly Montjoly 22 35 42 29
8 Sinnamary Sinnamary 22 27 34 24
9 Cosma Cosma 22 21 28 24
10 EF Iracoubo EF Iracoubo 22 21 39 22
11 Saint-Georges Saint-George 22 30 40 21
12 Javouhey Mana Javouhey 22 17 32 16
TEMPORADA 2012/2013
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Le Geldar Le Geldar 22 45 13 52
2 Matoury Matoury 22 41 15 48
3 CSC Cayenne CSC Cayenne 22 35 22 44
4 Agouado Agouado 22 31 29 31
5 Saint-Georges Saint-George 22 30 31 30
6 Sinnamary Sinnamary 22 23 25 27
7 Macouria Macouria 22 23 27 27
8 Javouhey Mana Javouhey 22 23 28 25
9 EF Iracoubo EF Iracoubo 22 23 34 22
10 Black Stars Black Stars 22 21 26 19
11 Remire Remire 22 17 28 19
12 Olympique Cayenne Olympique 22 16 50 13
TEMPORADA 2011/2012
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Matoury Matoury 22 43 15 51
2 Le Geldar Le Geldar 22 42 13 49
3 CSC Cayenne CSC Cayenne 22 35 24 35
4 Black Stars Black Stars 22 23 24 32
5 Agouado Agouado 22 26 26 29
6 EF Iracoubo EF Iracoubo 22 25 27 29
7 Javouhey Mana Javouhey 22 20 22 29
8 Saint-Georges Saint-George 22 32 44 29
9 Macouria Macouria 22 25 27 23
10 Remire Remire 22 28 34 23
11 Oyapock Oyapock 22 16 38 18
12 Olympique Cayenne Olympique 22 22 43 15
TEMPORADA 2010/2011
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Matoury Matoury 22 60 17 52
2 Le Geldar Le Geldar 22 36 13 46
3 CSC Cayenne CSC Cayenne 22 40 26 38
4 Macouria Macouria 22 24 21 35
5 Sinnamary Sinnamary 22 32 30 33
6 Black Stars Black Stars 22 27 22 32
7 Saint-Georges Saint-George 22 32 29 32
8 Agouado Agouado 22 40 42 25
9 Remire Remire 22 25 36 21
10 EF Iracoubo EF Iracoubo 22 30 45 21
11 Olympique Cayenne Olympique 22 20 42 20
12 Balata-Abriba Balata-Abrib 22 14 57 8

  USO DE MEMORIA  
6,202,104 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5487
Total Execution Time  0.5498
  CADENA URL  
/historico/Matoury
  GET DATOS  
$_GET['/historico/Matoury']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0135  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 = 'Matoury' 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.0125  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=51800 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=51800 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=51800 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 73191
0.0132  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 = 75314
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=51800 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1503 AND type_rel = 3
0.0134  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 = '51800' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '51800' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 73191 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=51800 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (75314,73191) 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.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 73191 AND teamId = 51800
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 75314 AND teamId = 51800
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 = 73191 WHERE rp.league_id = 73191 AND rp.teamId = 51800 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.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 = 73191 WHERE rp.league_id = 73191 AND rp.teamId = 51800 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 = 73191 WHERE rp.league_id = 73191 AND rp.teamId = 51800 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 51800 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73191 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.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 `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 = 69433 AND t.round = 18 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 `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 = 65849 AND t.round = 18 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 `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 = 60344 AND t.round = 14 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 `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 = 51108 AND t.round = 15 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 `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 = 49110 AND t.round = 22 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 = 49111 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 `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 = 37042 AND t.round = 22 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 `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 = 15965 AND t.round = 22 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 `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 = 9122 AND t.round = 22 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 `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 = 49112 AND t.round = 22 ORDER BY team.conference 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 `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 = 49113 AND t.round = 22 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 = 49114 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 49115 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC