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

Omonia Aradippou

Entrenador: Hugo Martins

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA CHIPRE GRUPO 1
Equipo PJ GF GC Puntos
1 Enosis Neon Paralimni Enosis Neon 15 22 11 33
2 Olympiakos Nicosia Olympiakos 15 20 10 30
3 Omonia Aradippou Omonia 15 20 10 29
4 Omonia 29is Omonia 29is 15 18 11 28
5 Peyia Peyia 15 24 11 27
6 Digenis Ypsonas Digenis 15 20 11 27
7 ASIL Lysi ASIL Lysi 15 16 14 23
8 Ayia Napa Ayia Napa 15 17 19 21
9 Achyronas-Onisilos Achyronas-On 15 16 14 19
10 Digenis Morphou Digenis 15 14 16 19
11 MEAP Nisou MEAP Nisou 15 11 19 15
12 Xylotympou Xylotympou 15 16 22 14
13 PAEEK PAEEK 15 17 24 14
14 Akritas Chlorakas Akritas 15 15 22 12
15 ENAD ENAD 15 14 21 12
16 Ermis Aradippou Ermis 15 17 42 7
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
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Karmiotissa Karmiotissa 30 52 20 63
2 Nea Salamis Nea Salamis 30 59 24 63
3 Akritas Chlorakas Akritas 30 49 26 58
4 Enosis Neon Paralimni Enosis Neon 30 48 24 57
5 Alki Oroklini Alki 30 36 38 47
6 Ermis Aradippou Ermis 30 43 42 44
7 Othellos Athienou Othellos 30 40 53 42
8 Xylotympou Xylotympou 30 39 42 38
9 Anagennisi Anagennisi 30 33 40 37
10 Omonia 29is Omonia 29is 30 31 33 36
11 Omonia Aradippou Omonia 30 30 44 35
12 Onisilos Onisilos 30 34 44 33
13 Ayia Napa Ayia Napa 30 41 52 31
14 Ahironas Ahironas 30 28 41 31
15 Olympiada Lympion Olympiada 30 23 44 28
16 ASIL Lysi ASIL Lysi 30 28 47 23
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
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
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Enosis Neon Paralimni Enosis Neon 26 54 20 60
2 Anagennisi Anagennisi 26 53 23 59
3 Othellos Athienou Othellos 26 45 19 54
4 Ayia Napa Ayia Napa 26 43 33 42
5 AE Zakakiou AE Zakakiou 26 36 26 41
6 Omonia Aradippou Omonia 26 39 33 38
7 Karmiotissa Karmiotissa 26 41 36 37
8 ASIL Lysi ASIL Lysi 26 32 35 32
9 PAEEK PAEEK 26 33 40 31
10 Digenis Voroklinis Digenis 26 30 50 28
11 EN THOI Lakatamia THOI 26 25 39 26
12 Xylotympou Xylotympou 26 29 44 26
13 Ethnikos Assias Ethnikos 26 22 42 18
14 Halkanoras Halkanoras 26 23 65 12
TEMPORADA 2016/2017
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Alki Oroklini Alki 26 60 16 64
2 Pafos Pafos 26 51 24 57
3 Olympiakos Nicosia Olympiakos 26 44 23 54
4 Othellos Athienou Othellos 26 53 33 49
5 Ayia Napa Ayia Napa 26 52 28 46
6 Enosis Neon Paralimni Enosis Neon 26 41 32 44
7 EN THOI Lakatamia THOI 26 32 34 33
8 ASIL Lysi ASIL Lysi 26 27 33 30
9 PAEEK PAEEK 26 26 38 24
10 Ethnikos Assias Ethnikos 26 24 52 23
11 Omonia Aradippou Omonia 26 16 30 22
12 Akritas Chlorakas Akritas 26 24 45 19
13 ENAD ENAD 26 26 52 19
14 EN Parekklisias Parekklisias 26 28 64 19
TEMPORADA 2015/2016
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Olympiakos Nicosia Olympiakos 26 51 19 62
2 Karmiotissa Karmiotissa 26 54 19 61
3 Anagennisi Anagennisi 26 50 18 59
4 AE Zakakiou AE Zakakiou 26 47 19 58
5 Othellos Athienou Othellos 26 55 24 56
6 PAEEK PAEEK 26 32 29 33
7 ENAD ENAD 26 30 32 33
8 EN THOI Lakatamia THOI 26 44 49 33
9 Omonia Aradippou Omonia 26 28 29 32
10 EN Parekklisias Parekklisias 26 35 37 27
11 ASIL Lysi ASIL Lysi 26 32 36 26
12 Elpida Astromeritis Elpida 26 24 60 15
13 N&S Erimis N&S Erimis 26 13 79 9
14 Digenis Voroklinis Digenis 26 16 61 8
TEMPORADA 2014/2015
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Pafos Pafos 26 55 19 62
2 Enosis Neon Paralimni Enosis Neon 26 55 14 60
3 Aris Limassol Aris 26 35 25 52
4 AE Zakakiou AE Zakakiou 26 29 19 44
5 Karmiotissa Karmiotissa 26 36 29 38
6 Anagennisi Anagennisi 26 27 26 38
7 Olympiakos Nicosia Olympiakos 26 34 42 35
8 Elpida Astromeritis Elpida 26 29 34 34
9 ENAD ENAD 26 30 30 29
10 N&S Erimis N&S Erimis 26 35 48 29
11 Omonia Aradippou Omonia 26 35 37 28
12 EN Parekklisias Parekklisias 26 28 38 28
13 Digenis Voroklinis Digenis 26 16 49 18
14 APEP APEP 26 18 52 14
TEMPORADA 2013/2014
SEGUNDA CHIPRE GRUPO 1
Equipo PJ GF GC Puntos
1 Ayia Napa Ayia Napa 28 58 29 63
2 Othellos Athienou Othellos 28 55 25 55
3 Anagennisi Anagennisi 28 67 36 51
4 Omonia Aradippou Omonia 28 41 33 45
5 N&S Erimis N&S Erimis 28 48 49 33
6 Olympiakos Nicosia Olympiakos 28 36 43 23
7 APEP APEP 28 22 61 19
8 Pafos Pafos 28 24 75 0
TEMPORADA 2012/2013
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Aris Limassol Aris 26 64 21 55
2 Ermis Aradippou Ermis 26 41 23 52
3 AE Kouklion AE Kouklion 26 55 28 50
4 Anagennisi Anagennisi 26 28 23 43
5 APEP APEP 26 35 25 42
6 N&S Erimis N&S Erimis 26 37 33 41
7 Omonia Aradippou Omonia 26 40 40 35
8 Othellos Athienou Othellos 26 28 35 34
9 PAEEK PAEEK 26 35 37 33
10 AE Zakakiou AE Zakakiou 26 34 45 32
11 Halkanoras Halkanoras 26 34 42 29
12 Onisilos Onisilos 26 21 32 29
13 Akritas Chlorakas Akritas 26 23 42 14
14 Ethnikos Assias Ethnikos 26 25 74 12
TEMPORADA 2011/2012
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Doxa Katokopias Doxa 26 36 20 50
2 Ayia Napa Ayia Napa 26 39 17 49
3 Pafos Pafos 26 40 23 49
4 APOP Kinyras APOP Kinyras 26 41 23 43
5 PAEEK PAEEK 26 24 28 36
6 Othellos Athienou Othellos 26 30 31 34
7 Akritas Chlorakas Akritas 26 37 40 34
8 Onisilos Onisilos 26 23 26 34
9 Ethnikos Assias Ethnikos 26 29 38 34
10 APEP APEP 26 26 38 33
11 Omonia Aradippou Omonia 26 40 34 32
12 Halkanoras Halkanoras 26 28 29 32
13 EN Parekklisias Parekklisias 26 21 33 28
14 Atromitos Yeroskipou Atromitos 26 10 44 7
TEMPORADA 2010/2011
SEGUNDA CHIPRE
Equipo PJ GF GC Puntos
1 Aris Limassol Aris 26 41 20 50
2 Nea Salamis Nea Salamis 26 45 19 48
3 Omonia Aradippou Omonia 26 37 27 47
4 Anagennisi Anagennisi 26 28 25 42
5 Othellos Athienou Othellos 26 28 22 41
6 Atromitos Yeroskipou Atromitos 26 35 26 40
7 PAEEK PAEEK 26 36 36 36
8 Akritas Chlorakas Akritas 26 34 38 34
9 APEP APEP 26 33 34 33
10 Halkanoras Halkanoras 26 41 44 33
11 Onisilos Onisilos 26 26 30 32
12 ASIL Lysi ASIL Lysi 26 20 41 23
13 Digenis Morphou Digenis 26 24 45 21
14 Adonis Idaliou Adonis 26 24 45 19
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

  USO DE MEMORIA  
6,959,216 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1199
Total Execution Time  0.1219
  CADENA URL  
/historico/Omonia-Aradippou-Cy
  GET DATOS  
$_GET['/historico/Omonia-Aradippou-Cy']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0039  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19175 AND type_rel = 2
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 = '19175' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73446 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=19175 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 (75144,74229,71432) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75144 AND teamId = 19175
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 19175
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 19175
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 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.0031  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 = 19175 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.0027  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 = 19175 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 19175 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 19175 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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 `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.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 `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.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 = 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.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 `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 = 38801 AND t.round = 26 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 `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 = 33687 AND t.round = 26 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 `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 = 15734 AND t.round = 26 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 `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 = 4169 AND t.round = 26 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 `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 = 8748 AND t.round = 28 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 `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 = 8746 AND t.round = 26 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 `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 = 8744 AND t.round = 26 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 `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 = 8743 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 `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.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 `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.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 `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