4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Vastogirardi
TEMPORADA 2023/2024
SERIE D GRUPO 6
Equipo PJ GF GC Puntos
1 Città di Campobasso Città 33 54 28 69
2 L'Aquila L'Aquila 33 39 22 65
3 Avezzano Avezzano 33 48 32 56
4 Sambenedettese Sambenedette 33 52 33 55
5 Roma City Roma City 33 52 35 49
6 Vigor Senigallia Vigor 33 54 45 49
7 Chieti Chieti 33 35 34 47
8 ASD Atletico Ascoli Atletico 33 35 31 47
9 SN Notaresco 2018 Notaresco 33 37 37 45
10 Termoli Calcio Termoli 33 29 35 42
11 Sora Sora 33 36 35 41
12 FC Fossombrone Fossombrone 33 28 27 41
13 Real Monterotondo Scalo Real 33 40 55 41
14 Riccione Riccione 33 46 47 37
15 Tivoli Tivoli 33 37 55 34
16 Fano Fano 33 30 47 29
17 Vastogirardi Vastogirardi 33 24 47 29
18 Matese Matese 33 20 51 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 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

  USO DE MEMORIA  
5,729,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4852
Total Execution Time  0.4865
  CADENA URL  
/historico/Asd-Vastogirardi
  GET DATOS  
$_GET['/historico/Asd-Vastogirardi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0147  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 = 'Asd-Vastogirardi' 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.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=121927 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=121927 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=121927 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=121927 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121927 AND type_rel = 2
0.0143  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 = '121927' AND l.year = 2024 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 = '121927' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0164  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 = 73559 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 73984 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=121927 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0135  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.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 73984 AND teamId = 121927
0.0180  SELECT count(id) as num_players from rel_players WHERE league_id = 73559 AND teamId = 121927
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 121927
0.0133  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 = '121927' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '121927' and rp.type = 4
0.0128  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 = '121927' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 73984 WHERE rp.league_id = 73984 AND rp.teamId = 121927 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.0137  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 = 121927 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 121927 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 121927 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254  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 = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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.0144  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.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 `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.0144  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