| 0.0017 | SELECT data1 FROM stats2025 t WHERE league_id = 78293 AND teamId = 6676425 and type = 33 |
| 0.0017 | SELECT data1 FROM stats2025 t WHERE league_id = 78293 AND teamId = 6676412 and type = 33 |
| 0.0030 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 78293 AND id_match = 231292 |
| 0.0019 | SELECT p.*
FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '231292' and rp.type = 2025 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16 |
| 0.0018 | SELECT iframe, title FROM futbol.match_videos WHERE matchId = 231292 AND year = 2025 AND channel = 'Footters' LIMIT 1 |
| 0.0017 | SELECT iframe, title FROM futbol.match_videos WHERE matchId = 231292 AND year = 2025 AND channel = 'Footters' LIMIT 1 |
| 0.0031 | SELECT t.points,t.team,t.round FROM `tables2025` 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 = 78293
AND t.round >= 1 AND t.round <= 9 ORDER BY t.round ASC, t.points DESC, cast(t.gf as signed) - cast(t.ga as signed) DESC, t.ga DESC, dt.nameShow ASC |
| 0.0018 | SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='231292' AND `active` = 1 AND year = 2025 |
| 0.0019 | SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='78293' AND relp.team_id=6676425
WHERE relp.in_squad=1 and mp.`match_id` = '231292' AND mp.year='2025'
ORDER BY mp.`team` ASC, p.`role` ASC |
| 0.0019 | SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='78293' AND relp.team_id=6676412
WHERE relp.in_squad=1 and mp.`match_id` = '231292' AND mp.year='2025'
ORDER BY mp.`team` ASC, p.`role` ASC |
| 0.0026 | SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '78293' AND id_match = '231292' |
| 0.0017 | SELECT
dt.id, dt.nick, dt.alias, dt.name, dt.last_name, t.teamId as team_id,
0 as tvotes,
0 as tpoints,
0 as rating
FROM dreamteam_data_real as dr INNER JOIN rel_dreamteam_real as rel
ON dr.id=rel.team_number
INNER JOIN teams as t
ON t.id = dr.team_id
INNER JOIN dataplayers as dt
ON dt.id=rel.player_id
WHERE dr.team_id=6676425
GROUP BY rel.player_id
HAVING SUM(rel.votes) > 1
ORDER BY tpoints DESC, votes DESC
LIMIT 1 |
| 0.0017 | SELECT
dt.id, dt.nick, dt.alias, dt.name, dt.last_name, t.teamId as team_id,
0 as tvotes,
0 as tpoints,
0 as rating
FROM dreamteam_data_real as dr INNER JOIN rel_dreamteam_real as rel
ON dr.id=rel.team_number
INNER JOIN teams as t
ON t.id = dr.team_id
INNER JOIN dataplayers as dt
ON dt.id=rel.player_id
WHERE dr.team_id=6676412
GROUP BY rel.player_id
HAVING SUM(rel.votes) > 1
ORDER BY tpoints DESC, votes DESC
LIMIT 1 |
| 0.0082 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=231292 AND extraId = 78293 AND type_rel = 4 |
| 0.0073 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=141 AND type_rel = 3 |
| 0.0018 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 141 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0017 | 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 (1349043,1348966,1348940,1348856,1348863) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0017 | SELECT avg_rating FROM elo_teams WHERE id=4348 |
| 0.0017 | SELECT * FROM futbol.calendars_lineups WHERE id = 231292 AND league_id = 78293 AND year = 2025 |
Claro Sports YouTube
Claro Sports
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
TV Azteca
ViX Premium
aztecadeportes.com
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports YouTube
Clarosports.com
Pluto TV
Claro Sports
Claro Sports YouTube
Clarosports.com
Pluto TV
Azteca Deportes Network
Azteca Deportes Network
Azteca Deportes Network
Azteca Deportes Network
Azteca Deportes Network
Azteca Deportes Network
Azteca Deportes Network
Azteca Deportes Network
Liga MX - Clausura