4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Crotone

Crotone

Entrenador: Lamberto Zauli

Temporada 2023/2024
TEMPORADA 2023/2024
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Juve Stabia Juve Stabia 37 54 22 76
2 Avellino Avellino 37 61 29 66
3 Taranto Taranto 37 44 30 66
4 Benevento Benevento 37 45 32 66
5 Casertana Casertana 37 46 36 62
6 Picerno Picerno 37 51 37 58
7 SSC Giugliano Giugliano 37 44 44 53
8 Crotone Crotone 37 54 46 52
9 Latina Latina 37 43 49 51
10 Audace Cerignola Audace 37 51 46 50
11 Calcio Foggia Calcio 37 40 43 48
12 Sorrento Sorrento 37 37 42 48
13 ACR Messina ACR Messina 37 40 47 45
14 Potenza Calcio Potenza 37 38 47 42
15 Catania Catania 37 38 38 42
16 Turris Neapolis Turris 37 44 56 41
17 Monopoli Monopoli 37 39 50 39
18 Virtus Francavilla Virtus 37 30 50 34
19 Monterosi Tuscia Monterosi 37 42 62 32
20 Brindisi Brindisi 37 27 62 29
TEMPORADA 2022/2023
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Catanzaro Catanzaro 38 102 21 96
2 Crotone Crotone 38 57 31 80
3 Pescara Pescara 38 58 42 65
4 Calcio Foggia Calcio 38 60 44 61
5 Audace Cerignola Audace 38 48 41 60
6 Picerno Picerno 38 40 34 59
7 Monopoli Monopoli 38 46 48 54
8 Latina Latina 38 39 46 49
9 Potenza Calcio Potenza 38 49 57 48
10 Juve Stabia Juve Stabia 38 37 49 46
11 Taranto Taranto 38 26 36 46
12 SSC Giugliano Giugliano 38 51 61 46
13 Virtus Francavilla Virtus 38 47 54 45
14 Avellino Avellino 38 42 49 43
15 Turris Neapolis Turris 38 40 56 43
16 Monterosi Tuscia Monterosi 38 39 45 42
17 ACR Messina ACR Messina 38 32 47 41
18 Gelbison Gelbison 38 25 40 36
19 Viterbese Viterbese 38 35 52 33
20 Fidelis Andria Fidelis 38 29 49 33
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 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 A
Equipo PJ GF GC Puntos
1 Juventus Juventus 38 86 24 95
2 Napoli Napoli 38 77 29 91
3 Roma Roma 38 61 28 77
4 Inter Inter 38 66 30 72
5 Lazio Lazio 38 89 49 72
6 Milan Milan 38 56 42 64
7 Atalanta Atalanta 38 57 39 60
8 Fiorentina Fiorentina 38 54 46 57
9 Torino Torino 38 54 46 54
10 Sampdoria Sampdoria 38 56 60 54
11 Sassuolo Sassuolo 38 29 59 43
12 Genoa Genoa 38 33 43 41
13 Chievo Chievo 38 36 59 40
14 Udinese Udinese 38 48 63 40
15 Bologna Bologna 38 40 52 39
16 Cagliari Cagliari 38 33 61 39
17 SPAL SPAL 38 39 59 38
18 Crotone Crotone 38 40 66 35
19 Hellas Verona Hellas 38 30 78 25
20 Benevento Benevento 38 33 84 21
TEMPORADA 2016/2017
SERIE A
Equipo PJ GF GC Puntos
1 Juventus Juventus 38 77 27 91
2 Roma Roma 38 90 38 87
3 Napoli Napoli 38 94 39 86
4 Atalanta Atalanta 38 62 41 72
5 Lazio Lazio 38 74 51 70
6 Milan Milan 38 57 45 63
7 Inter Inter 38 72 49 62
8 Fiorentina Fiorentina 38 63 57 60
9 Torino Torino 38 71 66 53
10 Sampdoria Sampdoria 38 49 55 48
11 Cagliari Cagliari 38 55 76 47
12 Sassuolo Sassuolo 38 58 63 46
13 Udinese Udinese 38 47 56 45
14 Chievo Chievo 38 43 61 43
15 Bologna Bologna 38 40 58 41
16 Genoa Genoa 38 38 64 36
17 Crotone Crotone 38 34 58 34
18 Empoli Empoli 38 29 61 32
19 Palermo FC Palermo FC 38 33 77 26
20 Pescara Pescara 38 37 81 18
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 B
Equipo PJ GF GC Puntos
1 Pescara Pescara 42 90 55 83
2 Torino Torino 42 57 28 83
3 Sassuolo Sassuolo 42 57 33 80
4 Hellas Verona Hellas 42 60 41 78
5 Varese Varese 42 57 41 71
6 Sampdoria Sampdoria 42 53 34 67
7 Padova Padova 42 56 58 63
8 Juve Stabia Juve Stabia 42 53 49 61
9 Brescia Brescia 42 48 50 57
10 SSC Bari SSC Bari 42 47 48 56
11 Ascoli Ascoli 42 47 50 56
12 Reggina Reggina 42 63 59 55
13 Crotone Crotone 42 60 58 54
14 Modena Modena 42 50 58 52
15 Grosseto Grosseto 42 47 60 49
16 Livorno Livorno 42 49 49 48
17 Cittadella Cittadella 42 51 64 48
18 Empoli Empoli 42 48 59 47
19 Vicenza Vicenza 42 43 61 44
20 Nocerina Nocerina 42 52 71 40
21 AS Gubbio 1910 Gubbio 1910 42 37 69 32
22 AlbinoLeffe AlbinoLeffe 42 39 69 30
TEMPORADA 2010/2011
SERIE B
Equipo PJ GF GC Puntos
1 Atalanta Atalanta 42 61 35 79
2 Siena Siena 42 67 35 77
3 Novara Novara 42 63 38 70
4 Varese Varese 42 51 34 68
5 Padova Padova 42 63 48 62
6 Reggina Reggina 42 46 40 61
7 Livorno Livorno 42 49 46 59
8 Torino Torino 42 49 48 58
9 Empoli Empoli 42 46 39 57
10 Ascoli Ascoli 42 44 48 56
11 Modena Modena 42 46 51 55
12 Crotone Crotone 42 45 50 54
13 Vicenza Vicenza 42 44 54 54
14 Pescara Pescara 42 44 48 53
15 Cittadella Cittadella 42 50 54 51
16 Sassuolo Sassuolo 42 42 46 51
17 Grosseto Grosseto 42 43 50 51
18 AlbinoLeffe AlbinoLeffe 42 55 66 49
19 Piacenza Piacenza 42 50 63 46
20 Triestina Triestina 42 34 57 40
21 Calcio Portogruaro-Summaga Calcio 42 39 63 40
22 Frosinone Frosinone 42 46 64 38
TEMPORADA 2009/2010
SERIE B
Equipo PJ GF GC Puntos
1 Lecce Lecce 42 66 47 75
2 Cesena Cesena 42 55 29 74
3 Brescia Brescia 42 60 44 72
4 Sassuolo Sassuolo 42 60 42 69
5 Torino Torino 42 53 36 68
6 Cittadella Cittadella 42 62 43 66
7 Crotone Crotone 42 53 50 62
8 Grosseto Grosseto 42 66 63 61
9 Ascoli Ascoli 42 57 57 57
10 Empoli Empoli 42 66 56 56
11 AlbinoLeffe AlbinoLeffe 42 59 56 55
12 Ancona Ancona 42 55 56 54
13 Reggina Reggina 42 51 56 54
14 Modena Modena 42 39 47 54
15 Vicenza Vicenza 42 40 41 53
16 Piacenza Piacenza 42 40 45 53
17 Frosinone Frosinone 42 50 67 53
18 Padova Padova 42 44 48 51
19 Triestina Triestina 42 41 51 51
20 Mantova Mantova 42 46 58 48
21 Gallipoli Gallipoli 42 43 74 40
22 Salernitana Salernitana 42 40 80 23
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 2
Equipo PJ GF GC Puntos
1 Salernitana Salernitana 34 42 24 62
2 Ancona Ancona 34 43 26 57
3 Taranto Taranto 34 47 31 55
4 Crotone Crotone 34 45 30 55
5 Pescara Pescara 34 47 36 54
6 SS Arezzo SS Arezzo 34 42 32 53
7 Perugia Perugia 34 35 34 53
8 Lucchese Libertas Lucchese 34 35 29 51
9 Gallipoli Gallipoli 34 49 41 47
10 Sorrento Sorrento 34 29 30 44
11 Virtus Lanciano Virtus 34 30 34 42
12 Sambenedettese Sambenedette 34 32 39 40
13 Massese Massese 34 34 43 40
14 Potenza SC Potenza SC 34 31 36 38
15 Pistoiese Pistoiese 34 27 38 34
16 Juve Stabia Juve Stabia 34 34 42 33
17 Sangiovannese Sangiovannes 34 24 48 29
18 Martina Martina 34 25 58 21
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 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  
9,012,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6672
Total Execution Time  0.6685
  CADENA URL  
/historico/Fc-Crotone
  GET DATOS  
$_GET['/historico/Fc-Crotone']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1056 AND type_rel = 2
0.0164  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1056 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0154  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 (25787,36803,36885,56474,62270) ORDER BY n.cover_points DESC, update_date DESC
0.0158  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 = '1056' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73270 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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=1056 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (74153,73270,72301,71432) 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.0163  SELECT count(id) as num_players from rel_players WHERE league_id = 72301 AND teamId = 1056
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 73270 AND teamId = 1056
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 1056
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1056
0.0167  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 = 72301 WHERE rp.league_id = 72301 AND rp.teamId = 1056 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.0164  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 = 72301 WHERE rp.league_id = 72301 AND rp.teamId = 1056 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 = 72301 WHERE rp.league_id = 72301 AND rp.teamId = 1056 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 1056 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0295  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 = 68593 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.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 38646 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 30661 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0154  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0158  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 = 1485 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 1188 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 873 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 538 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 507 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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