4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Pro Sesto
TEMPORADA 2023/2024
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Mantova Mantova 38 72 31 80
2 Padova Padova 38 55 28 77
3 Vicenza Vicenza 38 52 30 71
4 Triestina Triestina 38 61 44 64
5 Atalanta Sub 23 Atalanta 38 43 36 59
6 Legnago Salus Legnago 38 46 39 56
7 Giana Erminio Giana 38 46 44 53
8 Pro Vercelli Vercelli 38 50 47 53
9 Lumezzane Lumezzane 38 49 48 53
10 Trento Trento 38 34 37 51
11 Virtus Verona Virtus 38 35 43 47
12 Pro Patria Pro Patria 38 37 51 46
13 AlbinoLeffe AlbinoLeffe 38 34 37 45
14 Pergolettese Pergolettese 38 44 50 45
15 Renate Renate 38 35 46 45
16 Arzignano Valchiampo Arzignano 38 32 37 44
17 Novara Novara 38 39 49 43
18 Fiorenzuola Fiorenzuola 38 38 62 38
19 Pro Sesto Pro Sesto 38 25 40 35
20 US Alessandria Alessandria 38 20 48 20
TEMPORADA 2022/2023
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Feralpisalò Feralpisalò 38 41 21 71
2 Pordenone Pordenone 38 53 35 62
3 Lecco Lecco 38 45 40 62
4 Pro Sesto Pro Sesto 38 46 45 60
5 Padova Padova 38 47 40 59
6 Virtus Verona Virtus 38 46 30 58
7 Vicenza Vicenza 38 64 47 58
8 Renate Renate 38 49 55 53
9 Arzignano Valchiampo Arzignano 38 43 38 53
10 Novara Novara 38 48 45 52
11 Pergolettese Pergolettese 38 43 42 51
12 Pro Patria Pro Patria 38 37 43 50
13 Juventus Next Gen Juventus 38 42 48 49
14 Trento Trento 38 40 42 46
15 Pro Vercelli Vercelli 38 38 47 46
16 Mantova Mantova 38 48 62 45
17 Sangiuliano City Nova Sangiuliano 38 38 46 42
18 Triestina Triestina 38 31 45 39
19 AlbinoLeffe AlbinoLeffe 38 43 54 38
20 Piacenza Piacenza 38 42 59 38
TEMPORADA 2021/2022
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 FC Südtirol Südtirol 38 49 9 90
2 Padova Padova 38 60 26 85
3 Feralpisalò Feralpisalò 38 56 29 69
4 Renate Renate 38 59 43 62
5 Triestina Triestina 38 41 41 55
6 Lecco Lecco 38 51 42 55
7 Pro Vercelli Vercelli 38 41 40 55
8 Juventus Next Gen Juventus 38 43 43 54
9 Piacenza Piacenza 38 44 46 50
10 Pergolettese Pergolettese 38 42 55 46
11 Pro Patria Pro Patria 38 38 45 45
12 AlbinoLeffe AlbinoLeffe 38 42 43 45
13 Virtus Verona Virtus 38 35 38 45
14 Fiorenzuola Fiorenzuola 38 33 48 43
15 Mantova Mantova 38 37 42 42
16 Trento Trento 38 31 36 42
17 Pro Sesto Pro Sesto 38 33 46 38
18 Seregno Seregno 38 41 55 34
19 Giana Erminio Giana 38 25 41 34
20 Legnago Salus Legnago 38 32 65 30
TEMPORADA 2020/2021
SERIE C GRUPO 1
Equipo PJ GF GC Puntos
1 Como Como 38 59 44 75
2 US Alessandria Alessandria 38 48 29 68
3 Renate Renate 38 47 36 65
4 Pro Vercelli Vercelli 38 48 35 63
5 Pro Patria Pro Patria 38 37 28 61
6 Lecco Lecco 38 50 36 60
7 AlbinoLeffe AlbinoLeffe 38 43 36 57
8 Pontedera Pontedera 38 47 40 55
9 Grosseto Grosseto 38 43 41 54
10 Juventus Next Gen Juventus 38 52 50 52
11 Novara Novara 38 48 49 49
12 Piacenza Piacenza 38 47 48 49
13 Olbia Calcio Olbia Calcio 38 47 47 47
14 Giana Erminio Giana 38 36 45 44
15 Pergolettese Pergolettese 38 45 52 44
16 Carrarese Carrarese 38 34 40 44
17 Pro Sesto Pro Sesto 38 31 45 43
18 Pistoiese Pistoiese 38 27 52 31
19 Lucchese Libertas Lucchese 38 36 60 31
20 Livorno Livorno 38 41 53 29
TEMPORADA 2019/2020
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Pro Sesto Pro Sesto 27 46 29 56
2 AC Legnano AC Legnano 27 39 25 50
3 Scanzorosciate Scanzoroscia 27 32 21 46
4 Arconatese Arconatese 27 42 36 44
5 Folgore Caratese Folgore 27 31 24 43
6 Nibionnoggiono Nibionnoggio 27 38 25 42
7 Tritium Tritium 27 39 32 42
8 Sondrio Sondrio 27 31 29 41
9 Seregno Seregno 27 32 25 39
10 Calcio Brusaporto Calcio 27 27 24 39
11 Virtus Bergamo Virtus 27 34 35 35
12 Castellanzese Castellanzes 27 39 41 35
13 Virtus Bolzano Virtus 27 35 34 34
14 US Ponte San Pietro Ponte Pietro 27 29 31 33
15 Caravaggio Caravaggio 27 41 43 32
16 Villa Valle Villa Valle 27 33 43 29
17 Levico Levico 27 32 43 27
18 Bustese Milano City FC Bustese 27 21 35 23
19 Dro Calcio Dro Calcio 27 17 37 17
20 Inveruno Inveruno 27 31 57 17
TEMPORADA 2018/2019
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Como Como 34 68 18 89
2 Mantova Mantova 34 73 27 83
3 Pro Sesto Pro Sesto 34 61 42 69
4 Rezzato Rezzato 34 53 36 65
5 Caronnese Caronnese 34 57 41 59
6 Virtus Bergamo Virtus 34 34 41 45
7 Sondrio Sondrio 34 38 39 44
8 Seregno Seregno 34 37 42 43
9 Villa Valle Villa Valle 34 35 35 41
10 Pontisola Pontisola 34 51 52 40
11 Caravaggio Caravaggio 34 45 53 40
12 Scanzorosciate Scanzoroscia 34 35 37 39
13 Legnago Salus Legnago 34 38 57 38
14 Darfo Boario Darfo Boario 34 26 46 35
15 Ambrosiana Ambrosiana 34 45 62 33
16 Villafranca Villafranca 34 36 44 31
17 Ciserano Ciserano 34 42 68 26
18 Olginatese Olginatese 34 26 60 19
TEMPORADA 2017/2018
SERIE D GRUPO 1
Equipo PJ GF GC Puntos
1 Gozzano Gozzano 38 68 25 82
2 Como Como 38 58 27 81
3 Caronnese Caronnese 38 62 30 74
4 Chieri Chieri 38 64 37 71
5 Pro Sesto Pro Sesto 38 69 43 67
6 Folgore Caratese Folgore 38 45 39 56
7 Inveruno Inveruno 38 44 48 52
8 Borgosesia Borgosesia 38 40 39 51
9 Arconatese Arconatese 38 37 46 50
10 AS Bra AS Bra 38 45 51 49
11 Pavia Pavia 38 53 58 47
12 Borgaro Nobis Borgaro 38 35 44 46
13 Olginatese Olginatese 38 37 44 45
14 Seregno Seregno 38 45 54 44
15 OltrepòVoghera OltrepòVogh 38 34 47 43
16 Casale Casale 38 41 48 42
17 Varesina Varesina 38 33 45 41
18 Varese Varese 38 47 49 40
19 Derthona Derthona 38 25 62 26
20 Castellazzo Castellazzo 38 32 78 19
TEMPORADA 2016/2017
SERIE D GRUPO 1
Equipo PJ GF GC Puntos
1 Cuneo Cuneo 34 49 28 66
2 Varese Varese 34 48 29 63
3 Borgosesia Borgosesia 34 49 22 62
4 Gozzano Gozzano 34 58 37 59
5 Inveruno Inveruno 34 71 51 59
6 Caronnese Caronnese 34 55 38 59
7 Chieri Chieri 34 65 47 55
8 Pro Sesto Pro Sesto 34 42 35 54
9 Casale Casale 34 39 40 48
10 AS Bra AS Bra 34 43 42 41
11 Folgore Caratese Folgore 34 45 47 41
12 Voghera Voghera 34 42 57 38
13 Varesina Varesina 34 39 61 34
14 Bustese Milano City FC Bustese 34 37 54 31
15 AC Legnano AC Legnano 34 34 61 31
16 Verbania Verbania 34 36 56 30
17 Pinerolo Pinerolo 34 38 61 28
18 ASD Pro Settimo Settimo 34 28 52 26
TEMPORADA 2015/2016
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Piacenza Piacenza 38 85 27 96
2 Lecco Lecco 38 83 41 80
3 Seregno Seregno 38 63 47 64
4 Pontisola Pontisola 38 63 48 61
5 Pol. Ciliverghe Pol. 38 48 49 61
6 Olginatese Olginatese 38 57 50 56
7 Inveruno Inveruno 38 65 57 53
8 Ciserano Ciserano 38 48 55 53
9 Folgore Caratese Folgore 38 52 48 50
10 AC Monza AC Monza 38 52 49 49
11 Grumellese Grumellese 38 49 53 48
12 Pro Sesto Pro Sesto 38 50 51 47
13 Varesina Varesina 38 42 49 47
14 Pergolettese Pergolettese 38 38 42 46
15 Bustese Milano City FC Bustese 38 47 58 45
16 Virtus Bergamo Virtus 38 44 61 45
17 Caravaggio Caravaggio 38 35 56 34
18 Fiorenzuola Fiorenzuola 38 28 51 33
19 MapelloBonate MapelloBonat 38 36 59 31
20 Sondrio Sondrio 38 39 73 27
TEMPORADA 2014/2015
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Castiglione Castiglione 36 54 26 74
2 Lecco Lecco 36 65 42 66
3 Seregno Seregno 36 64 37 65
4 Ciserano Ciserano 36 53 39 60
5 Virtus Verona Virtus 36 58 34 59
6 Pergolettese Pergolettese 36 46 44 55
7 Olginatese Olginatese 36 44 34 54
8 Pontisola Pontisola 36 50 42 52
9 Pol. Ciliverghe Pol. 36 37 40 51
10 Sondrio Sondrio 36 46 50 51
11 Aurora Seriate Aurora 36 42 43 50
12 Inveruno Inveruno 36 47 48 49
13 Pro Sesto Pro Sesto 36 38 41 47
14 Villafranca Villafranca 36 44 49 47
15 MapelloBonate MapelloBonat 36 36 48 47
16 Caravaggio Caravaggio 36 37 42 41
17 Folgore Caratese Folgore 36 34 40 37
18 AC Castellana Castellana 36 36 61 30
19 AC Montichiari Montichiari 36 26 97 5
TEMPORADA 2013/2014
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Pro Piacenza Piacenza 34 69 45 66
2 Olginatese Olginatese 34 43 25 57
3 Piacenza Piacenza 34 59 46 57
4 Seregno Seregno 34 54 46 56
5 Inveruno Inveruno 34 65 43 55
6 Pontisola Pontisola 34 44 41 53
7 Pro Sesto Pro Sesto 34 38 32 52
8 Caravaggio Caravaggio 34 54 40 50
9 Lecco Lecco 34 50 43 50
10 Aurora Seriate Aurora 34 35 39 46
11 Legnago Salus Legnago 34 44 50 44
12 AC Castellana Castellana 34 38 45 42
13 MapelloBonate MapelloBonat 34 44 56 39
14 AlzanoCene AlzanoCene 34 32 43 36
15 Borgomanero ASD Borgomanero 34 43 56 36
16 Gozzano Gozzano 34 35 41 34
17 Darfo Boario Darfo Boario 34 40 61 29
18 AC Sambonifacese Sambonifaces 34 34 69 25
TEMPORADA 2012/2013
SERIE D GRUPO 2
Equipo PJ GF GC Puntos
1 Pergolettese Pergolettese 38 64 27 84
2 Pontisola Pontisola 38 87 45 83
3 Olginatese Olginatese 38 59 32 70
4 Voghera Voghera 38 60 43 68
5 Lecco Lecco 38 66 42 62
6 AC Castellana Castellana 38 50 44 58
7 Caronnese Caronnese 38 50 46 58
8 Caravaggio Caravaggio 38 41 36 56
9 AC Montichiari Montichiari 38 58 53 54
10 Aurora Seriate Aurora 38 55 52 53
11 MapelloBonate MapelloBonat 38 60 56 48
12 Darfo Boario Darfo Boario 38 57 55 48
13 AlzanoCene AlzanoCene 38 62 63 47
14 Seregno Seregno 38 51 53 46
15 Fersina Perginese Fersina 38 52 56 46
16 Pro Sesto Pro Sesto 38 44 50 44
17 AC Mezzocorona Mezzocorona 38 49 76 32
18 Trento Trento 38 45 82 28
19 St. Georgen St. Georgen 38 47 85 27
20 Sant Angelo Sant Angelo 38 31 92 13
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 C GRUPO 1
Equipo PJ GF GC Puntos
1 Cesena Cesena 34 41 25 60
2 Pro Patria Pro Patria 34 50 27 58
3 Ravenna FC Ravenna FC 34 48 36 56
4 Padova Padova 34 37 31 54
5 Reggiana Reggiana 34 34 33 54
6 SPAL SPAL 34 38 30 53
7 Hellas Verona Hellas 34 38 32 48
8 Novara Novara 34 36 36 46
9 Lumezzane Lumezzane 34 37 35 45
10 Pergocrema Pergocrema 34 28 28 44
11 Cremonese Cremonese 34 36 36 43
12 Calcio Portogruaro-Summaga Calcio 34 33 39 43
13 AC Monza AC Monza 34 41 48 38
14 Pro Sesto Pro Sesto 34 34 47 38
15 Lecco Lecco 34 29 34 35
16 Venezia Venezia 34 35 41 35
17 Sambenedettese Sambenedette 34 22 36 32
18 AC Legnano AC Legnano 34 31 54 30
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 1
Equipo PJ GF GC Puntos
1 Grosseto Grosseto 34 46 27 62
2 Sassuolo Sassuolo 34 42 27 61
3 Pisa SC Pisa SC 34 32 20 58
4 Venezia Venezia 34 41 29 54
5 Cittadella Cittadella 34 38 26 54
6 AC Monza AC Monza 34 42 32 54
7 Padova Padova 34 34 24 50
8 Lucchese Libertas Lucchese 34 44 32 45
9 Pistoiese Pistoiese 34 33 29 43
10 Pro Sesto Pro Sesto 34 24 28 41
11 Novara Novara 34 32 37 41
12 Massese Massese 34 32 39 41
13 Pro Patria Pro Patria 34 34 44 41
14 Cremonese Cremonese 34 33 43 41
15 Sangiovannese Sangiovannes 34 41 51 36
16 AS Pizzighettone Pizzighetton 34 24 41 33
17 US Ivrea Calcio Ivrea Calcio 34 25 43 31
18 Pavia Pavia 34 29 54 26
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
TEMPORADA 1949/1950
SERIE B
Equipo PJ GF GC Puntos
1 Napoli Napoli 42 76 34 88
2 Udinese Udinese 42 78 39 86
3 AC Legnano AC Legnano 42 86 52 82
4 SPAL SPAL 42 95 65 79
5 Modena Modena 42 76 43 74
6 Spezia Spezia 42 69 55 69
7 Brescia Brescia 42 81 64 65
8 Livorno Livorno 42 61 59 65
9 Hellas Verona Hellas 42 68 68 58
10 Siracusa Siracusa 42 68 71 58
11 Catania Catania 42 54 61 55
12 Pisa SC Pisa SC 42 56 50 54
13 Salernitana Salernitana 42 58 56 54
14 Vicenza Vicenza 42 63 67 54
15 Fanfulla Fanfulla 42 63 71 54
16 Cremonese Cremonese 42 56 57 53
17 Reggiana Reggiana 42 56 64 52
18 US Alessandria Alessandria 42 70 74 51
19 Empoli Empoli 42 51 69 49
20 Taranto Taranto 42 56 96 47
21 Prato Prato 42 55 97 34
22 Pro Sesto Pro Sesto 42 35 119 19

  USO DE MEMORIA  
8,041,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1704
Total Execution Time  0.1716
  CADENA URL  
/historico/Ac-Pro-Sesto
  GET DATOS  
$_GET['/historico/Ac-Pro-Sesto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0047  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 = 'Ac-Pro-Sesto' 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.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=51 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=51 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=51 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=51 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 = 72299
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=51 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90 AND type_rel = 3
0.0030  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 90 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (1288519,1278023,1273213,1269533,1269201) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '51' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0036  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 = '51' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72299 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=51 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 (74153,72299,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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72299 AND teamId = 51
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 51
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 51
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 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 = 72299 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '51' 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 = '51' 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 = '51' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 51 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.0038  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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 51 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 = 72299 WHERE rp.league_id = 72299 AND rp.teamId = 51 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 51 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 = 72299 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.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 `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 = 68591 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 `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 = 63824 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 `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 = 58760 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.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 `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 = 51157 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 44797 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 `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 = 39595 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 `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 = 33449 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 `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 = 15650 AND t.round = 38 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 `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 = 14783 AND t.round = 1 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 = 4815 AND t.round = 38 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 = 24670 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 `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 = 2088 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 `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 = 445 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 `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.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 `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 = 539 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 `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
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 `tables1950` 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 = 30822 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC