4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Juve Stabia Juve Stabia 38 57 24 79
2 Avellino Avellino 38 62 29 69
3 Benevento Benevento 38 45 33 66
4 Casertana Casertana 38 51 38 65
5 Taranto Taranto 38 46 31 65
6 Picerno Picerno 38 53 40 58
7 Audace Cerignola Audace 38 54 46 53
8 SSC Giugliano Giugliano 38 44 47 53
9 Crotone Crotone 38 54 47 52
10 Latina Latina 38 44 51 51
11 Calcio Foggia Calcio 38 40 44 48
12 Sorrento Sorrento 38 39 47 48
13 Catania Catania 38 39 38 45
14 ACR Messina ACR Messina 38 41 49 45
15 Turris Neapolis Turris 38 46 57 44
16 Potenza Calcio Potenza 38 38 47 43
17 Monopoli Monopoli 38 41 51 42
18 Virtus Francavilla Virtus 38 30 50 35
19 Monterosi Tuscia Monterosi 38 43 62 35
20 Brindisi Brindisi 38 28 64 25
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 C GRUPO 3
Equipo PJ GF GC Puntos
1 SSC Bari SSC Bari 36 52 26 75
2 Catanzaro Catanzaro 36 57 26 67
3 Palermo FC Palermo FC 36 64 33 66
4 Avellino Avellino 36 45 26 64
5 Monopoli Monopoli 36 38 31 59
6 Virtus Francavilla Virtus 36 48 38 56
7 Calcio Foggia Calcio 36 62 51 54
8 Turris Neapolis Turris 36 52 49 52
9 Monterosi Tuscia Monterosi 36 40 38 51
10 Picerno Picerno 36 41 45 50
11 Juve Stabia Juve Stabia 36 44 36 49
12 Latina Latina 36 37 42 45
13 Città di Campobasso Città 36 51 62 44
14 ACR Messina ACR Messina 36 40 57 39
15 Taranto Taranto 36 31 40 39
16 Potenza Calcio Potenza 36 37 51 37
17 Fidelis Andria Fidelis 36 26 45 30
18 Paganese Paganese 36 36 69 26
19 US Vibonese Calcio Vibonese 36 24 60 21
20 Catania Catania 0 0 0 0
TEMPORADA 2020/2021
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Taranto Taranto 34 50 23 69
2 Picerno Picerno 34 58 34 68
3 Fidelis Andria Fidelis 34 40 18 61
4 USD Bitonto USD Bitonto 34 51 42 55
5 Virtus Casarano Virtus 34 49 39 55
6 Lavello Lavello 34 55 40 54
7 Audace Cerignola Audace 34 62 39 52
8 Nardò Nardò 34 45 39 49
9 Team Altamura Team 34 49 42 47
10 Molfetta Calcio Molfetta 34 54 60 42
11 Sorrento Sorrento 34 41 54 41
12 Gravina Gravina 34 33 40 35
13 Città di Fasano Città 34 38 50 35
14 Brindisi Brindisi 34 27 45 35
15 FC Francavilla 1931 Francavilla 34 34 48 34
16 Real Agro Aversa Real Agro A. 34 40 57 34
17 Portici Portici 34 50 73 34
18 Puteolana Puteolana 34 23 56 26
TEMPORADA 2019/2020
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 USD Bitonto USD Bitonto 26 45 10 55
2 Calcio Foggia Calcio 26 33 16 54
3 Sorrento Sorrento 26 38 21 50
4 Audace Cerignola Audace 26 45 27 49
5 Virtus Casarano Virtus 26 34 28 42
6 Taranto Taranto 26 32 21 40
7 Città di Fasano Città 26 35 31 35
8 Gravina Gravina 26 36 32 34
9 Gelbison Gelbison 26 20 22 34
10 Gladiator Gladiator 26 25 27 33
11 Team Altamura Team 26 31 29 32
12 Brindisi Brindisi 26 23 35 31
13 Fidelis Andria Fidelis 26 31 41 29
14 Grumentum Grumentum 26 27 39 27
15 Nocerina Nocerina 26 30 45 27
16 Francavilla Calcio Francavilla 26 24 35 25
17 Nardò Nardò 26 24 35 25
18 Agropoli Agropoli 26 14 53 14
TEMPORADA 2018/2019
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Picerno Picerno 34 67 24 81
2 Audace Cerignola Audace 34 68 28 75
3 Taranto Taranto 34 65 28 71
4 USD Bitonto USD Bitonto 34 54 31 59
5 FC Savoia 1908 Savoia 1908 34 40 27 59
6 Fidelis Andria Fidelis 34 37 26 56
7 Città di Fasano Città 34 58 50 50
8 Gravina Gravina 34 48 43 48
9 Team Altamura Team 34 43 49 47
10 Sorrento Sorrento 34 47 50 43
11 FC Francavilla 1931 Francavilla 34 30 35 43
12 Nardò Nardò 34 30 39 37
13 Gelbison Gelbison 34 37 49 37
14 Sarnese Sarnese 34 32 50 36
15 Nola 1925 Nola 1925 34 36 55 36
16 Gragnano Gragnano 34 30 43 33
17 Pomigliano Pomigliano 34 17 59 19
18 Granata 1924 Granata 1924 34 21 74 14
TEMPORADA 2017/2018
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Potenza Calcio Potenza 34 81 28 81
2 Cavese 1919 Cavese 1919 34 68 31 76
3 Team Altamura Team 34 56 38 69
4 Taranto Taranto 34 62 38 68
5 Audace Cerignola Audace 34 60 38 62
6 Picerno Picerno 34 49 37 53
7 Gravina Gravina 34 58 42 52
8 Nardò Nardò 34 48 36 52
9 Gragnano Gragnano 34 34 40 42
10 Sarnese Sarnese 34 49 54 40
11 Turris Neapolis Turris 34 35 46 40
12 FC Francavilla 1931 Francavilla 34 59 70 39
13 Pomigliano Pomigliano 34 41 46 37
14 San Severo San Severo 34 35 48 33
15 Nerostellati Frattese Nerostellati 34 26 50 33
16 Real Agro Aversa Real Agro A. 34 31 56 30
17 SS Manfredonia Calcio Manfredonia 34 41 85 19
18 Sporting Fulgor Sporting 34 35 85 14
TEMPORADA 2016/2017
SERIE C GRUPO 3
Equipo PJ GF GC Puntos
1 Calcio Foggia Calcio 38 70 29 85
2 Lecce Lecce 38 62 36 74
3 Matera Matera 38 71 44 65
4 Juve Stabia Juve Stabia 38 65 43 64
5 Siracusa Siracusa 38 47 43 57
6 Virtus Francavilla Virtus 38 47 45 57
7 Cosenza Cosenza 38 57 46 55
8 Paganese Paganese 38 51 45 51
9 Casertana Casertana 38 38 42 49
10 Fondi Fondi 38 49 46 49
11 Fidelis Andria Fidelis 38 30 33 47
12 Catania Catania 38 40 36 47
13 ACR Messina ACR Messina 38 38 52 46
14 Reggina Reggina 38 44 54 45
15 Monopoli Monopoli 38 42 54 42
16 Akragas Akragas 38 30 47 39
17 US Vibonese Calcio Vibonese 38 27 46 39
18 Catanzaro Catanzaro 38 36 49 38
19 Melfi Melfi 38 38 68 34
20 Taranto Taranto 38 25 49 30
TEMPORADA 2015/2016
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Virtus Francavilla Virtus 34 45 26 66
2 Taranto Taranto 34 61 34 63
3 Francavilla Calcio Francavilla 34 61 35 61
4 Nardò Nardò 34 49 26 60
5 Fondi Fondi 34 75 52 52
6 SS Manfredonia Calcio Manfredonia 34 45 49 50
7 Pomigliano Pomigliano 34 47 46 47
8 Bisceglie Bisceglie 34 42 44 47
9 Progreditur Marcianise Progreditur 34 40 38 45
10 Torrecuso Torrecuso 34 57 50 44
11 San Severo San Severo 34 58 59 44
12 AC Isola Liri Isola Liri 34 42 45 44
13 Potenza Calcio Potenza 34 43 58 44
14 Turris Neapolis Turris 34 40 50 43
15 Serpentara Bellegra Serpentara 34 44 50 41
16 Picerno Picerno 34 43 60 30
17 Aprilia Aprilia 34 37 63 28
18 Gallipoli Gallipoli 34 25 69 21
TEMPORADA 2014/2015
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Fidelis Andria Fidelis 34 64 39 74
2 Taranto Taranto 34 53 24 69
3 Potenza SC Potenza SC 34 59 46 67
4 Cavese 1919 Cavese 1919 34 72 44 62
5 Bisceglie Bisceglie 34 57 33 62
6 Brindisi Brindisi 34 64 44 60
7 Gelbison Gelbison 34 43 41 49
8 SS Manfredonia Calcio Manfredonia 34 44 45 44
9 Sarnese Sarnese 34 51 57 44
10 Gallipoli Gallipoli 34 42 52 44
11 Monopoli Monopoli 34 48 39 43
12 Francavilla Calcio Francavilla 34 42 43 39
13 San Severo San Severo 34 45 53 39
14 Pomigliano Pomigliano 34 35 50 38
15 Arzanese Arzanese 34 40 50 33
16 SS Scafatese Calcio Scafatese 34 30 52 29
17 Puteolana Puteolana 34 22 64 24
18 Grottaglie Grottaglie 34 28 63 23
TEMPORADA 2013/2014
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Matera Matera 32 48 22 64
2 Taranto Taranto 32 56 37 62
3 Turris Neapolis Turris 32 45 26 58
4 Monopoli Monopoli 32 48 32 57
5 Progreditur Marcianise Progreditur 32 60 34 56
6 Brindisi Brindisi 32 51 35 54
7 Francavilla Calcio Francavilla 32 48 40 49
8 Bisceglie Bisceglie 32 46 39 44
9 Gelbison Gelbison 32 36 42 42
10 San Severo San Severo 32 31 46 39
11 SS Manfredonia Calcio Manfredonia 32 36 48 38
12 Mariano Keller Mariano 32 39 54 37
13 Nola 1925 Nola 1925 32 28 41 33
14 Puteolana Puteolana 32 26 35 30
15 Real Metapontino Real 32 29 42 29
16 Gladiator Gladiator 32 23 53 27
17 Grottaglie Grottaglie 32 30 54 26
18 Nardò Nardò 0 0 0 0
TEMPORADA 2012/2013
SERIE D GRUPO 8
Equipo PJ GF GC Puntos
1 Ischia Ischia 34 74 19 86
2 Matera Matera 34 68 38 70
3 Gladiator Gladiator 34 58 26 69
4 Monopoli Monopoli 34 60 30 65
5 Calcio Foggia Calcio 34 53 34 58
6 Bisceglie Bisceglie 34 57 41 56
7 Taranto Taranto 34 50 46 50
8 Brindisi Brindisi 34 45 44 44
9 Campania Campania 34 34 35 44
10 Francavilla Calcio Francavilla 34 49 53 44
11 Battipagliese Battipaglies 34 44 47 43
12 Pomigliano Pomigliano 34 33 38 43
13 Puteolana Puteolana 34 39 44 42
14 Nardò Nardò 34 34 38 41
15 Sant Antonio Abate Sant Antonio 34 38 43 37
16 Grottaglie Grottaglie 34 35 68 29
17 Fortis Trani Fortis Trani 34 16 75 12
18 Potenza SC Potenza SC 34 17 85 9
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 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 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
LEGA PRO 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Gallipoli Gallipoli 34 56 22 68
2 Taranto Taranto 34 35 23 58
3 Melfi Melfi 34 46 32 55
4 Pro Vasto Pro Vasto 34 38 27 55
5 AS Cisco Calcio Roma Cisco Calcio 34 37 26 55
6 Cosenza Calcio Cosenza 34 43 36 55
7 Viterbo Viterbo 34 32 35 53
8 SSC Giugliano Giugliano 34 41 38 46
9 Progreditur Marcianise Progreditur 34 32 35 43
10 Vigor Lamezia Vigor 34 35 39 43
11 AS Andria BAT Andria 34 31 35 43
12 Igea Virtus Igea Virtus 34 40 45 41
13 Potenza SC Potenza SC 34 31 38 41
14 Nocerina Nocerina 34 35 37 40
15 Rieti Rieti 34 27 34 39
16 Modica Modica 34 30 44 31
17 Latina Latina 34 26 43 30
18 Vittoria Vittoria 34 21 47 23
TEMPORADA 2003/2004
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Catanzaro Catanzaro 34 44 25 67
2 Crotone Crotone 34 57 33 65
3 Viterbese Viterbese 34 45 29 61
4 Acireale Acireale 34 40 26 60
5 Benevento Benevento 34 41 28 56
6 Virtus Lanciano Virtus 34 34 31 53
7 Sambenedettese Sambenedette 34 50 40 52
8 Chieti Chieti 34 39 35 48
9 Calcio Foggia Calcio 34 43 43 46
10 Teramo Teramo 34 40 41 45
11 Martina Martina 34 45 50 42
12 Real Giulianova Real 34 35 39 41
13 Sora Sora 34 27 35 41
14 Fermana Fermana 34 34 46 40
15 Vis Pesaro Vis Pesaro 34 31 48 36
16 Paternò Paternò 34 32 47 32
17 Taranto Taranto 34 31 46 30
18 L'Aquila L'Aquila 34 26 52 13

  USO DE MEMORIA  
8,125,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7661
Total Execution Time  0.7673
  CADENA URL  
/historico/Taranto-Sport
  GET DATOS  
$_GET['/historico/Taranto-Sport']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0182  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 = 'Taranto-Sport' 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.0126  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=2465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=2465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=2465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=2465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=2465 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0260  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 = 72301
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2465 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90 AND type_rel = 3
0.0135  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.0129  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.0139  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 = '2465' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0143  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 = '2465' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132  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=2465 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75937,74153,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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 75937 AND teamId = 2465
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 74153 AND teamId = 2465
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2465
0.0128  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 = '2465' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2465' and rp.type = 4
0.0127  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 = '2465' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 2465 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.0126  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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 2465 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 75937 WHERE rp.league_id = 75937 AND rp.teamId = 2465 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 2465 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0253  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.0253  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 = 63826 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.0251  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 = 58833 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.0130  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 = 51163 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 44803 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 39601 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 33445 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 15656 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 4821 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 24686 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 2094 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 `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.0143  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.0148  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.0147  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.0146  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.0146  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.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 `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 = 19913 AND t.round = 31 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 `tables2004` 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 = 585 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC