4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Diagoras
TEMPORADA 2023/2024
SEGUNDA GRECIA GRUPO 4
Equipo PJ GF GC Puntos
1 PAOK B PAOK B 6 12 9 27
2 Iraklis Thessaloniki Iraklis 6 6 3 27
3 Anagennisi Karditsas Anagennisi 6 2 5 20
4 Kampaniakos Chalastra Kampaniakos 6 7 7 19
5 Kozani FC Kozani FC 6 7 8 19
6 Aiolikos Aiolikos 6 3 5 15
7 Diagoras Diagoras 7 7 4 27
8 Egaleo Egaleo 6 6 3 22
9 Panachaiki Panachaiki 6 7 9 21
10 Panathinaikos B Panathinaiko 7 4 3 20
11 Giouchtas Giouchtas 6 5 10 17
12 Olympiacos Piraeus B Olympiacos 6 9 9 16
TEMPORADA 2022/2023
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Panserraikos FC Panserraikos 28 43 13 64
2 AE Larisa AE Larisa 28 50 19 58
3 Niki Volos Niki Volos 28 41 20 52
4 Iraklis Thessaloniki Iraklis 28 53 22 50
5 PAOK B PAOK B 28 51 33 49
6 Almopos Aridea Almopos 28 23 17 36
7 Anagennisi Karditsas Anagennisi 28 34 21 35
8 Makedonikos Neapolis Makedonikos 28 28 30 33
9 Panathinaikos B Panathinaiko 28 39 41 33
10 Diagoras Diagoras 28 38 42 33
11 Apollon Pontou Apollon 28 21 37 32
12 Veria NPS Veria NPS 28 28 32 31
13 Iraklis Larissa Iraklis 28 17 42 26
14 Thesprotos Thesprotos 28 26 49 17
15 Apollon Larisas Apollon 28 8 82 4
TEMPORADA 2021/2022
SEGUNDA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Levadiakos Levadiakos 32 68 19 72
2 Athens Kallithea Athens 32 46 19 65
3 Kalamata FC Kalamata FC 32 51 20 61
4 Chania Chania 32 46 25 55
5 AEK Athens B Athens 32 38 27 52
6 Kifisia Kifisia 32 37 31 50
7 Episkopi Episkopi 32 27 25 48
8 Egaleo Egaleo 32 31 31 46
9 Ergotelis Ergotelis 32 23 32 40
10 Irodotos Irodotos 32 29 42 37
11 OF Ierapetra Ierapetra 32 43 49 37
12 Diagoras Diagoras 32 22 36 36
13 Asteras Vlachioti Asteras 32 32 38 35
14 Panathinaikos B Panathinaiko 32 30 40 34
15 Karaiskakis Karaiskakis 32 24 50 29
16 Rodos Rodos 32 27 48 18
17 Zakynthos Zakynthos 32 19 61 12
TEMPORADA 2020/2021
SEGUNDA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ionikos Nikea Ionikos 27 44 29 53
2 Xanthi Xanthi 27 29 12 51
3 Levadiakos Levadiakos 27 42 16 50
4 Ergotelis Ergotelis 27 37 18 48
5 Chania Chania 27 22 19 42
6 Diagoras Diagoras 27 22 38 30
TEMPORADA 2019/2020
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Trikala Trikala 23 28 14 46
2 Ionikos Nikea Ionikos 23 26 13 40
3 Diagoras Diagoras 23 27 15 38
4 Niki Volos Niki Volos 23 27 20 37
5 OF Ierapetra Ierapetra 23 23 19 37
6 Kavala Kavala 23 23 12 36
7 Veria NPS Veria NPS 23 27 19 35
8 Olympiakos Volos Olympiakos 23 28 32 31
9 Egaleo Egaleo 23 14 22 27
10 Thesprotos Thesprotos 23 26 33 24
11 Ialysos Ialysos 23 17 28 24
12 Enosis Aspropyrgos Enosis 23 21 33 20
13 Triglia Rafinas Triglia 23 17 33 20
14 Kalamata FC Kalamata FC 23 17 28 19
TEMPORADA 2018/2019
TERCERA GRECIA GRUPO 6
Equipo PJ GF GC Puntos
1 Ialysos Ialysos 24 49 7 61
2 Diagoras Diagoras 24 42 9 54
3 Palliniakos Palliniakos 24 36 23 40
4 Diagoras Vrachneika Diagoras 24 31 18 38
5 PAO Vardas PAO Vardas 24 31 26 37
6 Thyella D Rafina Thyella 24 25 20 34
7 Paniliakos Paniliakos 24 32 26 32
8 Acharnaikos Acharnaikos 24 25 17 31
9 Niki Tragano Niki Tragano 24 25 33 28
10 Panegialios Panegialios 24 25 36 27
11 Panamvrakakikos A-M Panamvrakaki 24 21 36 21
12 Foivos Kremasti Foivos 24 11 36 16
13 Asteras Amaliadas Asteras 24 4 70 3
TEMPORADA 2017/2018
TERCERA GRECIA GRUPO 6
Equipo PJ GF GC Puntos
1 Ethnikos Piraeus Ethnikos 20 30 9 43
2 Proodeftiki FC Proodeftiki 20 29 10 41
3 Diagoras Diagoras 20 21 8 37
4 Ialysos Ialysos 19 30 17 33
5 Keratsini Keratsini 20 19 18 32
6 Ionikos Nikea Ionikos 20 18 12 29
7 Rodos Rodos 20 24 16 28
8 Enosi Panaspropyrgiakos Dox Enosi 20 15 22 28
9 Loutraki Loutraki 20 16 23 19
10 Pelopas Kiatou Pelopas 19 14 36 9
11 Zevgolateio Zevgolateio 20 3 48 3
TEMPORADA 2011/2012
FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Panthrakikos Panthrakikos 34 49 16 73
2 Veria NPS Veria NPS 34 56 19 72
3 Athens Kallithea Athens 34 58 32 64
4 Panachaiki Panachaiki 34 55 33 61
5 Platanias Platanias 34 41 20 60
6 Kalloni Kalloni 34 46 29 57
7 Panserraikos FC Panserraikos 34 39 22 57
8 Pierikos Pierikos 34 41 30 55
9 Anagennisi Epanomi Anagennisi 34 42 46 44
10 AE Larisa AE Larisa 34 38 29 43
11 Iraklis Psachna Iraklis 34 29 23 42
12 Thrasyvoulos Thrasyvoulos 34 37 40 42
13 Anagennisi Giannitsa Anagennisi 34 29 44 39
14 Fokikos Fokikos 34 27 38 35
15 Agrotikos Asteras Agrotikos 34 24 41 34
16 Vyzas Megara Vyzas Megara 34 24 42 34
17 Ethnikos Asteras Ethnikos 33 11 62 13
18 Diagoras Diagoras 33 3 83 3
TEMPORADA 2010/2011
FOOTBALL LEAGUE GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 OFI OFI 6 13 5 14
2 Levadiakos Levadiakos 6 12 2 13
3 Doxa Dramas Doxa Dramas 6 5 13 5
4 Diagoras Diagoras 6 2 12 1
TEMPORADA 2009/2010
FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiakos Volos Olympiakos 34 73 36 68
2 Kerkyra Kerkyra 34 45 25 63
3 OFI OFI 34 44 35 62
4 Ethnikos Piraeus Ethnikos 34 43 30 53
5 Panserraikos FC Panserraikos 34 36 35 52
6 Pierikos Pierikos 34 41 31 50
7 Panaitolikos Panaitolikos 34 43 36 50
8 Diagoras Diagoras 34 43 42 48
9 Ilioupoli Ilioupoli 34 33 35 46
10 Agrotikos Asteras Agrotikos 34 36 31 45
11 Ethnikos Asteras Ethnikos 34 39 37 45
12 Anagennisi Karditsas Anagennisi 34 29 28 44
13 Thrasyvoulos Thrasyvoulos 34 42 42 41
14 Doxa Dramas Doxa Dramas 34 37 49 40
15 Ionikos Nikea Ionikos 34 32 45 39
16 Rodos Rodos 34 31 46 34
17 Kalamata FC Kalamata FC 34 21 49 28
18 Aigaleo FC Athens Aigaleo 34 19 55 21
TEMPORADA 2008/2009
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Atromitos Atromitos 34 54 30 74
2 PAS Giannina Giannina 34 70 36 69
3 Kavala Kavala 34 56 28 65
4 Ionikos Nikea Ionikos 34 43 37 55
5 Kerkyra Kerkyra 34 45 40 51
6 Ilysiakos AO Ilysiakos 34 42 40 46
7 Agrotikos Asteras Agrotikos 34 39 39 45
8 Diagoras Diagoras 34 46 38 44
9 Kalamata FC Kalamata FC 34 33 43 43
10 Pierikos Pierikos 34 33 43 42
11 Ethnikos Asteras Ethnikos 34 42 40 41
12 Olympiakos Volos Olympiakos 34 32 36 41
13 Apollon Pontou Apollon 34 34 45 41
14 Ethnikos Piraeus Ethnikos 34 42 41 40
15 Anagennisi Karditsas Anagennisi 34 30 43 39
16 Veria NPS Veria NPS 34 27 36 38
17 Athens Kallithea Athens 34 25 43 34
18 Kastoria Kastoria 34 28 63 18
TEMPORADA 2007/2008
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ilioupoli Ilioupoli 35 61 30 74
2 Diagoras Diagoras 35 55 25 73
3 Panaitolikos Panaitolikos 34 63 27 65
4 PAS Korinthos Korinthos 35 40 35 54
5 Rodos Rodos 35 33 25 52
6 Aias Salamina Aias 35 45 45 52
7 Aiolikos Aiolikos 35 40 42 49
8 Panachaiki Panachaiki 34 41 32 48
9 Vyzas Megara Vyzas Megara 35 38 43 48
10 Asteras Rethymno Asteras 35 41 42 47
11 Fostiras Fostiras 35 44 40 45
12 Thyella Patras Thyella 35 26 39 44
13 Atsalenios Atsalenios 35 33 47 44
14 AO Koropi AO Koropi 35 25 37 42
15 Messiniakos Kalamata Messiniakos 35 30 37 40
16 Aharnaikos Aharnaikos 35 33 43 37
17 Panegialios Panegialios 35 35 53 35
18 Tiva Tiva 35 22 63 15
TEMPORADA 2006/2007
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Agios Dimitrios Agios 34 56 28 71
2 Rodos Rodos 34 51 20 69
3 Atsalenios Atsalenios 34 52 32 62
4 Panaitolikos Panaitolikos 34 55 33 58
5 Diagoras Diagoras 34 49 33 58
6 Ilioupoli Ilioupoli 34 47 35 51
7 Thyella Patras Thyella 34 42 36 51
8 Vyzas Megara Vyzas Megara 34 49 44 51
9 AO Koropi AO Koropi 34 43 45 49
10 Panachaiki Panachaiki 33 38 27 48
11 Aharnaikos Aharnaikos 34 29 36 42
12 Tiva Tiva 34 43 46 40
13 Aiolikos Aiolikos 34 43 51 39
14 Apollon Smyrnis Apollon 34 37 52 37
15 Paniliakos Paniliakos 34 39 56 33
16 OF Ierapetra Ierapetra 33 28 54 29
17 PAO Vardas PAO Vardas 34 23 52 28
18 Zakynthos Zakynthos 34 14 58 17
TEMPORADA 2005/2006
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Asteras Tripolis Asteras 32 56 19 73
2 Ethnikos Piraeus Ethnikos 32 44 14 66
3 Messiniakos Kalamata Messiniakos 32 38 22 63
4 Atsalenios Atsalenios 32 51 34 54
5 Chalkida Chalkida 32 45 31 49
6 Thyella Patras Thyella 32 35 33 48
7 Panaitolikos Panaitolikos 32 33 27 45
8 Aharnaikos Aharnaikos 32 36 38 44
9 Diagoras Diagoras 32 32 35 41
10 Aiolikos Aiolikos 32 33 34 40
11 Rodos Rodos 32 35 35 39
12 Agios Dimitrios Agios 32 27 31 37
13 Vyzas Megara Vyzas Megara 32 25 33 36
14 Apollon Smyrnis Apollon 32 23 43 34
15 Keratsini Keratsini 32 19 43 26
16 Ionia 2000 Ionia 2000 32 30 58 25
17 Achaiki Achaiki 32 22 54 20
TEMPORADA 1988/1989
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 45 20 63
2 Olympiacos Piraeus Olympiacos 30 54 25 57
3 Panathinaikos Panathinaiko 30 45 25 51
4 Iraklis Thessaloniki Iraklis 30 43 27 49
5 OFI OFI 30 45 36 47
6 Aris Thessaloniki Aris 30 31 26 44
7 AE Larisa AE Larisa 30 37 34 44
8 PAOK PAOK 30 34 30 43
9 Doxa Dramas Doxa Dramas 30 26 28 38
10 Panionios Panionios 30 32 36 37
11 Levadiakos Levadiakos 30 33 47 34
12 Olympiakos Volos Olympiakos 30 36 45 32
13 Apollon Smyrnis Apollon 30 29 38 30
14 Ethnikos Piraeus Ethnikos 30 31 49 29
15 Diagoras Diagoras 30 21 43 24
16 Apollon Pontou Apollon 30 24 57 21
TEMPORADA 1987/1988
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AE Larisa AE Larisa 30 51 22 61
2 PAOK PAOK 30 60 27 56
3 AEK Athens AEK Athens 30 51 31 55
4 OFI OFI 30 54 41 54
5 Panathinaikos Panathinaiko 30 47 34 51
6 Iraklis Thessaloniki Iraklis 30 42 32 47
7 Ethnikos Piraeus Ethnikos 30 27 28 44
8 Olympiacos Piraeus Olympiacos 30 39 41 40
9 Aris Thessaloniki Aris 30 39 41 38
10 Panionios Panionios 30 32 34 34
11 Apollon Pontou Apollon 30 23 39 31
12 Diagoras Diagoras 30 25 38 30
13 Levadiakos Levadiakos 30 32 46 30
14 Veria NPS Veria NPS 30 24 53 30
15 Panserraikos FC Panserraikos 30 24 42 29
16 Panachaiki Panachaiki 30 32 53 28

  USO DE MEMORIA  
6,856,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4601
Total Execution Time  0.4620
  CADENA URL  
/historico/Diagoras
  GET DATOS  
$_GET['/historico/Diagoras']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63639 AND type_rel = 2
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2166 AND type_rel = 3
0.0152  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 = '63639' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0153  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 = 63639 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 = 73942 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.0148  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 = 75675 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 65351 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.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 `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 = 59056 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.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 `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 = 62297 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 51506 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 45478 AND t.round = 26 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 `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 = 40665 AND t.round = 22 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 = 13406 AND t.round = 34 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 `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 = 13405 AND t.round = 34 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 `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 = 13408 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 `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 = 13404 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 13403 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 24850 AND t.round = 35 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 `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 = 24852 AND t.round = 34 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 `tables2006` 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 = 24854 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1989` 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 = 29008 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1988` 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 = 29009 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC