4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sheffield United Fem
TEMPORADA 2023/2024
PREMIER LEAGUE 2 FEMENINA
Equipo PJ GF GC Puntos
1 Crystal Palace Fem Crystal 21 55 20 45
2 Charlton Athletic Fem Charlton 21 30 17 42
3 Sunderland Fem Sunderland 21 31 18 40
4 Southampton Fem Southampton 21 39 23 39
5 Birmingham City Fem Birmingham 21 33 18 36
6 Blackburn Rovers Fem Blackburn 21 22 27 33
7 Sheffield United Fem Sheffield 21 31 28 29
8 London City Lionesses London City 21 23 34 22
9 Reading Fem Reading Fem 21 18 37 22
10 Durham Fem Durham Fem 21 23 44 20
11 Lewes Fem Lewes Fem 21 20 36 16
12 Watford Fem Watford Fem 21 19 42 12
TEMPORADA 2022/2023
PREMIER LEAGUE 2 FEMENINA
Equipo PJ GF GC Puntos
1 Bristol City WFC Fem Bristol City 22 39 12 48
2 Birmingham City Fem Birmingham 22 39 22 47
3 London City Lionesses London City 22 49 20 45
4 Charlton Athletic Fem Charlton 22 34 27 38
5 Crystal Palace Fem Crystal 22 28 34 34
6 Southampton Fem Southampton 22 22 15 33
7 Durham Fem Durham Fem 22 30 29 28
8 Sheffield United Fem Sheffield 22 32 25 27
9 Lewes Fem Lewes Fem 22 20 29 26
10 Blackburn Rovers Fem Blackburn 22 20 29 23
11 Sunderland Fem Sunderland 22 26 38 18
12 Coventry United Fem Coventry 22 16 75 7
TEMPORADA 2021/2022
PREMIER LEAGUE 2 FEMENINA
Equipo PJ GF GC Puntos
1 Liverpool Fem Liverpool 22 49 11 52
2 London City Lionesses London City 22 35 22 41
3 Bristol City WFC Fem Bristol City 22 43 28 37
4 Crystal Palace Fem Crystal 22 35 39 37
5 Charlton Athletic Fem Charlton 22 27 18 34
6 Durham Fem Durham Fem 22 30 28 34
7 Sheffield United Fem Sheffield 22 34 31 33
8 Lewes Fem Lewes Fem 22 23 24 29
9 Sunderland Fem Sunderland 22 23 32 24
10 Blackburn Rovers Fem Blackburn 22 17 41 17
11 Coventry United Fem Coventry 22 18 32 12
12 Watford Fem Watford Fem 22 18 46 11
TEMPORADA 2020/2021
PREMIER LEAGUE 2 FEMENINA
Equipo PJ GF GC Puntos
1 Leicester Fem Leicester 18 51 16 44
2 Durham Fem Durham Fem 18 33 13 39
3 Liverpool Fem Liverpool 18 29 15 33
4 Sheffield United Fem Sheffield 18 35 15 32
5 Lewes Fem Lewes Fem 19 16 22 25
6 London City Lionesses London City 18 18 18 21
7 Crystal Palace Fem Crystal 18 26 34 19
8 Coventry United Fem Coventry 17 21 43 16
9 Blackburn Rovers Fem Blackburn 17 18 27 14
10 Charlton Athletic Fem Charlton 14 15 24 14
11 London Bees London Bees 19 14 49 11
TEMPORADA 2019/2020
PREMIER LEAGUE 2 FEMENINA
Equipo PJ GF GC Puntos
1 Aston Villa Fem Aston Villa 14 39 11 40
2 Sheffield United Fem Sheffield 14 46 16 34
3 Durham Fem Durham Fem 14 33 10 32
4 London City Lionesses London City 15 25 24 26
5 London Bees London Bees 12 16 19 15
6 Leicester Fem Leicester 15 22 35 15
7 Blackburn Rovers Fem Blackburn 12 13 25 10
8 Crystal Palace Fem Crystal 14 15 33 10
9 Lewes Fem Lewes Fem 12 10 18 9
10 Coventry United Fem Coventry 14 19 35 9
11 Charlton Athletic Fem Charlton 12 9 21 7

  USO DE MEMORIA  
5,440,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.0953
Total Execution Time  0.0968
  CADENA URL  
/historico/Sheffield-United-Fem
  GET DATOS  
$_GET['/historico/Sheffield-United-Fem']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0082  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 = 72942
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138075 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1999 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1999 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (1280600,1098696,843083,838832,777883) ORDER BY n.cover_points DESC, update_date DESC
0.0031  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 = '138075' 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 = 72942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=138075 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (74416,74246,72942) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72942 AND teamId = 138075
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74416 AND teamId = 138075
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74246 AND teamId = 138075
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 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 = 72942 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '138075' 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 = '138075' and rp.type = 4
0.0021  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 = '138075' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042  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 = 72942 WHERE rp.league_id = 72942 AND rp.teamId = 138075 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.0027  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 = 72942 WHERE rp.league_id = 72942 AND rp.teamId = 138075 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 72942 WHERE rp.league_id = 72942 AND rp.teamId = 138075 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 138075 AND l.year <= 2024 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 `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 = 72942 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.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 `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 = 68395 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.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 `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 = 58278 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 `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 = 58276 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