4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Violette
TEMPORADA 2023/2024
APERTURA HAITÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Club Haïtien Racing Club 5 3 7 6
2 Real Du Cap Real Du Cap 8 10 5 15
3 Capoise Capoise 7 6 5 11
4 Ouanaminthe Ouanaminthe 7 5 6 10
5 Racing des Gonaives Racing 7 8 8 9
6 FICA FICA 7 2 7 5
7 Cosmopolites Cosmopolites 8 5 4 12
8 Baltimore Baltimore 8 4 3 12
9 Triomphe Liancourt Triomphe 7 3 4 9
10 Tempête Tempête 7 3 3 8
11 Rivartibonitienne Rivartibonit 8 3 4 8
12 America des Cayes America 5 11 3 11
13 Cavaly Cavaly 5 6 7 6
14 Juventus FC Juventus FC 5 2 5 2
15 Violette Violette 0 0 0 0
TEMPORADA 2020/2021
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Don Bosco Don Bosco 8 14 5 16
2 Mirebalais Mirebalais 9 8 5 15
3 Rivartibonitienne Rivartibonit 9 8 5 15
4 Ouanaminthe Ouanaminthe 9 7 7 13
5 Arcahaie Arcahaie 6 7 1 12
6 Cavaly Cavaly 6 9 4 12
7 FICA du Cap-Haïtien FICA 9 5 4 12
8 Tempête Tempête 8 7 8 12
9 Capoise Capoise 9 6 5 11
10 Triomphe Liancourt Triomphe 8 8 6 10
11 Real Du Cap Real Du Cap 9 10 11 10
12 Violette Violette 9 7 8 10
13 Racing des Gonaives Racing 9 4 7 10
14 America des Cayes America 7 7 7 8
15 Juventus FC Juventus FC 8 5 8 8
16 Baltimore Baltimore 8 6 9 6
17 Racing Club Haïtien Racing Club 8 8 16 6
18 Cosmopolites Cosmopolites 7 3 13 4
TEMPORADA 2019/2020
APERTURA HAITÍ
Equipo PJ GF GC Puntos
1 Baltimore Baltimore 4 5 0 10
2 Cavaly Cavaly 4 7 3 10
3 Don Bosco Don Bosco 4 6 2 7
4 Capoise Capoise 4 4 2 6
5 Real Du Cap Real Du Cap 4 4 3 6
6 Triomphe Liancourt Triomphe 4 4 3 6
7 Rivartibonitienne Rivartibonit 4 2 2 6
8 FICA du Cap-Haïtien FICA 4 2 3 6
9 Juventus FC Juventus FC 4 3 3 5
10 Violette Violette 4 3 3 5
11 Arcahaie Arcahaie 4 2 3 5
12 Cosmopolites Cosmopolites 4 2 3 5
13 Mirebalais Mirebalais 4 1 2 5
14 America des Cayes America 4 3 4 4
15 Ouanaminthe Ouanaminthe 4 1 4 4
16 Racing des Gonaives Racing 4 1 5 4
17 Racing Club Haïtien Racing Club 4 1 3 3
18 Tempête Tempête 4 2 5 3
TEMPORADA 2018/2019
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Don Bosco Don Bosco 4 8 3 12
2 Cavaly Cavaly 5 9 3 10
3 Tempête Tempête 4 6 2 10
4 Violette Violette 4 4 2 9
5 Baltimore Baltimore 5 2 0 9
6 Capoise Capoise 5 4 2 8
7 Ouanaminthe Ouanaminthe 5 5 4 8
8 Triomphe Liancourt Triomphe 5 3 3 7
9 Mirebalais Mirebalais 5 3 1 6
10 America des Cayes America 5 8 11 6
11 FICA du Cap-Haïtien FICA 5 4 5 5
12 Arcahaie Arcahaie 5 1 3 4
13 Racing des Gonaives Racing 5 3 9 4
14 Cosmopolites Cosmopolites 5 3 7 3
15 Real Du Cap Real Du Cap 5 1 4 2
16 Racing Club Haïtien Racing Club 4 1 6 0
TEMPORADA 2015/2016
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 FICA du Cap-Haïtien FICA 17 20 8 29
2 Ouanaminthe Ouanaminthe 16 19 9 29
3 Capoise Capoise 17 10 10 27
4 Real Du Cap Real Du Cap 16 20 14 24
5 America des Cayes America 15 12 6 22
6 Violette Violette 17 14 12 21
7 Petit Goave Petit Goave 16 10 14 21
8 Aigle Noir Aigle Noir 16 11 9 20
9 Mirebalais Mirebalais 16 11 10 20
10 Racing des Gonaives Racing 16 9 11 20
11 Cavaly Cavaly 16 14 16 19
12 Don Bosco Don Bosco 15 9 11 19
13 Baltimore Baltimore 16 9 10 18
14 Inter de Grand-Goâve Inter 13 9 13 18
15 Racing Club Haïtien Racing Club 16 15 17 17
16 Juventus FC Juventus FC 15 23 26 16
17 Tempête Tempête 16 8 17 16
18 Roulado Roulado 15 7 17 14
TEMPORADA 2014/2015
APERTURA HAITÍ
Equipo PJ GF GC Puntos
1 Don Bosco Don Bosco 19 29 15 38
2 Racing Club Haïtien Racing Club 19 24 10 37
3 America des Cayes America 19 24 13 35
4 Capoise Capoise 19 20 7 34
5 Aigle Noir Aigle Noir 19 25 13 33
6 FICA du Cap-Haïtien FICA 19 21 13 32
7 Baltimore Baltimore 19 14 13 29
8 Cavaly Cavaly 19 26 16 28
9 Mirebalais Mirebalais 19 20 23 28
10 Inter de Grand-Goâve Inter 19 17 21 28
11 Tempête Tempête 19 19 20 26
12 Petit Goave Petit Goave 19 13 15 26
13 Racing des Gonaives Racing 19 13 16 25
14 Ouanaminthe Ouanaminthe 19 21 26 22
15 Violette Violette 19 13 19 20
16 US LaJeune US LaJeune 19 12 18 20
17 Valencia de Leogane Valencia 19 15 23 20
18 Roulado Roulado 19 14 23 20
19 PNH FC PNH FC 19 14 29 11
20 Racine Racine 19 9 30 10
TEMPORADA 2013/2014
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Don Bosco Don Bosco 10 17 5 21
2 Tempête Tempête 10 11 6 19
3 Mirebalais Mirebalais 10 15 8 18
4 Racing des Gonaives Racing 10 11 8 16
5 Petit Goave Petit Goave 10 11 12 16
6 America des Cayes America 10 15 8 15
7 Cavaly Cavaly 10 12 9 15
8 Baltimore Baltimore 10 8 15 9
9 Racine Racine 10 7 16 9
10 Aigle Noir Aigle Noir 10 6 13 7
11 Violette Violette 10 2 15 5
TEMPORADA 2011/2012
LIGA HAITÍ GRUPO 3
Equipo PJ GF GC Puntos
1 Don Bosco Don Bosco 10 11 4 18
2 Cavaly Cavaly 10 8 5 18
3 Victory Victory 10 13 8 15
4 Mirebalais Mirebalais 10 9 9 11
5 Capoise Capoise 10 6 14 11
6 Violette Violette 10 7 14 9
TEMPORADA 2009/2010
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 America des Cayes America 15 22 10 27
2 Victory Victory 15 22 13 27
3 Carrefour Carrefour 15 17 12 25
4 Baltimore Baltimore 15 14 9 24
5 Saint-Louis Saint-Louis 15 14 13 23
6 Cavaly Cavaly 15 11 5 22
7 Tempête Tempête 15 16 13 22
8 Mirebalais Mirebalais 15 13 11 21
9 Don Bosco Don Bosco 15 17 10 20
10 Racing des Gonaives Racing 15 12 15 20
11 Capoise Capoise 15 13 17 20
12 Violette Violette 15 17 19 18
13 Eclair des Gonaïves Eclair 15 12 18 16
14 Aigle Noir Aigle Noir 15 7 17 16
15 Racing Club Haïtien Racing Club 15 15 19 15
16 Dynamite Dynamite 15 9 30 5
TEMPORADA 2008/2009
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Racing Club Haïtien Racing Club 15 19 9 28
2 Cavaly Cavaly 15 16 7 28
3 Violette Violette 15 18 10 26
4 Don Bosco Don Bosco 15 15 5 24
5 Mirebalais Mirebalais 15 16 7 24
6 Baltimore Baltimore 15 13 4 24
7 Saint-Louis Saint-Louis 15 15 8 24
8 Racing des Gonaives Racing 15 11 16 21
9 Tempête Tempête 15 14 10 20
10 Carrefour Carrefour 15 9 12 20
11 Capoise Capoise 15 15 11 18
12 Victory Victory 15 11 13 18
13 Dynamite Dynamite 15 10 14 16
14 Aigle Noir Aigle Noir 15 10 15 16
15 JS Capoise JS Capoise 15 9 32 12
16 ASPDIF ASPDIF 15 4 32 4
TEMPORADA 2007/2008
CLAUSURA HAITÍ
Equipo PJ GF GC Puntos
1 Baltimore Baltimore 13 13 5 26
2 Racing des Gonaives Racing 12 14 7 26
3 Aigle Noir Aigle Noir 13 12 11 21
4 Carrefour Carrefour 13 16 16 21
5 Violette Violette 12 14 9 20
6 Cavaly Cavaly 13 15 8 17
7 Victory Victory 13 10 10 17
8 Capoise Capoise 12 8 7 16
9 Mirebalais Mirebalais 13 11 9 14
10 Don Bosco Don Bosco 12 9 9 14
11 JS Capoise JS Capoise 13 15 19 14
12 Tempête Tempête 12 13 18 11
13 Valencia de Leogane Valencia 12 6 15 8
14 Zenith Zenith 13 6 19 7

  USO DE MEMORIA  
5,922,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1476
Total Execution Time  0.1497
  CADENA URL  
/historico/Violette
  GET DATOS  
$_GET['/historico/Violette']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57452 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1716 AND type_rel = 3
0.0023  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 = '57452' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=57452 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75610,70474) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75610 AND teamId = 57452
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 70474 AND teamId = 57452
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 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 = 75610 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0077  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 = '57452' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '57452' and rp.type = 4
0.0020  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 = '57452' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 57452 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.0020  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 = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 57452 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 57452 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 57452 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75610 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 58381 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.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 = 61996 AND t.round = 9 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 `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 = 55535 AND t.round = 4 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 `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 = 49082 AND t.round = 15 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 `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 = 50627 AND t.round = 15 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 `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 = 22213 AND t.round = 17 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 = 36098 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 15713 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 10892 AND t.round = 19 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 = 10889 AND t.round = 11 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 `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 = 10891 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 49085 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 49087 AND t.round = 3 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 = 49095 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 49100 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0068  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 = 49096 AND t.round = 12 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 = 49101 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 49097 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 49102 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC