| 0.0044 | 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 = 73971 |
| 0.0027 | 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 = 73159 |
| 0.0030 | 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 = 74005 |
| 0.0019 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60505 AND type_rel = 2 |
| 0.0022 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 60505 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5 |
| 0.0025 | 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 (327144,381805,513638,525744,533109) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0037 | 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 = '60505' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020 |
| 0.0026 | 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 = 73159 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0032 | 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 = 74005 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0023 | 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 = 73971 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0064 | 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=60505 AND l.year in (2023,2024,2025)
ORDER BY l.id DESC, l.year DESC ; |
| 0.0026 | 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 (74025,74005,73159,70964)
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.0046 | SELECT count(id) as num_players from rel_players WHERE league_id = 73159 AND teamId = 60505 |
| 0.0050 | SELECT count(id) as num_players from rel_players WHERE league_id = 74025 AND teamId = 60505 |
| 0.0055 | SELECT count(id) as num_players from rel_players WHERE league_id = 74005 AND teamId = 60505 |
| 0.0025 | SELECT count(id) as num_players from rel_players WHERE league_id = 70964 AND teamId = 60505 |
| 0.0028 | 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 = 73971
AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC |
| 0.0032 | 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 = '60505' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16 |
| 0.0021 | SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60505' and rp.type = 4 |
| 0.0025 | 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 = '60505' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18 |
| 0.0053 | 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 = 73971 WHERE rp.league_id = 73971 AND rp.teamId = 60505 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.0044 | 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 = 73971 WHERE rp.league_id = 73971 AND rp.teamId = 60505 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0024 | 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 = 73971 WHERE rp.league_id = 73971 AND rp.teamId = 60505 AND (e.action = 3 or e.action = 4) 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 = 73971 WHERE rp.league_id = 73971 AND rp.teamId = 60505 AND (e.action = 22) 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 = 73971 WHERE rp.league_id = 73971 AND rp.teamId = 60505 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
| 0.0041 | 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 = 73971 WHERE rp.league_id = 73971 AND rp.teamId = 60505 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30 |
Jan Zuberek
T. Guercio
Enoch Owusu
Yvan Maye
Grupo 4
Juventus Sub 19
Inter Sub 19
Roma Sub 19
Fiorentina Sub 19
Milan Sub 19
Atalanta Sub 19
Empoli Sub 19
Torino Sub 19
Genoa Sub 19
Lazio Sub 19
Sampdoria Sub 19
Sassuolo Sub 19
Bologna Sub 19
Cagliari Sub 19
Hellas Verona Sub 19
Frosinone Sub 19
Lecce Sub 19
AC Monza Sub 19
Napoli Sub 19
Parma Sub 19
Palermo Sub 19
Udinese Sub 19
Spezia Sub 19
Ascoli Sub 19
Brescia Sub 19
Cesena Sub 19
Pescara Sub 19
Crotone Sub 19
Virtus Entella Sub 19
Vicenza Sub 19
SSC Bari Sub 19
Cittadella Sub 19
Perugia Sub 19
Benevento Sub 19
Salernitana Sub 19
SPAL Sub 19
Pisa SC Sub 19
Venezia Sub 19
Cremonese Sub 19
Ternana Sub 19
Padova Sub 19
Nuova Cosenza Sub 19
AlbinoLeffe Sub 19
Reggiana Sub 19
Como Sub 19
Monopoli Sub 19
US Alessandria Sub 19
Feralpisalò Sub 19
Südtirol Sub 19
Renate Sub 19
Benfica Sub 19
Real Sociedad Sub 19
Salzburg Sub 19