4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2007/2008
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Sassuolo Sassuolo 34 46 32 63
2 Cremonese Cremonese 34 50 36 60
3 Cittadella Cittadella 34 52 34 58
4 Foligno Calcio Foligno 34 38 30 57
5 Calcio Foggia Calcio 34 47 34 56
6 Padova Padova 34 57 37 55
7 AC Legnano AC Legnano 34 42 34 48
8 AC Monza AC Monza 34 38 35 46
9 Novara Novara 34 44 52 46
10 Venezia Venezia 34 37 40 44
11 Pro Sesto Pro Sesto 34 42 45 43
12 Cavese 1919 Cavese 1919 34 41 42 42
13 Ternana Calcio Ternana 34 33 39 41
14 Pro Patria Pro Patria 34 33 35 38
15 Lecco Lecco 34 28 45 33
16 Paganese Paganese 34 26 41 32
17 Hellas Verona Hellas 34 24 41 31
18 SS Manfredonia Calcio Manfredonia 34 24 50 31
TEMPORADA 2006/2007
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Ravenna FC Ravenna FC 34 50 30 69
2 Avellino Avellino 34 64 37 68
3 Cavese 1919 Cavese 1919 34 46 30 62
4 Calcio Foggia Calcio 34 41 25 59
5 Taranto Taranto 34 44 30 56
6 Perugia Perugia 34 40 29 54
7 Juve Stabia Juve Stabia 34 34 27 53
8 Sambenedettese Sambenedette 34 45 45 49
9 SS Manfredonia Calcio Manfredonia 34 41 43 46
10 Salernitana Salernitana 34 37 41 44
11 Gallipoli Gallipoli 34 41 48 44
12 Ternana Calcio Ternana 34 30 36 39
13 Virtus Lanciano Virtus 34 26 33 39
14 Teramo Teramo 34 27 39 37
15 Martina Martina 34 27 40 37
16 Ancona Ancona 34 37 49 33
17 San Marino Calcio Marino 34 37 43 32
18 Real Giulianova Real 34 18 60 12
TEMPORADA 2005/2006
SERIE B
Equipo PJ GF GC Puntos
1 Atalanta Atalanta 42 61 39 81
2 Catania Catania 42 67 42 78
3 Torino Torino 42 51 31 76
4 Mantova Mantova 42 46 35 69
5 Modena Modena 42 59 41 67
6 Cesena Cesena 42 66 54 66
7 SS Arezzo SS Arezzo 42 45 34 66
8 Bologna Bologna 42 55 42 64
9 Crotone Crotone 42 56 48 63
10 Brescia Brescia 42 54 44 60
11 Piacenza Piacenza 42 56 52 54
12 Pescara Pescara 42 41 50 54
13 SSC Bari SSC Bari 42 43 47 51
14 Triestina Triestina 42 44 51 51
15 Hellas Verona Hellas 42 42 41 49
16 Vicenza Vicenza 42 38 49 49
17 Rimini Rimini 42 42 49 48
18 AlbinoLeffe AlbinoLeffe 42 38 52 46
19 Avellino Avellino 42 42 62 46
20 Ternana Calcio Ternana 42 36 58 39
21 Cremonese Cremonese 42 36 60 30
22 Catanzaro Catanzaro 42 26 63 28
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 B
Equipo PJ GF GC Puntos
1 Como Como 38 53 35 74
2 Modena Modena 38 58 23 72
3 Reggina Reggina 38 50 33 68
4 Empoli Empoli 38 60 35 67
5 Napoli Napoli 38 48 39 61
6 Salernitana Salernitana 38 57 59 53
7 SSC Bari SSC Bari 38 44 51 53
8 Ancona Ancona 38 43 52 50
9 Vicenza Vicenza 38 50 52 49
10 Sampdoria Sampdoria 38 42 46 48
11 Palermo FC Palermo FC 38 47 54 48
12 Genoa Genoa 38 43 40 47
13 Cagliari Cagliari 38 39 39 47
14 ACR Messina ACR Messina 38 41 42 47
15 Siena Siena 38 35 44 47
16 Cosenza Calcio Cosenza 38 47 57 47
17 Ternana Calcio Ternana 38 46 49 45
18 Cittadella Cittadella 38 49 63 37
19 Pistoiese Pistoiese 38 38 51 36
20 Crotone Crotone 38 44 70 25
TEMPORADA 2000/2001
SERIE B
Equipo PJ GF GC Puntos
1 Torino Torino 38 48 33 73
2 Piacenza Piacenza 38 48 26 70
3 Chievo Chievo 38 54 34 70
4 Venezia Venezia 38 62 43 69
5 Sampdoria Sampdoria 38 60 38 64
6 Empoli Empoli 38 52 43 64
7 Ternana Calcio Ternana 38 59 38 62
8 Cosenza Calcio Cosenza 38 49 46 60
9 Crotone Crotone 38 47 53 53
10 Ancona Ancona 38 56 58 51
11 Cagliari Cagliari 38 53 45 50
12 Genoa Genoa 38 44 39 47
13 Siena Siena 38 38 43 47
14 Salernitana Salernitana 38 37 42 43
15 Cittadella Cittadella 38 39 52 43
16 Pistoiese Pistoiese 38 46 50 42
17 Treviso Treviso 38 40 56 36
18 AC Monza AC Monza 38 41 77 31
19 Ravenna FC Ravenna FC 38 33 64 25
20 Pescara Pescara 38 30 56 22
TEMPORADA 1999/2000
SERIE B
Equipo PJ GF GC Puntos
1 Vicenza Vicenza 38 69 45 67
2 Atalanta Atalanta 38 51 34 63
3 Brescia Brescia 38 54 38 63
4 Napoli Napoli 38 55 44 63
5 Sampdoria Sampdoria 38 45 40 62
6 Genoa Genoa 38 51 42 57
7 Salernitana Salernitana 38 55 61 52
8 Treviso Treviso 38 56 48 51
9 Empoli Empoli 38 42 52 51
10 Ternana Calcio Ternana 38 45 47 49
11 Pistoiese Pistoiese 38 39 43 49
12 Ravenna FC Ravenna FC 38 41 39 48
13 Cosenza Calcio Cosenza 38 36 41 48
14 Pescara Pescara 38 62 55 47
15 AC Monza AC Monza 38 45 46 47
16 Chievo Chievo 38 48 53 47
17 Cesena Cesena 38 47 45 45
18 AlzanoCene AlzanoCene 38 39 51 42
19 FC Savoia 1908 Savoia 1908 38 36 62 29
20 Fermana Fermana 38 36 66 29
TEMPORADA 1998/1999
SERIE B
Equipo PJ GF GC Puntos
1 Hellas Verona Hellas 38 60 38 66
2 Torino Torino 38 58 36 65
3 Reggina Reggina 38 45 32 64
4 Lecce Lecce 38 47 39 64
5 Pescara Pescara 38 50 42 63
6 Atalanta Atalanta 38 44 27 61
7 Brescia Brescia 38 44 33 56
8 Treviso Treviso 38 52 42 56
9 Napoli Napoli 38 41 38 51
10 Ravenna FC Ravenna FC 38 47 51 51
11 Chievo Chievo 38 37 40 48
12 Genoa Genoa 38 53 53 46
13 Cesena Cesena 38 37 41 45
14 AC Monza AC Monza 38 32 38 45
15 Ternana Calcio Ternana 38 39 50 45
16 Cosenza Calcio Cosenza 38 41 53 43
17 Reggiana Reggiana 38 40 49 41
18 Fidelis Andria Fidelis 38 33 49 40
19 Lucchese Libertas Lucchese 38 35 45 37
20 Cremonese Cremonese 38 30 69 20
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 1979/1980
SERIE B
Equipo PJ GF GC Puntos
1 Como Como 38 33 17 64
2 Brescia Brescia 38 39 27 62
3 Pistoiese Pistoiese 38 36 23 58
4 AC Monza AC Monza 38 40 38 57
5 Vicenza Vicenza 38 49 37 55
6 Cesena Cesena 38 39 32 55
7 Sampdoria Sampdoria 38 33 27 51
8 Palermo FC Palermo FC 38 35 32 50
9 Atalanta Atalanta 38 29 24 49
10 SPAL SPAL 38 33 32 49
11 Genoa Genoa 38 33 34 49
12 Hellas Verona Hellas 38 24 26 49
13 Pisa SC Pisa SC 38 25 24 48
14 SSC Bari SSC Bari 38 26 30 47
15 Taranto Taranto 38 24 29 47
16 Lecce Lecce 38 27 30 46
17 Sambenedettese Sambenedette 38 23 31 45
18 Ternana Calcio Ternana 38 26 36 41
19 Parma Parma 38 27 49 34
20 Matera Matera 38 19 42 34
TEMPORADA 1978/1979
SERIE B
Equipo PJ GF GC Puntos
1 Udinese Udinese 38 52 22 76
2 Cagliari Cagliari 38 46 24 65
3 AC Monza AC Monza 38 39 20 64
4 Pescara Pescara 38 44 27 64
5 Pistoiese Pistoiese 38 38 28 59
6 Lecce Lecce 38 33 33 57
7 Palermo FC Palermo FC 38 38 34 52
8 Brescia Brescia 38 41 41 50
9 Genoa Genoa 38 34 35 46
10 Sampdoria Sampdoria 38 37 39 45
11 Sambenedettese Sambenedette 38 35 42 45
12 Cesena Cesena 38 27 29 44
13 SPAL SPAL 38 34 37 44
14 Ternana Calcio Ternana 38 33 39 44
15 Taranto Taranto 38 25 30 42
16 Calcio Foggia Calcio 38 39 45 41
17 SSC Bari SSC Bari 38 29 36 41
18 Nocerina Nocerina 38 24 39 37
19 Varese Varese 38 29 55 30
20 Rimini Rimini 38 17 39 27
TEMPORADA 1977/1978
SERIE B
Equipo PJ GF GC Puntos
1 Ascoli Ascoli 38 73 30 87
2 Catanzaro Catanzaro 38 50 41 60
3 Avellino Avellino 38 34 29 59
4 AC Monza AC Monza 38 36 29 56
5 Ternana Calcio Ternana 38 34 27 56
6 Palermo FC Palermo FC 38 42 36 52
7 Lecce Lecce 38 27 26 51
8 Sampdoria Sampdoria 38 41 37 50
9 Cagliari Cagliari 38 52 47 49
10 Cesena Cesena 38 36 33 49
11 Sambenedettese Sambenedette 38 30 28 49
12 SSC Bari SSC Bari 38 38 42 49
13 Taranto Taranto 38 31 38 48
14 Pistoiese Pistoiese 38 33 40 46
15 Varese Varese 38 34 44 45
16 Brescia Brescia 38 35 40 44
17 Rimini Rimini 38 31 39 43
18 Cremonese Cremonese 38 34 38 42
19 Como Como 38 25 37 39
20 Modena Modena 38 24 59 26
TEMPORADA 1976/1977
SERIE B
Equipo PJ GF GC Puntos
1 Vicenza Vicenza 38 47 29 69
2 Atalanta Atalanta 38 44 26 68
3 Pescara Pescara 38 48 29 66
4 Cagliari Cagliari 38 45 32 66
5 AC Monza AC Monza 38 46 27 65
6 Como Como 38 35 27 53
7 Lecce Lecce 38 33 32 52
8 Varese Varese 38 41 37 50
9 Taranto Taranto 38 32 31 49
10 Ascoli Ascoli 38 41 43 49
11 Sambenedettese Sambenedette 38 27 31 46
12 Ternana Calcio Ternana 38 32 45 43
13 Rimini Rimini 38 25 27 42
14 Modena Modena 38 28 35 42
15 Avellino Avellino 38 27 37 42
16 Brescia Brescia 38 35 46 41
17 Palermo FC Palermo FC 38 29 41 41
18 SPAL SPAL 38 29 37 37
19 Catania Catania 38 26 44 37
20 Novara Novara 38 34 48 36
TEMPORADA 1975/1976
SERIE B
Equipo PJ GF GC Puntos
1 Catanzaro Catanzaro 38 36 23 61
2 Calcio Foggia Calcio 38 28 23 60
3 Genoa Genoa 38 57 33 59
4 Varese Varese 38 50 37 59
5 Brescia Brescia 38 42 37 56
6 SPAL SPAL 38 40 36 54
7 Avellino Avellino 38 38 34 53
8 Modena Modena 38 30 34 52
9 Novara Novara 38 31 29 51
10 Atalanta Atalanta 38 26 24 51
11 Pescara Pescara 38 25 32 50
12 Palermo FC Palermo FC 38 34 35 49
13 Taranto Taranto 38 28 31 49
14 Sambenedettese Sambenedette 38 26 30 49
15 Ternana Calcio Ternana 38 30 33 48
16 Vicenza Vicenza 38 36 35 44
17 Catania Catania 38 27 30 44
18 Piacenza Piacenza 38 42 50 42
19 Brindisi Brindisi 38 20 41 34
20 Reggiana Reggiana 38 31 50 29
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 B
Equipo PJ GF GC Puntos
1 Varese Varese 38 51 28 69
2 Ternana Calcio Ternana 38 46 20 68
3 Ascoli Ascoli 38 41 22 67
4 Como Como 38 37 27 61
5 Taranto Taranto 38 27 26 50
6 Novara Novara 38 33 34 50
7 Parma Parma 38 39 32 49
8 SS Arezzo SS Arezzo 38 42 41 49
9 SPAL SPAL 38 29 32 49
10 Palermo FC Palermo FC 38 35 42 48
11 Atalanta Atalanta 38 24 24 47
12 Brescia Brescia 38 35 36 46
13 Avellino Avellino 38 34 39 46
14 Catanzaro Catanzaro 38 31 37 46
15 Perugia Perugia 38 30 31 44
16 Reggina Reggina 38 20 34 44
17 Reggiana Reggiana 38 30 37 43
18 Brindisi Brindisi 38 27 37 42
19 SSC Bari SSC Bari 38 12 26 37
20 Catania Catania 38 21 39 31
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 B
Equipo PJ GF GC Puntos
1 Ternana Calcio Ternana 38 43 28 68
2 Lazio Lazio 38 48 28 67
3 Palermo FC Palermo FC 38 35 22 65
4 Como Como 38 35 24 60
5 Reggiana Reggiana 38 42 23 59
6 Perugia Perugia 38 35 29 58
7 Cesena Cesena 38 36 25 56
8 Catania Catania 38 34 27 55
9 Genoa Genoa 38 35 34 55
10 Calcio Foggia Calcio 38 39 33 54
11 SSC Bari SSC Bari 38 36 31 52
12 Novara Novara 38 40 45 50
13 Brescia Brescia 38 29 25 49
14 Taranto Taranto 38 29 31 47
15 SS Arezzo SS Arezzo 38 28 37 41
16 Reggina Reggina 38 23 41 37
17 AC Monza AC Monza 38 20 37 34
18 Sorrento Sorrento 38 23 42 33
19 Livorno Livorno 38 21 42 33
20 Modena Modena 38 22 49 27

  USO DE MEMORIA  
8,196,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1781
Total Execution Time  0.1794
  CADENA URL  
/historico/Ternana-Calcio/2008
  GET DATOS  
$_GET['/historico/Ternana-Calcio/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0032  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 = 'Ternana-Calcio' AND l.year = 2008 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=2482 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=2482 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2482 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2482 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 (86159,99099,280497,889648,1020064) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '2482' AND l.year = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '2482' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0036  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=2482 AND l.year in (2007,2008,2009) 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 (14112,540) 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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 540 AND teamId = 2482
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 14112 AND teamId = 2482
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 = '2482' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2482' 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 = '2482' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0054  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 events2008 e ON e.player_id = p.id AND e.league_id = 537 WHERE rp.league_id = 537 AND rp.teamId = 2482 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.0049  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 events2008 e ON e.player_id = p.id AND e.league_id = 537 WHERE rp.league_id = 537 AND rp.teamId = 2482 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054  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 events2008 e ON e.player_id = p.id AND e.league_id = 537 WHERE rp.league_id = 537 AND rp.teamId = 2482 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0058  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 = 2482 AND l.year <= 2008 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 537 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 `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 = 540 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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.0033  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.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 `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.0033  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 = 512 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 513 AND t.round = 38 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 `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 = 514 AND t.round = 38 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 `tables1999` 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 = 515 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0062  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 `tables1993` 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 = 30865 AND t.round = 38 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 `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 = 30852 AND t.round = 38 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 `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 = 30851 AND t.round = 38 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 `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 = 30850 AND t.round = 38 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 = 30849 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 30848 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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.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 `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 = 30846 AND t.round = 38 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 `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 = 30844 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC