4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Olympia Agnonese
TEMPORADA 2020/2021
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Città di Campobasso Città 34 63 29 72
2 SN Notaresco 2018 Notaresco 34 59 34 64
3 Pineto Pineto 34 45 35 56
4 Cynthialbalonga Cynthialbalo 34 51 36 56
5 Matese Matese 34 46 38 56
6 Castelfidardo Calcio Castelfidard 34 46 33 55
7 Recanatese Recanatese 34 62 45 50
8 Castelnuovo Vomano Castelnuovo 34 53 53 50
9 Vastese Vastese 34 47 37 48
10 Montegiorgio Montegiorgio 34 42 42 46
11 Rieti Rieti 34 38 42 44
12 Aprilia Aprilia 34 43 49 44
13 Tolentino Tolentino 34 52 53 40
14 Fiuggi Fiuggi 34 40 41 40
15 Vastogirardi Vastogirardi 34 46 51 40
16 Real Giulianova Real 34 33 50 31
17 Porto Sant'Elpidio Porto 34 22 63 17
18 Olympia Agnonese Olympia 34 26 83 15
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 2018/2019
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Cesena Cesena 38 69 28 83
2 Matelica Calcio Matelica 38 74 36 80
3 Recanatese Recanatese 38 55 35 63
4 Pineto Pineto 38 59 41 62
5 Sangiustese Sangiustese 38 49 38 61
6 Francavilla Calcio Francavilla 38 59 44 60
7 SN Notaresco 2018 Notaresco 38 48 43 54
8 Jesina Jesina 38 34 38 51
9 Montegiorgio Montegiorgio 38 36 43 51
10 Città di Campobasso Città 38 49 49 49
11 Sammaurese Sammaurese 38 36 48 49
12 Savignanese Savignanese 38 42 43 48
13 Avezzano Avezzano 38 47 50 45
14 Real Giulianova Real 38 34 47 44
15 Forli Forli 38 47 47 43
16 Vastese Vastese 38 47 61 42
17 Olympia Agnonese Olympia 38 36 46 41
18 Santarcangelo Santarcangel 38 41 61 37
19 Isernia Isernia 38 28 53 35
20 Castelfidardo Calcio Castelfidard 38 34 73 23
TEMPORADA 2017/2018
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Vis Pesaro Vis Pesaro 34 61 29 73
2 Matelica Calcio Matelica 34 66 28 71
3 Avezzano Avezzano 34 51 26 62
4 Pineto Pineto 34 53 41 57
5 L'Aquila L'Aquila 34 57 40 55
6 Francavilla Calcio Francavilla 34 47 38 53
7 San Marino Calcio Marino 34 45 35 51
8 Vastese Vastese 34 55 50 51
9 Città di Campobasso Città 34 41 40 49
10 Sangiustese Sangiustese 34 39 41 48
11 Castelfidardo Calcio Castelfidard 34 43 54 44
12 Recanatese Recanatese 34 47 47 43
13 Olympia Agnonese Olympia 34 34 35 41
14 SN Notaresco 2018 Notaresco 34 42 51 40
15 Jesina Jesina 34 32 46 34
16 Monticelli Monticelli 34 25 45 30
17 Fabriano Cerreto Fabriano 34 29 69 20
18 Nerostellati Pratola Nerostellati 34 19 71 18
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
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Ancona Ancona 34 69 18 78
2 Matelica Calcio Matelica 34 64 29 68
3 Termoli Calcio Termoli 34 66 28 67
4 Maceratese Maceratese 34 61 34 64
5 Vis Pesaro Vis Pesaro 34 53 38 49
6 Recanatese Recanatese 34 53 39 49
7 FC Celano Marsica Celano 34 46 26 46
8 Jesina Jesina 34 51 48 46
9 Fermana Fermana 34 48 40 45
10 Fano Fano 34 37 31 44
11 Real Giulianova Real 34 45 41 44
12 Civitanovese Civitanovese 34 36 32 44
13 Olympia Agnonese Olympia 34 41 47 43
14 Amiternina Amiternina 34 38 40 40
15 Sulmona Sulmona 34 40 53 40
16 Isernia Isernia 34 29 57 28
17 RC Angolana RC Angolana 34 34 53 26
18 Bojano Bojano 34 9 166 4
TEMPORADA 2012/2013
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Sambenedettese Sambenedette 34 75 35 71
2 Termoli Calcio Termoli 34 74 39 68
3 San Cesareo Calcio Cesareo 34 69 44 68
4 Maceratese Maceratese 34 58 39 64
5 Vis Pesaro Vis Pesaro 34 47 25 57
6 Olympia Agnonese Olympia 34 68 56 53
7 Ancona Ancona 34 54 43 53
8 Astrea Astrea 34 53 47 50
9 Jesina Jesina 34 50 47 46
10 Civitanovese Civitanovese 34 34 45 42
11 Amiternina Amiternina 34 39 49 40
12 Fidene Fidene 34 41 52 40
13 Isernia Isernia 34 46 65 38
14 RC Angolana RC Angolana 34 35 53 37
15 FC Celano Marsica Celano 34 32 42 33
16 Recanatese Recanatese 34 28 51 29
17 SN Notaresco 2018 Notaresco 34 36 62 22
18 Città di Marino Città 34 33 78 20
TEMPORADA 2011/2012
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Teramo Teramo 34 86 29 73
2 Sambenedettese Sambenedette 34 57 31 72
3 Civitanovese Civitanovese 34 60 33 68
4 Isernia Isernia 34 46 35 60
5 Atletico Trivento Atletico 34 60 46 59
6 SN Notaresco 2018 Notaresco 34 43 40 50
7 Jesina Jesina 34 48 33 48
8 Olympia Agnonese Olympia 34 64 56 48
9 Recanatese Recanatese 34 41 36 46
10 Vis Pesaro Vis Pesaro 34 45 47 44
11 Riccione Riccione 34 52 56 39
12 Atessa Val di Sangro Atessa 34 40 49 39
13 RC Angolana RC Angolana 34 34 45 36
14 Santegidiese Santegidiese 34 48 62 36
15 Miglianico Miglianico 34 32 57 24
16 Luco Canistro Luco 34 22 71 19
17 Real Rimini FC Real Rimini 34 16 105 6
TEMPORADA 2010/2011
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Santarcangelo Santarcangel 38 65 20 77
2 Teramo Teramo 38 63 38 73
3 Rimini Rimini 38 66 39 71
4 Forli Forli 38 50 43 66
5 Santegidiese Santegidiese 38 62 51 59
6 Jesina Jesina 38 43 37 59
7 RC Angolana RC Angolana 38 59 44 58
8 Real Rimini FC Real Rimini 38 51 44 56
9 Recanatese Recanatese 38 32 35 56
10 Civitanovese Civitanovese 38 37 35 52
11 Atletico Trivento Atletico 38 56 43 51
12 Sambenedettese Sambenedette 38 51 46 51
13 Luco Canistro Luco 38 50 54 51
14 Olympia Agnonese Olympia 38 42 51 51
15 US Venafro US Venafro 38 52 64 49
16 Atessa Val di Sangro Atessa 38 36 44 47
17 Real Cesenatico Real 38 39 61 35
18 Miglianico Miglianico 38 40 57 32
19 FC Fossombrone Fossombrone 38 24 56 22
20 Bojano Bojano 38 21 77 10
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

  USO DE MEMORIA  
6,645,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.8319
Total Execution Time  0.8332
  CADENA URL  
/historico/Olympia-Agnonese
  GET DATOS  
$_GET['/historico/Olympia-Agnonese']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0133  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 = 'Olympia-Agnonese' 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.0144  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 = 'Olympia-Agnonese' 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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=6930 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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6930 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=6930 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=6930 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=6930 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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=6930 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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 = 58831
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6930 AND type_rel = 2
0.0144  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 = '6930' ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '6930' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0142  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 = '6930' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '6930' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139  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 = 58831 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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=6930 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0134  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 (58831,51105) 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.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 58831 AND teamId = 6930
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 51105 AND teamId = 6930
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 58831 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '6930' 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 = '6930' and rp.type = 4
0.0132  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 = '6930' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0165  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 events2021 e ON e.player_id = p.id AND e.league_id = 58831 WHERE rp.league_id = 58831 AND rp.teamId = 6930 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.0141  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 events2021 e ON e.player_id = p.id AND e.league_id = 58831 WHERE rp.league_id = 58831 AND rp.teamId = 6930 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 events2021 e ON e.player_id = p.id AND e.league_id = 58831 WHERE rp.league_id = 58831 AND rp.teamId = 6930 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 6930 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0136  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 = 58831 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.0134  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.0134  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 = 39599 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 `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.0137  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.0129  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.0134  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 = 24680 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 2095 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 `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 = 1696 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 24700 AND t.round = 38 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 `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.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 `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.0127  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 58831 ORDER BY nameShow LIMIT 100