4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1970/1971
SERIE B
Equipo PJ GF GC Puntos
1 SSC Bari SSC Bari 38 43 24 66
2 Mantova Mantova 38 40 24 65
3 Catanzaro Catanzaro 38 37 27 64
4 Atalanta Atalanta 38 41 25 62
5 Brescia Brescia 38 39 27 61
6 Perugia Perugia 38 36 28 57
7 SS Arezzo SS Arezzo 38 40 33 52
8 Reggina Reggina 38 24 28 50
9 Modena Modena 38 31 37 50
10 Como Como 38 35 43 50
11 Novara Novara 38 37 34 48
12 Ternana Calcio Ternana 38 35 32 48
13 Livorno Livorno 38 21 25 46
14 Palermo FC Palermo FC 38 33 33 45
15 Cesena Cesena 38 25 29 45
16 AC Monza AC Monza 38 31 38 44
17 Pisa SC Pisa SC 38 31 44 41
18 Taranto Taranto 38 27 34 38
19 Casertana Casertana 38 32 50 33
20 Massese Massese 38 20 43 26
TEMPORADA 1969/1970
SERIE B
Equipo PJ GF GC Puntos
1 Varese Varese 38 41 21 65
2 Calcio Foggia Calcio 38 42 25 64
3 Catania Catania 38 34 19 63
4 AC Monza AC Monza 38 30 19 60
5 Mantova Mantova 38 39 22 59
6 Reggina Reggina 38 39 34 54
7 Pisa SC Pisa SC 38 31 29 50
8 Livorno Livorno 38 26 25 49
9 Ternana Calcio Ternana 38 30 31 49
10 Perugia Perugia 38 25 25 45
11 Como Como 38 33 44 45
12 Modena Modena 38 24 30 44
13 Cesena Cesena 38 25 28 43
14 Atalanta Atalanta 38 30 29 41
15 Taranto Taranto 38 27 35 41
16 Catanzaro Catanzaro 38 23 30 40
17 Reggiana Reggiana 38 22 31 39
18 SS Arezzo SS Arezzo 38 15 27 39
19 Piacenza Piacenza 38 26 45 39
20 Genoa Genoa 38 19 32 35
TEMPORADA 1968/1969
SERIE B
Equipo PJ GF GC Puntos
1 Lazio Lazio 38 55 27 67
2 Brescia Brescia 38 46 24 65
3 Reggiana Reggiana 38 36 23 63
4 SSC Bari SSC Bari 38 34 27 61
5 Reggina Reggina 38 36 24 57
6 Como Como 38 33 28 55
7 Genoa Genoa 38 36 29 51
8 Calcio Foggia Calcio 38 33 35 49
9 Perugia Perugia 38 31 26 47
10 Ternana Calcio Ternana 38 34 36 47
11 Livorno Livorno 38 29 35 46
12 Mantova Mantova 38 30 30 45
13 Catanzaro Catanzaro 38 23 31 45
14 Catania Catania 38 19 28 45
15 Cesena Cesena 38 27 37 44
16 AC Monza AC Monza 38 32 38 43
17 Modena Modena 38 26 34 41
18 SPAL SPAL 38 30 38 39
19 Lecco Lecco 38 26 38 37
20 Padova Padova 38 25 53 37

  USO DE MEMORIA  
7,982,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2195
Total Execution Time  0.2215
  CADENA URL  
/historico/Ternana-Calcio/2002
  GET DATOS  
$_GET['/historico/Ternana-Calcio/2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0038  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 = 2002 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2482 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=2482 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=2482 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=2482 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 512
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 = 22610
0.0026  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 22611
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2482 AND type_rel = 2
0.0020  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.0023  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 = 2002 ORDER BY l.year DESC,cat.coefficient DESC
0.0055  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.0021  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 = 22611 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 = 512 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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 (2001,2002,2003) ORDER BY l.id DESC, l.year DESC ;
0.0048  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 (22622,513) 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.0081  SELECT count(id) as num_players from rel_players WHERE league_id = 513 AND teamId = 2482
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 22622 AND teamId = 2482
0.0022  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.0019  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.0090  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 events2002 e ON e.player_id = p.id AND e.league_id = 512 WHERE rp.league_id = 512 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.0105  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 events2002 e ON e.player_id = p.id AND e.league_id = 512 WHERE rp.league_id = 512 AND rp.teamId = 2482 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0093  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 events2002 e ON e.player_id = p.id AND e.league_id = 512 WHERE rp.league_id = 512 AND rp.teamId = 2482 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0079  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 <= 2002 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.0037  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.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 `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.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 `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.0047  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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.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 `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.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 `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.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 `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 = 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.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.0037  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
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 = 30843 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 `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 = 30842 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 `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 = 30841 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 512 ORDER BY nameShow LIMIT 100