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

MEAP Nisou

Entrenador: Ioannis Limpouris

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA CHIPRE GRUPO 3
Equipo PJ GF GC Puntos
1 PAEEK PAEEK 14 30 10 32
2 Digenis Morphou Digenis 14 27 13 32
3 Akritas Chlorakas Akritas 14 20 11 23
4 MEAP Nisou MEAP Nisou 14 18 19 18
5 Achyronas-Onisilos Achyronas-On 14 16 18 17
6 ENAD ENAD 14 18 20 14
7 Ermis Aradippou Ermis 14 11 28 13
8 Xylotympou Xylotympou 14 12 33 6
TEMPORADA 2022/2023
SEGUNDA CHIPRE GRUPO 2
Equipo PJ GF GC Puntos
1 Othellos Athienou Othellos 14 23 13 29
2 Ethnikos Achnas Ethnikos 14 22 8 26
3 AE Zakakiou AE Zakakiou 14 23 12 25
4 Omonia 29is Omonia 29is 14 14 11 25
5 Achyronas-Onisilos Achyronas-On 14 16 21 13
6 Peyia Peyia 14 7 17 13
7 MEAP Nisou MEAP Nisou 14 11 26 11
8 Omonia Aradippou Omonia 14 7 15 9
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
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Omonia 29is Omonia 29is 26 45 22 58
2 Olympiada Lympion Olympiada 25 49 16 53
3 Peyia Peyia 26 46 27 52
4 Ethnikos Assias Ethnikos 26 49 30 43
5 MEAP Nisou MEAP Nisou 25 39 31 38
6 Halkanoras Halkanoras 26 40 31 38
7 Ormideia Ormideia 25 42 36 37
8 Iraklis Yerolakkou Iraklis 25 37 33 35
9 APONA Anagias APONA 26 35 34 31
10 APEP APEP 26 30 34 31
11 Oroklini / Troulloi Oroklini 25 28 47 26
12 Elpida Astromeritis Elpida 25 27 45 25
13 ENAD ENAD 25 21 40 25
14 Amathous Amathous 26 23 37 24
15 Elia Lythrodonta Elia 26 34 45 23
16 O Kormakitis Kormakitis 25 20 57 12
TEMPORADA 2019/2020
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Ahironas Ahironas 22 49 26 49
2 PAEEK PAEEK 22 48 20 46
3 Kouris Erimi Kouris Erimi 22 43 23 45
4 EN THOI Lakatamia THOI 22 39 23 41
5 Halkanoras Halkanoras 22 45 31 39
6 MEAP Nisou MEAP Nisou 22 47 31 37
7 Elpida Astromeritis Elpida 22 39 36 36
8 Elia Lythrodonta Elia 22 31 25 32
9 Iraklis Yerolakkou Iraklis 22 29 25 30
10 APONA Anagias APONA 22 26 36 28
11 Ormideia Ormideia 22 33 26 25
12 Ethnikos Assias Ethnikos 22 32 41 23
13 Amathous Amathous 22 21 42 17
14 O Kormakitis Kormakitis 22 20 45 17
15 Digenis Voroklinis Digenis 22 20 59 9
16 ENAD ENAD 22 18 51 8
TEMPORADA 2018/2019
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Ethnikos Achnas Ethnikos 30 72 23 71
2 Olympiakos Nicosia Olympiakos 30 77 29 69
3 Aris Limassol Aris 30 62 33 68
4 Othellos Athienou Othellos 30 66 35 50
5 Anagennisi Anagennisi 30 46 33 46
6 Omonia Aradippou Omonia 30 46 39 45
7 ASIL Lysi ASIL Lysi 30 43 38 45
8 Onisilos Onisilos 30 42 49 39
9 Karmiotissa Karmiotissa 30 47 64 37
10 AE Zakakiou AE Zakakiou 30 42 55 37
11 Ayia Napa Ayia Napa 30 44 45 35
12 Akritas Chlorakas Akritas 30 37 61 35
13 EN THOI Lakatamia THOI 30 27 57 32
14 MEAP Nisou MEAP Nisou 30 42 55 28
15 PAEEK PAEEK 30 35 65 22
16 Digenis Voroklinis Digenis 30 28 75 14
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
TEMPORADA 2013/2014
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Elpida Astromeritis Elpida 26 43 10 62
2 ENAD ENAD 26 59 20 60
3 EN THOI Lakatamia THOI 26 58 24 54
4 Ahironas Ahironas 26 42 25 45
5 MEAP Nisou MEAP Nisou 26 35 40 38
6 Ormideia Ormideia 26 32 31 36
7 Foinikas Agia Marina Foinikas 26 41 40 36
8 Ethnikos Assias Ethnikos 26 37 46 35
9 Akritas Chlorakas Akritas 26 25 35 32
10 Ethnikos Latsion Ethnikos 26 27 38 30
11 Digenis Morphou Digenis 26 24 40 25
12 Spartakos Kitiou Spartakos 26 31 52 25
13 Adonis Idaliou Adonis 26 33 51 17
14 Constantinos Constantinos 26 31 66 12
TEMPORADA 2010/2011
TERCERA CHIPRE
Equipo PJ GF GC Puntos
1 Ethnikos Assias Ethnikos 26 43 23 52
2 EN Parekklisias Parekklisias 26 49 29 48
3 Ayia Napa Ayia Napa 26 39 14 47
4 ENAD ENAD 26 36 24 47
5 Spartakos Kitiou Spartakos 26 38 33 40
6 AEK Kouklia AEK Kouklia 26 32 36 39
7 Frenaros 2000 Frenaros 26 28 23 34
8 AE Zakakiou AE Zakakiou 26 35 46 33
9 Anagennisi Germasogeias Anagennisi 26 31 38 31
10 N&S Erimis N&S Erimis 26 33 41 29
11 Elpida Astromeritis Elpida 26 25 34 29
12 Digenis Voroklinis Digenis 26 31 41 24
13 MEAP Nisou MEAP Nisou 26 31 44 21
14 Iraklis Yerolakkou Iraklis 26 24 49 17
TEMPORADA 2009/2010
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Alki Alki 26 44 24 55
2 AEK Larnaca AEK Larnaca 26 41 20 47
3 Olympiakos Nicosia Olympiakos 26 45 34 44
4 Othellos Athienou Othellos 26 31 28 39
5 Atromitos Yeroskipou Atromitos 26 35 31 37
6 Digenis Morphou Digenis 26 35 33 36
7 Omonia Aradippou Omonia 26 26 28 36
8 PAEEK PAEEK 26 24 27 36
9 ASIL Lysi ASIL Lysi 26 29 29 35
10 Onisilos Onisilos 26 30 31 33
11 Akritas Chlorakas Akritas 26 25 26 32
12 Frenaros 2000 Frenaros 26 26 32 28
13 Ayia Napa Ayia Napa 26 19 41 20
14 MEAP Nisou MEAP Nisou 26 19 45 14
TEMPORADA 2008/2009
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Ermis Aradippou Ermis 26 47 26 50
2 Aris Limassol Aris 26 56 25 49
3 Nea Salamis Nea Salamis 26 38 21 49
4 Olympiakos Nicosia Olympiakos 26 39 21 48
5 Digenis Morphou Digenis 26 38 28 44
6 Omonia Aradippou Omonia 26 33 41 37
7 MEAP Nisou MEAP Nisou 26 25 28 36
8 Onisilos Onisilos 26 30 36 31
9 Ayia Napa Ayia Napa 26 23 31 31
10 ASIL Lysi ASIL Lysi 26 29 30 30
11 PAEEK PAEEK 26 27 31 29
12 EN THOI Lakatamia THOI 26 31 46 25
13 Halkanoras Halkanoras 26 28 48 25
14 Ethnikos Assias Ethnikos 26 30 62 17
TEMPORADA 2007/2008
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Pafos Pafos 26 46 22 54
2 APEP APEP 26 45 26 51
3 Digenis Morphou Digenis 26 44 26 46
4 Atromitos Yeroskipou Atromitos 26 41 23 46
5 Onisilos Onisilos 26 32 23 38
6 Ermis Aradippou Ermis 26 51 43 38
7 Ayia Napa Ayia Napa 26 32 32 34
8 Omonia Aradippou Omonia 26 25 24 33
9 ASIL Lysi ASIL Lysi 26 20 24 32
10 EN THOI Lakatamia THOI 26 28 40 31
11 MEAP Nisou MEAP Nisou 26 32 49 31
12 Anagennisi Anagennisi 26 21 35 30
13 Akritas Chlorakas Akritas 26 22 39 22
14 Olympos Olympos 26 23 56 16
TEMPORADA 2006/2007
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 APOP Kinyras APOP Kinyras 26 65 22 58
2 Alki Alki 26 46 16 56
3 Doxa Katokopias Doxa 26 36 20 50
4 EN THOI Lakatamia THOI 26 54 36 49
5 ASIL Lysi ASIL Lysi 26 48 26 47
6 Anagennisi Anagennisi 26 30 27 36
7 Omonia Aradippou Omonia 26 38 31 35
8 MEAP Nisou MEAP Nisou 26 33 40 35
9 Onisilos Onisilos 26 39 31 33
10 APEP APEP 26 38 43 31
11 Akritas Chlorakas Akritas 26 33 41 30
12 Halkanoras Halkanoras 26 36 47 26
13 Iraklis Yerolakkou Iraklis 26 25 62 13
14 AE Mesogis AE Mesogis 26 25 104 3

  USO DE MEMORIA  
6,633,088 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1448
Total Execution Time  0.1463
  CADENA URL  
/historico/Meap-Nisou
  GET DATOS  
$_GET['/historico/Meap-Nisou']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0039  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 = 'Meap-Nisou' 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.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=17258 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=17258 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=17258 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17258 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=708 AND type_rel = 3
0.0019  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.0024  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.0024  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 = '17258' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '17258' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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=17258 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (75145) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 75145 AND teamId = 17258
0.0021  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 = '17258' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17258' 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 = '17258' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 17258 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.0039  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 = 17258 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 17258 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 17258 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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 = 75145 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.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 `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.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 `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 = 70914 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.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 `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.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 `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 = 58330 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.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 = 51095 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.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 `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 = 44927 AND t.round = 30 ORDER BY team.conference 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 `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.0032  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.0043  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
0.0034  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 = 3551 AND t.round = 26 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 `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 = 23920 AND t.round = 26 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 `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 = 8742 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 8740 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 8739 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables2007` 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 = 8737 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC