4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mislata B
TEMPORADA 2022/2023
AUTO. VALENCIA FEMENINA
Equipo PJ GF GC Puntos
1 La Nucia A La Nucia A 27 101 25 69
2 Intercity Intercity 28 81 39 58
3 La Eliana La Eliana 30 56 42 52
4 Levante D Levante D 25 58 34 51
5 Tavernes Blanques A Tavernes 26 49 43 46
6 Valencia C Fem Valencia 23 46 30 43
7 Villarreal C Villarreal 27 42 46 39
8 Fenix Moncada A Fenix 30 54 57 38
9 At. Càrcer At. Càrcer 30 55 62 37
10 Mislata B Mislata B 27 44 56 34
11 CD Onda A CD Onda A 27 43 53 31
12 Elche B Elche B 29 50 62 31
13 Alqueries A Alqueries A 26 30 58 29
14 Atco Aspe A Atco Aspe A 26 32 53 27
15 Discobolo La Torre B Discobolo 26 31 78 20
16 CF Maritim Fem Maritim 27 38 72 17
TEMPORADA 2021/2022
AUTO. VALENCIA FEMENINA
Equipo PJ GF GC Puntos
1 Levante C Fem Levante 27 92 32 65
2 La Eliana La Eliana 28 68 36 54
3 At. Càrcer At. Càrcer 28 57 36 51
4 Mislata B Mislata B 28 71 44 50
5 La Nucia A La Nucia A 29 56 42 50
6 Atco Aspe A Atco Aspe A 28 45 33 49
7 Valencia C Fem Valencia 27 65 45 43
8 Alzira Alzira 27 43 36 40
9 Fenix Moncada A Fenix 29 46 54 36
10 Villarreal C Villarreal 28 52 49 34
11 CF Maritim Fem Maritim 27 46 63 29
12 Alqueries A Alqueries A 27 26 61 28
13 CD Onda A CD Onda A 27 33 64 23
14 Atletico Benidorm Atletico 15 18 29 17
15 SPA Alicante B Alicante 28 28 85 11
16 Biensa CF A Biensa CF A 9 7 44 0
TEMPORADA 2019/2020
AUTO. VALENCIA FEMENINA
Equipo PJ GF GC Puntos
1 Mislata B Mislata B 22 65 21 53
2 Atco Aspe A Atco Aspe A 21 46 13 49
3 Alzira Alzira 22 41 18 45
4 InPro Sports Fem InPro Sports 22 56 34 44
5 Biensa CF A Biensa CF A 22 51 35 40
6 Atletico Benidorm Atletico 22 41 26 40
7 Alqueries A Alqueries A 21 28 29 27
8 CD Onda A CD Onda A 22 34 47 26
9 Levante D Levante D 22 34 38 25
10 SPA Alicante B Alicante 21 43 51 23
11 Quart de Poblet A Quart Poblet 21 25 47 19
12 Juventud Manisense Juventud 22 22 44 17
13 El Rumbo A El Rumbo A 22 14 55 11
14 Rafelbuñol A Rafelbuñol 20 19 61 9
TEMPORADA 2018/2019
AUTO. VALENCIA FEMENINA
Equipo PJ GF GC Puntos
1 SPA Alicante B Alicante 24 88 19 61
2 Valencia C Fem Valencia 25 45 19 56
3 Levante C Fem Levante 24 66 21 55
4 Villarreal B Fem Villarreal 25 46 26 50
5 InPro Sports Fem InPro Sports 24 42 46 34
6 Alqueries A Alqueries A 25 39 39 33
7 Mislata B Mislata B 25 30 40 33
8 Juventud Manisense Juventud 25 34 39 31
9 Alzira Alzira 24 30 44 27
10 El Rumbo A El Rumbo A 25 25 47 26
11 Rafelbuñol A Rafelbuñol 25 38 60 22
12 Crevillente Femenino Crevillente 25 15 57 21
13 La Union Femenina Manises A Union 25 18 45 18
14 Villajoyosa Villajoyosa 9 7 21 3
TEMPORADA 2017/2018
1ª VALENCIA FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Pl de Argel Alicante D Argel 26 100 21 68
2 Rafelbuñol A Rafelbuñol 26 99 26 64
3 El Rumbo A El Rumbo A 26 64 29 55
4 Mislata B Mislata B 26 76 27 54
5 Cff Maritim B Maritim 26 86 41 52
6 Drac Castellon A Drac 26 59 38 44
7 Joventut Almassora B Joventut 26 76 88 34
8 La Eliana La Eliana 26 62 87 34
9 Camporrobles Camporrobles 25 41 67 30
10 Juventud Manisense B Juventud 26 42 64 27
11 Club de Fútbol Sporting Vil Club Fútbol 25 36 75 19
12 Club Esportiu Forti Femeni Club 26 35 89 18
13 Requena Racing Club de Fútb Requena 26 26 78 14
14 Alaquas I Walter A Alaquas 26 25 97 9
TEMPORADA 2016/2017
1ª VALENCIA FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Alqueries A Alqueries A 26 119 19 71
2 La Union Femenina Manises A Union 26 95 31 61
3 El Rumbo A El Rumbo A 26 79 32 54
4 Mislata B Mislata B 26 82 26 53
5 Alzira Alzira 26 84 56 49
6 Drac Castellon A Drac 26 73 42 48
7 Joventut Almassora B Joventut 26 61 59 35
8 Alaquas I Walter A Alaquas 26 42 48 35
9 Rafelbuñol A Rafelbuñol 26 48 59 33
10 Club de Fútbol Sporting Vil Club Fútbol 25 58 72 29
11 Camporrobles Camporrobles 25 48 74 22
12 Mare Nostrum Puerto Sagunto Mare Nostrum 26 25 97 16
13 Cabanyal Canyamelar Cabanyal 26 34 89 14
14 Cff Maritim C Maritim 26 10 154 3
TEMPORADA 2015/2016
1ª VALENCIA FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 Biensa Biensa 26 90 30 62
2 Discobolo La Torre Fem Discobolo 26 85 25 62
3 Juventud Manisense Juventud 26 113 28 59
4 Alqueries A Alqueries A 26 66 33 54
5 Alaquas I Walter A Alaquas 26 58 48 46
6 Alginet Alginet 26 83 48 46
7 Vilamarxant A Vilamarxant 26 73 44 43
8 Mislata B Mislata B 26 76 59 40
9 Cff Juventud Paternense A Juventud 26 74 61 36
10 Camporrobles Camporrobles 26 45 60 29
11 Cabanyal Canyamelar Cabanyal 26 34 137 16
12 Cff Maritim C Maritim 26 25 86 15
13 Mare Nostrum Puerto Sagunto Mare Nostrum 26 22 96 13
14 Amazonas Condor A Amazonas 26 36 125 10
TEMPORADA 2014/2015
1ª VALENCIA FEMENINA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Castellón Fem Castellón 29 127 34 74
2 Alqueries Cf Alqueries 29 106 19 72
3 Historics de Valencia Historics 29 87 26 71
4 Sporting Sagunto Sporting 29 96 26 70
5 Cabanyal Canyamelar Cabanyal 29 102 69 53
6 Juventud Paternense Juventud 29 70 43 52
7 Maritim D Maritim D 29 69 40 49
8 Camporrobles Camporrobles 28 63 63 42
9 Juventud Manisense Juventud 29 50 50 40
10 Ciutat de Torrent B Ciutat 28 47 77 37
11 Borriol Borriol 29 34 66 24
12 Mislata B Mislata B 29 36 69 23
13 R. Onda Fem R. Onda Fem 29 47 90 19
14 Mare Nostrum Puerto Sagunto Mare Nostrum 29 37 102 17
15 Torrefiel Ath. Torrefiel 29 40 112 15
16 Betera Betera 29 13 138 2

  USO DE MEMORIA  
5,535,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1110
Total Execution Time  0.1122
  CADENA URL  
/historico/Mislata-Cf-B-Femenina
  GET DATOS  
$_GET['/historico/Mislata-Cf-B-Femenina']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0026  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 = 'Mislata-Cf-B-Femenina' 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 = 'Mislata-Cf-B-Femenina' 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=81898 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=81898 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=81898 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=81898 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=81898 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=81898 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=81898 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=81898 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=81898 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 69045
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=81898 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1181 AND type_rel = 3
0.0028  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 = '81898' 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 = '81898' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '81898' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 69045 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=81898 AND l.year in (2022,2023,2024) 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 (69045) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 69045 AND teamId = 81898
0.0022  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 = '81898' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0023  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '81898' 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 = '81898' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 events2023 e ON e.player_id = p.id AND e.league_id = 69045 WHERE rp.league_id = 69045 AND rp.teamId = 81898 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.0019  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 events2023 e ON e.player_id = p.id AND e.league_id = 69045 WHERE rp.league_id = 69045 AND rp.teamId = 81898 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2023 e ON e.player_id = p.id AND e.league_id = 69045 WHERE rp.league_id = 69045 AND rp.teamId = 81898 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 81898 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 69045 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.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 `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 = 64490 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.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 `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 = 51395 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 48152 AND t.round = 26 ORDER BY team.conference 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 `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 = 42685 AND t.round = 26 ORDER BY team.conference 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 = 36824 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 19649 AND t.round = 26 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 `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 = 7270 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC