4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Muravera
TEMPORADA 2021/2022
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 SSC Giugliano Giugliano 34 63 24 75
2 Sassari Torres Sassari 34 53 18 66
3 Team Nuova Florida Team Nuova. 34 57 35 66
4 Arzachena Arzachena 34 53 38 64
5 Afragolese Afragolese 34 56 45 58
6 Cynthialbalonga Cynthialbalo 34 62 45 55
7 Aprilia Aprilia 34 47 40 52
8 Ostia Mare Ostia Mare 34 44 36 48
9 Muravera Muravera 34 54 60 47
10 Vis Artena Vis Artena 34 44 48 46
11 Gladiator Gladiator 34 50 52 44
12 Real Monterotondo Scalo Real 34 48 59 39
13 Cassino Cassino 34 38 49 38
14 Atletico Uri Atletico 34 32 53 35
15 Carbonia Carbonia 34 38 64 29
16 Insieme Formia Insieme 34 33 64 29
17 Lanusei Lanusei 34 32 55 28
18 Latte Dolce Latte Dolce 34 30 49 27
TEMPORADA 2020/2021
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Monterosi Tuscia Monterosi 34 65 26 81
2 Latina Latina 34 60 29 65
3 FC Savoia 1908 Savoia 1908 34 39 22 57
4 Nocerina Nocerina 34 51 32 53
5 Vis Artena Vis Artena 34 51 43 53
6 Insieme Formia Insieme 34 52 39 50
7 Lanusei Lanusei 34 46 40 47
8 Muravera Muravera 34 42 40 47
9 Carbonia Carbonia 34 56 55 46
10 Latte Dolce Latte Dolce 34 45 42 44
11 Cassino Cassino 34 41 48 41
12 Gladiator Gladiator 34 37 44 40
13 Team Nuova Florida Team Nuova. 34 39 48 39
14 Arzachena Arzachena 34 39 50 36
15 Sassari Torres Sassari 34 31 48 34
16 Afragolese Afragolese 34 40 60 34
17 Nola 1925 Nola 1925 34 37 58 34
18 SSC Giugliano Giugliano 34 29 76 20
TEMPORADA 2019/2020
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Turris Neapolis Turris 26 65 24 61
2 Ostia Mare Ostia Mare 26 46 21 57
3 Sassari Torres Sassari 26 44 25 51
4 Trastevere Trastevere 26 46 33 45
5 Latte Dolce Latte Dolce 26 40 29 45
6 Latina Latina 26 40 30 39
7 Cassino Cassino 26 27 30 39
8 Vis Artena Vis Artena 26 35 38 35
9 Muravera Muravera 26 33 32 34
10 Team Nuova Florida Team Nuova. 26 33 35 33
11 Lanusei Lanusei 26 23 25 31
12 Portici Portici 26 31 41 30
13 Aprilia Aprilia 26 25 30 29
14 Arzachena Arzachena 26 31 39 27
15 Città di Anagni Città 26 32 44 25
16 Pro Calcio Tor Sapienza Calcio 26 23 55 19
17 Ladispoli Ladispoli 26 25 42 18
18 Budoni Budoni 26 23 49 16
TEMPORADA 2016/2017
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Arzachena Arzachena 34 62 21 74
2 Monterosi Tuscia Monterosi 34 69 22 73
3 Rieti Rieti 34 67 29 71
4 L'Aquila L'Aquila 34 57 27 63
5 Ostia Mare Ostia Mare 34 59 33 63
6 Nuorese Calcio Nuorese 34 43 33 58
7 Albalonga Albalonga 34 59 42 55
8 Avezzano Avezzano 34 42 36 46
9 Sansepolcro Calcio Sansepolcro 34 50 47 46
10 Flaminia Flaminia 34 48 41 45
11 Lanusei Lanusei 34 45 52 44
12 Sporting Trestina Sporting 34 46 44 43
13 Latte Dolce Latte Dolce 34 34 44 38
14 San Teodoro San Teodoro 34 32 57 31
15 Muravera Muravera 34 24 51 30
16 Sassari Torres Sassari 34 23 58 28
17 Città di Castello Città 34 25 64 24
18 Foligno Calcio Foligno 34 12 96 12
TEMPORADA 2015/2016
SERIE D GRUPO 7
Equipo PJ GF GC Puntos
1 Viterbese Viterbese 34 67 24 76
2 Grosseto Grosseto 34 71 43 68
3 Sassari Torres Sassari 34 64 28 66
4 Olbia Calcio Olbia Calcio 34 58 42 63
5 Rieti Rieti 34 52 30 62
6 Arzachena Arzachena 34 44 37 59
7 Albalonga Albalonga 34 63 45 57
8 Nuorese Calcio Nuorese 34 41 33 51
9 Flaminia Flaminia 34 49 44 47
10 Ostia Mare Ostia Mare 34 34 34 44
11 Trastevere Trastevere 34 35 38 40
12 Muravera Muravera 34 38 51 37
13 Lanusei Lanusei 34 25 49 35
14 Budoni Budoni 34 36 49 34
15 Cynthia Cynthia 34 37 60 33
16 Castiadas Castiadas 34 31 57 31
17 San Cesareo Calcio Cesareo 34 24 48 28
18 Astrea Astrea 34 22 79 14

  USO DE MEMORIA  
5,702,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1142
Total Execution Time  0.1154
  CADENA URL  
/historico/Muravera
  GET DATOS  
$_GET['/historico/Muravera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0025  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 = 'Muravera' 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.0036  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 = 'Muravera' 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=66535 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=66535 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=66535 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=66535 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=66535 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=66535 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=66535 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=66535 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=66535 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=66535 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 64281
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66535 AND type_rel = 2
0.0023  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 = '66535' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '66535' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '66535' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '66535' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 64281 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=66535 AND l.year in (2021,2022,2023) 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 (64281,64181) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 64281 AND teamId = 66535
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 64181 AND teamId = 66535
0.0021  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 = '66535' 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 = '66535' 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 = '66535' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 events2022 e ON e.player_id = p.id AND e.league_id = 64281 WHERE rp.league_id = 64281 AND rp.teamId = 66535 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.0037  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 events2022 e ON e.player_id = p.id AND e.league_id = 64281 WHERE rp.league_id = 64281 AND rp.teamId = 66535 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2022 e ON e.player_id = p.id AND e.league_id = 64281 WHERE rp.league_id = 64281 AND rp.teamId = 66535 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 66535 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 64281 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.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 `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 = 58832 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.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 `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 = 51162 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.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 = 33455 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 `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 = 15655 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC