4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Djoliba AC
TEMPORADA 2023/2024
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 Djoliba AC Djoliba AC 25 35 13 54
2 Stade Malien Stade Malien 24 36 17 45
3 Real Bamako Real Bamako 25 31 18 44
4 Bakaridjan Bakaridjan 25 35 22 40
5 US Bougouba US Bougouba 24 22 17 37
6 Binga Binga 25 21 22 35
7 AS Korofina AS Korofina 25 20 18 34
8 USFAS Bamako USFAS Bamako 25 22 21 34
9 Afrique Football Élite Afrique 25 21 22 32
10 Bougouni Bougouni 25 21 24 31
11 Onze Créateurs Onze 25 22 26 31
12 CO Bamako CO Bamako 25 23 35 28
13 Police de Bamako Police 25 16 27 27
14 ATS Koro ATS Koro 25 21 33 23
15 USC Kita USC Kita 25 18 30 20
16 AS Black Stars Black Stars 25 19 38 18
TEMPORADA 2022/2023
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 Real Bamako Real Bamako 30 45 17 62
2 Djoliba AC Djoliba AC 30 39 12 59
3 USFAS Bamako USFAS Bamako 30 32 22 49
4 Bakaridjan Bakaridjan 30 29 23 47
5 Onze Créateurs Onze 30 34 28 45
6 Afrique Football Élite Afrique 30 30 21 44
7 Binga Binga 30 24 19 43
8 Bougouni Bougouni 30 39 35 43
9 Stade Malien Stade Malien 30 21 16 41
10 AS Korofina AS Korofina 30 25 26 38
11 Police de Bamako Police 30 23 29 37
12 USC Kita USC Kita 30 23 28 33
13 AS Black Stars Black Stars 30 30 38 31
14 CO Bamako CO Bamako 30 22 43 30
15 LC Bamako LC Bamako 30 17 36 22
16 Yeelen Olympique Yeelen 30 21 61 12
TEMPORADA 2021/2022
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 Djoliba AC Djoliba AC 34 44 20 62
2 Bakaridjan Bakaridjan 34 39 29 54
3 USC Kita USC Kita 34 34 28 54
4 Stade Malien Stade Malien 34 38 25 53
5 Real Bamako Real Bamako 34 25 16 48
6 AS Korofina AS Korofina 34 32 28 48
7 Afrique Football Élite Afrique 34 29 27 48
8 Onze Créateurs Onze 34 32 23 46
9 CO Bamako CO Bamako 34 27 25 46
10 USFAS Bamako USFAS Bamako 34 26 30 46
11 Police de Bamako Police 34 29 30 45
12 Yeelen Olympique Yeelen 34 31 29 44
13 LC Bamako LC Bamako 34 33 35 44
14 AS Black Stars Black Stars 34 24 29 44
15 Duguwolofila Duguwolofila 34 33 39 42
16 US Bougouba US Bougouba 34 38 46 37
17 ASOM ASOM 34 17 44 23
18 AS Douannes AS Douannes 34 16 44 21
TEMPORADA 2020/2021
CHAMPIONNAT NATIONAL MALÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Stade Malien Stade Malien 6 8 2 12
2 Onze Créateurs Onze 6 7 7 8
3 Djoliba AC Djoliba AC 6 3 4 6
4 Real Bamako Real Bamako 6 2 7 5
TEMPORADA 2018/2019
CHAMPIONNAT NATIONAL MALÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Djoliba AC Djoliba AC 22 37 12 51
2 Real Bamako Real Bamako 22 42 19 40
3 Police de Bamako Police 22 25 15 37
4 Duguwolofila Duguwolofila 22 26 16 35
5 LC Bamako LC Bamako 22 28 29 34
6 Bakaridjan Bakaridjan 22 20 16 32
7 AS Nianan AS Nianan 22 23 34 28
8 Soni Soni 22 19 25 26
9 As Bamako As Bamako 22 19 17 24
10 Avenir de Tombouctou Avenir 22 13 37 19
11 Performance Performance 22 19 34 16
12 Mamahira Kati Mamahira 22 13 30 15
13 Stade Malien Stade Malien 20 37 7 54
14 Yeelen Olympique Yeelen 20 39 22 39
15 CO Bamako CO Bamako 20 27 15 36
16 Onze Créateurs Onze 20 16 9 36
17 USC Kita USC Kita 20 17 12 34
18 USFAS Bamako USFAS Bamako 20 21 22 24
19 AS Black Stars Black Stars 20 24 30 24
20 ASOM ASOM 20 16 27 21
21 CSK CSK 20 21 23 17
22 Bougouni Bougouni 20 11 36 11
23 Sabana Mopti Sabana Mopti 20 15 41 11
TEMPORADA 2016/2017
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 Stade Malien Stade Malien 21 47 5 55
2 USC Kita USC Kita 21 24 16 41
3 Djoliba AC Djoliba AC 20 29 8 40
4 CO Bamako CO Bamako 20 24 14 36
5 LC Bamako LC Bamako 21 38 19 35
6 Onze Créateurs Onze 21 26 17 33
7 ASOM ASOM 21 22 25 31
8 Bakaridjan Bakaridjan 20 24 18 29
9 Real Bamako Real Bamako 21 21 17 29
10 USFAS Bamako USFAS Bamako 21 18 19 26
11 AS Black Stars Black Stars 21 24 29 26
12 As Bamako As Bamako 20 14 18 24
13 Bougouni Bougouni 21 17 31 23
14 Mamahira Kati Mamahira 21 20 33 20
15 CSK CSK 20 20 32 19
16 Duguwolofila Duguwolofila 20 13 25 17
17 AS Nianan AS Nianan 20 19 37 17
18 Soni Soni 20 11 48 9
TEMPORADA 2015/2016
CHAMPIONNAT NATIONAL MALÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Stade Malien Stade Malien 6 6 1 14
2 Real Bamako Real Bamako 6 3 4 7
3 Djoliba AC Djoliba AC 6 3 4 6
4 Onze Créateurs Onze 6 2 5 5
TEMPORADA 2014/2015
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 Stade Malien Stade Malien 22 37 12 50
2 Onze Créateurs Onze 22 32 17 41
3 USFAS Bamako USFAS Bamako 22 32 20 41
4 Real Bamako Real Bamako 22 28 15 36
5 Bakaridjan Bakaridjan 22 26 17 36
6 Duguwolofila Duguwolofila 22 21 21 32
7 Police de Bamako Police 22 23 24 27
8 AS Nianan AS Nianan 22 22 27 27
9 Mamahira Kati Mamahira 22 20 32 22
10 ASOM ASOM 22 13 29 18
11 As Bamako As Bamako 22 13 26 15
12 Sabana Mopti Sabana Mopti 22 14 41 13
13 Avenir de Tombouctou Avenir 0 0 0 0
14 CO Bamako CO Bamako 0 0 0 0
15 CSK CSK 0 0 0 0
16 Djoliba AC Djoliba AC 0 0 0 0
TEMPORADA 2013/2014
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 CSK Bamako CSK Bamako 60 51 48 79
2 Stade Malien Stade Malien 30 42 9 67
3 CO Bamako CO Bamako 30 46 19 62
4 Real Bamako Real Bamako 30 55 20 58
5 Duguwolofila Duguwolofila 30 41 23 51
6 Djoliba AC Djoliba AC 30 22 19 49
7 Bakaridjan Bakaridjan 30 31 25 48
8 Onze Créateurs Onze 30 32 25 43
9 USFAS Bamako USFAS Bamako 30 30 26 42
10 Police de Bamako Police 30 27 32 38
11 ASOM ASOM 30 20 39 31
12 AS Nianan AS Nianan 30 16 33 28
13 Office du Niger Sports Office Niger 30 20 46 21
14 Debo Debo 30 21 51 19
15 Elwidj Elwidj 30 24 63 11
TEMPORADA 2012/2013
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 Stade Malien Stade Malien 30 56 14 79
2 Real Bamako Real Bamako 30 51 28 59
3 Djoliba AC Djoliba AC 30 47 19 55
4 CO Bamako CO Bamako 30 37 23 55
5 Onze Créateurs Onze 30 40 28 46
6 AS Nianan AS Nianan 30 33 32 43
7 Bakaridjan Bakaridjan 30 23 22 41
8 Duguwolofila Duguwolofila 30 20 30 38
9 CSK CSK 30 26 29 37
10 ASOM ASOM 30 30 37 36
11 Office du Niger Sports Office Niger 30 23 39 34
12 CSK Bamako CSK Bamako 30 36 36 33
13 USFAS Bamako USFAS Bamako 30 27 33 33
14 AS Korofina AS Korofina 30 32 36 32
15 Jeanne d´Arc FC Jeanne 30 21 41 30
16 Atar Club Atar Club 30 14 69 10
TEMPORADA 2011/2012
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 Djoliba AC Djoliba AC 30 46 9 74
2 CSK Bamako CSK Bamako 60 52 81 73
3 Stade Malien Stade Malien 30 74 23 66
4 Bakaridjan Bakaridjan 30 31 20 52
5 Duguwolofila Duguwolofila 30 38 32 47
6 AS Korofina AS Korofina 30 35 28 46
7 Jeanne d´Arc FC Jeanne 30 32 29 46
8 CO Bamako CO Bamako 30 36 26 45
9 ASOM ASOM 30 36 36 42
10 Real Bamako Real Bamako 30 33 28 39
11 Onze Créateurs Onze 30 38 43 33
12 AS Nianan AS Nianan 30 30 44 31
13 Sigui Sigui 30 18 46 26
14 Stade Malien Sikasso Stade Malien 30 19 47 24
15 Police de Bamako Police 30 29 55 19
TEMPORADA 2010/2011
CHAMPIONNAT NATIONAL MALÍ
Equipo PJ GF GC Puntos
1 CSK Bamako CSK Bamako 52 56 78 62
2 Stade Malien Stade Malien 26 46 12 59
3 Djoliba AC Djoliba AC 26 37 19 49
4 Real Bamako Real Bamako 26 35 20 45
5 AS Korofina AS Korofina 26 24 21 41
6 CO Bamako CO Bamako 26 29 23 38
7 Jeanne d´Arc FC Jeanne 26 32 32 36
8 Duguwolofila Duguwolofila 26 31 31 36
9 Onze Créateurs Onze 26 40 39 32
10 Bakaridjan Bakaridjan 26 28 35 31
11 Police de Bamako Police 26 34 35 30
12 USFAS Bamako USFAS Bamako 26 34 44 26
13 CASS CASS 26 13 50 11

  USO DE MEMORIA  
6,066,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6955
Total Execution Time  0.6967
  CADENA URL  
/historico/Djoliba-Ac
  GET DATOS  
$_GET['/historico/Djoliba-Ac']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0200  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 = 'Djoliba-Ac' 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.0150  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=15829 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=15829 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0311  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 = 74322
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15829 AND type_rel = 2
0.0177  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 = '15829' ORDER BY l.year DESC,cat.coefficient DESC
0.0175  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 = '15829' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0175  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 = '15829' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 74322 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0167  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=15829 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (74322,70140,69490) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 74322 AND teamId = 15829
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 69490 AND teamId = 15829
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 70140 AND teamId = 15829
0.0153  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 = 74322 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0152  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 = '15829' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0151  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15829' and rp.type = 4
0.0146  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 = '15829' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0151  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 = 74322 WHERE rp.league_id = 74322 AND rp.teamId = 15829 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.0148  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 = 74322 WHERE rp.league_id = 74322 AND rp.teamId = 15829 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 74322 WHERE rp.league_id = 74322 AND rp.teamId = 15829 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 15829 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 74322 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 70230 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.0160  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 = 65880 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.0164  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 = 61642 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.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 `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 = 63167 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 51118 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 37891 AND t.round = 22 ORDER BY team.conference 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 `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 = 15836 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 37767 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 8448 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 16258 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 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 = 3242 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 16259 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 16260 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC