TEMPORADA 2023/2024
SERIE B
Equipo PJ GF GC Puntos
1 Parma Parma 34 59 32 70
2 Como Como 33 49 35 64
3 Venezia Venezia 33 60 38 61
4 Cremonese Cremonese 33 43 28 59
5 Catanzaro Catanzaro 33 53 42 55
6 Palermo FC Palermo FC 34 58 48 52
7 Brescia Brescia 33 38 35 45
8 Sampdoria Sampdoria 33 47 48 44
9 Pisa SC Pisa SC 33 44 45 43
10 Cittadella Cittadella 33 37 40 43
11 FC Südtirol Südtirol 33 40 41 42
12 Reggiana Reggiana 34 34 42 40
13 Cosenza Cosenza 34 39 38 39
14 Modena Modena 33 37 44 39
15 Ternana Calcio Ternana 33 38 45 36
16 SSC Bari SSC Bari 33 32 42 35
17 Spezia Spezia 33 31 46 35
18 Ascoli Ascoli 33 33 38 33
19 Feralpisalò Feralpisalò 33 38 54 31
20 Lecco Lecco 33 31 60 26
TEMPORADA 2022/2023
SERIE B
Equipo PJ GF GC Puntos
1 Frosinone Frosinone 38 63 26 80
2 Genoa Genoa 38 53 28 73
3 SSC Bari SSC Bari 38 58 37 65
4 Parma Parma 38 48 39 60
5 Cagliari Cagliari 38 50 34 60
6 FC Südtirol Südtirol 38 38 34 58
7 Reggina Reggina 38 49 45 50
8 Venezia Venezia 38 51 50 49
9 Palermo FC Palermo FC 38 48 49 49
10 Modena Modena 38 47 53 48
11 Pisa SC Pisa SC 38 48 42 47
12 Ascoli Ascoli 38 40 47 47
13 Como Como 38 47 48 47
14 Ternana Calcio Ternana 38 37 52 43
15 Cittadella Cittadella 38 34 45 43
16 Brescia Brescia 38 36 57 40
17 Cosenza Cosenza 38 30 53 40
18 Perugia Perugia 38 40 52 39
19 SPAL SPAL 38 41 51 38
20 Benevento Benevento 38 33 49 35
TEMPORADA 2021/2022
SERIE B
Equipo PJ GF GC Puntos
1 Lecce Lecce 38 59 31 71
2 Cremonese Cremonese 38 57 39 69
3 Pisa SC Pisa SC 38 48 35 67
4 AC Monza AC Monza 38 60 38 67
5 Brescia Brescia 38 55 35 66
6 Ascoli Ascoli 38 52 42 65
7 Benevento Benevento 38 62 39 63
8 Perugia Perugia 38 40 32 58
9 Frosinone Frosinone 38 58 45 58
10 Ternana Calcio Ternana 38 58 61 54
11 Cittadella Cittadella 38 38 36 52
12 Parma Parma 38 48 43 49
13 Como Como 38 49 54 47
14 Reggina Reggina 38 31 49 46
15 SPAL SPAL 38 46 54 42
16 Cosenza Cosenza 38 36 59 35
17 Vicenza Vicenza 38 38 59 34
18 US Alessandria Alessandria 38 37 59 34
19 Crotone Crotone 38 41 61 26
20 Pordenone Pordenone 38 29 71 18
TEMPORADA 2020/2021
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Ternana Calcio Ternana 36 95 32 90
2 Catanzaro Catanzaro 36 44 29 68
3 Avellino Avellino 36 53 33 68
4 SSC Bari SSC Bari 36 52 34 63
5 Juve Stabia Juve Stabia 36 51 39 61
6 Catania Catania 36 50 38 59
7 Palermo FC Palermo FC 36 44 40 53
8 Teramo Teramo 36 38 34 52
9 Calcio Foggia Calcio 36 36 39 51
10 Casertana Casertana 36 47 59 45
11 Monopoli Monopoli 36 43 51 41
12 Viterbese Viterbese 36 36 42 40
13 Potenza Calcio Potenza 36 38 52 39
14 Turris Neapolis Turris 36 40 56 39
15 Virtus Francavilla Virtus 36 32 44 38
16 US Vibonese Calcio Vibonese 36 34 37 36
17 Paganese Paganese 36 26 49 32
18 Bisceglie Bisceglie 36 28 51 30
19 Cavese 1919 Cavese 1919 36 27 55 23
20 Trapani Trapani 0 0 0 0
TEMPORADA 2019/2020
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Reggina Reggina 30 54 19 69
2 SSC Bari SSC Bari 30 54 24 60
3 Monopoli Monopoli 30 40 22 57
4 Potenza Calcio Potenza 30 36 23 56
5 Ternana Calcio Ternana 30 38 29 51
6 Catania Catania 30 39 38 47
7 Catanzaro Catanzaro 30 41 36 43
8 Teramo Teramo 30 29 31 41
9 Virtus Francavilla Virtus 30 39 36 40
10 Avellino Avellino 30 34 38 40
11 US Vibonese Calcio Vibonese 30 48 37 39
12 Viterbese Viterbese 30 37 38 39
13 Cavese 1919 Cavese 1919 30 24 36 38
14 Casertana Casertana 30 37 35 38
15 Paganese Paganese 30 35 34 36
16 Picerno Picerno 30 29 38 32
17 Sicula Leonzio Sicula 30 31 46 29
18 Bisceglie Bisceglie 30 21 40 20
19 Rende Rende 30 19 50 18
20 Rieti Rieti 30 29 64 15
TEMPORADA 2018/2019
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Pordenone Pordenone 38 56 32 73
2 Triestina Triestina 38 60 33 67
3 Imolese Imolese 38 51 33 62
4 Feralpisalò Feralpisalò 38 50 41 62
5 AC Monza AC Monza 38 45 35 60
6 FC Südtirol Südtirol 38 42 33 55
7 Ravenna FC Ravenna FC 38 39 38 55
8 Vicenza Vicenza 38 43 38 51
9 Sambenedettese Sambenedette 38 40 40 50
10 Fermana Fermana 38 21 35 47
11 Ternana Calcio Ternana 38 39 40 44
12 AS Gubbio 1910 Gubbio 1910 38 35 45 44
13 AlbinoLeffe AlbinoLeffe 38 31 35 43
14 Teramo Teramo 38 36 46 43
15 Vis Pesaro Vis Pesaro 38 29 31 42
16 Giana Erminio Giana 38 42 50 42
17 Renate Renate 38 23 33 39
18 Rimini Rimini 38 28 44 39
19 Virtus Verona Virtus 38 36 50 38
20 Fano Fano 38 18 32 38
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 1
Equipo PJ GF GC Puntos
1 Taranto Taranto 34 41 16 70
2 Ternana Calcio Ternana 34 40 19 65
3 AC Carpi AC Carpi 34 46 26 61
4 Sorrento Sorrento 34 43 26 60
5 Benevento Benevento 34 46 34 58
6 Pro Vercelli Vercelli 34 40 19 57
7 Pisa SC Pisa SC 34 37 35 46
8 Reggiana Reggiana 34 36 42 43
9 Lumezzane Lumezzane 34 28 35 43
10 SPAL SPAL 34 32 36 42
11 Calcio Foggia Calcio 34 33 38 42
12 Avellino Avellino 34 39 46 40
13 Como Como 34 39 47 39
14 Tritium Tritium 34 26 40 37
15 Viareggio Viareggio 34 31 47 36
16 Pavia Pavia 34 37 50 33
17 AC Monza AC Monza 34 27 42 33
18 Foligno Calcio Foligno 34 24 47 25
TEMPORADA 2010/2011
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Nocerina Nocerina 34 51 30 72
2 Benevento Benevento 34 53 40 61
3 Atlético Roma Atlético 34 53 33 57
4 Juve Stabia Juve Stabia 34 43 35 55
5 Taranto Taranto 34 36 28 55
6 Calcio Foggia Calcio 34 67 58 47
7 Lucchese Libertas Lucchese 34 42 38 44
8 Cosenza Cosenza 34 36 38 44
9 Virtus Lanciano Virtus 34 28 31 44
10 Siracusa Siracusa 34 32 38 44
11 Pisa SC Pisa SC 34 39 40 43
12 Barletta Barletta 34 32 38 40
13 Gela Gela 34 31 42 40
14 AS Andria BAT Andria 34 31 37 39
15 Ternana Calcio Ternana 34 30 46 38
16 Foligno Calcio Foligno 34 36 45 35
17 Cavese 1919 Cavese 1919 34 31 41 35
18 Viareggio Viareggio 34 30 43 31
TEMPORADA 2009/2010
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Calcio Portogruaro-Summaga Calcio 34 39 26 59
2 Pescara Pescara 34 39 25 58
3 Hellas Verona Hellas 34 38 20 55
4 Rimini Rimini 34 39 36 51
5 Reggiana Reggiana 34 45 38 49
6 Ternana Calcio Ternana 34 34 34 49
7 SPAL SPAL 34 37 29 45
8 Taranto Taranto 34 26 24 45
9 Progreditur Marcianise Progreditur 34 44 40 44
10 Virtus Lanciano Virtus 34 31 36 44
11 Cavese 1919 Cavese 1919 34 25 25 43
12 Cosenza Calcio Cosenza 34 43 45 43
13 Calcio Foggia Calcio 34 27 37 41
14 Ravenna FC Ravenna FC 34 38 36 40
15 AS Andria BAT Andria 34 31 35 40
16 Pescina V. Giovenca Pescina 34 32 49 34
17 Potenza SC Potenza SC 34 30 48 34
18 Real Giulianova Real 34 28 43 32
TEMPORADA 2008/2009
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Gallipoli Gallipoli 34 55 32 66
2 Benevento Benevento 34 49 31 64
3 Crotone Crotone 34 46 37 59
4 SS Arezzo SS Arezzo 34 56 37 56
5 Calcio Foggia Calcio 34 44 33 56
6 Cavese 1919 Cavese 1919 34 40 35 53
7 Perugia Perugia 34 33 30 43
8 Progreditur Marcianise Progreditur 34 32 33 43
9 Pescara Pescara 34 36 45 43
10 Ternana Calcio Ternana 34 36 34 42
11 Sorrento Sorrento 34 37 39 42
12 Taranto Taranto 34 31 41 42
13 Paganese Paganese 34 21 29 41
14 Virtus Lanciano Virtus 34 37 46 41
15 Foligno Calcio Foligno 34 35 45 35
16 Juve Stabia Juve Stabia 34 29 40 34
17 Pistoiese Pistoiese 34 27 42 33
18 Potenza SC Potenza SC 34 24 39 31
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

  USO DE MEMORIA  
8,622,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1664
Total Execution Time  0.1677
  CADENA URL  
/historico/Ternana-Calcio
  GET DATOS  
$_GET['/historico/Ternana-Calcio']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2482 AND type_rel = 2
0.0026  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.0029  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.0062  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.0027  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.0059  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 <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0057  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 = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 67914 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.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 `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 = 62741 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.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 `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 = 58762 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.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 `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 = 51023 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 44232 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 `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.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 `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.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 `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.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 `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.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 `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 = 1565 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 `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 = 1218 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 `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 = 1042 AND t.round = 34 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 `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 = 446 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 `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.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 `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.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 `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 = 508 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 `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