4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1985/1986
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 43 17 45
2 Roma Roma 30 51 27 41
3 Napoli Napoli 30 35 21 39
4 Torino Torino 30 31 26 33
5 Fiorentina Fiorentina 30 29 23 33
6 Inter Inter 30 36 33 32
7 Milan Milan 30 26 24 31
8 Atalanta Atalanta 30 27 26 29
9 Como Como 30 32 32 29
10 Hellas Verona Hellas 30 31 40 28
11 Avellino Avellino 30 28 38 27
12 Sampdoria Sampdoria 30 27 25 27
13 Udinese Udinese 30 31 37 25
14 Pisa SC Pisa SC 30 27 40 23
15 SSC Bari SSC Bari 30 18 31 22
16 Lecce Lecce 30 23 55 16
TEMPORADA 1984/1985
SERIE A
Equipo PJ GF GC Puntos
1 Hellas Verona Hellas 30 42 19 43
2 Torino Torino 30 36 22 39
3 Inter Inter 30 42 28 38
4 Sampdoria Sampdoria 30 36 21 37
5 Milan Milan 30 31 25 36
6 Juventus Juventus 30 48 33 36
7 Roma Roma 30 33 25 34
8 Napoli Napoli 30 34 29 33
9 Fiorentina Fiorentina 30 33 31 29
10 Atalanta Atalanta 30 20 32 28
11 Como Como 30 17 27 25
12 Udinese Udinese 30 43 46 25
13 Avellino Avellino 30 27 33 25
14 Ascoli Ascoli 30 24 40 22
15 Lazio Lazio 30 16 45 15
16 Cremonese Cremonese 30 22 48 15
TEMPORADA 1983/1984
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 57 29 43
2 Roma Roma 30 48 28 41
3 Fiorentina Fiorentina 30 48 31 36
4 Inter Inter 30 37 23 35
5 Torino Torino 30 37 30 33
6 Hellas Verona Hellas 30 43 35 32
7 Sampdoria Sampdoria 30 36 30 32
8 Milan Milan 30 37 40 32
9 Udinese Udinese 30 47 40 31
10 Ascoli Ascoli 30 29 35 29
11 Avellino Avellino 30 33 39 26
12 Napoli Napoli 30 28 38 26
13 Lazio Lazio 30 35 49 25
14 Genoa Genoa 30 24 36 25
15 Pisa SC Pisa SC 30 20 35 22
16 Catania Catania 30 14 55 12
TEMPORADA 1982/1983
SERIE B
Equipo PJ GF GC Puntos
1 Milan Milan 38 77 36 73
2 Lazio Lazio 38 44 32 60
3 Catania Catania 38 37 21 59
4 Cremonese Cremonese 38 42 28 58
5 Como Como 38 36 24 58
6 Cavese 1919 Cavese 1919 38 38 37 54
7 AC Monza AC Monza 38 40 42 51
8 Atalanta Atalanta 38 30 27 47
9 Sambenedettese Sambenedette 38 33 32 47
10 Perugia Perugia 38 36 37 47
11 Varese Varese 38 31 37 46
12 SS Arezzo SS Arezzo 38 30 38 46
13 Città di Campobasso Città 38 26 34 45
14 Palermo FC Palermo FC 38 36 46 45
15 Lecce Lecce 38 33 44 44
16 Pistoiese Pistoiese 38 33 34 41
17 Bologna Bologna 38 31 47 41
18 SSC Bari SSC Bari 38 30 46 39
19 Reggiana Reggiana 38 39 49 38
20 Calcio Foggia Calcio 38 24 35 38
TEMPORADA 1981/1982
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 30 48 14 46
2 Fiorentina Fiorentina 30 36 17 45
3 Roma Roma 30 40 29 38
4 Napoli Napoli 30 31 21 35
5 Inter Inter 30 39 34 35
6 Ascoli Ascoli 30 26 21 32
7 Catanzaro Catanzaro 30 25 29 28
8 Avellino Avellino 30 22 26 27
9 Torino Torino 30 25 30 27
10 Cesena Cesena 30 34 41 27
11 Udinese Udinese 30 27 37 26
12 Cagliari Cagliari 30 33 36 25
13 Genoa Genoa 30 24 29 25
14 Milan Milan 30 21 31 24
15 Bologna Bologna 30 25 37 23
16 Como Como 30 18 42 17
TEMPORADA 1980/1981
SERIE B
Equipo PJ GF GC Puntos
1 Milan Milan 38 49 29 68
2 Genoa Genoa 38 47 29 65
3 Cesena Cesena 38 44 26 64
4 Lazio Lazio 38 50 32 59
5 Pescara Pescara 38 35 38 55
6 Sampdoria Sampdoria 38 39 33 54
7 SSC Bari SSC Bari 38 40 41 50
8 Pisa SC Pisa SC 38 35 37 49
9 Palermo FC Palermo FC 38 35 33 48
10 Lecce Lecce 38 33 40 47
11 Rimini Rimini 38 40 42 46
12 Catania Catania 38 38 50 46
13 SPAL SPAL 38 45 46 45
14 Varese Varese 38 41 43 45
15 Taranto Taranto 38 29 32 45
16 Calcio Foggia Calcio 38 32 38 44
17 Vicenza Vicenza 38 34 40 41
18 Hellas Verona Hellas 38 24 28 40
19 Atalanta Atalanta 38 28 40 39
20 AC Monza AC Monza 38 24 45 29
TEMPORADA 1979/1980
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 30 44 25 41
2 Juventus Juventus 30 42 25 38
3 Torino Torino 30 26 15 35
4 Ascoli Ascoli 30 35 28 34
5 Fiorentina Fiorentina 30 33 27 33
6 Roma Roma 30 34 35 32
7 Bologna Bologna 30 23 24 30
8 Cagliari Cagliari 30 27 29 30
9 Perugia Perugia 30 27 32 30
10 Napoli Napoli 30 20 20 28
11 Avellino Avellino 30 24 32 27
12 Catanzaro Catanzaro 30 20 34 24
13 Udinese Udinese 30 24 38 21
14 Pescara Pescara 30 18 44 16
15 Milan Milan 30 34 19 0
16 Lazio Lazio 30 21 25 0
TEMPORADA 1978/1979
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 30 46 19 44
2 Perugia Perugia 30 34 16 41
3 Juventus Juventus 30 40 23 37
4 Inter Inter 30 38 24 36
5 Torino Torino 30 35 23 36
6 Napoli Napoli 30 23 21 32
7 Fiorentina Fiorentina 30 26 26 32
8 Lazio Lazio 30 35 40 29
9 Catanzaro Catanzaro 30 23 30 28
10 Ascoli Ascoli 30 26 31 26
11 Avellino Avellino 30 19 26 26
12 Roma Roma 30 24 32 26
13 Bologna Bologna 30 23 30 24
14 Vicenza Vicenza 30 29 42 24
15 Atalanta Atalanta 30 20 33 24
16 Hellas Verona Hellas 30 14 39 15
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

  USO DE MEMORIA  
8,303,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2034
Total Execution Time  0.2046
  CADENA URL  
/historico/Milan/1986
  GET DATOS  
$_GET['/historico/Milan/1986']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0082  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 = 1986 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.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=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.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=1692 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=1692 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 5591
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 = 22707
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 = 56542
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1692 AND type_rel = 2
0.0086  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.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 (1257629,1250956,1313016,1312942,1312783) ORDER BY n.cover_points DESC, update_date DESC
0.0042  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 = 1986 ORDER BY l.year DESC,cat.coefficient DESC
0.0078  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 = 56542 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 = 5591 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0044  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 (1985,1986,1987) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72423,56542,53545,10952) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 53545 AND teamId = 1692
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 10952 AND teamId = 1692
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 56542 AND teamId = 1692
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72423 AND teamId = 1692
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 FROM `tables1986` 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 = 5591 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032  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 events1986 e ON e.player_id = p.id AND e.league_id = 5591 WHERE rp.league_id = 5591 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.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 events1986 e ON e.player_id = p.id AND e.league_id = 5591 WHERE rp.league_id = 5591 AND rp.teamId = 1692 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 events1986 e ON e.player_id = p.id AND e.league_id = 5591 WHERE rp.league_id = 5591 AND rp.teamId = 1692 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0047  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 <= 1986 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1986` 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 = 5591 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 `tables1985` 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 = 5590 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 `tables1984` 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 = 5589 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 `tables1983` 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 = 30855 AND t.round = 38 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 `tables1982` 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 = 5587 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 `tables1981` 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 = 30853 AND t.round = 38 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 `tables1980` 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 = 5585 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 `tables1979` 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 = 5584 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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `tables1970` 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 = 5575 AND t.round = 30 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 `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.0053  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.0054  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.0030  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 = 5591 ORDER BY nameShow LIMIT 100