4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fabril CD
TEMPORADA 2023/2024
SEGUNDA RFFPA GRUPO 2
Equipo PJ GF GC Puntos
1 Puerto Vega FC Puerto Vega 32 78 30 74
2 Club Hispano Club Hispano 32 66 35 65
3 Atlético Camocha Atlético 32 58 39 55
4 Siderúrgico Llaranes CF Siderúrgico 32 50 36 55
5 Fabril CD Fabril CD 32 59 38 52
6 Navia CF Navia CF 32 43 36 49
7 Narcea Narcea 32 50 44 47
8 Tineo Tineo 32 41 46 44
9 Barcia CF B Barcia CF B 32 48 55 43
10 Codema CF Codema CF 32 52 61 40
11 Triple A Gijón Triple 32 49 54 38
12 Podes CF Podes CF 32 47 57 36
13 CD Salas CD Salas 32 39 46 36
14 Condal B Condal B 32 53 60 36
15 Gozón Gozón 32 47 58 34
16 CD Manuel Rubio Manuel Rubio 32 33 49 32
17 CD Treviense Treviense 32 28 53 29
18 GD Bosco GD Bosco 32 36 80 25
TEMPORADA 2022/2023
TERCERA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Triple A Gijón Triple 26 83 18 66
2 GD Bosco GD Bosco 26 84 23 60
3 Arguero CF Arguero CF 26 84 35 59
4 Fabril CD Fabril CD 26 86 33 56
5 Unión Astur CF Unión Astur 26 67 38 49
6 Asunción A Asunción A 26 55 43 46
7 CD Aboño CD Aboño 26 52 42 35
8 CF Estudiantes Estudiantes 26 58 47 31
9 Versalles CF Versalles 26 39 47 28
10 Rayo Gijonés Rayo 26 40 74 23
11 Camocha B Camocha B 26 50 73 20
12 CD Montevil Montevil 26 45 93 20
13 Quintueles CF B Quintueles 26 39 100 16
14 Atlantic Gijón A Atlantic 26 22 138 5
TEMPORADA 2021/2022
TERCERA RFFPA GRUPO 1
Equipo PJ GF GC Puntos
1 Codema CF Codema CF 22 76 19 57
2 Arguero CF Arguero CF 22 73 26 51
3 Unión Astur CF Unión Astur 22 77 29 50
4 Candas CF B Candas CF B 22 42 38 40
5 Fabril CD Fabril CD 21 55 28 39
6 Iberia CF Iberia CF 22 50 46 29
7 CD Aboño CD Aboño 22 41 49 28
8 Asunción A Asunción A 22 37 45 22
9 Rayo Gijonés Rayo 21 41 69 22
10 CD Montevil Montevil 22 33 59 19
11 Erreala De Gijón Erreala 20 22 67 16
12 Quintueles CF B Quintueles 22 24 96 2

  USO DE MEMORIA  
5,052,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0809
Total Execution Time  0.0821
  CADENA URL  
/historico/Fabril-Cd-A
  GET DATOS  
$_GET['/historico/Fabril-Cd-A']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0025  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 = 'Fabril-Cd-A' 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.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=138975 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=138975 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 73671
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138975 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=709 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 709 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1088975,806083,759289,50689) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = '138975' 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 = '138975' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '138975' 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 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=138975 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 (73671,71755) 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 = 73671 AND teamId = 138975
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71755 AND teamId = 138975
0.0019  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 = '138975' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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 = '138975' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73671 WHERE rp.league_id = 73671 AND rp.teamId = 138975 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.0030  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 = 73671 WHERE rp.league_id = 73671 AND rp.teamId = 138975 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 73671 WHERE rp.league_id = 73671 AND rp.teamId = 138975 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 138975 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73671 AND t.round = 32 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 `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 = 68984 AND t.round = 26 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 `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 = 63768 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