4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fostiras
TEMPORADA 2023/2024
TERCERA GRECIA GRUPO 4
Equipo PJ GF GC Puntos
1 Panionios Panionios 33 80 21 83
2 Ethnikos Piraeus Ethnikos 33 60 18 71
3 Almyros Gaziou Almyros 33 58 27 62
4 Ilysiakos AO Ilysiakos 33 42 27 57
5 Aris Petroupolis Aris 33 45 37 57
6 Ypatou Ypatou 33 42 31 50
7 Agios Nikolaos Agios 33 52 38 49
8 Atsalenios Atsalenios 33 39 33 47
9 Ellopiakos Ellopiakos 33 42 40 47
10 Chaidari Chaidari 33 37 29 46
11 Proodeftiki FC Proodeftiki 33 45 38 45
12 Apollon Smyrnis Apollon 33 34 37 39
13 Episkopi Episkopi 33 40 52 37
14 Ermis Zoniana Ermis 33 35 53 36
15 Fostiras Fostiras 32 29 37 31
16 Peramaikos Peramaikos 33 32 56 30
17 Agia Paraskevi Agia 32 25 79 17
18 Atromitos Pireo Atromitos 33 16 100 11
TEMPORADA 2022/2023
TERCERA GRECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Giouchtas Giouchtas 25 35 18 47
2 Marko Marko 26 31 11 46
3 Thyella D Rafina Thyella 26 39 27 42
4 Fostiras Fostiras 26 38 20 40
5 Ethnikos Piraeus Ethnikos 26 25 14 40
6 Agios Nikolaos Agios 26 34 26 38
7 Almyros Gaziou Almyros 26 38 30 37
8 Aris Petroupolis Aris 26 32 24 37
9 Agia Paraskevi Agia 26 29 22 37
10 Keratsini Keratsini 26 31 20 36
11 Moschato Moschato 26 30 42 33
12 Poros Poros 26 29 32 29
13 Tympaki Tympaki 26 24 50 15
14 Agios Ierotheos Agios 25 11 90 3
TEMPORADA 2021/2022
TERCERA GRECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Ilioupoli Ilioupoli 20 41 11 48
2 Fostiras Fostiras 20 29 16 39
3 Santorini Santorini 20 30 9 36
4 Foinikas N. Epidavrou Foinikas 20 24 23 29
5 AE Mykonou AE Mykonou 20 27 28 28
6 Ermionidas-Ermis Ermionidas-E 20 19 25 27
7 Agios Ierotheos Agios 20 21 26 27
8 Charavgiakos Charavgiakos 20 19 27 25
9 Panarkadikos Panarkadikos 20 27 27 23
10 Ermis Meligous Ermis 20 16 29 20
11 Aris Skalas Aris Skalas 20 10 42 8
TEMPORADA 2020/2021
TERCERA GRECIA GRUPO 6
Equipo PJ GF GC Puntos
1 Panionios Panionios 10 20 7 26
2 Ilioupoli Ilioupoli 10 21 9 25
3 Charavgiakos Charavgiakos 10 17 14 17
4 Proodeftiki FC Proodeftiki 10 14 10 16
5 Fostiras Fostiras 10 13 12 15
6 Ethnikos Piraeus Ethnikos 10 10 13 11
7 AE Mykonou AE Mykonou 10 10 12 10
8 Aittitos Spata Aittitos 10 6 11 10
9 Marko Marko 10 6 13 9
10 Moschato Moschato 10 8 17 9
11 Pannaxiakos Pannaxiakos 10 8 15 7
TEMPORADA 2019/2020
TERCERA GRECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Athens Kallithea Athens 23 39 15 53
2 Thyella Kamari Thyella 23 44 19 51
3 Fostiras Fostiras 23 36 21 40
4 Agios Ierotheos Agios 23 31 25 40
5 Kifisia Kifisia 23 26 22 36
6 Moschato Moschato 23 40 29 35
7 Panthiraikos AO Panthiraikos 23 22 17 35
8 Ethnikos Piraeus Ethnikos 23 26 24 31
9 Katastari Katastari 23 18 25 29
10 AE Mykonou AE Mykonou 23 15 17 27
11 Akratitos Akratitos 23 20 36 21
12 Ilisiakos Ilisiakos 23 17 32 18
13 Agioi Anargyroi Agioi 23 14 35 13
14 Ermis Korydallos Ermis 23 19 50 11
TEMPORADA 2017/2018
TERCERA GRECIA GRUPO 8
Equipo PJ GF GC Puntos
1 Irodotos Irodotos 20 30 12 44
2 Egaleo Egaleo 20 31 22 36
3 OF Ierapetra Ierapetra 20 23 14 30
4 Ilysiakos AO Ilysiakos 20 23 17 27
5 Atsalenios Atsalenios 20 16 19 27
6 Agios Ierotheos Agios 20 24 23 26
7 Palaiochora Palaiochora 20 16 19 26
8 Fostiras Fostiras 20 16 18 22
9 Kifisia Kifisia 20 23 33 21
10 AE Mylopotamos Mylopotamos 20 19 27 19
11 Ermis Zoniana Ermis 20 18 35 18
TEMPORADA 2016/2017
TERCERA GRECIA GRUPO 3
Equipo PJ GF GC Puntos
1 Panachaiki Panachaiki 28 47 9 65
2 Chalkida Chalkida 28 34 22 52
3 PAO Vardas PAO Vardas 28 36 26 48
4 Ermionidas-Ermis Ermionidas-E 28 40 31 43
5 Asteras Amaliadas Asteras 28 25 30 38
6 AO Thiva AO Thiva 28 32 29 37
7 Fostiras Fostiras 28 25 20 36
8 Achaiki Achaiki 28 30 33 36
9 Aiolikos Aiolikos 28 31 25 35
10 Panarkadikos Panarkadikos 28 21 25 35
11 Panargiakos Argos Panargiakos 28 24 32 35
12 Pylou AO Tsiklitiras Pylou 28 24 30 32
13 Loutraki Loutraki 28 22 35 31
14 Zevgolateio Zevgolateio 28 15 37 26
15 Doxa Megalopoli Doxa 28 24 46 25
TEMPORADA 2015/2016
TERCERA GRECIA GRUPO 4
Equipo PJ GF GC Puntos
1 OFI OFI 30 53 11 68
2 Fostiras Fostiras 30 42 22 63
3 Triglia Rafinas Triglia 30 44 25 57
4 Ethnikos Piraeus Ethnikos 30 44 29 56
5 Ialysos Ialysos 30 41 31 55
6 Ermis Zoniana Ermis 30 45 37 50
7 Ionikos Nikea Ionikos 30 36 23 49
8 Ilysiakos AO Ilysiakos 30 37 28 46
9 Kifisia Kifisia 30 38 32 46
10 Kyanos Asteras Vari Kyanos 30 33 30 41
11 Kroussonas Kroussonas 30 28 43 32
12 Atromitos Piraeus Atromitos 30 26 42 32
13 Episkopi Episkopi 30 29 41 29
14 Iraklio Iraklio 30 41 55 26
15 Glyfada Glyfada 30 19 57 10
16 Trachones Trachones 30 16 66 9
TEMPORADA 2014/2015
FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 24 67 10 65
2 Panachaiki Panachaiki 24 41 22 46
3 Apollon Smyrnis Apollon 24 32 17 45
4 Chania Chania 24 28 20 42
5 Ermionidas-Ermis Ermionidas-E 24 30 28 41
6 Panegialios Panegialios 24 24 12 40
7 Acharnaikos Acharnaikos 24 28 22 35
8 Athens Kallithea Athens 24 25 25 33
9 Episkopi Episkopi 24 25 34 26
10 Iraklis Psachna Iraklis 24 23 37 23
11 Trachones Trachones 24 15 25 21
12 Fostiras Fostiras 24 20 43 15
13 Paniliakos Paniliakos 24 7 70 1
TEMPORADA 2013/2014
FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiakos Volos Olympiakos 26 54 18 56
2 Chania Chania 26 29 13 48
3 Fostiras Fostiras 26 27 19 46
4 Iraklis Psachna Iraklis 26 32 14 44
5 Panegialios Panegialios 26 27 19 44
6 Panachaiki Panachaiki 26 28 21 40
7 Athens Kallithea Athens 26 32 21 39
8 Acharnaikos Acharnaikos 26 26 22 37
9 Fokikos Fokikos 26 33 31 36
10 Paniliakos Paniliakos 26 30 28 35
11 Episkopi Episkopi 26 30 28 34
12 Asteras Magoula Asteras 26 26 36 27
13 Glyfada Glyfada 26 16 62 9
14 Vyzas Megara Vyzas Megara 26 17 75 8
TEMPORADA 2012/2013
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Fostiras Fostiras 24 28 13 43
2 Panegialios Panegialios 24 37 21 42
3 Acharnaikos Acharnaikos 24 34 21 41
4 Episkopi Episkopi 24 36 26 39
5 Asteras Magoula Asteras 24 32 26 39
6 Chania Chania 24 31 24 38
7 Proodeftiki FC Proodeftiki 24 34 26 36
8 Paniliakos Paniliakos 24 30 24 34
9 Glyfada Glyfada 24 33 33 34
10 Rouvas Rouvas 24 27 27 30
11 PAS Korinthos Korinthos 24 24 28 26
12 Kalamata FC Kalamata FC 24 18 23 23
13 Ethnikos Asteras Ethnikos 24 0 72 0
TEMPORADA 2008/2009
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ilioupoli Ilioupoli 34 66 22 81
2 Rodos Rodos 34 56 19 77
3 Panachaiki Panachaiki 34 48 19 75
4 Fostiras Fostiras 34 47 30 62
5 Panargiakos Argos Panargiakos 34 43 39 49
6 PAS Korinthos Korinthos 34 41 34 48
7 Agia Paraskevi Agia 34 45 42 48
8 Keravnos Kerateas Keravnos 34 37 32 47
9 Chaidari Chaidari 35 33 33 46
10 Vyzas Megara Vyzas Megara 34 40 33 45
11 Olympiakos Chersonisos Olympiakos 33 40 33 44
12 Aias Salamina Aias 34 38 39 44
13 Atsalenios Atsalenios 34 31 30 42
14 AO Koropi AO Koropi 34 23 25 39
15 Agios Dimitrios Agios 34 39 52 39
16 Asteras Rethymno Asteras 34 31 44 36
17 Egaleo Egaleo 34 31 73 20
18 Aiolikos Aiolikos 34 5 95 0
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 2003/2004
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Kerkyra Kerkyra 30 42 13 67
2 Apollon Pontou Apollon 30 53 27 58
3 Ergotelis Ergotelis 30 39 24 55
4 Kassandra FC Kassandra 30 37 23 53
5 Poseidon Neon Poron Poseidon 30 42 23 52
6 Niki Volos Niki Volos 30 31 18 49
7 Ethnikos Asteras Ethnikos 30 35 28 45
8 Levadiakos Levadiakos 30 30 31 43
9 Apollon Smyrnis Apollon 30 36 37 41
10 Kalamata FC Kalamata FC 30 26 27 41
11 Patraikos Patraikos 30 28 25 40
12 Panserraikos FC Panserraikos 30 31 31 40
13 Atromitos Atromitos 30 33 45 37
14 PAS Giannina Giannina 30 26 31 31
15 Fostiras Fostiras 30 2 55 5
16 Panachaiki Panachaiki 30 1 54 3
TEMPORADA 2002/2003
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Halkidona Halkidona 30 61 20 65
2 Paniliakos Paniliakos 30 43 25 60
3 Apollon Pontou Apollon 30 38 19 59
4 Fostiras Fostiras 30 34 27 45
5 Kerkyra Kerkyra 30 31 23 44
6 Ethnikos Asteras Ethnikos 30 36 32 44
7 Kalamata FC Kalamata FC 30 29 22 40
8 Apollon Smyrnis Apollon 30 40 43 39
9 Atromitos Atromitos 30 30 33 37
10 Patraikos Patraikos 30 28 32 36
11 Panserraikos FC Panserraikos 30 33 41 36
12 Panegialios Panegialios 30 31 42 34
13 Athinaikos Athinaikos 30 30 41 34
14 Kassandra FC Kassandra 30 27 36 33
15 Olympiakos Volos Olympiakos 30 25 43 31
16 Kavala Kavala 30 21 58 16
TEMPORADA 2001/2002
TERCERA GRECIA
Equipo PJ GF GC Puntos
1 Kerkyra Kerkyra 30 44 17 63
2 Kassandra FC Kassandra 29 42 18 62
3 Fostiras Fostiras 30 51 28 59
4 Kavala Kavala 29 49 21 54
5 Atromitos Atromitos 30 44 29 51
6 Kilkisiakos Kilkisiakos 30 35 27 47
7 Apollon Larisas Apollon 30 37 34 42
8 Ethnikos Piraeus Ethnikos 30 38 41 41
9 Marko Marko 30 37 41 41
10 Chania Chania 30 35 37 40
11 Panelefsiniakos Panelefsinia 30 24 43 32
12 Leonidio Leonidio 30 25 35 28
13 Trikala Trikala 30 17 32 28
14 Nafpaktiakos Asteras Nafpaktiakos 30 24 37 26
15 Panaitolikos Panaitolikos 30 24 46 25
16 Apollon K.V. Apollon K.V. 30 14 54 14

  USO DE MEMORIA  
6,613,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7241
Total Execution Time  0.7253
  CADENA URL  
/historico/Fostiras
  GET DATOS  
$_GET['/historico/Fostiras']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0154  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 = 'Fostiras' 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.0145  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=12679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=12679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0291  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 = 73590
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12679 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=344 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 344 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1098455,1051323,606708,277509,105444) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '12679' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '12679' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73590 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=12679 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (73590,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.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 73590 AND teamId = 12679
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 12679
0.0167  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 = 73590 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0157  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 = 73590 WHERE rp.league_id = 73590 AND rp.teamId = 12679 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.0156  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 = 73590 WHERE rp.league_id = 73590 AND rp.teamId = 12679 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 73590 WHERE rp.league_id = 73590 AND rp.teamId = 12679 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 12679 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0167  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 = 73590 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.0162  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 = 70499 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.0162  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 = 65488 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.0159  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 = 59062 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.0153  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 = 51445 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.0153  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 = 40667 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 36069 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 15929 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 4428 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 13420 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 = 3486 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 2782 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 24847 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.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 `tables2004` 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 = 13398 AND t.round = 30 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 `tables2003` 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 = 13397 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 `tables2002` 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 = 24859 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 73590 ORDER BY nameShow LIMIT 100