4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Chieti
TEMPORADA 2023/2024
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Città di Campobasso Città 32 52 28 66
2 L'Aquila L'Aquila 32 39 22 64
3 Sambenedettese Sambenedette 32 51 32 54
4 Avezzano Avezzano 32 46 32 53
5 Vigor Senigallia Vigor 32 53 43 49
6 Roma City Roma City 32 51 34 48
7 Chieti Chieti 32 35 32 47
8 SN Notaresco 2018 Notaresco 32 37 36 45
9 ASD Atletico Ascoli Atletico 32 34 31 44
10 Termoli Calcio Termoli 32 29 35 41
11 Sora Sora 32 36 35 40
12 FC Fossombrone Fossombrone 32 28 27 40
13 Real Monterotondo Scalo Real 32 37 55 38
14 Riccione Riccione 32 44 46 34
15 Tivoli Tivoli 32 33 54 31
16 Fano Fano 32 30 45 29
17 Vastogirardi Vastogirardi 32 23 43 29
18 Matese Matese 32 20 48 25
TEMPORADA 2022/2023
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Pineto Pineto 34 50 21 72
2 Vigor Senigallia Vigor 34 52 34 67
3 Trastevere Trastevere 34 56 41 62
4 Fano Fano 34 45 34 60
5 Cynthialbalonga Cynthialbalo 34 32 23 52
6 Matese Matese 34 44 38 47
7 Sambenedettese Sambenedette 34 39 37 46
8 Chieti Chieti 34 29 27 46
9 Porto D'Ascoli Porto 34 28 27 45
10 Vastogirardi Vastogirardi 34 30 31 42
11 Team Nuova Florida Team Nuova. 34 33 44 42
12 Avezzano Avezzano 34 35 41 40
13 Roma City Roma City 34 29 42 37
14 Vastese Vastese 34 37 43 36
15 Termoli Calcio Termoli 34 25 34 34
16 Montegiorgio Montegiorgio 34 21 34 31
17 Tolentino Tolentino 34 25 41 31
18 SN Notaresco 2018 Notaresco 34 23 41 31
TEMPORADA 2021/2022
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Recanatese Recanatese 34 69 23 68
2 Trastevere Trastevere 34 54 33 59
3 Tolentino Tolentino 34 42 30 56
4 Sambenedettese Sambenedette 34 41 36 55
5 Vastese Vastese 34 44 32 53
6 Pineto Pineto 34 43 29 52
7 Fiuggi Fiuggi 34 41 45 51
8 SN Notaresco 2018 Notaresco 34 45 41 49
9 Matese Matese 34 44 41 49
10 Porto D'Ascoli Porto 34 41 39 49
11 Montegiorgio Montegiorgio 34 38 36 49
12 Chieti Chieti 34 38 38 49
13 Fano Fano 34 44 39 48
14 Vastogirardi Vastogirardi 34 48 51 46
15 Castelnuovo Vomano Castelnuovo 34 49 51 44
16 Castelfidardo Calcio Castelfidard 34 36 36 41
17 Nereto Nereto 34 23 80 12
18 Aurora Alto Casertano Aurora Alto 34 21 81 7
TEMPORADA 2019/2020
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Matelica Calcio Matelica 26 49 17 55
2 Città di Campobasso Città 26 47 24 52
3 SN Notaresco 2018 Notaresco 26 43 30 52
4 Recanatese Recanatese 26 48 42 48
5 Pineto Pineto 26 35 30 43
6 Vastese Vastese 26 40 33 42
7 Olympia Agnonese Olympia 26 40 34 40
8 Montegiorgio Montegiorgio 26 32 27 38
9 Tolentino Tolentino 26 33 37 36
10 Porto Sant'Elpidio Porto 26 40 40 34
11 Vastogirardi Vastogirardi 26 42 45 34
12 Fiuggi Fiuggi 26 37 38 33
13 Cattolica Cattolica 26 31 36 28
14 Real Giulianova Real 26 29 40 28
15 Sangiustese Sangiustese 26 27 39 20
16 Avezzano Avezzano 26 16 33 20
17 Chieti Chieti 26 26 51 18
18 Jesina Jesina 26 27 46 13
TEMPORADA 2016/2017
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Fermana Fermana 32 51 28 69
2 Matelica Calcio Matelica 32 56 30 63
3 SN Notaresco 2018 Notaresco 32 53 29 60
4 Vis Pesaro Vis Pesaro 32 48 32 53
5 Olympia Agnonese Olympia 32 45 33 51
6 Sammaurese Sammaurese 32 37 25 50
7 Monticelli Monticelli 32 37 33 47
8 Vastese Vastese 32 43 32 45
9 San Marino Calcio Marino 32 43 38 41
10 Jesina Jesina 32 35 44 40
11 Romagna Centro Romagna 32 34 42 39
12 Pineto Pineto 32 35 44 39
13 Città di Campobasso Città 32 32 44 38
14 Alfonsine FC 1921 Alfonsine 32 33 45 30
15 Castelfidardo Calcio Castelfidard 32 28 44 28
16 Recanatese Recanatese 32 30 50 27
17 Civitanovese Civitanovese 32 22 69 17
18 Chieti Chieti 0 0 0 0
TEMPORADA 2015/2016
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Sambenedettese Sambenedette 34 76 36 81
2 Fano Fano 34 49 29 68
3 Città di Campobasso Città 34 48 27 61
4 Matelica Calcio Matelica 34 57 37 58
5 Fermana Fermana 34 50 39 55
6 Chieti Chieti 34 49 38 49
7 Recanatese Recanatese 34 45 50 48
8 Jesina Jesina 34 39 46 47
9 SN Notaresco 2018 Notaresco 34 49 42 46
10 Avezzano Avezzano 34 51 52 44
11 Vis Pesaro Vis Pesaro 34 40 42 43
12 Castelfidardo Calcio Castelfidard 34 33 40 42
13 Olympia Agnonese Olympia 34 47 49 40
14 Monticelli Monticelli 34 42 48 37
15 Isernia Isernia 34 27 49 37
16 Folgore Veregra Folgore 34 34 52 32
17 Real Giulianova Real 34 27 63 27
18 Amiternina Amiternina 34 34 58 24
TEMPORADA 2014/2015
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Maceratese Maceratese 34 61 22 78
2 Fano Fano 34 60 25 74
3 Sambenedettese Sambenedette 34 71 40 63
4 Città di Campobasso Città 34 49 42 57
5 SN Notaresco 2018 Notaresco 34 59 46 52
6 Chieti Chieti 34 52 46 50
7 Civitanovese Civitanovese 34 56 51 50
8 Matelica Calcio Matelica 34 36 34 45
9 Real Giulianova Real 34 44 43 45
10 Jesina Jesina 34 40 38 42
11 Fermana Fermana 34 37 44 42
12 Recanatese Recanatese 34 37 44 39
13 Termoli Calcio Termoli 34 31 53 39
14 Amiternina Amiternina 34 30 45 38
15 Olympia Agnonese Olympia 34 31 51 31
16 Castelfidardo Calcio Castelfidard 34 25 49 31
17 Vis Pesaro Vis Pesaro 34 35 45 29
18 FC Celano Marsica Celano 34 23 59 17
TEMPORADA 2013/2014
LEGA PRO 2 GRUPO 2
Equipo PJ GF GC Puntos
1 ACR Messina ACR Messina 34 43 33 57
2 Casertana Casertana 34 38 28 57
3 Teramo Teramo 34 48 34 55
4 Cosenza Cosenza 34 38 29 55
5 Calcio Foggia Calcio 34 50 40 51
6 Melfi Melfi 34 39 31 51
7 Ischia Ischia 34 33 29 48
8 Vigor Lamezia Vigor 34 37 39 46
9 Sorrento Sorrento 34 40 36 45
10 Tuttocuoio Tuttocuoio 34 41 38 44
11 Real Agro Aversa Real Agro A. 34 36 40 43
12 Arzanese Arzanese 34 41 46 43
13 Martina Franca Martina 34 36 36 42
14 Chieti Chieti 34 34 35 41
15 Aprilia Aprilia 34 41 50 41
16 Poggibonsi Poggibonsi 34 31 41 36
17 Castel Rigone Castel 34 39 56 34
18 Follonica Gavorrano Follonica 34 24 48 30
TEMPORADA 2012/2013
LEGA PRO 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Salernitana Salernitana 37 67 36 79
2 Pontedera Pontedera 35 52 32 65
3 Aprilia Aprilia 34 46 32 57
4 L'Aquila L'Aquila 36 43 35 57
5 Chieti Chieti 34 43 34 55
6 Poggibonsi Poggibonsi 34 41 31 53
7 Teramo Teramo 36 44 37 53
8 Martina Franca Martina 36 33 40 47
9 Vigor Lamezia Vigor 36 27 24 46
10 Città di Campobasso Città 34 35 37 46
11 Melfi Melfi 35 30 30 45
12 Borgo a Buggiano Borgo 34 41 35 44
13 Arzanese Arzanese 34 39 39 44
14 ASD HinterReggio HinterReggio 35 35 39 42
15 Follonica Gavorrano Follonica 35 43 45 41
16 Foligno Calcio Foligno 34 32 38 41
17 Fondi Fondi 34 27 70 15
18 Real Agro Aversa Real Agro A. 35 26 70 15
TEMPORADA 2011/2012
LEGA PRO 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Perugia Perugia 40 65 29 87
2 Catanzaro Catanzaro 40 66 29 83
3 Vigor Lamezia Vigor 40 57 27 80
4 Chieti Chieti 40 55 38 69
5 Aprilia Aprilia 40 60 44 65
6 Paganese Paganese 40 47 37 65
7 Follonica Gavorrano Follonica 40 69 54 62
8 L'Aquila L'Aquila 40 38 31 60
9 Fano Fano 40 48 48 58
10 Arzanese Arzanese 40 50 55 55
11 Real Agro Aversa Real Agro A. 40 31 37 48
12 Melfi Melfi 40 46 50 46
13 Real Giulianova Real 40 39 51 46
14 Fondi Fondi 40 41 49 45
15 Città di Campobasso Città 40 38 47 45
16 Milazzo Milazzo 40 44 46 44
17 US Vibonese Calcio Vibonese 40 41 51 42
18 Neapolis Neapolis 40 42 59 42
19 AC Isola Liri Isola Liri 40 39 62 34
20 Ebolitana Ebolitana 40 34 62 34
21 FC Celano Marsica Celano 40 31 75 25
TEMPORADA 2010/2011
LEGA PRO 2 GRUPO 2
Equipo PJ GF GC Puntos
1 AC Carpi AC Carpi 30 45 16 65
2 Carrarese Carrarese 30 51 18 63
3 Prato Prato 30 35 25 49
4 L'Aquila L'Aquila 30 30 27 49
5 San Marino Calcio Marino 30 36 30 47
6 Chieti Chieti 30 37 29 46
7 AC Giacomense Giacomense 30 33 27 41
8 Poggibonsi Poggibonsi 30 29 40 40
9 Sangiovannese Sangiovannes 30 28 35 37
10 Bellaria Igea Bellaria 30 31 31 35
11 Real Giulianova Real 30 31 40 32
12 Follonica Gavorrano Follonica 30 34 40 31
13 Villacidrese Calcio Villacidrese 30 33 43 28
14 Crociati Noceto Crociati 30 35 48 28
15 Fano Fano 30 29 46 28
16 FC Celano Marsica Celano 30 29 51 25
TEMPORADA 2009/2010
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Chieti Chieti 34 54 31 67
2 Santegidiese Santegidiese 34 62 38 63
3 Atessa Val di Sangro Atessa 34 61 41 63
4 L'Aquila L'Aquila 34 52 28 61
5 Atletico Trivento Atletico 34 42 20 58
6 Civitanovese Civitanovese 34 42 30 58
7 Recanatese Recanatese 34 33 19 52
8 Olympia Agnonese Olympia 34 52 46 50
9 Casoli Casoli 34 41 42 44
10 Città di Campobasso Città 34 35 29 43
11 Bojano Bojano 34 33 42 43
12 RC Angolana RC Angolana 34 41 50 41
13 Miglianico Miglianico 34 36 50 41
14 Luco Canistro Luco 34 40 42 40
15 Morro d'Oro Morro d'Oro 34 41 55 39
16 Centobuchi Centobuchi 34 33 51 37
17 Elpidiense Elpidiense 34 18 66 15
18 SS Real Montecchio Real 34 19 55 14
TEMPORADA 2008/2009
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Pro Vasto Pro Vasto 34 49 25 71
2 Fano Fano 33 60 33 67
3 Casoli Casoli 34 52 32 65
4 Città di Campobasso Città 34 51 38 56
5 Chieti Chieti 34 36 33 55
6 Olympia Agnonese Olympia 34 44 40 53
7 RC Angolana RC Angolana 34 47 36 51
8 Santegidiese Santegidiese 34 40 37 46
9 Recanatese Recanatese 33 28 25 45
10 Atletico Trivento Atletico 34 31 33 44
11 Morro d'Oro Morro d'Oro 34 40 45 39
12 Centobuchi Centobuchi 34 32 45 39
13 Elpidiense Elpidiense 34 29 40 36
14 SS Real Montecchio Real 34 32 42 33
15 Tolentino Tolentino 34 27 40 32
16 Luco Canistro Luco 34 30 49 32
17 Maceratese Maceratese 34 28 44 30
18 Grottammare Grottammare 34 16 35 24
TEMPORADA 2005/2006
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Napoli Napoli 34 48 20 68
2 Frosinone Frosinone 34 43 37 55
3 Sassari Torres Sassari 34 44 32 53
4 Grosseto Grosseto 34 43 32 51
5 Sangiovannese Sangiovannes 34 37 34 51
6 Perugia Perugia 34 35 37 50
7 Lucchese Libertas Lucchese 34 33 27 49
8 Martina Martina 34 41 39 47
9 Gela Gela 34 31 35 43
10 Pistoiese Pistoiese 34 28 24 42
11 SS Manfredonia Calcio Manfredonia 34 36 38 42
12 Virtus Lanciano Virtus 34 36 35 41
13 Calcio Foggia Calcio 34 32 32 40
14 Acireale Acireale 34 29 34 39
15 Pisa SC Pisa SC 34 31 43 39
16 Massese Massese 34 21 36 38
17 Juve Stabia Juve Stabia 34 25 36 33
18 Chieti Chieti 34 24 46 28
TEMPORADA 2004/2005
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Rimini Rimini 34 50 23 70
2 Avellino Avellino 34 48 29 64
3 Napoli Napoli 34 45 31 61
4 Reggiana Reggiana 34 41 24 54
5 Sambenedettese Sambenedette 34 38 25 54
6 Padova Padova 34 46 39 48
7 Virtus Lanciano Virtus 34 36 38 46
8 Benevento Benevento 34 31 38 45
9 SPAL SPAL 34 36 33 43
10 Calcio Foggia Calcio 34 36 35 42
11 Martina Martina 34 31 41 42
12 Cittadella Cittadella 34 36 37 41
13 Teramo Teramo 34 32 37 40
14 Fermana Fermana 34 30 45 39
15 Sora Sora 34 35 42 36
16 Real Giulianova Real 34 20 43 31
17 Chieti Chieti 34 19 32 30
18 Vis Pesaro Vis Pesaro 34 21 39 25
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
TEMPORADA 2002/2003
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Pescara Pescara 34 64 36 69
2 Avellino Avellino 34 51 25 69
3 Martina Martina 34 52 37 62
4 Teramo Teramo 34 58 40 58
5 Sambenedettese Sambenedette 34 46 26 56
6 Crotone Crotone 34 40 29 50
7 Virtus Lanciano Virtus 34 39 39 49
8 Benevento Benevento 34 27 32 44
9 Taranto Taranto 34 31 35 41
10 Chieti Chieti 34 28 32 41
11 Viterbese Viterbese 34 37 50 39
12 Sassari Torres Sassari 34 34 37 38
13 Vis Pesaro Vis Pesaro 34 29 40 36
14 Real Giulianova Real 34 29 37 35
15 Paternò Paternò 34 31 46 35
16 Sora Sora 34 36 48 34
17 L'Aquila L'Aquila 34 30 53 33
18 Fermana Fermana 34 28 48 32
TEMPORADA 2001/2002
SERIE C GRUPO 2
Equipo PJ GF GC Puntos
1 Ascoli Ascoli 34 55 26 67
2 Taranto Taranto 34 50 30 62
3 Catania Catania 34 44 26 58
4 Pescara Pescara 34 48 29 53
5 Real Giulianova Real 34 44 31 51
6 Virtus Lanciano Virtus 34 36 30 51
7 Avellino Avellino 35 40 43 48
8 Chieti Chieti 34 28 27 47
9 Fermana Fermana 34 32 33 46
10 L'Aquila L'Aquila 35 33 46 46
11 Viterbese Viterbese 34 33 35 44
12 Sassari Torres Sassari 34 41 35 43
13 Vis Pesaro Vis Pesaro 34 32 32 43
14 Castel Sangro Castel 34 27 37 39
15 Benevento Benevento 34 27 38 39
16 Nocerina Nocerina 34 32 59 30
17 Sora Sora 34 21 39 29
18 Lodigiani Lodigiani 34 24 51 23

  USO DE MEMORIA  
7,842,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7116
Total Execution Time  0.7129
  CADENA URL  
/historico/Chieti
  GET DATOS  
$_GET['/historico/Chieti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0156  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 = 'Chieti' 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.0145  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=2865 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2865 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2865 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=2865 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2865 AND type_rel = 2
0.0150  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 = '2865' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '2865' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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=2865 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (73984,73559,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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73984 AND teamId = 2865
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 2865
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2865
0.0147  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 = '2865' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2865' and rp.type = 4
0.0146  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 = '2865' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0166  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 = 73984 WHERE rp.league_id = 73984 AND rp.teamId = 2865 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.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 = 73984 WHERE rp.league_id = 73984 AND rp.teamId = 2865 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 73984 WHERE rp.league_id = 73984 AND rp.teamId = 2865 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 2865 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0306  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 = 73984 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 68752 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.0165  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 = 64280 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.0162  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 = 51161 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.0168  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 = 33454 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 15654 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 `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 = 4819 AND t.round = 34 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 `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 = 2746 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 `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 = 2085 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 = 1638 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 `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 = 24714 AND t.round = 34 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 `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 = 24732 AND t.round = 34 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 `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 = 542 AND t.round = 34 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 = 583 AND t.round = 34 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
0.0159  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 `tables2003` 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 = 587 AND t.round = 34 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 `tables2002` 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 = 589 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC