4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Villarreal Fem

Villarreal Fem

Entrenador: Sara Monforte

Presidente: Fernando Roig

TEMPORADA 2023/2024
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 24 106 8 70
2 Real Madrid Fem Real Madrid 24 62 27 58
3 Levante Fem Levante Fem 25 46 23 47
4 Madrid CFF Fem Madrid 24 53 38 46
5 Atlético Fem Atlético 24 42 18 45
6 Athletic Fem Athletic 24 29 27 41
7 Sevilla FC Fem Sevilla 25 47 49 39
8 Costa Adeje Tenerife Fem Costa Adeje 25 33 40 31
9 Real Sociedad Fem Real 24 30 43 29
10 Valencia Fem Valencia 25 31 49 26
11 Eibar Fem Eibar Fem 24 18 38 26
12 Granada CF Fem Granada 25 27 46 24
13 Real Betis Fem Real Betis 25 25 61 22
14 Villarreal Fem Villarreal 25 22 47 21
15 Levante Las Planas Fem Levante 24 28 49 20
16 Sporting Huelva Fem Sporting 25 16 52 6
TEMPORADA 2022/2023
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 118 10 85
2 Real Madrid Fem Real Madrid 30 80 25 75
3 Levante Fem Levante Fem 30 80 34 66
4 Atlético Fem Atlético 30 54 35 57
5 Madrid CFF Fem Madrid 30 65 48 56
6 Costa Adeje Tenerife Fem Costa Adeje 30 35 44 40
7 Sevilla FC Fem Sevilla 30 45 44 40
8 Real Sociedad Fem Real 30 54 50 39
9 Valencia Fem Valencia 30 36 55 37
10 Athletic Fem Athletic 30 34 44 35
11 Levante Las Planas Fem Levante 30 24 61 26
12 Real Betis Fem Real Betis 30 26 62 25
13 Sporting Huelva Fem Sporting 30 24 54 25
14 Villarreal Fem Villarreal 30 27 65 23
15 Alhama ElPozo Fem Alhama 30 24 57 21
16 Deportivo Alavés Fem Deportivo 30 35 73 21
TEMPORADA 2021/2022
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 159 11 90
2 Real Sociedad Fem Real 30 67 38 66
3 Real Madrid Fem Real Madrid 30 41 31 60
4 Atlético Fem Atlético 30 71 28 59
5 Costa Adeje Tenerife Fem Costa Adeje 30 42 44 54
6 Levante Fem Levante Fem 30 52 39 50
7 Athletic Fem Athletic 30 45 47 47
8 Sevilla FC Fem Sevilla 30 37 52 38
9 Real Betis Fem Real Betis 30 31 52 31
10 Sporting Huelva Fem Sporting 30 28 44 31
11 Deportivo Alavés Fem Deportivo 30 30 63 30
12 Villarreal Fem Villarreal 30 29 63 29
13 Madrid CFF Fem Madrid 30 42 64 27
14 Valencia Fem Valencia 30 27 56 27
15 Eibar Fem Eibar Fem 30 35 63 23
16 Rayo Vallecano Fem Rayo 30 27 68 14
TEMPORADA 2020/2021
PRIMERA DIVISIÓN B FEMENINA GRUPO 5
Equipo PJ GF GC Puntos
1 Villarreal Fem Villarreal 24 56 19 55
2 Alba Fundación Fem Alba 24 49 27 49
3 Granada CF Fem Granada 22 37 23 43
4 Pozoalbense Fem Pozoalbense 22 35 29 37
5 Alhama ElPozo Fem Alhama 24 35 22 40
6 Real Union Tacuense Fem Real Union. 24 32 27 36
7 CP Cacereño Fem Cacereño 22 24 42 25
8 UDG Tenerife B Fem Tenerife 22 20 25 22
TEMPORADA 2019/2020
PRIMERA DIVISIÓN B FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Santa Teresa Fem Santa Teresa 22 43 15 51
2 Granada CF Fem Granada 22 43 15 50
3 Albacete Fem Albacete 22 48 16 47
4 Villarreal Fem Villarreal 22 37 24 42
5 Málaga CF Fem Málaga 22 28 21 36
6 Alhama ElPozo Fem Alhama 22 40 31 35
7 Pozoalbense Fem Pozoalbense 22 36 39 32
8 Córdoba CF Fem Córdoba 22 21 21 31
9 CP Cacereño Fem Cacereño 22 36 36 30
10 UDG Tenerife B Fem Tenerife 22 27 36 28
11 Spar Gran Canaria Fem Spar Gran C. 22 34 36 27
12 Levante B Fem Levante 22 31 33 24
13 Valencia B Fem Valencia 22 24 34 21
14 CD Juan Grande Fem Juan Grande 22 28 39 16
15 Real Union Tacuense Fem Real Union. 22 18 57 12
16 Collerense Fem Collerense 22 31 72 9
TEMPORADA 2018/2019
TERCERA FEDERACIÓN FEMENINA GRUPO 8
Equipo PJ GF GC Puntos
1 Valencia B Fem Valencia 26 83 22 63
2 Alhama ElPozo Fem Alhama 26 74 25 61
3 Villarreal Fem Villarreal 26 51 23 58
4 Levante B Fem Levante 26 56 35 54
5 Mislata Fem Mislata Fem 26 49 32 43
6 SPA Alicante Fem Alicante 26 53 26 40
7 Lorca Fem Lorca Fem 26 41 40 39
8 UD Aldaia Fem Aldaia 26 34 29 38
9 CD Castellón Fem Castellón 26 48 51 38
10 Elche CF Fem Elche 26 38 46 31
11 CF Maritim Fem Maritim 26 27 50 21
12 Fundación Albacete B Fem Fundación 26 24 58 13
13 Discobolo La Torre Fem Discobolo 26 19 66 12
14 Ciudad de Murcia Fem Ciudad 26 18 112 4
TEMPORADA 2017/2018
TERCERA FEDERACIÓN FEMENINA GRUPO 7
Equipo PJ GF GC Puntos
1 SPA Alicante Fem Alicante 26 83 22 63
2 Levante B Fem Levante 26 48 20 54
3 UD Aldaia Fem Aldaia 26 82 23 53
4 Alhama ElPozo Fem Alhama 26 36 20 44
5 CD Castellón Fem Castellón 26 65 49 42
6 CF Maritim Fem Maritim 26 37 35 41
7 Valencia B Fem Valencia 26 59 32 41
8 Villarreal Fem Villarreal 26 53 41 37
9 Mislata Fem Mislata Fem 26 37 29 36
10 Lorca Fem Lorca Fem 26 41 41 33
11 La Solana Fem Solana 26 46 46 32
12 CFF Albacete Albacete 26 45 52 30
13 Murcia FC Femenino Murcia 26 9 137 6
14 CD Minerva CD Minerva 26 19 113 1
TEMPORADA 2016/2017
TERCERA FEDERACIÓN FEMENINA GRUPO 7
Equipo PJ GF GC Puntos
1 Levante B Fem Levante 26 46 27 56
2 Valencia B Fem Valencia 26 57 23 54
3 SPA Alicante Fem Alicante 26 67 23 52
4 UD Aldaia Fem Aldaia 26 36 21 51
5 Murcia FC Femenino Murcia 26 48 40 40
6 Villarreal Fem Villarreal 26 30 23 40
7 Mislata Fem Mislata Fem 26 35 33 37
8 CD Castellón Fem Castellón 26 43 55 33
9 Alhama ElPozo Fem Alhama 26 25 32 32
10 CFF Albacete Albacete 26 26 41 29
11 Lorca Fem Lorca Fem 26 35 48 27
12 Elche CF Fem Elche 26 36 40 25
13 Transportes Alcaine B Fem Transportes 26 24 42 18
14 Atletico Benidorm Atletico 26 19 79 15
TEMPORADA 2015/2016
TERCERA FEDERACIÓN FEMENINA GRUPO 8
Equipo PJ GF GC Puntos
1 Valencia B Fem Valencia 26 63 22 59
2 Lorca Fem Lorca Fem 26 42 19 54
3 UD Aldaia Fem Aldaia 26 55 24 53
4 SPA Alicante Fem Alicante 26 57 33 49
5 Levante B Fem Levante 26 38 23 48
6 CFF Albacete Fem Albacete 26 48 43 40
7 Elche CF Fem Elche 26 36 34 34
8 Villarreal Fem Villarreal 26 41 39 33
9 Mislata Fem Mislata Fem 26 37 48 33
10 Atletico Benidorm Atletico 26 36 40 31
11 Alhama ElPozo Fem Alhama 26 33 52 31
12 CF Maritim Fem Maritim 26 45 41 29
13 Al-Basit Al-Basit 26 24 71 17
14 CD Zeneta CD Zeneta 26 8 74 7
TEMPORADA 2014/2015
TERCERA FEDERACIÓN FEMENINA GRUPO 7
Equipo PJ GF GC Puntos
1 SPA Alicante Fem Alicante 25 82 28 60
2 UD Aldaia Fem Aldaia 25 48 21 55
3 CFF Albacete Fem Albacete 26 59 37 50
4 Valencia B Fem Valencia 26 49 24 49
5 Levante B Fem Levante 25 43 30 45
6 CF Maritim Fem Maritim 26 50 34 43
7 Villarreal Fem Villarreal 26 48 39 37
8 Lorca Fem Lorca Fem 26 36 50 31
9 Elche CF Fem Elche 26 28 39 30
10 Atletico Benidorm Atletico 26 37 51 28
11 Alhama ElPozo Fem Alhama 26 25 53 24
12 Murcia FC Femenino Murcia 26 29 65 20
13 Cartagena Cartagena 26 40 81 20
14 Ciutat de Torrent Fem Ciutat 25 27 49 15
TEMPORADA 2013/2014
TERCERA FEDERACIÓN FEMENINA GRUPO 8
Equipo PJ GF GC Puntos
1 Albacete Fem Albacete 26 92 19 65
2 SPA Alicante Fem Alicante 26 73 21 65
3 CF Maritim Fem Maritim 26 79 25 64
4 Villarreal Fem Villarreal 26 73 31 60
5 CF Albacete Femenino Albacete 26 55 33 46
6 Murcia FC Femenino Murcia 26 45 47 41
7 Levante B Fem Levante 26 39 34 32
8 UD Aldaia Fem Aldaia 26 32 28 32
9 Lorca Fem Lorca Fem 26 41 59 26
10 Ciutat de Torrent Fem Ciutat 26 22 48 24
11 Elche CF Femenino Elche 26 26 62 23
12 Real Murcia CF Femenino Real Murcia 26 24 61 19
13 Aspe UD Femenino Aspe 26 16 84 10
14 CDE Pozo de las Nieves Feme Pozo Nieves 26 19 84 8

  USO DE MEMORIA  
6,277,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0985
Total Execution Time  0.1000
  CADENA URL  
/historico/Villareal-Cf-Femenino
  GET DATOS  
$_GET['/historico/Villareal-Cf-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12398 AND type_rel = 2
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12398 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 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 (98604,341611,406172,420780,586222) ORDER BY n.cover_points DESC, update_date 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 = '12398' 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 = 72467 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=12398 AND l.year in (2023,2024,2025) 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 (74006,73659,72467) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72467 AND teamId = 12398
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74006 AND teamId = 12398
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73659 AND teamId = 12398
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 = '12398' 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 = '12398' 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 = '12398' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 12398 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.0034  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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 12398 AND (e.action = 4 or e.action = 5) 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 = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 12398 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 12398 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 `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 = 63280 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 `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 = 58766 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 61736 AND t.round = 8 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 = 49901 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.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 `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 = 44736 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 `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 = 39399 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 `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 = 35134 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 `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 = 16655 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 `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 = 4407 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 `tables2014` 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 = 2755 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC