4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Quart de Les Valls
TEMPORADA 2023/2024
PRIMERA FFCV GRUPO 1
Equipo PJ GF GC Puntos
1 Paterna CF Paterna CF 27 47 25 53
2 Odisea FC Odisea FC 27 41 22 50
3 Mare Nostrum Puerto Sagunto Mare Nostrum 26 42 24 46
4 Moncofa Moncofa 27 44 29 44
5 Benicarló Benicarló 27 47 38 40
6 CD Roda B CD Roda B 27 39 36 39
7 Quart de Les Valls Quart Valls 27 56 41 38
8 Cabanes Cabanes 27 38 41 37
9 CF Albuixech Albuixech 27 35 38 36
10 Nules Nules 26 30 47 33
11 Vinaròs Vinaròs 26 45 55 32
12 CF Alcalá CF Alcalá 27 55 48 30
13 Tavernes Blanques CF Tavernes 26 35 46 29
14 C.F San Pedro Pedro 26 25 39 29
15 Ibarsos Ibarsos 26 31 54 28
16 Puzol Puzol 27 44 71 25
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Mare Nostrum Puerto Sagunto Mare Nostrum 30 85 22 78
2 Nules Nules 30 77 29 70
3 Quart de Les Valls Quart Valls 30 74 30 65
4 CF Albuixech Albuixech 30 81 37 62
5 Almenara Atlètic Almenara 30 67 44 54
6 Betxi Betxi 30 57 38 49
7 At. Gilet At. Gilet 30 60 61 47
8 Vall de Uxó B Vall Uxó 30 53 45 41
9 FB Sagunto FB Sagunto 30 43 43 38
10 Faura Faura 30 54 74 37
11 Jupiter de Massamagrell A Jupiter 30 51 62 34
12 CD Burriana B Burriana 30 32 65 25
13 La Vilavella Vilavella 30 43 82 25
14 Jerica Jerica 30 31 56 23
15 Rafelbuñol Rafelbuñol 30 45 117 16
16 El Puig El Puig 30 29 77 15
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Moncofa Moncofa 28 45 19 60
2 Betxi Betxi 28 56 32 56
3 FB Sagunto FB Sagunto 28 47 22 53
4 Jerica Jerica 27 46 31 44
5 Vall de Uxó B Vall Uxó 27 44 29 44
6 Quart de Les Valls Quart Valls 28 48 40 44
7 Nules Nules 27 48 45 39
8 Rafelbuñol Rafelbuñol 28 42 41 39
9 El Puig El Puig 27 50 45 37
10 Faura Faura 27 64 58 36
11 La Vilavella Vilavella 28 42 46 36
12 Villa de Onda Villa Onda 28 54 54 34
13 Onda B Onda B 27 33 54 23
14 Artana Artana 28 26 77 11
15 Xilxes Xilxes 22 18 70 6
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 A. Moncadense Moncadense 13 43 16 29
2 Mare Nostrum Puerto Sagunto Mare Nostrum 12 35 15 29
3 Serranos Serranos 12 24 9 26
4 FB Sagunto FB Sagunto 13 17 14 21
5 El Rumbo A El Rumbo A 13 25 29 20
6 Jerica Jerica 13 25 26 19
7 Jupiter de Massamagrell A Jupiter 13 23 23 18
8 Rafelbuñol Rafelbuñol 13 21 22 16
9 Foios Atletic Foios 13 20 18 15
10 Benimamet Benimamet 13 26 32 15
11 Meliana Meliana 13 22 30 15
12 Quart de Les Valls Quart Valls 13 24 33 12
13 Puzol B Puzol B 13 18 28 12
14 P. Farnals P. Farnals 13 14 42 6
TEMPORADA 2019/2020
SEGUNDA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Patacona CF Patacona CF 24 56 21 51
2 Onda B Onda B 24 45 26 48
3 Club La Vall Club Vall 24 38 25 42
4 T. Blanques T. Blanques 24 33 21 39
5 Burriana S. A Burriana 24 37 35 37
6 Esportiu Vila Real Esportiu 24 45 31 35
7 Moncofa Moncofa 24 31 25 34
8 Artana Artana 24 36 45 30
9 Jupiter de Massamagrell A Jupiter 24 37 47 30
10 Quart de Les Valls Quart Valls 24 26 38 29
11 FB Sagunto FB Sagunto 24 30 38 25
12 Xilxes Xilxes 24 33 48 25
13 Foios Atletic Foios 24 34 42 24
14 Puzol B Puzol B 24 35 38 23
15 Jerica Jerica 24 34 44 23
16 P. Farnals P. Farnals 24 29 55 21
TEMPORADA 2018/2019
SEGUNDA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 Soneja Soneja 30 84 26 73
2 Artana Artana 30 53 35 59
3 T. Blanques T. Blanques 30 59 36 55
4 Club La Vall Club Vall 30 54 46 45
5 Burriana S. A Burriana 30 51 53 39
6 Jerica Jerica 30 46 48 39
7 P. Farnals P. Farnals 30 62 64 38
8 Puzol B Puzol B 30 51 56 38
9 Moncofa Moncofa 30 40 46 37
10 FB Sagunto FB Sagunto 30 32 45 36
11 Jupiter de Massamagrell A Jupiter 30 37 52 35
12 Betxi Betxi 30 57 55 33
13 Quart de Les Valls Quart Valls 30 61 73 33
14 Foios Atletic Foios 30 36 56 33
15 El Puig El Puig 30 38 54 30
16 Saguntino B Saguntino B 30 36 52 25
TEMPORADA 2017/2018
TERCERA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Quart de Les Valls Quart Valls 27 99 17 74
2 CD de Futbol Canet A Futbol Canet 28 80 37 62
3 Faura Faura 27 82 41 58
4 Viver Viver 27 68 37 56
5 At. Gilet At. Gilet 28 69 45 56
6 La Vilavella Vilavella 28 60 46 47
7 E. Vila-Real B Vila-Real 28 66 56 41
8 R. Onda R. Onda 28 70 61 40
9 Alqueries B Alqueries B 28 56 47 38
10 Almenara Atl. B Almenara 28 55 61 34
11 Estivella Estivella 28 40 77 27
12 Huracan Vila Real A Huracan Vila 26 32 70 23
13 Benicató Benicató 27 38 84 16
14 Andiamo Vila Real Andiamo Vila 28 34 97 15
15 Ribesalbes A Ribesalbes 28 30 103 6
16 CF No Solo Futbol Sagunto A Solo Futbol 0 0 0 0
TEMPORADA 2016/2017
TERCERA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Soneja Soneja 26 69 28 61
2 Quart de Les Valls Quart Valls 26 85 33 57
3 Jerica Jerica 24 64 17 56
4 Almazora B Almazora B 25 55 25 54
5 Viver Viver 25 75 38 43
6 Alqueries B Alqueries B 24 50 44 39
7 La Vilavella Vilavella 26 57 40 37
8 Benicató Benicató 25 51 47 34
9 La Llosa La Llosa 25 53 74 31
10 Ribesalbes A Ribesalbes 25 47 59 27
11 Huracan Vila Real A Huracan Vila 25 41 66 27
12 E. Vila-Real B Vila-Real 25 29 61 16
13 Andiamo Vila Real Andiamo Vila 25 29 84 14
14 Montanejos CF Montanejos 0 0 0 0
15 Racing Onda B Racing Onda 18 16 105 0
TEMPORADA 2015/2016
TERCERA FFCV GRUPO 4
Equipo PJ GF GC Puntos
1 Independent Albuixech Independent 30 106 33 80
2 Foios Atletic Foios 30 75 30 71
3 P. Farnals P. Farnals 30 89 40 70
4 Jupiter de Massamagrell A Jupiter 30 72 38 63
5 Saguntino B Saguntino B 30 67 58 48
6 Albuixech B Albuixech B 30 70 51 48
7 Rafelbuñol Rafelbuñol 30 59 59 41
8 Biensa Biensa 30 54 65 39
9 At. Gilet At. Gilet 30 62 65 37
10 Quart de Les Valls Quart Valls 30 50 53 37
11 Albalat CF Albalat CF 30 55 71 30
12 CD de Futbol Canet A Futbol Canet 30 48 71 30
13 El Puig B El Puig B 30 48 68 26
14 Estivella Estivella 30 43 74 25
15 San Lorenzo San Lorenzo 30 33 79 17
16 Benifairo V. A Benifairo 30 40 116 16

  USO DE MEMORIA  
5,879,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5144
Total Execution Time  0.5156
  CADENA URL  
/historico/Cf-At-Quart-De-Les-Valls-Senior
  GET DATOS  
$_GET['/historico/Cf-At-Quart-De-Les-Valls-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
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 = 'Cf-At-Quart-De-Les-Valls-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.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=83486 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=83486 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83486 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6 AND type_rel = 3
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 6 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0134  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1240552,1212752,1211465,1207372,1081973) ORDER BY n.cover_points DESC, update_date DESC
0.0139  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 = '83486' ORDER BY l.year DESC,cat.coefficient DESC
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 = '83486' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0139  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 = '83486' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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=83486 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (73769,69370) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73769 AND teamId = 83486
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 69370 AND teamId = 83486
0.0130  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 = '83486' 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 = '83486' and rp.type = 4
0.0133  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 = '83486' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0162  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 83486 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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 83486 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 73769 WHERE rp.league_id = 73769 AND rp.teamId = 83486 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 83486 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73769 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 69370 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.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 `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 = 64333 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.0127  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 = 62461 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.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 `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 = 59527 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.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 `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 = 51327 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.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 `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 = 45231 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 39662 AND t.round = 30 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 = 35306 AND t.round = 30 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 = 16881 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC