4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2004/2005
SERIE B
Equipo PJ GF GC Puntos
1 Genoa Genoa 42 72 44 76
2 Empoli Empoli 42 58 36 74
3 Perugia Perugia 42 56 34 74
4 Torino Torino 42 49 31 74
5 Treviso Treviso 42 58 48 64
6 Modena Modena 42 47 37 62
7 Ascoli Ascoli 42 51 52 62
8 Hellas Verona Hellas 42 60 47 61
9 Ternana Calcio Ternana 42 51 54 57
10 SSC Bari SSC Bari 42 41 37 56
11 Piacenza Piacenza 42 44 46 56
12 AlbinoLeffe AlbinoLeffe 42 55 51 55
13 Catania Catania 42 42 44 55
14 Crotone Crotone 42 48 45 53
15 SS Arezzo SS Arezzo 42 51 52 51
16 Salernitana Salernitana 42 50 57 51
17 Cesena Cesena 42 47 61 50
18 Vicenza Vicenza 42 59 67 49
19 Triestina Triestina 42 43 54 48
20 Pescara Pescara 42 43 61 46
21 Venezia Venezia 42 33 58 35
22 Catanzaro Catanzaro 42 40 82 26
TEMPORADA 2003/2004
SERIE B
Equipo PJ GF GC Puntos
1 Palermo FC Palermo FC 47 78 39 86
2 Cagliari Cagliari 47 83 52 86
3 ACR Messina ACR Messina 47 74 46 82
4 Livorno Livorno 46 75 45 79
5 Atalanta Atalanta 46 59 36 77
6 Fiorentina Fiorentina 47 54 51 73
7 Ternana Calcio Ternana 46 64 52 69
8 Piacenza Piacenza 46 50 47 68
9 Catania Catania 46 53 53 67
10 Triestina Triestina 46 50 50 64
11 Ascoli Ascoli 46 54 54 60
12 Torino Torino 47 58 57 59
13 Napoli Napoli 47 35 43 57
14 Vicenza Vicenza 46 48 51 56
15 Treviso Treviso 46 48 51 55
16 Genoa Genoa 46 57 62 55
17 AlbinoLeffe AlbinoLeffe 47 47 59 55
18 Salernitana Salernitana 46 36 53 55
19 Hellas Verona Hellas 46 54 65 53
20 Venezia Venezia 46 40 57 51
21 SSC Bari SSC Bari 47 50 66 50
22 Pescara Pescara 46 46 69 46
23 Avellino Avellino 46 51 69 37
24 Como Como 46 34 71 33
TEMPORADA 2002/2003
SERIE B
Equipo PJ GF GC Puntos
1 Siena Siena 38 47 25 68
2 Sampdoria Sampdoria 38 53 31 67
3 Lecce Lecce 38 46 33 63
4 Ancona Ancona 38 53 40 61
5 Triestina Triestina 38 54 46 58
6 Palermo FC Palermo FC 38 45 42 58
7 Ternana Calcio Ternana 38 45 37 55
8 Vicenza Vicenza 38 55 50 54
9 Cagliari Cagliari 38 47 46 54
10 Livorno Livorno 38 48 43 49
11 SSC Bari SSC Bari 38 38 37 49
12 Ascoli Ascoli 38 46 52 48
13 Hellas Verona Hellas 38 42 42 46
14 ACR Messina ACR Messina 38 51 54 46
15 Napoli Napoli 38 42 49 45
16 Venezia Venezia 38 39 49 45
17 Catania Catania 38 46 59 44
18 Genoa Genoa 38 47 51 39
19 Cosenza Calcio Cosenza 38 29 52 36
20 Salernitana Salernitana 38 28 63 23
TEMPORADA 2001/2002
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Ascoli Ascoli 34 55 26 67
2 Taranto Taranto 34 50 30 62
3 Catania Catania 34 44 26 58
4 Pescara Pescara 34 48 29 53
5 Real Giulianova Real 34 44 31 51
6 Virtus Lanciano Virtus 34 36 30 51
7 Avellino Avellino 35 40 43 48
8 Chieti Chieti 34 28 27 47
9 Fermana Fermana 34 32 33 46
10 L'Aquila L'Aquila 35 33 46 46
11 Viterbese Viterbese 34 33 35 44
12 Sassari Torres Sassari 34 41 35 43
13 Vis Pesaro Vis Pesaro 34 32 32 43
14 Castel Sangro Castel 34 27 37 39
15 Benevento Benevento 34 27 38 39
16 Nocerina Nocerina 34 32 59 30
17 Sora Sora 34 21 39 29
18 Lodigiani Lodigiani 34 24 51 23
TEMPORADA 2000/2001
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Palermo FC Palermo FC 34 47 31 64
2 ACR Messina ACR Messina 34 40 26 61
3 Catania Catania 34 49 40 58
4 Avellino Avellino 34 45 27 57
5 Ascoli Ascoli 34 47 33 54
6 Sassari Torres Sassari 34 55 45 53
7 Castel Sangro Castel 34 44 40 47
8 L'Aquila L'Aquila 34 37 35 46
9 Fermana Fermana 34 41 38 42
10 Real Giulianova Real 34 36 40 42
11 Vis Pesaro Vis Pesaro 34 26 29 39
12 Lodigiani Lodigiani 34 34 44 39
13 Benevento Benevento 34 40 54 39
14 Nocerina Nocerina 34 29 42 36
15 Viterbese Viterbese 34 32 48 29
16 Atl. Catania Atl. Catania 34 27 44 27
TEMPORADA 1999/2000
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Crotone Crotone 34 65 28 69
2 Ancona Ancona 34 50 28 62
3 Ascoli Ascoli 34 53 30 56
4 Viterbese Viterbese 34 45 38 53
5 SS Arezzo SS Arezzo 34 48 36 52
6 Palermo FC Palermo FC 34 30 23 52
7 Catania Catania 34 39 31 49
8 Nocerina Nocerina 34 27 26 45
9 Avellino Avellino 34 34 33 44
10 Real Giulianova Real 34 36 42 43
11 Juve Stabia Juve Stabia 34 38 40 41
12 Benevento Benevento 34 29 33 41
13 Castel Sangro Castel 34 29 36 41
14 Lodigiani Lodigiani 34 38 46 41
15 Fidelis Andria Fidelis 34 30 43 34
16 Gualdo Gualdo 34 34 46 33
17 Atl. Catania Atl. Catania 34 25 51 25
18 Marsala Marsala 34 25 65 25
TEMPORADA 1994/1995
SERIE B
Equipo PJ GF GC Puntos
1 Piacenza Piacenza 38 55 27 71
2 Udinese Udinese 38 63 35 70
3 Vicenza Vicenza 38 54 26 68
4 Atalanta Atalanta 38 49 36 66
5 Salernitana Salernitana 38 57 40 61
6 Ancona Ancona 38 55 50 58
7 Perugia Perugia 38 47 35 54
8 Cosenza Calcio Cosenza 38 38 35 51
9 Cesena Cesena 38 44 43 51
10 Venezia Venezia 38 46 44 50
11 Hellas Verona Hellas 38 40 40 48
12 Pescara Pescara 38 50 63 46
13 Palermo FC Palermo FC 38 33 35 44
14 Chievo Chievo 38 35 38 44
15 Fidelis Andria Fidelis 38 36 41 44
16 Lucchese Libertas Lucchese 38 49 54 42
17 Acireale Acireale 38 27 42 41
18 Ascoli Ascoli 38 27 57 34
19 Como Como 38 25 58 33
20 Lecce Lecce 38 36 67 24
TEMPORADA 1993/1994
SERIE B
Equipo PJ GF GC Puntos
1 Fiorentina Fiorentina 38 53 19 67
2 Cesena Cesena 38 49 48 60
3 SSC Bari SSC Bari 38 49 27 59
4 Brescia Brescia 38 68 53 59
5 Padova Padova 38 37 29 54
6 Venezia Venezia 38 43 40 53
7 Ascoli Ascoli 38 38 38 53
8 Ancona Ancona 38 46 43 50
9 Pescara Pescara 38 50 54 50
10 Hellas Verona Hellas 38 36 42 48
11 Palermo FC Palermo FC 38 32 38 48
12 Fidelis Andria Fidelis 38 28 28 47
13 Cosenza Calcio Cosenza 38 30 38 47
14 Vicenza Vicenza 38 30 33 46
15 Lucchese Libertas Lucchese 38 34 35 45
16 Pisa SC Pisa SC 38 36 40 45
17 Acireale Acireale 38 32 39 43
18 Ravenna FC Ravenna FC 38 36 47 39
19 Modena Modena 38 29 45 39
20 AC Monza AC Monza 38 27 47 28
TEMPORADA 1992/1993
SERIE B
Equipo PJ GF GC Puntos
1 Reggiana Reggiana 38 41 16 71
2 Cremonese Cremonese 38 63 35 70
3 Piacenza Piacenza 38 42 26 65
4 Padova Padova 38 45 35 64
5 Lecce Lecce 38 45 38 63
6 Ascoli Ascoli 38 57 35 62
7 Cosenza Calcio Cosenza 38 37 27 57
8 Pisa SC Pisa SC 38 25 26 53
9 SSC Bari SSC Bari 38 43 44 52
10 Cesena Cesena 38 37 35 50
11 Venezia Venezia 38 41 41 47
12 Hellas Verona Hellas 38 30 34 45
13 Modena Modena 38 34 43 43
14 Lucchese Libertas Lucchese 38 35 38 39
15 AC Monza AC Monza 38 24 31 39
16 SPAL SPAL 38 30 42 39
17 Bologna Bologna 38 38 55 39
18 Fidelis Andria Fidelis 38 27 34 38
19 Taranto Taranto 38 30 51 33
20 Ternana Calcio Ternana 38 25 63 22
TEMPORADA 1991/1992
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 34 74 21 56
2 Juventus Juventus 34 45 22 48
3 Torino Torino 34 42 20 43
4 Napoli Napoli 34 56 40 42
5 Roma Roma 34 37 31 40
6 Sampdoria Sampdoria 34 38 31 38
7 Parma Parma 34 32 28 38
8 Inter Inter 34 28 28 37
9 Calcio Foggia Calcio 34 58 58 35
10 Lazio Lazio 34 43 40 34
11 Atalanta Atalanta 34 31 33 34
12 Fiorentina Fiorentina 34 44 41 32
13 Cagliari Cagliari 34 30 34 29
14 Genoa Genoa 34 35 47 29
15 SSC Bari SSC Bari 34 26 47 22
16 Hellas Verona Hellas 34 24 57 21
17 Cremonese Cremonese 34 27 49 20
18 Ascoli Ascoli 34 25 68 14
TEMPORADA 1990/1991
SERIE B
Equipo PJ GF GC Puntos
1 Calcio Foggia Calcio 38 67 36 72
2 Hellas Verona Hellas 38 42 29 60
3 Udinese Udinese 38 53 43 56
4 Ascoli Ascoli 38 48 34 55
5 Cremonese Cremonese 38 28 21 55
6 Padova Padova 38 41 36 54
7 Reggiana Reggiana 38 52 45 51
8 Lucchese Libertas Lucchese 38 29 30 50
9 Ancona Ancona 38 38 43 48
10 Taranto Taranto 38 28 33 47
11 Avellino Avellino 38 27 36 47
12 Cosenza Calcio Cosenza 38 38 50 47
13 Modena Modena 38 35 35 46
14 Brescia Brescia 38 29 32 46
15 ACR Messina ACR Messina 38 34 45 46
16 Pescara Pescara 38 36 32 45
17 Salernitana Salernitana 38 29 38 43
18 Reggina Reggina 38 29 37 37
19 Triestina Triestina 38 33 43 37
20 Barletta Barletta 38 29 47 36
TEMPORADA 1989/1990
SERIE A
Equipo PJ GF GC Puntos
1 Napoli Napoli 34 57 31 51
2 Milan Milan 34 56 27 49
3 Inter Inter 34 55 32 44
4 Juventus Juventus 34 56 36 44
5 Sampdoria Sampdoria 34 46 26 43
6 Roma Roma 34 45 40 41
7 Atalanta Atalanta 34 36 43 35
8 Bologna Bologna 34 29 36 34
9 Lazio Lazio 34 34 33 31
10 SSC Bari SSC Bari 34 34 37 31
11 Genoa Genoa 34 27 31 29
12 Fiorentina Fiorentina 34 41 42 28
13 Cesena Cesena 34 26 36 28
14 Lecce Lecce 34 29 46 28
15 Udinese Udinese 34 37 51 27
16 Hellas Verona Hellas 34 27 44 25
17 Cremonese Cremonese 34 29 50 23
18 Ascoli Ascoli 34 20 43 21
TEMPORADA 1988/1989
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 34 67 19 58
2 Napoli Napoli 34 57 28 47
3 Milan Milan 34 61 25 46
4 Juventus Juventus 34 51 36 43
5 Sampdoria Sampdoria 34 43 25 39
6 Atalanta Atalanta 34 37 32 36
7 Fiorentina Fiorentina 34 44 43 34
8 Roma Roma 34 33 40 34
9 Lecce Lecce 34 25 35 31
10 Lazio Lazio 34 23 32 29
11 Hellas Verona Hellas 34 18 27 29
12 Ascoli Ascoli 34 30 41 29
13 Cesena Cesena 34 24 39 29
14 Bologna Bologna 34 26 43 29
15 Torino Torino 34 37 49 27
16 Pescara Pescara 34 28 43 27
17 Pisa SC Pisa SC 34 17 39 23
18 Como Como 34 24 49 22
TEMPORADA 1987/1988
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 30 44 12 47
2 Napoli Napoli 30 53 28 40
3 Sampdoria Sampdoria 30 41 30 37
4 Roma Roma 30 37 27 36
5 Inter Inter 30 42 35 32
6 Juventus Juventus 30 35 30 31
7 Torino Torino 30 33 30 31
8 Fiorentina Fiorentina 30 29 33 28
9 Pisa SC Pisa SC 30 24 28 26
10 Cesena Cesena 30 23 32 26
11 Hellas Verona Hellas 30 23 30 25
12 Como Como 30 22 37 25
13 Ascoli Ascoli 30 30 37 24
14 Pescara Pescara 30 27 44 24
15 Avellino Avellino 30 19 39 23
16 Empoli Empoli 30 20 30 20
TEMPORADA 1986/1987
SERIE A
Equipo PJ GF GC Puntos
1 Napoli Napoli 30 41 21 42
2 Juventus Juventus 30 42 27 39
3 Inter Inter 30 32 17 38
4 Hellas Verona Hellas 30 36 25 36
5 Milan Milan 30 31 21 35
6 Sampdoria Sampdoria 30 37 21 35
7 Roma Roma 30 37 31 33
8 Avellino Avellino 30 31 38 30
9 Como Como 30 16 20 26
10 Fiorentina Fiorentina 30 30 35 26
11 Torino Torino 30 26 32 26
12 Ascoli Ascoli 30 18 33 24
13 Empoli Empoli 30 13 33 23
14 Brescia Brescia 30 25 35 22
15 Atalanta Atalanta 30 22 32 21
16 Udinese Udinese 30 25 41 15
TEMPORADA 1985/1986
SERIE B
Equipo PJ GF GC Puntos
1 Ascoli Ascoli 38 56 33 67
2 Brescia Brescia 38 41 28 64
3 Vicenza Vicenza 38 48 33 62
4 Triestina Triestina 38 40 30 60
5 Empoli Empoli 38 32 28 58
6 Bologna Bologna 38 37 29 56
7 Genoa Genoa 38 35 31 54
8 Cesena Cesena 38 42 38 51
9 Catania Catania 38 30 37 48
10 Cagliari Cagliari 38 27 38 48
11 Cremonese Cremonese 38 35 31 47
12 Lazio Lazio 38 38 42 47
13 Città di Campobasso Città 38 30 36 46
14 Sambenedettese Sambenedette 38 26 26 45
15 SS Arezzo SS Arezzo 38 37 40 45
16 Pescara Pescara 38 33 37 43
17 Palermo FC Palermo FC 38 27 35 41
18 Perugia Perugia 38 29 39 40
19 Catanzaro Catanzaro 38 33 45 39
20 AC Monza AC Monza 38 25 45 32
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 A
Equipo PJ GF GC Puntos
1 Roma Roma 30 47 24 43
2 Juventus Juventus 30 49 26 39
3 Inter Inter 30 40 23 38
4 Hellas Verona Hellas 30 37 31 35
5 Fiorentina Fiorentina 30 36 25 34
6 Udinese Udinese 30 25 29 32
7 Sampdoria Sampdoria 30 31 30 31
8 Torino Torino 30 30 28 30
9 Avellino Avellino 30 29 34 28
10 Napoli Napoli 30 22 29 28
11 Genoa Genoa 30 34 38 27
12 Pisa SC Pisa SC 30 27 27 27
13 Ascoli Ascoli 30 32 37 27
14 Cagliari Cagliari 30 23 33 26
15 Cesena Cesena 30 22 35 22
16 Catanzaro Catanzaro 30 21 56 13
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

  USO DE MEMORIA  
8,353,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.9274
Total Execution Time  0.9286
  CADENA URL  
/historico/Ascoli/2005
  GET DATOS  
$_GET['/historico/Ascoli/2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0240  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 = 'Ascoli' AND l.year = 2005 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.0155  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=290 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0156  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=290 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0157  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=290 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  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=290 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0306  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 = 509
0.0179  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 = 14117
0.0172  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 = 10621
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=290 AND type_rel = 2
0.0161  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 290 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0160  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 (94809,112005,159579,158208,159350) ORDER BY n.cover_points DESC, update_date DESC
0.0197  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 = '290' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0161  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 = '290' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 14117 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 10621 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0171  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=290 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0155  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 (14128,10621,510,35) 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.0180  SELECT count(id) as num_players from rel_players WHERE league_id = 35 AND teamId = 290
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 510 AND teamId = 290
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 14128 AND teamId = 290
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 10621 AND teamId = 290
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 509 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0169  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 events2005 e ON e.player_id = p.id AND e.league_id = 509 WHERE rp.league_id = 509 AND rp.teamId = 290 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.0179  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 events2005 e ON e.player_id = p.id AND e.league_id = 509 WHERE rp.league_id = 509 AND rp.teamId = 290 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0188  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 events2005 e ON e.player_id = p.id AND e.league_id = 509 WHERE rp.league_id = 509 AND rp.teamId = 290 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172  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 = 290 AND l.year <= 2005 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 509 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 510 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 511 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 589 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 591 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables2000` 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 = 19804 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1995` 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 = 22417 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables1994` 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 = 30866 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` 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 = 5597 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables1991` 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 = 30863 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables1990` 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 = 5595 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1989` 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 = 5594 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables1988` 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 = 5593 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172  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 `tables1987` 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 = 5592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 30858 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0524  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.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 5588 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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