| 0.0035 | 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 = 'Celta-Juvenil' 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=3265 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=3265 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=3265 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1 |
| 0.0040 | 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 = 73240 |
| 0.0018 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3265 AND type_rel = 2 |
| 0.0020 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3265 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5 |
| 0.0022 | 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 (217964,218861,246903,275826,365094) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0032 | 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 = '3265' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020 |
| 0.0021 | 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 = 73240 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
España
Grupo 1
RC Celta Sub 19
Deportivo Sub 19
Racing Sub 19
Real Sporting Sub 19
CD Covadonga Sub 19
Real Oviedo Sub 19
Veriña CF Sub 19
Atlético Perines Sub 19
Arosa SC Sub 19
Bansander Sub 19
CD Lugo Sub 19
ED Val Miñor Sub 19
Choco Sub 19
SD Compostela Sub 19
CD Revilla Sub 19
Coruxo FC Sub 19
Real Madrid Sub 19
Atlético Sub 19
Barcelona Sub 19
Sevilla Sub 19
Las Palmas Sub 19
Valencia Sub 19
Athletic Sub 19
Villarreal Sub 19
Levante Sub 19
Tenerife Sub 19
Rayo Vallecano Sub 19
Real Betis Sub 19
Leganés Sub 19
Real Sociedad Sub 19
Espanyol Sub 19
Antiguoko KE Sub 19
Mallorca Sub 19
CF Damm Sub 19
Elche Sub 19
Osasuna Sub 19
Atlético Madrileño Sub 19
Cádiz Sub 19
Granada CF Sub 19
Badalona Sub 19
Rayo Majadahonda Sub 19
Arucas Sub 19
Universitario FC Sub 19