4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Massanassa C.F. A
TEMPORADA 2023/2024
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 UD Quart De Poblet Quart Poblet 28 42 17 60
2 Mislata Mislata 28 54 39 50
3 Historics de Valencia Historics 28 67 52 48
4 UD Paterna UD Paterna 28 57 43 47
5 At. La Luz Xirivella Xirivella 28 44 40 44
6 Godella Godella 28 58 61 41
7 San Marcelino Marcelino 28 50 51 40
8 Turis Turis 28 48 38 40
9 Cracks Cracks 28 39 43 35
10 San Antonio Benagéber Antonio 28 38 43 35
11 Vilamarxant Vilamarxant 28 37 44 32
12 Massanassa C.F. A Massanassa 28 37 46 32
13 Bétera Bétera 28 44 50 31
14 Vallbonense Vallbonense 28 31 41 30
15 Union Benetuser Union 28 43 54 29
16 S. Mislata S. Mislata 28 28 55 27
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 5
Equipo PJ GF GC Puntos
1 UE La Mancomunitat Mancomunitat 30 64 39 62
2 Racing D´ Algemesí Racing 29 56 25 60
3 Massanassa C.F. A Massanassa 30 59 25 57
4 Alcàsser Alcàsser 30 62 31 55
5 Picassent Picassent 30 55 36 49
6 Enguera Enguera 29 52 37 48
7 CD Llosa CD Llosa 30 51 32 47
8 Almusafes Almusafes 30 48 44 46
9 UD Castellonense B Castellonens 30 54 55 45
10 Vall Dels Alcalans Vall Dels A. 30 42 42 42
11 C.D. Apolo C.D. Apolo 30 49 60 36
12 Moixent C.F. Moixent C.F. 30 36 49 31
13 Rafelguaraf Rafelguaraf 29 43 56 26
14 Balompié Alfafar Balompié 29 48 85 23
15 CD Benifaio CD Benifaio 30 39 85 23
16 Racing Xativa A Racing 30 35 92 14
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 5
Equipo PJ GF GC Puntos
1 Promeses Sueca Promeses 28 56 22 58
2 Picassent Picassent 28 59 31 58
3 Vall Dels Alcalans Vall Dels A. 28 40 21 54
4 C.D. Apolo C.D. Apolo 28 56 44 48
5 Paiporta Paiporta 28 67 37 46
6 Monte Sión Monte Sión 28 39 32 42
7 Massanassa C.F. A Massanassa 28 43 46 41
8 Racing Xativa A Racing 28 48 37 39
9 San Marcelino B Marcelino 28 45 60 34
10 Fonteta Fonteta 28 35 41 32
11 Almusafes Almusafes 28 39 47 32
12 Cuenca-Mestallistes 1925 Cuenca-Mesta 28 49 55 31
13 Casas Casas 28 48 65 26
14 Juventud Picanya Juventud 28 40 77 26
15 Silla B Silla B 28 35 84 12
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 26
Equipo PJ GF GC Puntos
1 UD Castellonense B Castellonens 6 11 5 12
2 C.D. Apolo C.D. Apolo 6 20 16 12
3 UD Carcaixent B Carcaixent 6 17 16 12
4 Massanassa C.F. A Massanassa 6 12 14 9
5 Teresianas-Torrent Teresianas-T 6 12 12 8
6 Catarroja CF Catarroja 6 14 13 7
7 Benicalap Benicalap 6 7 17 1
TEMPORADA 2019/2020
TERCERA FFCV GRUPO 8
Equipo PJ GF GC Puntos
1 Fonteta Fonteta 24 50 20 60
2 Massanassa C.F. A Massanassa 24 88 23 58
3 Atletico Sedavi A Atletico 24 62 30 51
4 Almussafes B Almussafes 24 51 30 44
5 Cuenca-Mestallistes 1925 Cuenca-Mesta 24 71 45 39
6 O. Alcàsser Alcàsser 24 52 44 37
7 Albal CF Albal CF 24 51 46 34
8 Union Benetuser-Fabara B Union 24 47 54 34
9 Beniparrell Beniparrell 24 51 53 33
10 La Rambleta La Rambleta 24 50 48 32
11 C.D. Apolo B C.D. Apolo 24 49 42 29
12 Castellar-Oliveral B Castellar-Ol 24 43 57 29
13 Balompié Alfafar Balompié 24 37 59 29
14 At. Ciudad Paiporta Ciudad 24 38 81 15
15 Valls Dels Alcalans B Valls Dels. 24 27 92 13
16 Catarroja B Catarroja B 24 21 64 10
TEMPORADA 2018/2019
SEGUNDA FFCV GRUPO 5
Equipo PJ GF GC Puntos
1 SD Sueca SD Sueca 30 71 22 67
2 Llosa Llosa 29 87 36 66
3 Almusafes Almusafes 30 73 30 60
4 Catarroja CF Catarroja 30 58 47 54
5 Vall Dels Alcalans Vall Dels A. 29 50 33 50
6 Promeses Sueca Promeses 30 63 55 46
7 Racing D´ Algemesí Racing 30 38 40 45
8 Silla B Silla B 29 37 46 40
9 CF Cullera CF Cullera 30 60 64 38
10 Alberic Promeses Alberic 30 41 47 37
11 Picassent Picassent 29 48 47 35
12 CD Benifaio CD Benifaio 29 41 51 35
13 Alginet B Alginet B 30 35 47 32
14 Massanassa C.F. A Massanassa 30 57 70 29
15 CD de Futbol Canet A Futbol Canet 24 28 79 17
16 CD Chella CD Chella 29 24 97 6
TEMPORADA 2017/2018
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Vilamarxant Vilamarxant 34 74 26 77
2 Ribarroja CF Ribarroja 34 86 31 73
3 Torrent Torrent 34 67 30 72
4 CD Utiel CD Utiel 34 68 41 66
5 Burjassot Burjassot 34 59 44 60
6 UD Quart De Poblet Quart Poblet 33 51 42 52
7 San Marcelino Marcelino 34 52 54 49
8 Mislata Mislata 34 62 53 47
9 Juv. Barrio Cristo Juv. Barrio 34 43 46 42
10 Vallbonense Vallbonense 34 45 56 42
11 Castellar-Oliveral Castellar-Ol 34 47 68 41
12 Alcàsser Alcàsser 33 41 49 40
13 Huracan Moncada Huracan 34 51 56 38
14 SC Requena SC Requena 34 38 53 36
15 Discóbolo-La Torre Discóbolo-L 34 34 54 36
16 Massanassa C.F. A Massanassa 34 43 64 33
17 San Antonio Benagéber Antonio 34 38 73 33
18 Lliria UD Lliria UD 34 30 89 13
TEMPORADA 2016/2017
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Paiporta Paiporta 34 66 30 67
2 Ribarroja CF Ribarroja 34 73 34 65
3 Vilamarxant Vilamarxant 34 62 28 63
4 SC Requena SC Requena 34 55 34 63
5 UD Quart De Poblet Quart Poblet 34 48 29 61
6 Torrent Torrent 34 46 32 55
7 Castellar-Oliveral Castellar-Ol 34 51 47 52
8 CD Utiel CD Utiel 34 47 33 50
9 Burjassot Burjassot 34 51 43 50
10 Juv. Barrio Cristo Juv. Barrio 33 51 43 49
11 Lliria UD Lliria UD 34 39 40 47
12 R. Benagéber Benagéber 34 60 53 46
13 Alginet Alginet 34 50 53 44
14 Massanassa C.F. A Massanassa 33 41 51 41
15 Discóbolo-La Torre Discóbolo-L 33 36 46 39
16 Serranos Serranos 34 27 62 25
17 CD Cheste CD Cheste 33 42 91 22
18 CF Chiva CF Chiva 34 17 113 1
TEMPORADA 2015/2016
SEGUNDA FFCV GRUPO 5
Equipo PJ GF GC Puntos
1 Massanassa C.F. A Massanassa 30 85 46 68
2 Alcàsser Alcàsser 30 68 29 63
3 Picassent Picassent 30 65 37 62
4 Juventud Picanya Juventud 30 52 26 56
5 Torrent B Torrent B 30 60 42 50
6 Promeses Sueca Promeses 30 52 45 49
7 Almusafes Almusafes 30 47 43 48
8 Monte Sión Monte Sión 30 50 46 42
9 San Marcelino Marcelino 30 42 44 39
10 Catarroja CF Catarroja 30 56 63 37
11 CD Benifaio CD Benifaio 30 55 54 35
12 Imposibles Imposibles 30 48 72 34
13 L. Alfafar L. Alfafar 30 48 55 33
14 Carlet Carlet 30 40 62 24
15 Union Benetuser Union 30 24 70 20
16 Fonteta Fonteta 30 30 88 9

  USO DE MEMORIA  
5,873,656 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1088
Total Execution Time  0.1104
  CADENA URL  
/historico/Massanassa-A-Senior
  GET DATOS  
$_GET['/historico/Massanassa-A-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0029  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 = 'Massanassa-A-Senior' 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.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=66227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=66227 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 73770
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66227 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 = '66227' 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 = '66227' AND l.year = 2024 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 = '66227' 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 = 73770 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=66227 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73770,69373) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73770 AND teamId = 66227
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 69373 AND teamId = 66227
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 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 = 73770 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '66227' 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 = '66227' and rp.type = 4
0.0021  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 = '66227' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 73770 WHERE rp.league_id = 73770 AND rp.teamId = 66227 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.0028  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 = 73770 WHERE rp.league_id = 73770 AND rp.teamId = 66227 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 73770 WHERE rp.league_id = 73770 AND rp.teamId = 66227 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 = 66227 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73770 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `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 = 69373 AND t.round = 30 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 `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 = 64336 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 59530 AND t.round = 13 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 `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 = 62464 AND t.round = 7 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 `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 = 51385 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 45234 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 39356 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 16843 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 73770 ORDER BY nameShow LIMIT 100