4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del S. Mislata
TEMPORADA 2023/2024
PRIMERA FFCV GRUPO 2
Equipo PJ GF GC Puntos
1 UD Quart De Poblet Quart Poblet 26 39 16 57
2 Mislata Mislata 26 50 34 49
3 Historics de Valencia Historics 26 63 44 47
4 UD Paterna UD Paterna 26 51 42 41
5 Godella Godella 26 54 55 40
6 San Marcelino Marcelino 26 49 45 40
7 At. La Luz Xirivella Xirivella 26 41 39 38
8 Turis Turis 26 43 34 37
9 Cracks Cracks 27 36 40 34
10 San Antonio Benagéber Antonio 25 33 37 32
11 Bétera Bétera 26 43 46 30
12 Vilamarxant Vilamarxant 27 35 43 29
13 Massanassa C.F. A Massanassa 26 31 45 26
14 Vallbonense Vallbonense 26 28 40 26
15 Union Benetuser Union 25 40 50 26
16 S. Mislata S. Mislata 26 24 50 24
TEMPORADA 2022/2023
SEGUNDA FFCV GRUPO 4
Equipo PJ GF GC Puntos
1 At. La Luz Xirivella Xirivella 30 67 19 71
2 UD Paterna UD Paterna 30 67 30 67
3 Turis Turis 29 66 33 62
4 S. Mislata S. Mislata 30 69 44 57
5 Juv. Barrio Cristo Juv. Barrio 30 53 29 57
6 Colegio Salgui EDE Colegio 29 48 41 43
7 Serranos Serranos 30 52 45 40
8 San Marcelino B Marcelino 30 64 64 39
9 Monte Sión Monte Sión 30 52 54 35
10 Alaquas I Walter A Alaquas 30 36 45 34
11 Xirivella Xirivella 30 50 72 34
12 Fonteta Fonteta 29 35 50 33
13 CD Cheste CD Cheste 30 44 66 33
14 EAF Valencia Valencia 30 53 62 31
15 J. Manisense A Manisense 30 39 70 23
16 La Hoya CF La Hoya CF 29 28 99 5
TEMPORADA 2021/2022
SEGUNDA FFCV GRUPO 4
Equipo PJ GF GC Puntos
1 Mislata Mislata 28 70 15 68
2 S. Mislata S. Mislata 28 61 22 66
3 Serranos Serranos 28 68 36 53
4 CD Cheste CD Cheste 28 57 32 51
5 At. La Luz Xirivella Xirivella 28 54 33 47
6 Xirivella Xirivella 28 55 46 45
7 Turis Turis 28 64 44 43
8 La Hoya CF La Hoya CF 28 61 61 38
9 UD Paterna UD Paterna 28 56 57 35
10 Torrefiel Ath. Torrefiel 28 47 64 34
11 Paterna B Paterna B 28 44 52 33
12 Benimamet Benimamet 28 46 55 33
13 Zafranar A Zafranar A 28 31 83 19
14 El Rumbo A El Rumbo A 28 34 68 11
15 At. Quelmo-Manises Quelmo-Manis 28 28 108 10
TEMPORADA 2020/2021
SEGUNDA FFCV GRUPO 14
Equipo PJ GF GC Puntos
1 San Antonio Benagéber Antonio 6 14 6 14
2 Bétera Bétera 6 17 10 14
3 S. Mislata S. Mislata 6 10 7 12
4 Cracks Cracks 6 14 11 8
5 Benisano Benisano 6 15 16 7
6 Lliria UD Lliria UD 6 8 20 3
7 Mislata Mislata 6 14 22 1
TEMPORADA 2019/2020
SEGUNDA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Union Benetuser Union 24 60 33 50
2 Monte Sión Monte Sión 24 49 28 48
3 Juventud Picanya Juventud 24 54 29 46
4 Alaquas I Walter A Alaquas 24 41 31 42
5 Yatova Yatova 24 58 45 40
6 Turis Turis 24 44 40 37
7 Mislata Mislata 24 51 38 36
8 At. La Luz Xirivella Xirivella 24 36 33 36
9 C.D. Apolo C.D. Apolo 24 43 38 35
10 CF Chiva CF Chiva 24 36 34 35
11 J. Manisense A Manisense 24 46 50 32
12 Castellar-Oliveral Castellar-Ol 24 34 54 27
13 Xirivella Xirivella 24 21 37 25
14 S. Mislata S. Mislata 24 30 48 23
15 UD Aldaia B UD Aldaia B 24 25 60 18
16 Zafranar A Zafranar A 24 28 58 13
TEMPORADA 2018/2019
SEGUNDA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Benimar Picanya Benimar 30 75 35 71
2 Manises Manises 30 70 37 65
3 Juventud Picanya Juventud 30 58 37 60
4 Yatova Yatova 30 71 50 53
5 Xirivella Xirivella 29 54 45 44
6 Zafranar A Zafranar A 30 51 55 42
7 Paterna B Paterna B 30 48 49 39
8 S. Mislata S. Mislata 29 43 43 38
9 Alaquas I Walter A Alaquas 30 47 60 38
10 C.D. Apolo C.D. Apolo 30 40 39 35
11 Turis Turis 30 33 48 35
12 CD Cheste CD Cheste 30 41 46 34
13 J. Manisense A Manisense 30 50 65 34
14 Casas Casas 30 48 54 31
15 UD Aldaia B UD Aldaia B 29 43 69 31
16 R. Paterna R. Paterna 29 32 72 18
TEMPORADA 2017/2018
SEGUNDA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 UD Aldaia UD Aldaia 30 90 25 67
2 Monte Sión Monte Sión 29 56 26 63
3 Zafranar A Zafranar A 30 64 40 60
4 Manises Manises 30 79 43 58
5 Yatova Yatova 30 57 58 47
6 CD Cheste CD Cheste 30 46 42 46
7 S. Mislata S. Mislata 30 47 48 39
8 Turis Turis 30 37 43 38
9 Casas Casas 30 56 63 37
10 Alaquas I Walter A Alaquas 30 54 62 36
11 J. Manisense A Manisense 30 34 58 33
12 Paterna B Paterna B 30 51 62 32
13 Historics de Valencia Historics 30 42 54 29
14 CF Chiva CF Chiva 30 51 70 29
15 Fonteta Fonteta 30 48 63 26
16 UD Paterna UD Paterna 29 34 89 19
TEMPORADA 2016/2017
SEGUNDA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Mislata Cf Mislata Cf 29 72 25 69
2 Xirivella Xirivella 30 69 32 66
3 T. Blanques T. Blanques 30 65 30 66
4 S. Mislata S. Mislata 30 72 38 62
5 Monte Sión Monte Sión 29 71 38 48
6 Historics de Valencia Historics 30 74 51 48
7 Foios Atletic Foios 30 57 51 43
8 Alfarense Alfarense 30 54 59 41
9 Yatova Yatova 30 56 65 40
10 Casas Casas 30 60 50 37
11 Alaquas I Walter A Alaquas 29 51 53 37
12 Turis Turis 30 36 43 34
13 Villena B Villena B 30 51 63 34
14 Bellavista-Meliana Bellavista-M 30 38 96 21
15 A. Requenense Requenense 30 32 84 13
16 Chiva B Chiva B 29 31 111 12
TEMPORADA 2015/2016
SEGUNDA FFCV GRUPO 3
Equipo PJ GF GC Puntos
1 Burjassot Burjassot 30 79 21 79
2 Serranos Serranos 30 80 36 68
3 S. Mislata S. Mislata 30 64 28 64
4 Xirivella Xirivella 30 50 36 50
5 Casas Casas 30 51 52 46
6 Mislata Cf Mislata Cf 30 54 41 42
7 Turis Turis 30 60 57 42
8 San Antonio Benagéber Antonio 30 36 44 42
9 Alaquas I Walter A Alaquas 30 48 53 36
10 Moncada Moncada 30 55 65 36
11 A. Requenense Requenense 30 29 39 35
12 T. Blanques T. Blanques 30 47 76 33
13 Turia Turia 30 51 61 31
14 Puzol B Puzol B 30 43 62 31
15 Meliana Meliana 30 37 59 26
16 Masamagrell Masamagrell 30 37 91 19
TEMPORADA 2014/2015
SEGUNDA FFCV GRUPO 4
Equipo PJ GF GC Puntos
1 Manises Manises 30 79 25 76
2 Pedralba Pedralba 30 77 36 68
3 R. Benagéber Benagéber 30 70 28 65
4 Cracks Cracks 30 64 31 64
5 La Eliana La Eliana 30 42 33 51
6 Moncada Moncada 30 50 41 46
7 Vallbonense Vallbonense 30 56 43 45
8 S. Mislata S. Mislata 30 46 50 40
9 Los Silos A Los Silos A 30 45 51 40
10 A. Moncadense Moncadense 30 30 40 35
11 Benicalap Benicalap 30 40 68 34
12 Casinos Casinos 30 49 60 30
13 Atl. Villar Atl. Villar 30 40 59 30
14 S. Ribarroja Ribarroja 30 43 77 28
15 Ribarroja B Ribarroja B 30 38 72 19
16 R. Paterna R. Paterna 30 30 85 14

  USO DE MEMORIA  
5,960,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.5494
Total Execution Time  0.5513
  CADENA URL  
/historico/Club-Sporting-Mislata-Union-De-Futbol-Senior
  GET DATOS  
$_GET['/historico/Club-Sporting-Mislata-Union-De-Futbol-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
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 = 'Club-Sporting-Mislata-Union-De-Futbol-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=46316 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=46316 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46316 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6 AND type_rel = 3
0.0127  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.0127  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.0128  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 = '46316' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '46316' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '46316' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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.0129  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=46316 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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,69372) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73770 AND teamId = 46316
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 69372 AND teamId = 46316
0.0126  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 = '46316' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  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 = '46316' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73770 WHERE rp.league_id = 73770 AND rp.teamId = 46316 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.0139  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 = 46316 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 46316 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 46316 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 69372 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.0138  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 = 64335 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.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 = 59528 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.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 `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 = 62452 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.0141  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 = 51328 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.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 `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 = 45232 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 39363 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 34293 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 = 16841 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 7085 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC