4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Digenis Ypsonas

Digenis Ypsonas

Entrenador: Liasos Louka

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA CHIPRE GRUPO 2
Equipo PJ GF GC Puntos
1 Omonia Aradippou Omonia 14 26 9 32
2 Omonia 29is Omonia 29is 14 28 10 30
3 Olympiakos Nicosia Olympiakos 14 23 11 24
4 Enosis Neon Paralimni Enosis Neon 14 22 22 21
5 ASIL Lysi ASIL Lysi 14 20 22 20
6 Digenis Ypsonas Digenis 14 19 25 17
7 Ayia Napa Ayia Napa 14 18 33 9
8 Peyia Peyia 14 9 33 5
TEMPORADA 2022/2023
SEGUNDA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 Xylotympou Xylotympou 12 23 11 21
2 Ermis Aradippou Ermis 13 18 14 20
3 Anagennisi Anagennisi 12 19 22 20
4 Digenis Ypsonas Digenis 13 33 20 19
5 PAEEK PAEEK 12 19 14 17
6 Ayia Napa Ayia Napa 12 12 15 17
7 Olympiada Lympion Olympiada 12 13 32 7
8 Alki Oroklini Alki 2 1 10 0
TEMPORADA 2021/2022
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Peyia Peyia 26 42 12 57
2 MEAP Nisou MEAP Nisou 26 41 23 49
3 Digenis Ypsonas Digenis 26 41 26 48
4 AE Zakakiou AE Zakakiou 26 44 26 47
5 Digenis Morphou Digenis 26 45 25 43
6 Elia Lythrodonta Elia 26 35 36 35
7 Iraklis Yerolakkou Iraklis 26 35 40 32
8 Kouris Erimi Kouris Erimi 26 29 36 29
9 EN THOI Lakatamia THOI 26 32 35 29
10 APEP APEP 26 32 40 29
11 Ethnikos Assias Ethnikos 26 26 43 28
12 Ormideia Ormideia 26 27 42 28
13 Halkanoras Halkanoras 26 28 44 25
14 Omonia Psevda Omonia 26 33 62 21
TEMPORADA 2020/2021
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Aris Limassol Aris 34 50 22 70
2 PAEEK PAEEK 34 68 28 70
3 Othellos Athienou Othellos 34 55 32 69
4 Ayia Napa Ayia Napa 34 51 36 60
5 Alki Oroklini Alki 34 56 38 53
6 Onisilos Onisilos 34 61 51 51
7 Omonia Aradippou Omonia 34 55 49 51
8 ASIL Lysi ASIL Lysi 34 34 34 46
9 Ahironas Ahironas 34 43 43 45
10 Anagennisi Anagennisi 34 50 50 44
11 Akritas Chlorakas Akritas 34 41 47 43
12 Xylotympou Xylotympou 34 42 45 41
13 Kouris Erimi Kouris Erimi 34 50 56 39
14 Digenis Morphou Digenis 34 43 53 37
15 Omonia Psevda Omonia 34 44 62 34
16 AE Zakakiou AE Zakakiou 34 32 51 34
17 EN THOI Lakatamia THOI 34 35 68 20
18 Digenis Ypsonas Digenis 34 32 77 19
TEMPORADA 2019/2020
SEGUNDA CHIPRE GRUPO 4
Equipo PJ GF GC Puntos
1 Alki Oroklini Alki 6 12 5 12
2 AE Zakakiou AE Zakakiou 6 5 1 12
3 Omonia Aradippou Omonia 6 9 6 11
4 Xylotympou Xylotympou 6 8 6 11
5 Digenis Morphou Digenis 6 6 7 9
6 Akritas Chlorakas Akritas 6 6 7 7
7 Digenis Ypsonas Digenis 6 5 11 5
8 Omonia Psevda Omonia 6 6 14 0
TEMPORADA 2018/2019
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Digenis Morphou Digenis 30 62 26 62
2 Omonia Psevda Omonia 30 50 35 58
3 Digenis Ypsonas Digenis 30 52 27 53
4 Xylotympou Xylotympou 30 39 25 52
5 ENAD ENAD 30 45 35 47
6 Halkanoras Halkanoras 30 52 50 43
7 Ethnikos Assias Ethnikos 30 44 44 43
8 Kouris Erimi Kouris Erimi 30 39 39 42
9 Ormideia Ormideia 30 44 39 41
10 Ahironas Ahironas 30 42 42 40
11 Elpida Astromeritis Elpida 30 38 49 39
12 Amathous Amathous 30 37 42 38
13 APEA APEA 30 43 50 38
14 Olympiada Lympion Olympiada 30 43 53 33
15 Ethnikos Latsion Ethnikos 30 30 52 25
16 Peyia Peyia 30 25 77 9
TEMPORADA 2017/2018
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Onisilos Onisilos 30 60 22 68
2 MEAP Nisou MEAP Nisou 30 67 31 63
3 Akritas Chlorakas Akritas 30 44 22 58
4 Digenis Ypsonas Digenis 30 61 45 48
5 ENAD ENAD 30 47 35 47
6 Elpida Astromeritis Elpida 30 44 36 46
7 Peyia Peyia 30 41 48 45
8 APEA APEA 30 35 39 41
9 Ahironas Ahironas 30 41 47 38
10 Ormideia Ormideia 30 33 35 38
11 Ethnikos Latsion Ethnikos 30 45 55 37
12 Digenis Morphou Digenis 30 45 47 36
13 Olympiada Lympion Olympiada 30 45 60 35
14 APEP APEP 30 36 46 32
15 Foinikas Agia Marina Foinikas 30 23 51 20
16 Leivadiakós Leivadiakós 30 35 83 15
TEMPORADA 2016/2017
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Xylotympou Xylotympou 30 54 22 70
2 Digenis Voroklinis Digenis 30 57 35 57
3 Halkanoras Halkanoras 30 52 39 56
4 Ethnikos Latsion Ethnikos 30 59 25 54
5 Olympiada Lympion Olympiada 30 41 45 46
6 Digenis Ypsonas Digenis 30 42 45 43
7 Digenis Morphou Digenis 30 48 48 42
8 Ahironas Ahironas 30 38 38 39
9 Peyia Peyia 30 41 38 38
10 MEAP Nisou MEAP Nisou 30 34 44 36
11 Ormideia Ormideia 30 31 36 35
12 APEP APEP 30 32 40 35
13 Leivadiakós Leivadiakós 30 44 48 34
14 Iraklis Yerolakkou Iraklis 30 41 48 32
15 Elpida Astromeritis Elpida 30 36 54 29
16 Agiou Georgiou Vrysoúllon Agiou 30 27 72 18
TEMPORADA 2015/2016
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Akritas Chlorakas Akritas 30 72 21 67
2 Alki Oroklini Alki 30 62 25 67
3 Ethnikos Assias Ethnikos 30 64 34 57
4 MEAP Nisou MEAP Nisou 30 51 33 50
5 Ahironas Ahironas 30 44 36 49
6 Halkanoras Halkanoras 30 44 34 47
7 Xylotympou Xylotympou 30 36 43 44
8 Digenis Ypsonas Digenis 30 31 38 39
9 Iraklis Yerolakkou Iraklis 30 39 41 38
10 Olympiada Lympion Olympiada 30 38 48 38
11 Ormideia Ormideia 30 37 50 34
12 Digenis Morphou Digenis 30 44 59 34
13 Ethnikos Latsion Ethnikos 30 24 39 33
14 APEP APEP 30 38 55 33
15 Kouris Erimi Kouris Erimi 30 27 53 20
16 Amathous Amathous 30 26 68 17
TEMPORADA 2014/2015
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 EN THOI Lakatamia THOI 26 46 17 57
2 ASIL Lysi ASIL Lysi 26 37 16 46
3 Digenis Ypsonas Digenis 26 36 29 41
4 PAEEK PAEEK 26 36 30 41
5 MEAP Nisou MEAP Nisou 26 33 32 39
6 Akritas Chlorakas Akritas 26 37 37 36
7 Ahironas Ahironas 26 33 29 35
8 Ethnikos Latsion Ethnikos 26 28 31 34
9 Amathous Amathous 26 40 46 33
10 Ethnikos Assias Ethnikos 26 30 36 33
11 Chalkanoras Idaliou Chalkanoras 26 37 41 30
12 Ormideia Ormideia 26 32 38 28
13 Digenis Morphou Digenis 26 21 37 23
14 Foinikas Agia Marina Foinikas 26 20 47 13

  USO DE MEMORIA  
6,044,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1579
Total Execution Time  0.1592
  CADENA URL  
/historico/Digenis-Ypsonas
  GET DATOS  
$_GET['/historico/Digenis-Ypsonas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0043  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 = 'Digenis-Ypsonas' 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.0018  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=19120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=19120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=19120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73446
0.0027  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 = 75144
0.0027  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 = 74229
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19120 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=708 AND type_rel = 3
0.0030  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 708 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  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 (1267270,1252536,262172,90198,9789) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '19120' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '19120' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 75144 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=19120 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (75144,74229,67320) 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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 75144 AND teamId = 19120
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 19120
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 19120
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 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 = 73446 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '19120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0025  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19120' and rp.type = 4
0.0022  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 = '19120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0063  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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 19120 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.0077  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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 19120 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0045  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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 19120 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 19120 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0033  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 = 73446 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.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 = 75144 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.0035  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 = 69228 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.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 `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 = 70915 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.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 `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 = 64646 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.0026  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 = 57796 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.0025  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 = 51093 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.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 `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 = 55494 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.0025  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 = 44928 AND t.round = 30 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 `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 = 39162 AND t.round = 30 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 `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 = 33689 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15847 AND t.round = 30 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 `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 = 4165 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC