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

Levadiakos

Entrenador: Nikolaos Nioplias

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA GRECIA GRUPO 3
Equipo PJ GF GC Puntos
1 Levadiakos Levadiakos 6 12 3 44
2 AE Larisa AE Larisa 6 13 12 31
3 Niki Volos Niki Volos 6 6 7 24
4 Makedonikos Neapolis Makedonikos 5 8 11 21
5 AEK Athens B Athens 5 6 12 18
6 Athens Kallithea Athens 6 13 3 37
7 Chania Chania 6 12 11 31
8 Ionikos Nikea Ionikos 6 9 6 27
9 Ilioupoli Ilioupoli 5 7 12 25
10 Kalamata FC Kalamata FC 5 0 9 19
TEMPORADA 2022/2023
SUPER LEAGUE GRIEGA GRUPO 3
Equipo PJ GF GC Puntos
1 OFI OFI 33 37 41 41
2 Atromitos Atromitos 33 34 36 38
3 PAS Giannina Giannina 33 33 50 34
4 Asteras Tripolis Asteras 33 23 36 31
5 Panaitolikos Panaitolikos 33 32 53 30
6 Lamia Lamia 33 23 53 29
7 Ionikos Nikea Ionikos 33 24 51 27
8 Levadiakos Levadiakos 33 25 48 26
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
SEGUNDA GRECIA
Equipo PJ GF GC Puntos
1 PAS Giannina Giannina 20 44 11 49
2 Apollon Smyrnis Apollon 20 36 13 42
3 Levadiakos Levadiakos 20 27 15 38
4 Chania Chania 20 29 13 35
5 Karaiskakis Karaiskakis 20 32 29 31
6 Apollon Larisas Apollon 20 27 25 30
7 Ergotelis Ergotelis 20 31 33 29
8 Panachaiki Panachaiki 20 34 19 28
9 Platanias Platanias 20 26 32 26
10 Doxa Dramas Doxa Dramas 20 25 25 24
11 Apollon Pontou Apollon 20 8 58 0
12 Kerkyra Kerkyra 20 6 52 0
TEMPORADA 2018/2019
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 PAOK PAOK 30 66 14 80
2 Olympiacos Piraeus Olympiacos 30 71 17 75
3 AEK Athens AEK Athens 30 50 19 57
4 Atromitos Atromitos 30 41 28 52
5 Aris Thessaloniki Aris 30 46 33 49
6 Panionios Panionios 30 27 45 38
7 Lamia Lamia 30 28 37 37
8 Panathinaikos Panathinaiko 30 38 30 36
9 Panaitolikos Panaitolikos 30 34 48 36
10 AE Larisa AE Larisa 30 26 34 34
11 Asteras Tripolis Asteras 30 25 30 33
12 Xanthi Xanthi 30 22 34 32
13 OFI OFI 30 30 42 32
14 PAS Giannina Giannina 30 19 38 27
15 Levadiakos Levadiakos 30 15 45 21
16 Apollon Smyrnis Apollon 30 11 55 10
TEMPORADA 2017/2018
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 50 12 70
2 PAOK PAOK 30 59 19 64
3 Olympiacos Piraeus Olympiacos 30 63 28 57
4 Atromitos Atromitos 30 43 21 56
5 Asteras Tripolis Asteras 30 39 24 45
6 Xanthi Xanthi 30 31 30 45
7 Panionios Panionios 30 32 31 40
8 Panaitolikos Panaitolikos 30 31 40 35
9 PAS Giannina Giannina 30 31 34 34
10 Levadiakos Levadiakos 30 23 34 34
11 Panathinaikos Panathinaiko 30 30 30 32
12 AE Larisa AE Larisa 30 22 41 31
13 Lamia Lamia 30 20 34 30
14 Apollon Smyrnis Apollon 30 23 36 29
15 Kerkyra Kerkyra 30 19 51 22
16 Platanias Platanias 30 14 65 10
TEMPORADA 2016/2017
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 57 16 67
2 PAOK PAOK 30 52 19 61
3 Panathinaikos Panathinaiko 30 45 19 57
4 AEK Athens AEK Athens 30 54 23 53
5 Panionios Panionios 30 35 23 52
6 Xanthi Xanthi 30 34 25 48
7 Platanias Platanias 30 34 38 42
8 Atromitos Atromitos 30 29 38 39
9 PAS Giannina Giannina 30 30 37 36
10 Kerkyra Kerkyra 30 22 43 32
11 Panaitolikos Panaitolikos 30 29 40 31
12 Asteras Tripolis Asteras 30 34 49 28
13 AE Larisa AE Larisa 30 23 42 28
14 Levadiakos Levadiakos 30 27 49 26
15 Iraklis Thessaloniki Iraklis 30 28 39 26
16 Veria NPS Veria NPS 30 23 56 22
TEMPORADA 2015/2016
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 81 16 85
2 AEK Athens AEK Athens 30 43 21 57
3 Panathinaikos Panathinaiko 30 52 26 55
4 PAOK PAOK 30 45 32 48
5 Panionios Panionios 30 33 27 44
6 PAS Giannina Giannina 30 36 40 42
7 Atromitos Atromitos 30 26 31 42
8 Asteras Tripolis Asteras 30 31 30 41
9 Platanias Platanias 30 32 30 39
10 Levadiakos Levadiakos 30 27 36 37
11 Iraklis Thessaloniki Iraklis 30 24 32 35
12 Panaitolikos Panaitolikos 30 30 46 35
13 Xanthi Xanthi 30 27 32 33
14 Veria NPS Veria NPS 30 19 33 27
15 Panthrakikos Panthrakikos 30 18 58 17
16 Kalloni Kalloni 30 19 53 16
TEMPORADA 2014/2015
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 79 23 78
2 Panathinaikos Panathinaiko 34 59 31 66
3 PAOK PAOK 34 57 42 65
4 Asteras Tripolis Asteras 34 52 37 59
5 Atromitos Atromitos 34 43 27 54
6 PAS Giannina Giannina 34 47 33 53
7 Panaitolikos Panaitolikos 34 41 28 52
8 Xanthi Xanthi 34 44 41 47
9 Platanias Platanias 34 32 30 44
10 Kerkyra Kerkyra 34 39 38 44
11 Kalloni Kalloni 34 34 39 44
12 Levadiakos Levadiakos 34 41 34 43
13 Panionios Panionios 34 43 42 43
14 Veria NPS Veria NPS 34 45 54 43
15 Panthrakikos Panthrakikos 34 35 44 43
16 Ergotelis Ergotelis 34 35 60 32
17 OFI OFI 33 26 72 0
18 Niki Volos Niki Volos 33 7 84 0
TEMPORADA 2013/2014
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 34 88 19 86
2 PAOK PAOK 34 68 37 69
3 Panathinaikos Panathinaiko 34 57 28 66
4 Atromitos Atromitos 34 54 25 66
5 Asteras Tripolis Asteras 34 46 35 58
6 Ergotelis Ergotelis 34 39 40 44
7 OFI OFI 34 30 39 44
8 Panaitolikos Panaitolikos 34 32 33 42
9 Levadiakos Levadiakos 34 42 61 42
10 PAS Giannina Giannina 34 34 43 41
11 Panthrakikos Panthrakikos 34 39 52 41
12 Panionios Panionios 34 33 42 39
13 Kalloni Kalloni 34 31 62 39
14 Platanias Platanias 34 39 48 38
15 Veria NPS Veria NPS 34 31 51 38
16 Xanthi Xanthi 34 44 54 38
17 Apollon Smyrnis Apollon 34 43 54 36
18 Aris Thessaloniki Aris 34 26 53 22
TEMPORADA 2012/2013
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 64 16 77
2 PAOK PAOK 30 46 19 62
3 Asteras Tripolis Asteras 30 41 25 56
4 Atromitos Atromitos 30 26 22 46
5 PAS Giannina Giannina 30 28 24 44
6 Panathinaikos Panathinaiko 30 32 30 40
7 Xanthi Xanthi 30 28 26 40
8 Panionios Panionios 30 35 42 36
9 Platanias Platanias 30 29 42 36
10 Panthrakikos Panthrakikos 30 30 33 36
11 Levadiakos Levadiakos 30 21 35 34
12 Veria NPS Veria NPS 30 30 35 33
13 Aris Thessaloniki Aris 30 32 40 33
14 OFI OFI 30 33 46 32
15 AEK Athens AEK Athens 30 21 36 27
16 Kerkyra Kerkyra 30 16 41 20
TEMPORADA 2011/2012
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 70 17 73
2 Panathinaikos Panathinaiko 30 54 23 66
3 Atromitos Atromitos 30 32 26 50
4 PAOK PAOK 30 45 27 50
5 AEK Athens AEK Athens 30 36 30 48
6 Asteras Tripolis Asteras 30 30 34 45
7 Levadiakos Levadiakos 30 33 42 39
8 PAS Giannina Giannina 30 30 35 38
9 Aris Thessaloniki Aris 30 29 33 37
10 OFI OFI 30 27 32 37
11 Xanthi Xanthi 30 31 35 36
12 Panionios Panionios 30 26 34 33
13 Kerkyra Kerkyra 30 31 44 32
14 Ergotelis Ergotelis 30 27 44 29
15 Panaitolikos Panaitolikos 30 23 37 28
16 Doxa Dramas Doxa Dramas 30 11 42 17
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
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 30 54 17 70
2 Olympiacos Piraeus Olympiacos 30 47 18 64
3 PAOK PAOK 30 41 16 62
4 AEK Athens AEK Athens 30 43 31 53
5 Aris Thessaloniki Aris 30 35 28 46
6 Kavala Kavala 30 31 32 39
7 Atromitos Atromitos 30 34 36 38
8 Panionios Panionios 30 34 35 37
9 Iraklis Thessaloniki Iraklis 30 39 41 37
10 AE Larisa AE Larisa 30 31 42 37
11 Ergotelis Ergotelis 30 37 41 36
12 Asteras Tripolis Asteras 30 29 36 36
13 Xanthi Xanthi 30 27 36 35
14 Levadiakos Levadiakos 30 31 44 34
15 PAS Giannina Giannina 30 27 46 28
16 Panthrakikos Panthrakikos 30 21 62 12
TEMPORADA 2008/2009
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 50 14 71
2 PAOK PAOK 30 39 16 63
3 Panathinaikos Panathinaiko 30 51 18 61
4 AEK Athens AEK Athens 30 40 24 55
5 AE Larisa AE Larisa 30 36 26 49
6 Aris Thessaloniki Aris 30 30 31 47
7 Xanthi Xanthi 30 25 21 38
8 Panionios Panionios 30 40 40 37
9 Ergotelis Ergotelis 30 31 39 36
10 Iraklis Thessaloniki Iraklis 30 22 38 33
11 Panthrakikos Panthrakikos 30 23 37 33
12 Asteras Tripolis Asteras 30 33 31 33
13 Levadiakos Levadiakos 30 28 36 32
14 OFI OFI 30 30 50 24
15 Panserraikos FC Panserraikos 30 19 45 24
16 Thrasyvoulos Thrasyvoulos 30 22 53 14

  USO DE MEMORIA  
6,738,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1550
Total Execution Time  0.1563
  CADENA URL  
/historico/Levadiakos
  GET DATOS  
$_GET['/historico/Levadiakos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0037  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 = 'Levadiakos' 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=10042 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=10042 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=10042 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=10042 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 = 75674
0.0024  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 = 73551
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10042 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10042 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  SELECT /*35 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 (10767,31671,93908,108187,113017) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '10042' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '10042' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '10042' 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 = 73551 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 75674 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=10042 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 (75674,73551,71245,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71245 AND teamId = 10042
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75674 AND teamId = 10042
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 10042
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 10042
0.0020  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 = 75674 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '10042' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10042' and rp.type = 4
0.0021  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 = '10042' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 = 75674 WHERE rp.league_id = 75674 AND rp.teamId = 10042 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.0026  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 = 75674 WHERE rp.league_id = 75674 AND rp.teamId = 10042 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75674 WHERE rp.league_id = 75674 AND rp.teamId = 10042 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 10042 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0020  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 = 75674 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.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 = 67777 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.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 `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 = 71245 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.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 `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.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 `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.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 = 51252 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.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 = 44207 AND t.round = 30 ORDER BY team.conference 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 `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 = 38720 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 `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 = 33417 AND t.round = 30 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 `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 = 15431 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 = 3825 AND t.round = 34 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 `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 = 2517 AND t.round = 34 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 = 2040 AND t.round = 30 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 `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 = 1552 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 `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.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 `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.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 `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 = 868 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 `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 = 395 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 75674 ORDER BY nameShow LIMIT 100