4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1977/1978
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 46 17 44
2 Vicenza Vicenza 30 50 34 39
3 Torino Torino 30 36 23 39
4 Milan Milan 30 38 25 37
5 Inter Inter 30 35 24 36
6 Napoli Napoli 30 35 31 30
7 Perugia Perugia 30 36 35 30
8 Roma Roma 30 31 34 28
9 Atalanta Atalanta 30 28 32 27
10 Hellas Verona Hellas 30 25 30 26
11 Lazio Lazio 30 30 38 26
12 Bologna Bologna 30 21 32 26
13 Fiorentina Fiorentina 30 28 37 25
14 Genoa Genoa 30 23 33 25
15 Calcio Foggia Calcio 30 28 43 25
16 Pescara Pescara 30 22 44 17
TEMPORADA 1976/1977
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 50 20 51
2 Torino Torino 30 51 14 50
3 Fiorentina Fiorentina 30 38 31 35
4 Inter Inter 30 34 27 33
5 Lazio Lazio 30 34 28 31
6 Perugia Perugia 30 32 28 29
7 Napoli Napoli 30 37 38 28
8 Roma Roma 30 27 33 28
9 Hellas Verona Hellas 30 26 32 28
10 Milan Milan 30 30 33 27
11 Genoa Genoa 30 40 45 27
12 Bologna Bologna 30 24 31 27
13 Calcio Foggia Calcio 30 33 39 26
14 Sampdoria Sampdoria 30 28 42 24
15 Catanzaro Catanzaro 30 26 43 21
16 Cesena Cesena 30 22 48 14
TEMPORADA 1975/1976
SERIE A
Equipo PJ GF GC Puntos
1 Torino Torino 30 49 22 45
2 Juventus Juventus 30 46 26 43
3 Milan Milan 30 42 28 38
4 Inter Inter 30 36 28 37
5 Napoli Napoli 30 40 27 36
6 Cesena Cesena 30 39 35 32
7 Bologna Bologna 30 32 32 32
8 Perugia Perugia 30 31 34 31
9 Fiorentina Fiorentina 30 39 39 27
10 Roma Roma 30 25 31 25
11 Hellas Verona Hellas 30 35 46 24
12 Sampdoria Sampdoria 30 21 32 24
13 Lazio Lazio 30 35 40 23
14 Ascoli Ascoli 30 19 34 23
15 Como Como 30 28 36 21
16 Cagliari Cagliari 30 25 52 19
TEMPORADA 1974/1975
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 49 19 43
2 Napoli Napoli 30 50 22 41
3 Roma Roma 30 27 15 39
4 Lazio Lazio 30 34 28 37
5 Milan Milan 30 37 22 36
6 Torino Torino 30 40 30 35
7 Bologna Bologna 30 36 33 32
8 Fiorentina Fiorentina 30 31 27 31
9 Inter Inter 30 26 26 30
10 Cagliari Cagliari 30 22 30 26
11 Cesena Cesena 30 23 35 25
12 Ascoli Ascoli 30 14 27 24
13 Sampdoria Sampdoria 30 21 35 24
14 Vicenza Vicenza 30 19 34 21
15 Ternana Calcio Ternana 30 19 42 19
16 Varese Varese 30 19 42 17
TEMPORADA 1973/1974
SERIE A
Equipo PJ GF GC Puntos
1 Lazio Lazio 30 45 23 43
2 Juventus Juventus 30 50 26 41
3 Napoli Napoli 30 35 28 36
4 Inter Inter 30 47 33 35
5 Torino Torino 30 27 24 34
6 Fiorentina Fiorentina 30 32 26 33
7 Milan Milan 30 34 36 30
8 Roma Roma 30 29 28 29
9 Bologna Bologna 30 35 36 29
10 Cagliari Cagliari 30 25 32 28
11 Cesena Cesena 30 25 28 27
12 Vicenza Vicenza 30 22 37 26
13 Sampdoria Sampdoria 30 27 34 20
14 Calcio Foggia Calcio 30 20 34 18
15 Genoa Genoa 30 16 37 17
16 Hellas Verona Hellas 30 28 35 0
TEMPORADA 1972/1973
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 45 22 45
2 Milan Milan 30 65 33 44
3 Lazio Lazio 30 33 16 43
4 Fiorentina Fiorentina 30 39 26 37
5 Inter Inter 30 32 23 37
6 Torino Torino 30 33 21 31
7 Bologna Bologna 30 33 31 31
8 Cagliari Cagliari 30 26 28 29
9 Napoli Napoli 30 18 20 28
10 Hellas Verona Hellas 30 28 34 26
11 Roma Roma 30 23 28 24
12 Sampdoria Sampdoria 30 16 25 24
13 Vicenza Vicenza 30 15 31 24
14 Atalanta Atalanta 30 16 33 24
15 Palermo FC Palermo FC 30 13 41 17
16 Ternana Calcio Ternana 30 14 37 16
TEMPORADA 1971/1972
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 48 24 43
2 Milan Milan 30 36 17 42
3 Torino Torino 30 39 25 42
4 Cagliari Cagliari 30 39 23 39
5 Inter Inter 30 49 28 36
6 Fiorentina Fiorentina 30 28 20 36
7 Roma Roma 30 37 31 35
8 Napoli Napoli 30 27 31 28
9 Sampdoria Sampdoria 30 23 28 28
10 Atalanta Atalanta 30 21 26 26
11 Bologna Bologna 30 28 36 25
12 Vicenza Vicenza 30 30 43 23
13 Hellas Verona Hellas 30 21 36 22
14 Mantova Mantova 30 23 39 21
15 Catanzaro Catanzaro 30 17 34 21
16 Varese Varese 30 17 42 13
TEMPORADA 1970/1971
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 30 50 26 46
2 Milan Milan 30 54 26 42
3 Napoli Napoli 30 33 19 39
4 Juventus Juventus 30 41 30 35
5 Bologna Bologna 30 30 24 34
6 Roma Roma 30 32 25 32
7 Cagliari Cagliari 30 33 35 30
8 Torino Torino 30 27 30 26
9 Varese Varese 30 29 33 26
10 Vicenza Vicenza 30 23 31 26
11 Hellas Verona Hellas 30 23 35 26
12 Sampdoria Sampdoria 30 30 34 25
13 Fiorentina Fiorentina 30 26 32 25
14 Calcio Foggia Calcio 30 28 43 25
15 Lazio Lazio 30 28 43 22
16 Catania Catania 30 18 39 21
TEMPORADA 1969/1970
SERIE A
Equipo PJ GF GC Puntos
1 Cagliari Cagliari 30 42 11 45
2 Inter Inter 30 41 19 41
3 Juventus Juventus 30 43 20 38
4 Milan Milan 30 38 24 36
5 Fiorentina Fiorentina 30 40 33 36
6 Napoli Napoli 30 24 21 31
7 Torino Torino 30 20 31 30
8 Lazio Lazio 30 33 32 29
9 Vicenza Vicenza 30 32 31 29
10 Bologna Bologna 30 22 24 28
11 Roma Roma 30 27 36 28
12 Hellas Verona Hellas 30 26 30 26
13 Sampdoria Sampdoria 30 22 37 24
14 Brescia Brescia 30 20 35 20
15 Palermo FC Palermo FC 30 23 45 20
16 SSC Bari SSC Bari 30 11 35 19
TEMPORADA 1968/1969
SERIE A
Equipo PJ GF GC Puntos
1 Fiorentina Fiorentina 30 38 18 45
2 Cagliari Cagliari 30 41 18 41
3 Milan Milan 30 31 12 41
4 Inter Inter 30 55 26 36
5 Juventus Juventus 30 32 24 35
6 Torino Torino 30 33 24 33
7 Napoli Napoli 30 26 25 32
8 Roma Roma 30 35 35 30
9 Bologna Bologna 30 27 36 29
10 Hellas Verona Hellas 30 40 49 26
11 Palermo FC Palermo FC 30 21 32 25
12 Sampdoria Sampdoria 30 21 27 23
13 Vicenza Vicenza 30 26 39 23
14 Varese Varese 30 20 43 22
15 Pisa SC Pisa SC 30 26 44 20
16 Atalanta Atalanta 30 25 45 19
TEMPORADA 1967/1968
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 30 53 24 46
2 Napoli Napoli 30 34 24 37
3 Juventus Juventus 30 33 29 36
4 Fiorentina Fiorentina 30 35 23 35
5 Inter Inter 30 46 34 33
6 Bologna Bologna 30 30 23 33
7 Torino Torino 30 44 31 32
8 Varese Varese 30 28 27 32
9 Cagliari Cagliari 30 44 38 31
10 Sampdoria Sampdoria 30 27 34 27
11 Roma Roma 30 25 35 27
12 Vicenza Vicenza 30 22 30 25
13 Atalanta Atalanta 30 26 42 25
14 SPAL SPAL 30 24 38 22
15 Brescia Brescia 30 20 35 22
16 Mantova Mantova 30 13 37 17
TEMPORADA 1966/1967
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 34 44 19 49
2 Inter Inter 34 59 22 48
3 Bologna Bologna 34 48 27 45
4 Napoli Napoli 34 46 23 44
5 Fiorentina Fiorentina 34 53 29 43
6 Cagliari Cagliari 34 35 17 40
7 Torino Torino 34 33 26 38
8 Milan Milan 34 36 32 37
9 Mantova Mantova 34 22 23 34
10 Roma Roma 34 35 39 33
11 Atalanta Atalanta 34 28 43 31
12 SPAL SPAL 34 28 36 29
13 Vicenza Vicenza 34 26 39 28
14 Brescia Brescia 34 22 40 28
15 Lazio Lazio 34 20 35 27
16 Calcio Foggia Calcio 34 28 49 24
17 Venezia Venezia 34 29 57 17
18 Lecco Lecco 34 21 57 17
TEMPORADA 1965/1966
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 34 70 28 50
2 Bologna Bologna 34 60 37 46
3 Napoli Napoli 34 44 27 45
4 Fiorentina Fiorentina 34 45 22 43
5 Juventus Juventus 34 38 23 42
6 Vicenza Vicenza 34 44 34 40
7 Milan Milan 34 43 33 38
8 Roma Roma 34 28 31 36
9 Brescia Brescia 34 43 44 32
10 Torino Torino 34 31 34 31
11 Cagliari Cagliari 34 36 37 30
12 Calcio Foggia Calcio 34 22 30 29
13 Lazio Lazio 34 28 41 29
14 Atalanta Atalanta 34 24 37 29
15 SPAL SPAL 34 38 45 28
16 Sampdoria Sampdoria 34 27 47 27
17 Catania Catania 34 24 56 22
18 Varese Varese 34 23 62 15
TEMPORADA 1964/1965
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 34 68 29 54
2 Milan Milan 34 52 23 51
3 Torino Torino 34 48 27 44
4 Juventus Juventus 34 43 24 41
5 Fiorentina Fiorentina 34 52 37 41
6 Bologna Bologna 34 43 42 34
7 Cagliari Cagliari 34 33 35 34
8 Catania Catania 34 46 51 32
9 Calcio Foggia Calcio 34 26 30 31
10 Roma Roma 34 29 35 31
11 Varese Varese 34 28 37 30
12 Vicenza Vicenza 34 33 44 30
13 Atalanta Atalanta 34 19 28 30
14 Sampdoria Sampdoria 34 19 30 29
15 Lazio Lazio 34 25 38 29
16 Genoa Genoa 34 30 46 28
17 ACR Messina ACR Messina 34 26 44 22
18 Mantova Mantova 34 20 40 21
TEMPORADA 1963/1964
SERIE A
Equipo PJ GF GC Puntos
1 Bologna Bologna 34 54 18 54
2 Inter Inter 34 54 21 54
3 Milan Milan 34 58 28 51
4 Fiorentina Fiorentina 34 43 27 38
5 Juventus Juventus 34 49 37 38
6 Vicenza Vicenza 34 34 36 36
7 Torino Torino 34 32 32 35
8 Genoa Genoa 34 33 35 30
9 Lazio Lazio 34 21 24 30
10 Catania Catania 34 32 44 30
11 Atalanta Atalanta 34 26 43 30
12 Roma Roma 34 43 44 29
13 Mantova Mantova 34 28 39 29
14 ACR Messina ACR Messina 34 25 46 28
15 Sampdoria Sampdoria 34 38 50 27
16 Modena Modena 34 29 42 27
17 SPAL SPAL 34 28 39 24
18 SSC Bari SSC Bari 34 21 43 22
TEMPORADA 1962/1963
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 34 56 20 49
2 Juventus Juventus 34 50 25 45
3 Milan Milan 34 53 27 43
4 Bologna Bologna 34 58 39 42
5 Roma Roma 34 57 32 40
6 Fiorentina Fiorentina 34 52 32 38
7 Vicenza Vicenza 34 35 35 36
8 Atalanta Atalanta 34 43 44 34
9 SPAL SPAL 34 36 38 34
10 Torino Torino 34 34 38 34
11 Sampdoria Sampdoria 34 41 50 30
12 Modena Modena 34 36 47 30
13 Mantova Mantova 34 34 46 30
14 Catania Catania 34 35 56 30
15 Genoa Genoa 34 32 48 28
16 Napoli Napoli 34 35 58 27
17 Venezia Venezia 34 36 51 22
18 Palermo FC Palermo FC 34 17 54 20
TEMPORADA 1961/1962
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 34 83 36 53
2 Inter Inter 34 59 31 48
3 Fiorentina Fiorentina 34 57 32 46
4 Bologna Bologna 34 57 41 45
5 Roma Roma 34 61 35 44
6 Atalanta Atalanta 34 38 37 38
7 Torino Torino 34 41 39 36
8 Palermo FC Palermo FC 34 30 35 35
9 Mantova Mantova 34 42 42 32
10 Sampdoria Sampdoria 34 32 40 30
11 Catania Catania 34 30 45 30
12 Venezia Venezia 34 35 41 29
13 Juventus Juventus 34 48 56 29
14 Vicenza Vicenza 34 29 43 27
15 SPAL SPAL 34 30 50 27
16 Padova Padova 34 29 49 23
17 Lecco Lecco 34 30 53 23
18 Udinese Udinese 34 37 63 17
TEMPORADA 1960/1961
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 34 80 42 49
2 Milan Milan 34 65 39 45
3 Inter Inter 34 73 39 44
4 Sampdoria Sampdoria 34 54 51 41
5 Roma Roma 34 58 46 39
6 Padova Padova 34 47 40 38
7 Fiorentina Fiorentina 34 46 34 37
8 Catania Catania 34 45 44 36
9 Atalanta Atalanta 34 35 41 31
10 Bologna Bologna 34 44 51 31
11 Vicenza Vicenza 34 35 46 31
12 Torino Torino 34 34 41 30
13 SPAL SPAL 34 39 50 30
14 Lecco Lecco 34 33 49 29
15 Udinese Udinese 34 39 53 29
16 SSC Bari SSC Bari 34 27 38 29
17 Napoli Napoli 34 30 47 25
18 Lazio Lazio 34 30 63 18
TEMPORADA 1959/1960
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 34 92 33 55
2 Fiorentina Fiorentina 34 68 31 47
3 Milan Milan 34 56 37 44
4 Inter Inter 34 55 43 40
5 Bologna Bologna 34 50 42 36
6 Padova Padova 34 50 46 36
7 SPAL SPAL 34 45 50 36
8 Sampdoria Sampdoria 34 41 46 35
9 Roma Roma 34 53 53 34
10 Vicenza Vicenza 34 39 42 32
11 Atalanta Atalanta 34 31 39 31
12 Lazio Lazio 34 32 45 30
13 SSC Bari SSC Bari 34 32 42 29
14 Napoli Napoli 34 33 48 29
15 Udinese Udinese 34 39 54 28
16 Palermo FC Palermo FC 34 27 40 27
17 US Alessandria Alessandria 34 28 51 25
18 Genoa Genoa 34 21 50 0
TEMPORADA 1958/1959
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 34 84 32 52
2 Fiorentina Fiorentina 34 95 35 49
3 Inter Inter 34 77 41 46
4 Juventus Juventus 34 74 51 42
5 Sampdoria Sampdoria 34 50 44 38
6 Roma Roma 34 57 41 35
7 Vicenza Vicenza 34 41 41 34
8 Padova Padova 34 50 52 34
9 Napoli Napoli 34 39 50 34
10 Bologna Bologna 34 47 53 31
11 SSC Bari SSC Bari 34 38 49 30
12 Lazio Lazio 34 37 54 30
13 Genoa Genoa 34 44 62 30
14 US Alessandria Alessandria 34 33 57 28
15 Udinese Udinese 34 32 59 27
16 SPAL SPAL 34 29 48 26
17 Triestina Triestina 34 34 56 23
18 Torino Torino 34 36 72 23

  USO DE MEMORIA  
8,247,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.2880
Total Execution Time  0.2898
  CADENA URL  
/historico/Milan/1978
  GET DATOS  
$_GET['/historico/Milan/1978']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0045  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 = 'Milan' AND l.year = 1978 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=1692 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=1692 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=1692 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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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 = 5583
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 = 59489
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 = 11058
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1692 AND type_rel = 2
0.0069  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1692 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026  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 (1257629,1250956,1313016,1312942,1312783) ORDER BY n.cover_points DESC, update_date DESC
0.0056  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 = '1692' AND l.year = 1978 ORDER BY l.year DESC,cat.coefficient DESC
0.0064  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 = '1692' 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 = 59489 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 11058 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 = 5583 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0100  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=1692 AND l.year in (1977,1978,1979) 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 (59497,11058,10945,5584) 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.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 5584 AND teamId = 1692
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 10945 AND teamId = 1692
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 59497 AND teamId = 1692
0.0065  SELECT count(id) as num_players from rel_players WHERE league_id = 11058 AND teamId = 1692
0.0031  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1978` 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 = 5583 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0061  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 events1978 e ON e.player_id = p.id AND e.league_id = 5583 WHERE rp.league_id = 5583 AND rp.teamId = 1692 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.0058  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 events1978 e ON e.player_id = p.id AND e.league_id = 5583 WHERE rp.league_id = 5583 AND rp.teamId = 1692 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0052  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 events1978 e ON e.player_id = p.id AND e.league_id = 5583 WHERE rp.league_id = 5583 AND rp.teamId = 1692 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 1692 AND l.year <= 1978 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030  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 `tables1978` 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 = 5583 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1977` 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 = 5582 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1976` 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 = 5581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1975` 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 = 5580 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1974` 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 = 5579 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1973` 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 = 5578 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1972` 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 = 5577 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1971` 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 = 5576 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1969` 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 = 5574 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables1968` 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 = 5573 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1967` 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 = 5572 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0706  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 `tables1966` 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 = 5571 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 `tables1965` 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 = 5570 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables1964` 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 = 5569 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables1963` 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 = 5568 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1962` 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 = 5567 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables1961` 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 = 5566 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables1960` 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 = 5565 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables1959` 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 = 5564 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 5583 ORDER BY nameShow LIMIT 100