4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hawasa Ketema
TEMPORADA 2023/2024
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Ethiopia Nigd Bank Ethiopia 22 40 21 46
2 Mechal Mechal 22 28 21 41
3 Kedus St George Kedus George 22 34 19 39
4 Ethiopia Bunna Ethiopia 22 31 23 34
5 Bahardar Bahardar 21 24 18 34
6 Adama Ketema Adama Ketema 22 28 24 34
7 Fasil Kenema Fasil Kenema 22 30 22 33
8 Dire Dawa Kenema Dire Dawa K. 22 26 25 33
9 Hadiya Hosaena Hadiya 22 18 14 31
10 Hawasa Ketema Hawasa 22 30 32 29
11 Welayta Dicha Welayta 22 21 23 28
12 Sidama Bunna Sidama Bunna 22 19 21 27
13 Ethiopian Insurance Ethiopian 22 21 29 22
14 Wolkite Ketema Wolkite 21 7 24 16
15 Shashemene City Shashemene 22 14 27 13
16 Hambericho Durame Hambericho 22 10 38 8
TEMPORADA 2022/2023
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 30 54 21 64
2 Bahardar Bahardar 30 51 30 60
3 Ethiopian Insurance Ethiopian 30 50 42 49
4 Ethiopia Bunna Ethiopia 30 38 32 43
5 Fasil Kenema Fasil Kenema 30 29 24 43
6 Hadiya Hosaena Hadiya 30 29 24 43
7 Hawasa Ketema Hawasa 30 34 32 42
8 Adama Ketema Adama Ketema 30 41 36 41
9 Mechal Mechal 30 39 36 40
10 Dire Dawa Kenema Dire Dawa K. 30 42 47 40
11 Sidama Bunna Sidama Bunna 30 34 42 38
12 Welayta Dicha Welayta 30 25 27 37
13 Wolkite Ketema Wolkite 30 34 39 35
14 Arba Minch Kenema Arba Minch. 30 35 36 34
15 Legetafo Legedadi Legetafo 30 24 67 18
16 Mebrat Hayl Mebrat Hayl 30 27 51 15
TEMPORADA 2021/2022
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 30 50 11 65
2 Fasil Kenema Fasil Kenema 30 49 23 61
3 Sidama Bunna Sidama Bunna 30 40 30 48
4 Hawasa Ketema Hawasa 30 38 38 45
5 Welayta Dicha Welayta 30 23 24 42
6 Ethiopia Bunna Ethiopia 30 29 37 42
7 Arba Minch Kenema Arba Minch. 30 27 26 40
8 Wolkite Ketema Wolkite 30 33 36 38
9 Mechal Mechal 30 25 25 37
10 Hadiya Hosaena Hadiya 30 36 40 37
11 Adama Ketema Adama Ketema 30 24 23 35
12 Bahardar Bahardar 30 29 29 35
13 Dire Dawa Kenema Dire Dawa K. 30 28 40 33
14 Addis Ababa Ketema Addis Ababa 30 37 42 32
15 Sebeta City Sebeta City 30 22 46 25
16 Jimma Aba Jifar Jimma Jifar 30 23 43 23
TEMPORADA 2020/2021
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Fasil Kenema Fasil Kenema 24 38 17 54
2 Ethiopia Bunna Ethiopia 24 44 29 41
3 Kedus St George Kedus George 24 37 26 40
4 Hadiya Hosaena Hadiya 24 26 19 38
5 Sebeta City Sebeta City 24 28 26 37
6 Hawasa Ketema Hawasa 24 31 27 35
7 Bahardar Bahardar 24 27 23 33
8 Welayta Dicha Welayta 24 31 29 33
9 Sidama Bunna Sidama Bunna 24 27 31 31
10 Dire Dawa Kenema Dire Dawa K. 24 24 31 28
11 Wolkite Ketema Wolkite 24 21 29 22
12 Jimma Kenema Jimma Kenema 24 19 42 15
13 Adama Ketema Adama Ketema 24 18 42 14
TEMPORADA 2019/2020
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Fasil Kenema Fasil Kenema 17 26 13 30
2 Mekelle 70 Enderta Mekelle 17 21 15 29
3 Kedus St George Kedus George 17 22 13 28
4 Sidama Bunna Sidama Bunna 17 34 28 27
5 Bahardar Bahardar 17 23 23 27
6 Shire Endaselassie Shire 17 16 19 24
7 Hawasa Ketema Hawasa 17 20 28 23
8 Ethiopia Bunna Ethiopia 17 27 18 22
9 Adama Ketema Adama Ketema 17 18 14 22
10 Sebeta City Sebeta City 17 19 20 22
11 Welayta Dicha Welayta 17 19 20 22
12 Wolkite Ketema Wolkite 17 13 15 22
13 Dire Dawa Kenema Dire Dawa K. 17 16 26 21
14 Jimma Kenema Jimma Kenema 17 11 14 19
15 Welwalo Adigrat University Welwalo 17 19 25 18
16 Hadiya Hosaena Hadiya 17 12 25 14
TEMPORADA 2018/2019
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Mekelle 70 Enderta Mekelle 30 45 24 59
2 Sidama Bunna Sidama Bunna 30 45 29 58
3 Fasil Kenema Fasil Kenema 30 49 17 57
4 Kedus St George Kedus George 29 28 18 46
5 Jimma Kenema Jimma Kenema 30 33 36 46
6 Hawasa Ketema Hawasa 30 42 31 44
7 Welayta Dicha Welayta 30 34 27 41
8 Bahardar Bahardar 30 27 31 41
9 Ethiopia Bunna Ethiopia 30 27 23 39
10 Welwalo Adigrat University Welwalo 29 16 21 37
11 Adama Ketema Adama Ketema 30 28 28 35
12 Dire Dawa Kenema Dire Dawa K. 30 29 34 35
13 Shire Endaselassie Shire 30 29 39 34
14 Mechal Mechal 30 37 57 32
15 Debub Police Debub Police 30 34 41 29
16 Dedebit Dedebit 30 21 68 13
TEMPORADA 2017/2018
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 30 38 19 53
2 Jimma Kenema Jimma Kenema 30 34 15 53
3 Mekelle 70 Enderta Mekelle 30 26 13 52
4 Ethiopia Bunna Ethiopia 30 35 22 47
5 Adama Ketema Adama Ketema 30 32 21 45
6 Fasil Kenema Fasil Kenema 30 23 27 44
7 Sidama Bunna Sidama Bunna 30 30 31 41
8 Dedebit Dedebit 30 33 29 39
9 Hawasa Ketema Hawasa 30 27 31 37
10 Welwalo Adigrat University Welwalo 30 22 30 36
11 Mechal Mechal 30 21 24 35
12 Dire Dawa Kenema Dire Dawa K. 30 15 18 33
13 Welayta Dicha Welayta 30 22 27 33
14 Mebrat Hayl Mebrat Hayl 30 30 47 32
15 Arba Minch Kenema Arba Minch. 30 25 33 31
16 Woldya Kenema Woldya 30 14 40 22
TEMPORADA 2016/2017
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 30 49 20 62
2 Dedebit Dedebit 30 36 22 51
3 Adama Ketema Adama Ketema 30 27 17 51
4 Sidama Bunna Sidama Bunna 30 30 22 49
5 Ethiopia Bunna Ethiopia 30 36 25 48
6 Fasil Kenema Fasil Kenema 30 32 30 43
7 Woldya Kenema Woldya 30 18 20 37
8 Mechal Mechal 30 24 35 37
9 Welayta Dicha Welayta 30 24 30 36
10 Hawasa Ketema Hawasa 30 35 37 35
11 Dire Dawa Kenema Dire Dawa K. 30 21 29 35
12 Arba Minch Kenema Arba Minch. 30 25 32 34
13 Mebrat Hayl Mebrat Hayl 30 23 24 33
14 Jimma Aba Bunna Jimma Bunna 30 18 22 32
15 Ethiopia Nigd Bank Ethiopia 30 27 38 31
16 Addis Ababa Ketema Addis Ababa 30 17 39 20
TEMPORADA 2015/2016
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 26 37 12 55
2 Ethiopia Bunna Ethiopia 26 28 21 45
3 Adama Ketema Adama Ketema 26 31 21 44
4 Dedebit Dedebit 26 37 33 39
5 Sidama Bunna Sidama Bunna 26 25 23 36
6 Ethiopia Nigd Bank Ethiopia 26 19 14 35
7 Hawasa Ketema Hawasa 26 32 35 35
8 Welayta Dicha Welayta 26 18 21 35
9 Arba Minch Kenema Arba Minch. 26 25 20 33
10 Mechal Mechal 26 22 20 33
11 Dire Dawa Kenema Dire Dawa K. 26 22 31 30
12 Mebrat Hayl Mebrat Hayl 26 23 34 30
13 Dashen Birra Dashen Birra 26 22 28 28
14 Hossana Kenema Hossana 26 22 50 8
TEMPORADA 2014/2015
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 26 38 14 57
2 Dedebit Dedebit 26 43 25 44
3 Adama Ketema Adama Ketema 26 32 24 42
4 Sidama Bunna Sidama Bunna 26 28 27 40
5 Ethiopia Nigd Bank Ethiopia 26 38 30 39
6 Ethiopia Bunna Ethiopia 26 30 28 36
7 Arba Minch Kenema Arba Minch. 26 18 24 35
8 Mechal Mechal 26 21 21 34
9 Welayta Dicha Welayta 26 20 24 33
10 Hawasa Ketema Hawasa 26 29 34 33
11 Mebrat Hayl Mebrat Hayl 26 27 32 30
12 Dashen Birra Dashen Birra 26 23 29 30
13 Muger Cemento Muger 26 20 26 27
14 Woldya Kenema Woldya 26 18 47 16
TEMPORADA 2013/2014
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 26 55 14 68
2 Ethiopia Bunna Ethiopia 26 35 23 48
3 Mechal Mechal 26 28 24 42
4 Ethiopia Nigd Bank Ethiopia 26 27 25 39
5 Welayta Dicha Welayta 26 23 17 38
6 Sidama Bunna Sidama Bunna 26 23 24 38
7 Arba Minch Kenema Arba Minch. 26 19 19 35
8 Hawasa Ketema Hawasa 26 24 28 32
9 Dedebit Dedebit 26 37 31 31
10 Muger Cemento Muger 26 23 29 31
11 Dashen Birra Dashen Birra 26 11 14 30
12 Mebrat Hayl Mebrat Hayl 26 26 42 25
13 Harar Birra Harar Birra 26 16 38 19
14 Ethiopian Insurance Ethiopian 26 16 35 14
TEMPORADA 2012/2013
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Dedebit Dedebit 26 63 26 61
2 Kedus St George Kedus George 26 36 17 51
3 Ethiopia Bunna Ethiopia 26 41 23 50
4 Mechal Mechal 26 31 23 42
5 Hawasa Ketema Hawasa 26 39 33 41
6 Mebrat Hayl Mebrat Hayl 26 35 27 39
7 Arba Minch Kenema Arba Minch. 26 29 25 34
8 Ethiopian Insurance Ethiopian 26 23 25 30
9 Sidama Bunna Sidama Bunna 26 24 29 28
10 Ethiopia Nigd Bank Ethiopia 26 22 29 26
11 Harar Birra Harar Birra 26 23 36 26
12 Muger Cemento Muger 26 16 30 25
13 Weha Serawoch Weha 26 22 55 15
14 Adama Ketema Adama Ketema 26 15 41 13
TEMPORADA 2011/2012
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Kedus St George Kedus George 26 52 12 59
2 Dedebit Dedebit 26 49 22 55
3 Mebrat Hayl Mebrat Hayl 26 42 24 46
4 Muger Cemento Muger 26 28 32 35
5 Ethiopia Bunna Ethiopia 26 42 42 34
6 Ethiopia Nigd Bank Ethiopia 26 30 31 34
7 Harar Birra Harar Birra 26 22 22 33
8 Sidama Bunna Sidama Bunna 26 27 30 33
9 Mechal Mechal 26 28 30 32
10 Arba Minch Kenema Arba Minch. 26 25 35 32
11 Hawasa Ketema Hawasa 26 21 28 29
12 Adama Ketema Adama Ketema 26 21 35 29
13 Dire Dawa Kenema Dire Dawa K. 26 22 33 23
14 Ayer Hayl Ayer Hayl 26 16 49 12
TEMPORADA 2010/2011
LIGA ETIOPÍA
Equipo PJ GF GC Puntos
1 Ethiopia Bunna Ethiopia 30 52 28 61
2 Kedus St George Kedus George 30 44 16 60
3 Dedebit Dedebit 30 62 29 58
4 Sidama Bunna Sidama Bunna 30 32 16 53
5 Mechal Mechal 30 51 37 53
6 Hawasa Ketema Hawasa 30 39 36 41
7 Adama Ketema Adama Ketema 30 29 39 39
8 Harar Birra Harar Birra 30 28 26 38
9 Muger Cemento Muger 30 24 30 37
10 Mebrat Hayl Mebrat Hayl 30 35 35 36
11 Ethiopia Nigd Bank Ethiopia 30 33 39 36
12 Dire Dawa Kenema Dire Dawa K. 30 25 41 36
13 Trans Ethiopia Trans 30 29 40 35
14 Sebeta City Sebeta City 30 30 37 34
15 Lideta Nyala Lideta Nyala 30 29 55 22
16 Fincha Sekwar Fincha 30 14 52 10

  USO DE MEMORIA  
6,427,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.5579
Total Execution Time  0.5595
  CADENA URL  
/historico/Awassa-Kenema
  GET DATOS  
$_GET['/historico/Awassa-Kenema']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0256  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 = 73993
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59805 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1501 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1501 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0140  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 (1159676,1150788,421450,405601,402982) ORDER BY n.cover_points DESC, update_date DESC
0.0145  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 = '59805' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 73993 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=59805 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73993) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73993 AND teamId = 59805
0.0132  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 = 73993 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '59805' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59805' and rp.type = 4
0.0131  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 = '59805' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 73993 WHERE rp.league_id = 73993 AND rp.teamId = 59805 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.0159  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 = 73993 WHERE rp.league_id = 73993 AND rp.teamId = 59805 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 73993 WHERE rp.league_id = 73993 AND rp.teamId = 59805 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 59805 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146  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 = 73993 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 69762 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.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 `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 = 64078 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.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 = 60247 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.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 `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 = 51512 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.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 = 46945 AND t.round = 30 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 `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 = 41026 AND t.round = 30 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 = 36096 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 15877 AND t.round = 26 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 `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 = 9116 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 `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 = 16201 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 `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 = 16200 AND t.round = 26 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 `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 = 16199 AND t.round = 26 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 `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 = 16198 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73993 ORDER BY nameShow LIMIT 100