4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SERIE B
Equipo PJ GF GC Puntos
1 Parma Parma 35 63 32 73
2 Como Como 35 55 38 68
3 Venezia Venezia 35 64 40 67
4 Cremonese Cremonese 35 44 30 60
5 Catanzaro Catanzaro 35 55 44 57
6 Palermo FC Palermo FC 35 59 50 52
7 Brescia Brescia 35 38 35 47
8 Sampdoria Sampdoria 35 48 49 46
9 Pisa SC Pisa SC 35 47 48 45
10 Cittadella Cittadella 35 38 41 45
11 FC Südtirol Südtirol 35 40 42 43
12 Modena Modena 35 38 44 43
13 Reggiana Reggiana 35 36 43 43
14 Cosenza Cosenza 35 43 39 42
15 Ascoli Ascoli 35 34 38 37
16 Ternana Calcio Ternana 35 38 46 37
17 Spezia Spezia 35 31 46 37
18 SSC Bari SSC Bari 35 34 47 36
19 Feralpisalò Feralpisalò 35 41 60 32
20 Lecco Lecco 35 32 66 26
TEMPORADA 2022/2023
SERIE A
Equipo PJ GF GC Puntos
1 Napoli Napoli 38 77 28 90
2 Lazio Lazio 38 60 30 74
3 Inter Inter 38 71 42 72
4 Milan Milan 38 64 43 70
5 Atalanta Atalanta 38 66 48 64
6 Roma Roma 38 50 38 63
7 Juventus Juventus 38 56 33 62
8 Fiorentina Fiorentina 38 53 43 56
9 Bologna Bologna 38 53 49 54
10 Torino Torino 38 42 41 53
11 AC Monza AC Monza 38 48 52 52
12 Udinese Udinese 38 47 48 46
13 Sassuolo Sassuolo 38 47 61 45
14 Empoli Empoli 38 37 49 43
15 Salernitana Salernitana 38 48 62 42
16 Lecce Lecce 38 33 46 36
17 Spezia Spezia 38 31 62 31
18 Hellas Verona Hellas 38 31 59 31
19 Cremonese Cremonese 38 36 69 27
20 Sampdoria Sampdoria 38 24 71 19
TEMPORADA 2021/2022
SERIE A
Equipo PJ GF GC Puntos
1 Milan Milan 38 69 31 86
2 Inter Inter 38 84 32 84
3 Napoli Napoli 38 74 31 79
4 Juventus Juventus 38 57 37 70
5 Lazio Lazio 38 77 58 64
6 Roma Roma 38 59 43 63
7 Fiorentina Fiorentina 38 59 51 62
8 Atalanta Atalanta 38 65 48 59
9 Hellas Verona Hellas 38 65 59 53
10 Torino Torino 38 46 41 50
11 Sassuolo Sassuolo 38 64 66 50
12 Udinese Udinese 38 61 58 47
13 Bologna Bologna 38 44 55 46
14 Empoli Empoli 38 50 70 41
15 Sampdoria Sampdoria 38 46 63 36
16 Spezia Spezia 38 41 71 36
17 Salernitana Salernitana 38 33 78 31
18 Cagliari Cagliari 38 34 68 30
19 Genoa Genoa 38 27 60 28
20 Venezia Venezia 38 34 69 27
TEMPORADA 2020/2021
SERIE A
Equipo PJ GF GC Puntos
1 Inter Inter 38 89 35 91
2 Milan Milan 38 74 41 79
3 Atalanta Atalanta 38 90 47 78
4 Juventus Juventus 38 77 38 78
5 Napoli Napoli 38 86 41 77
6 Lazio Lazio 38 61 55 68
7 Roma Roma 38 68 58 62
8 Sassuolo Sassuolo 38 64 56 62
9 Sampdoria Sampdoria 38 52 54 52
10 Hellas Verona Hellas 38 46 48 45
11 Genoa Genoa 38 47 58 42
12 Bologna Bologna 38 51 65 41
13 Fiorentina Fiorentina 38 47 59 40
14 Udinese Udinese 38 42 58 40
15 Spezia Spezia 38 52 72 39
16 Cagliari Cagliari 38 43 59 37
17 Torino Torino 38 50 69 37
18 Benevento Benevento 38 40 75 33
19 Crotone Crotone 38 45 92 23
20 Parma Parma 38 39 83 20
TEMPORADA 2019/2020
SERIE B
Equipo PJ GF GC Puntos
1 Benevento Benevento 38 67 27 86
2 Crotone Crotone 38 63 40 68
3 Spezia Spezia 38 54 40 61
4 Pordenone Pordenone 38 48 46 58
5 Cittadella Cittadella 38 49 49 58
6 Chievo Chievo 38 48 38 56
7 Empoli Empoli 38 47 48 54
8 Frosinone Frosinone 38 41 38 54
9 Pisa SC Pisa SC 38 49 45 54
10 Salernitana Salernitana 38 53 50 52
11 Venezia Venezia 38 37 40 50
12 Cremonese Cremonese 38 42 43 49
13 Virtus Entella Virtus 38 46 50 48
14 Ascoli Ascoli 38 50 58 46
15 Cosenza Cosenza 38 50 49 46
16 Perugia Perugia 38 38 49 45
17 Pescara Pescara 38 48 55 45
18 Trapani Trapani 38 48 60 44
19 Juve Stabia Juve Stabia 38 47 63 41
20 Livorno Livorno 38 30 67 21
TEMPORADA 2018/2019
SERIE B
Equipo PJ GF GC Puntos
1 Brescia Brescia 36 69 42 67
2 Lecce Lecce 36 66 45 66
3 Benevento Benevento 36 61 45 60
4 Pescara Pescara 36 50 46 55
5 Hellas Verona Hellas 36 49 46 52
6 Cittadella Cittadella 36 49 38 51
7 Spezia Spezia 36 53 46 51
8 Perugia Perugia 36 49 49 50
9 Cremonese Cremonese 36 37 33 49
10 Cosenza Cosenza 36 34 42 46
11 Palermo FC Palermo FC 36 57 38 43
12 Crotone Crotone 36 40 42 43
13 Ascoli Ascoli 36 40 56 43
14 Livorno Livorno 36 38 51 39
15 Venezia Venezia 36 35 46 38
16 Salernitana Salernitana 36 41 57 38
17 Calcio Foggia Calcio 36 44 49 37
18 Padova Padova 36 36 49 31
19 AC Carpi AC Carpi 36 39 67 29
TEMPORADA 2017/2018
SERIE B
Equipo PJ GF GC Puntos
1 Empoli Empoli 42 88 49 85
2 Parma Parma 42 57 37 72
3 Frosinone Frosinone 42 65 47 72
4 Palermo FC Palermo FC 42 59 39 71
5 Venezia Venezia 42 56 42 67
6 Cittadella Cittadella 42 61 48 66
7 SSC Bari SSC Bari 42 59 48 65
8 Perugia Perugia 42 67 58 60
9 Calcio Foggia Calcio 42 66 68 58
10 Spezia Spezia 42 46 45 53
11 AC Carpi AC Carpi 42 32 46 52
12 Salernitana Salernitana 42 51 58 51
13 Cesena Cesena 42 55 61 50
14 Cremonese Cremonese 42 48 47 48
15 Avellino Avellino 42 49 60 48
16 Brescia Brescia 42 41 52 48
17 Pescara Pescara 42 50 64 48
18 Ascoli Ascoli 42 40 60 46
19 Virtus Entella Virtus 42 41 54 44
20 Novara Novara 42 42 52 44
21 Pro Vercelli Vercelli 42 47 70 40
22 Ternana Calcio Ternana 42 62 77 37
TEMPORADA 2016/2017
SERIE B
Equipo PJ GF GC Puntos
1 SPAL SPAL 42 66 39 78
2 Hellas Verona Hellas 42 64 40 74
3 Frosinone Frosinone 42 57 42 74
4 Perugia Perugia 42 54 40 65
5 Benevento Benevento 42 56 42 65
6 Cittadella Cittadella 42 60 54 63
7 AC Carpi AC Carpi 42 41 40 62
8 Spezia Spezia 42 38 34 60
9 Novara Novara 42 48 50 56
10 Salernitana Salernitana 42 44 44 54
11 Virtus Entella Virtus 42 54 51 54
12 SSC Bari SSC Bari 42 39 44 53
13 Cesena Cesena 42 51 48 53
14 Avellino Avellino 42 40 55 50
15 Brescia Brescia 42 49 58 50
16 Ascoli Ascoli 42 44 49 49
17 Pro Vercelli Vercelli 42 35 45 49
18 Ternana Calcio Ternana 42 42 53 49
19 Trapani Trapani 42 45 55 44
20 Vicenza Vicenza 42 33 52 41
21 Pisa SC Pisa SC 42 23 36 35
22 Latina Latina 42 38 50 32
TEMPORADA 2015/2016
SERIE B
Equipo PJ GF GC Puntos
1 Cagliari Cagliari 42 78 41 83
2 Crotone Crotone 42 61 36 82
3 Trapani Trapani 42 64 49 73
4 Pescara Pescara 42 69 52 72
5 Cesena Cesena 42 57 37 68
6 SSC Bari SSC Bari 42 58 48 68
7 Spezia Spezia 42 47 45 66
8 Novara Novara 42 57 35 65
9 Virtus Entella Virtus 42 51 40 64
10 Perugia Perugia 42 40 40 55
11 Brescia Brescia 42 55 64 54
12 Ternana Calcio Ternana 42 50 56 53
13 Vicenza Vicenza 42 41 53 49
14 Avellino Avellino 42 52 66 49
15 Ascoli Ascoli 42 45 64 47
16 Latina Latina 42 44 51 46
17 Pro Vercelli Vercelli 42 43 53 46
18 Salernitana Salernitana 42 48 62 45
19 Virtus Lanciano Virtus 42 43 56 44
20 Livorno Livorno 42 45 57 42
21 Modena Modena 42 37 55 42
22 Como Como 42 39 64 33
TEMPORADA 2014/2015
SERIE B
Equipo PJ GF GC Puntos
1 AC Carpi AC Carpi 42 59 28 80
2 Frosinone Frosinone 42 62 49 71
3 Bologna Bologna 42 49 35 68
4 Vicenza Vicenza 42 44 37 68
5 Spezia Spezia 42 59 40 67
6 Perugia Perugia 42 49 40 66
7 Pescara Pescara 42 69 55 61
8 Livorno Livorno 42 57 50 59
9 Avellino Avellino 42 42 42 59
10 SSC Bari SSC Bari 42 43 49 54
11 Trapani Trapani 42 56 67 53
12 Ternana Calcio Ternana 42 36 47 51
13 Virtus Lanciano Virtus 42 49 48 50
14 Latina Latina 42 38 41 50
15 Pro Vercelli Vercelli 42 46 57 49
16 Crotone Crotone 42 42 52 48
17 Modena Modena 42 37 39 47
18 Virtus Entella Virtus 42 37 52 47
19 Cittadella Cittadella 42 47 56 44
20 Brescia Brescia 42 54 63 42
21 Catania Catania 42 59 60 37
22 Varese Varese 42 40 67 35
TEMPORADA 2013/2014
SERIE B
Equipo PJ GF GC Puntos
1 Palermo FC Palermo FC 42 62 28 86
2 Empoli Empoli 42 59 35 72
3 Latina Latina 42 44 36 68
4 Cesena Cesena 42 45 35 66
5 Modena Modena 42 65 43 64
6 SSC Bari SSC Bari 42 52 43 63
7 Crotone Crotone 42 56 52 63
8 Spezia Spezia 42 46 48 62
9 Siena Siena 42 57 41 61
10 Virtus Lanciano Virtus 42 44 45 60
11 Brescia Brescia 42 56 53 59
12 Avellino Avellino 42 48 45 59
13 AC Carpi AC Carpi 42 50 49 59
14 Trapani Trapani 42 58 54 57
15 Pescara Pescara 42 50 53 52
16 Ternana Calcio Ternana 42 54 56 51
17 Cittadella Cittadella 42 42 49 47
18 Varese Varese 42 51 63 47
19 Novara Novara 42 40 58 44
20 Padova Padova 42 45 63 41
21 Reggina Reggina 42 38 70 29
22 Juve Stabia Juve Stabia 42 37 80 19
TEMPORADA 2012/2013
SERIE B
Equipo PJ GF GC Puntos
1 Sassuolo Sassuolo 42 78 40 85
2 Hellas Verona Hellas 42 67 32 82
3 Livorno Livorno 42 77 47 80
4 Empoli Empoli 42 69 51 72
5 Novara Novara 42 73 46 63
6 Brescia Brescia 42 58 50 62
7 Varese Varese 42 55 53 60
8 Modena Modena 42 52 51 55
9 SSC Bari SSC Bari 42 55 47 53
10 Ternana Calcio Ternana 42 37 38 53
11 Crotone Crotone 42 45 56 53
12 Padova Padova 42 47 51 51
13 Spezia Spezia 42 52 58 51
14 Juve Stabia Juve Stabia 42 54 65 50
15 Cittadella Cittadella 42 48 61 50
16 Cesena Cesena 42 46 59 50
17 Reggina Reggina 42 42 51 49
18 Virtus Lanciano Virtus 42 50 60 48
19 Vicenza Vicenza 42 41 58 42
20 Ascoli Ascoli 42 48 67 41
21 Pro Vercelli Vercelli 42 37 67 33
22 Grosseto Grosseto 42 44 67 28
TEMPORADA 2011/2012
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Spezia Spezia 36 49 30 65
2 Trapani Trapani 36 59 45 63
3 Siracusa Siracusa 35 46 35 63
4 Virtus Lanciano Virtus 41 48 43 62
5 Cremonese Cremonese 35 50 30 58
6 Barletta Barletta 35 44 39 50
7 Frosinone Frosinone 36 41 41 49
8 Calcio Portogruaro-Summaga Calcio 37 43 45 49
9 Piacenza Piacenza 36 43 50 47
10 FC Südtirol Südtirol 35 39 35 46
11 Carrarese Carrarese 37 44 44 46
12 Pergocrema Pergocrema 34 33 46 45
13 AS Andria BAT Andria 34 37 38 39
14 Triestina Triestina 37 50 59 39
15 Prato Prato 35 37 44 38
16 Feralpisalò Feralpisalò 34 26 37 38
17 Latina Latina 35 37 46 35
18 Bassano Virtus Bassano 34 29 48 32
TEMPORADA 2010/2011
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 AS Gubbio 1910 Gubbio 1910 34 48 31 66
2 Salernitana Salernitana 34 49 39 59
3 Sorrento Sorrento 34 61 43 58
4 US Alessandria Alessandria 34 40 28 57
5 Hellas Verona Hellas 34 42 30 50
6 Spezia Spezia 34 38 33 48
7 Lumezzane Lumezzane 34 34 34 47
8 Como Como 34 41 40 45
9 Reggiana Reggiana 34 36 37 45
10 SPAL SPAL 34 39 37 44
11 Cremonese Cremonese 34 37 38 42
12 Bassano Virtus Bassano 34 26 29 42
13 Ravenna FC Ravenna FC 34 34 41 42
14 Pavia Pavia 34 34 45 39
15 Pergocrema Pergocrema 34 30 35 36
16 AC Monza AC Monza 34 35 50 32
17 FC Südtirol Südtirol 34 28 43 32
18 Paganese Paganese 34 17 36 32
TEMPORADA 2009/2010
LEGA PRO 2 GRUPO 1
Equipo PJ GF GC Puntos
1 FC Südtirol Südtirol 34 33 23 63
2 Spezia Spezia 34 47 27 60
3 AC Legnano AC Legnano 34 49 31 57
4 Feralpisalò Feralpisalò 34 41 32 57
5 Pavia Pavia 34 49 32 57
6 Poli. Alghero Poli. 34 43 25 56
7 AC Rodengo Saiano Rodengo 34 40 32 49
8 Olbia Calcio Olbia Calcio 34 32 27 42
9 Crociati Noceto Crociati 34 36 37 42
10 AC Sambonifacese Sambonifaces 34 44 46 41
11 Valenzana Calcio Valenzana 34 24 29 41
12 Pro Vercelli Vercelli 34 31 37 41
13 FC Canavese FC Canavese 34 31 39 40
14 AC Mezzocorona Mezzocorona 34 42 46 39
15 Villacidrese Calcio Villacidrese 34 38 43 39
16 AC Carpenedolo Carpenedolo 34 34 50 35
17 Pro Belvedere Belvedere 34 15 39 28
18 Pro Sesto Pro Sesto 34 24 58 20
TEMPORADA 2008/2009
SERIE D GRUPO 10
Equipo PJ GF GC Puntos
1 Renate Renate 2 4 4 3
2 Viterbese Calcio Viterbese 2 3 3 3
3 Chioggia Sottomarina Chioggia 2 2 2 3
4 Vico Equense Vico Equense 2 3 1 4
5 Spezia Spezia 2 3 2 3
6 Fano Fano 2 1 4 1
7 Nocerina Nocerina 2 5 4 3
8 AC Salò Valsabbia Salò 2 3 2 3
9 Follonica Gavorrano Follonica 2 2 4 3
TEMPORADA 2007/2008
SERIE B
Equipo PJ GF GC Puntos
1 Chievo Chievo 42 77 43 85
2 Bologna Bologna 42 58 29 84
3 Lecce Lecce 42 70 29 83
4 AlbinoLeffe AlbinoLeffe 42 67 48 78
5 Brescia Brescia 42 59 40 72
6 Pisa SC Pisa SC 42 61 44 71
7 Rimini Rimini 42 68 46 69
8 Ascoli Ascoli 42 64 49 62
9 Mantova Mantova 42 56 49 60
10 Frosinone Frosinone 42 63 67 56
11 SSC Bari SSC Bari 42 50 55 55
12 Triestina Triestina 42 55 67 51
13 Grosseto Grosseto 42 47 54 49
14 ACR Messina ACR Messina 42 38 62 49
15 Piacenza Piacenza 42 43 59 47
16 Modena Modena 42 57 65 46
17 Treviso Treviso 42 41 52 45
18 Vicenza Vicenza 42 43 60 45
19 Avellino Avellino 42 42 64 36
20 Ravenna FC Ravenna FC 42 48 75 35
21 Spezia Spezia 42 45 66 34
22 Cesena Cesena 42 37 66 32
TEMPORADA 2006/2007
SERIE B
Equipo PJ GF GC Puntos
1 Juventus Juventus 42 83 30 94
2 Napoli Napoli 42 52 29 79
3 Genoa Genoa 42 68 44 78
4 Piacenza Piacenza 42 57 50 68
5 Rimini Rimini 42 55 38 67
6 Brescia Brescia 42 51 43 67
7 Bologna Bologna 42 52 43 65
8 Mantova Mantova 42 47 36 64
9 Lecce Lecce 42 56 53 58
10 AlbinoLeffe AlbinoLeffe 42 46 48 53
11 SS Arezzo SS Arezzo 42 42 46 51
12 Vicenza Vicenza 42 42 43 50
13 Treviso Treviso 42 44 47 50
14 SSC Bari SSC Bari 42 40 46 50
15 Frosinone Frosinone 42 44 54 50
16 Modena Modena 42 38 46 49
17 Triestina Triestina 42 37 48 49
18 Cesena Cesena 42 51 66 49
19 Hellas Verona Hellas 42 34 46 48
20 Spezia Spezia 42 50 61 46
21 Crotone Crotone 42 36 67 32
22 Pescara Pescara 42 36 77 25
TEMPORADA 2005/2006
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Spezia Spezia 34 42 22 63
2 Genoa Genoa 34 42 27 59
3 AC Monza AC Monza 34 35 25 56
4 Pavia Pavia 34 44 29 54
5 Teramo Teramo 34 39 35 53
6 Salernitana Salernitana 34 42 30 52
7 Cittadella Cittadella 34 38 33 50
8 Novara Novara 34 40 36 48
9 Padova Padova 34 36 32 47
10 Pro Patria Pro Patria 34 36 39 44
11 AS Pizzighettone Pizzighetton 34 37 32 43
12 Real Giulianova Real 34 33 33 43
13 Ravenna FC Ravenna FC 34 30 33 43
14 Sambenedettese Sambenedette 34 35 48 42
15 Pro Sesto Pro Sesto 34 28 48 38
16 San Marino Calcio Marino 34 32 38 35
17 Lumezzane Lumezzane 34 35 44 35
18 Fermana Fermana 34 18 58 13

  USO DE MEMORIA  
8,340,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1897
Total Execution Time  0.1909
  CADENA URL  
/historico/Asd-Spezia
  GET DATOS  
$_GET['/historico/Asd-Spezia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0116  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 = 'Asd-Spezia' AND l.year = 2024 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.0022  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=2817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=2817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=2817 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=2817 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2817 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2817 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (3281,3523,9448,9569,14539) ORDER BY n.cover_points DESC, update_date DESC
0.0052  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 = '2817' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0056  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 = '2817' 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 = 72045 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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=2817 AND l.year in (2023,2024,2025) 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 (73270,72045,71936,71432,67673) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67673 AND teamId = 2817
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72045 AND teamId = 2817
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73270 AND teamId = 2817
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71936 AND teamId = 2817
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2817
0.0041  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72045 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '2817' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2817' and rp.type = 4
0.0020  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 = '2817' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 events2024 e ON e.player_id = p.id AND e.league_id = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 2817 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.0036  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 events2024 e ON e.player_id = p.id AND e.league_id = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 2817 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 events2024 e ON e.player_id = p.id AND e.league_id = 72045 WHERE rp.league_id = 72045 AND rp.teamId = 2817 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 2817 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 72045 AND t.round = 35 ORDER BY team.conference ASC,t.position 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 `tables2023` 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 = 67673 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 62734 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 57792 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 49921 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `tables2019` 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 = 44205 AND t.round = 38 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 `tables2018` 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 = 38719 AND t.round = 42 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 `tables2017` 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 = 33799 AND t.round = 42 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 `tables2016` 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 = 15392 AND t.round = 42 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 `tables2015` 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 = 3822 AND t.round = 42 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 `tables2014` 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 = 2741 AND t.round = 42 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 `tables2013` 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 = 2082 AND t.round = 42 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 `tables2012` 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 = 1566 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2011` 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 = 1217 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT 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 `tables2010` 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 = 1044 AND t.round = 34 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 `tables2009` 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 = 24718 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables2009` 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 = 24740 AND t.round = 3 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 `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 = 506 AND t.round = 42 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 `tables2006` 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 = 541 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC