4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2019/2020
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 10 21 7 91
2 PAOK PAOK 10 8 6 73
3 AEK Athens AEK Athens 10 17 10 69
4 Panathinaikos Panathinaiko 10 8 9 58
5 Aris Thessaloniki Aris 10 10 19 42
6 OFI OFI 10 8 21 36
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
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 65 18 73
2 Panathinaikos Panathinaiko 30 47 26 60
3 AEK Athens AEK Athens 30 46 37 50
4 PAOK PAOK 30 32 29 48
5 Olympiakos Volos Olympiakos 30 40 28 47
6 Aris Thessaloniki Aris 30 29 29 45
7 Kavala Kavala 30 29 27 40
8 Ergotelis Ergotelis 30 32 38 39
9 Xanthi Xanthi 30 29 35 36
10 Iraklis Thessaloniki Iraklis 30 22 28 35
11 Panionios Panionios 30 25 35 35
12 Atromitos Atromitos 30 30 34 34
13 Kerkyra Kerkyra 30 30 40 33
14 Asteras Tripolis Asteras 30 21 29 31
15 AE Larisa AE Larisa 30 29 47 25
16 Panserraikos FC Panserraikos 30 22 48 24
TEMPORADA 2009/2010
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 PAOK PAOK 6 7 3 19
2 AEK Athens AEK Athens 6 8 7 9
3 Aris Thessaloniki Aris 6 8 9 8
4 Olympiacos Piraeus Olympiacos 6 3 7 8
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
TEMPORADA 2007/2008
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 65 17 68
2 Olympiacos Piraeus Olympiacos 30 55 24 67
3 Panathinaikos Panathinaiko 30 44 18 66
4 Aris Thessaloniki Aris 30 33 20 50
5 Panionios Panionios 30 39 42 45
6 AE Larisa AE Larisa 30 35 30 45
7 Asteras Tripolis Asteras 30 28 24 44
8 Xanthi Xanthi 30 33 39 36
9 PAOK PAOK 30 29 35 35
10 Iraklis Thessaloniki Iraklis 30 28 34 35
11 Levadiakos Levadiakos 30 31 51 33
12 OFI OFI 30 39 49 32
13 Ergotelis Ergotelis 30 28 42 30
14 Atromitos Atromitos 30 23 36 29
15 Apollon Pontou Apollon 30 28 54 25
16 Veria NPS Veria NPS 30 21 44 23
TEMPORADA 2006/2007
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 62 23 71
2 AEK Athens AEK Athens 30 60 27 62
3 Panathinaikos Panathinaiko 30 47 28 54
4 Aris Thessaloniki Aris 30 32 26 46
5 Panionios Panionios 30 33 31 45
6 PAOK PAOK 30 32 29 45
7 OFI OFI 30 41 45 42
8 Atromitos Atromitos 30 40 44 40
9 Ergotelis Ergotelis 30 30 32 39
10 AE Larisa AE Larisa 30 30 38 36
11 Xanthi Xanthi 30 24 22 36
12 Apollon Pontou Apollon 30 27 36 35
13 Kerkyra Kerkyra 30 34 36 35
14 Iraklis Thessaloniki Iraklis 30 24 36 33
15 Aigaleo FC Athens Aigaleo 30 27 45 28
16 Ionikos Nikea Ionikos 30 16 61 5
TEMPORADA 2005/2006
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 63 23 70
2 Panathinaikos Panathinaiko 30 55 23 67
3 AEK Athens AEK Athens 30 42 20 67
4 Iraklis Thessaloniki Iraklis 30 39 31 51
5 Xanthi Xanthi 30 31 25 47
6 PAOK PAOK 30 44 31 46
7 Atromitos Atromitos 30 36 37 42
8 AE Larisa AE Larisa 30 31 37 39
9 Apollon Pontou Apollon 30 32 36 38
10 Aigaleo FC Athens Aigaleo 30 23 41 33
11 Panionios Panionios 30 33 45 32
12 Ionikos Nikea Ionikos 30 36 41 32
13 OFI OFI 30 23 37 31
14 Levadiakos Levadiakos 30 24 36 31
15 Athens Kallithea Athens 30 28 49 20
16 Akratitos Akratitos 30 19 47 18
TEMPORADA 2004/2005
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 54 18 65
2 Panathinaikos Panathinaiko 30 51 18 64
3 AEK Athens AEK Athens 30 46 22 62
4 Xanthi Xanthi 30 43 29 50
5 PAOK PAOK 30 43 39 46
6 Aigaleo FC Athens Aigaleo 30 31 26 45
7 Iraklis Thessaloniki Iraklis 30 36 30 41
8 Halkidona Halkidona 30 34 38 38
9 Athens Kallithea Athens 30 39 44 37
10 Ionikos Nikea Ionikos 30 22 32 36
11 Panionios Panionios 30 25 32 35
12 Apollon Pontou Apollon 30 31 49 33
13 OFI OFI 30 36 44 32
14 Aris Thessaloniki Aris 30 26 37 25
15 Ergotelis Ergotelis 30 19 50 20
16 Kerkyra Kerkyra 30 21 49 17
TEMPORADA 2003/2004
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Panathinaikos Panathinaiko 30 62 18 77
2 Olympiacos Piraeus Olympiacos 30 70 19 75
3 PAOK PAOK 30 47 27 60
4 AEK Athens AEK Athens 30 57 32 55
5 Aigaleo FC Athens Aigaleo 30 37 26 52
6 Panionios Panionios 30 40 29 47
7 Halkidona Halkidona 30 40 39 45
8 Iraklis Thessaloniki Iraklis 30 40 39 42
9 Ionikos Nikea Ionikos 30 33 43 33
10 Xanthi Xanthi 30 28 42 30
11 OFI OFI 30 27 44 29
12 Athens Kallithea Athens 30 37 42 27
13 Aris Thessaloniki Aris 30 24 46 27
14 Akratitos Akratitos 30 31 69 23
15 Paniliakos Paniliakos 30 28 56 21
16 Proodeftiki FC Proodeftiki 30 26 56 20
TEMPORADA 2002/2003
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 75 21 70
2 Panathinaikos Panathinaiko 30 50 19 70
3 AEK Athens AEK Athens 30 74 29 68
4 PAOK PAOK 30 59 38 53
5 Panionios Panionios 30 35 25 53
6 Aris Thessaloniki Aris 30 37 34 51
7 Iraklis Thessaloniki Iraklis 30 44 37 49
8 OFI OFI 30 39 34 44
9 Xanthi Xanthi 30 31 33 35
10 Aigaleo FC Athens Aigaleo 30 28 44 31
11 Proodeftiki FC Proodeftiki 30 25 38 30
12 Akratitos Akratitos 30 33 62 26
13 Athens Kallithea Athens 30 29 46 26
14 Ionikos Nikea Ionikos 30 22 42 24
15 Panachaiki Panachaiki 30 11 71 9
16 PAS Giannina Giannina 30 25 44 0

  USO DE MEMORIA  
7,975,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2243
Total Execution Time  0.2262
  CADENA URL  
/historico/Olympiakos-Piraeus/2020
  GET DATOS  
$_GET['/historico/Olympiakos-Piraeus/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (60)  
0.0080  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 = 'Olympiakos-Piraeus' AND l.year = 2020 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.0020  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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1863 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 51184
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 = 49866
0.0025  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 = 55620
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1863 AND type_rel = 2
0.0032  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1863 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024  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 (408,1855,2676,3017,3042) ORDER BY n.cover_points DESC, update_date DESC
0.0046  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 = '1863' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0046  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 = '1863' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 51184 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 53486 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 55620 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0057  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=1863 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (61824,60338,59709,59177,58620,56547,44847) 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 = 61824 AND teamId = 1863
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 59177 AND teamId = 1863
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 60338 AND teamId = 1863
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 58620 AND teamId = 1863
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 44847 AND teamId = 1863
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 59709 AND teamId = 1863
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 1863
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 `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 = 51184 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '1863' 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 = '1863' 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 = '1863' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1863' and rp.type = 4
0.0033  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 events2020 e ON e.player_id = p.id AND e.league_id = 51184 WHERE rp.league_id = 51184 AND rp.teamId = 1863 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.0034  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 events2020 e ON e.player_id = p.id AND e.league_id = 51184 WHERE rp.league_id = 51184 AND rp.teamId = 1863 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 events2020 e ON e.player_id = p.id AND e.league_id = 51184 WHERE rp.league_id = 51184 AND rp.teamId = 1863 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 1863 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0047  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 = 49866 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.0038  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 = 55620 AND t.round = 10 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 `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.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 = 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.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 = 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.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 = 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.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 `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.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 `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.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 = 1196 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 `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.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 `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 = 10442 AND t.round = 6 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 `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.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 `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 = 396 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 `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 = 397 AND t.round = 30 ORDER BY team.conference 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 `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 = 398 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 `tables2005` 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 = 399 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 `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 = 400 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 `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 = 401 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  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 = 51184 ORDER BY nameShow LIMIT 100