4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 UD Aldaia Fem Aldaia 19 52 12 47
2 CD Castellón Fem Castellón 19 52 12 47
3 SPA Alicante Fem Alicante 19 50 20 41
4 Elche CF Fem Elche 19 32 23 34
5 Mislata Fem Mislata Fem 19 37 33 30
6 Discobolo La Torre Fem Discobolo 19 38 30 28
7 Lorca Fem Lorca Fem 19 29 23 28
8 Fundación Albacete B Fem Fundación 19 26 25 28
9 Villarreal B Fem Villarreal 19 32 31 21
10 Real Murcia Fem Real Murcia 19 27 49 19
11 Valencia C Fem Valencia 19 29 36 15
12 Levante C Fem Levante 19 22 49 15
13 Ciudad de Murcia Fem Ciudad 19 21 76 12
14 CF Maritim Fem Maritim 19 16 44 10
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Spar Gran Canaria Fem Spar Gran C. 26 255 7 75
2 Unión Viera Fem Unión Viera 26 166 21 72
3 CD Juan Grande Fem Juan Grande 26 255 15 69
4 Las Majoreras Fem Majoreras 26 76 35 53
5 UD Las Torres Torres 26 70 50 46
6 CFS La Garita Garita 26 67 71 39
7 CD Achamán Fem Achamán 26 59 58 38
8 Montaña Alta Montaña 26 60 63 38
9 Cardones Cardones 26 63 74 35
10 CD Casa Pastores-Iregui Casa 26 43 68 28
11 CD Firgas Fem Firgas 26 41 110 17
12 Yoñé La Garita Yoñé 26 31 161 13
13 CD Águilas CD Águilas 26 16 220 9
14 C.D. Vallinámar Femenino C.D. 26 14 255 3
Ver
TEMPORADA 2017/2018
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
Ver
TEMPORADA 2016/2017
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
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Real Union Tacuense Fem Real Union. 24 155 8 65
2 Echedey Timbamba Echedey 24 116 21 58
3 UDG Tenerife B Fem Tenerife 24 89 14 57
4 Tarsa Fem Tarsa Fem 24 52 24 48
5 Atl. Unión Güímar Fem Atl. Unión 24 71 38 45
6 Once Piratas Once Piratas 24 50 25 43
7 Laguna Laguna 24 38 54 31
8 San Lorenzo Constancia Lorenzo 24 54 75 31
9 Club Atlético Tacoronte Club 24 36 65 23
10 Ofra Ofra 24 28 94 16
11 Hidalgo Hidalgo 24 19 89 13
12 Llano del Moro Llano Moro 24 26 84 12
13 San Antonio Pilar Fem Antonio 24 22 165 8
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Costa Adeje Tenerife Fem Costa Adeje 19 152 3 57
2 Real Union Tacuense Fem Real Union. 19 59 13 48
3 CF Chaboyme Arico Femenino Chaboyme 18 86 32 41
4 Tarsa Fem Tarsa Fem 17 60 17 34
5 Cd Once Piratas Femenino Once Piratas 19 55 33 30
6 CD Candela Femenino Candela 18 42 43 29
7 CD Charco del Pino Femenino Charco Pino 18 32 49 19
8 CD Sauzal Femenino Sauzal 19 44 43 18
9 CF Costa Adeje Femenino Costa Adeje 18 49 53 17
10 San Antonio Pilar Fem Antonio 17 47 62 15
11 Moneyba Hierro Astra Fem Moneyba 19 20 118 7
12 Club Atlético Granadilla Fe Club 19 1 181 1
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Fundación Albacete Fundación 26 84 17 70
2 Murcia Féminas Murcia 26 69 20 65
3 CFF Albacete Albacete 26 50 26 47
4 Villarreal Cf Villarreal 26 70 43 46
5 Scf Plaza Argel Plaza Argel 26 60 32 45
6 Ff La Solana Solana 26 43 27 44
7 Cff Maritim Cff Maritim 26 67 42 43
8 Levante Ud B Femenino Levante 26 40 43 36
9 Aspe Ud Aspe Ud 26 51 51 33
10 Dinamo Guadalajara Fem Dinamo 26 35 57 28
11 Elche Cf Femenino Elche 26 35 57 22
12 Cde Tnt Daimiel Femenino Daimiel 26 18 65 17
13 Mislata Cf Mislata Cf 26 25 72 16
14 Ad Alquerías Femenino Femen Alquerías 26 15 110 3
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Fundación Albacete Fundación 26 89 24 68
2 Sporting Atlético Ciutat Sporting 26 91 36 61
3 CFF Albacete Albacete 26 63 35 52
4 Cff Maritim Cff Maritim 26 60 28 50
5 Villarreal Cf Villarreal 26 78 45 49
6 Aspe Ud Aspe Ud 26 53 31 47
7 Ff La Solana Solana 26 51 36 46
8 Scf Plaza Argel Plaza Argel 26 68 33 42
9 Murcia Féminas Murcia 26 41 44 31
10 Atlético Altobuey Atlético 26 44 48 31
11 Mislata Cf Mislata Cf 26 38 59 19
12 Lorca Féminas Ad Lorca 26 19 96 11
13 Cd Bargas Cd Bargas 26 22 103 8
14 Rcd Mallorca Mallorca 26 20 119 7

  USO DE MEMORIA  
5,687,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0882
Total Execution Time  0.0901
  CADENA URL  
/segunda_division_femenina2020/grupo7/historico
  GET DATOS  
$_GET['/segunda_division_femenina2020/grupo7/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0017  SELECT type FROM routes WHERE alias = 'segunda_division_femenina2020'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_femenina' AND (l.group_code = 7 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=7 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=283 ORDER BY order_id ASC
0.0021  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50905 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 283 AND group_code = 7 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0031  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 = 50905 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 44735 AND t.round = 26 ORDER BY team.conference 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 `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.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 = 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.0048  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 = 16657 AND t.round = 26 ORDER BY team.conference 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 `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.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 `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 = 2749 AND t.round = 24 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 `tables2013` 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 = 2121 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 `tables2012` 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 = 1854 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 url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 18:28:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 18:28:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 18:28:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0017  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 18:28:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_division_femenina' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50905 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50905 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50905 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50905 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50905 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50905 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  SELECT *,(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 = 50905 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC