| 0.0018 | SELECT data1 FROM stats2024 t WHERE league_id = 74909 AND teamId = 6623954 and type = 33 |
| 0.0018 | SELECT data1 FROM stats2024 t WHERE league_id = 74909 AND teamId = 6623957 and type = 33 |
| 0.0019 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74909 AND id_match = 730040 |
| 0.0020 | SELECT p.*
FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '730040' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16 |
| 0.0017 | SELECT iframe, title FROM futbol.match_videos WHERE matchId = 730040 AND year = 2024 AND channel = 'Footters' LIMIT 1 |
| 0.0018 | SELECT iframe, title FROM futbol.match_videos WHERE matchId = 730040 AND year = 2024 AND channel = 'Footters' LIMIT 1 |
| 0.0019 | SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='730040' AND `active` = 1 AND year = 2024 |
| 0.0027 | 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='74909' AND relp.team_id=6623954
WHERE relp.in_squad=1 and mp.`match_id` = '730040' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC |
| 0.0031 | 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='74909' AND relp.team_id=6623957
WHERE relp.in_squad=1 and mp.`match_id` = '730040' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC |
| 0.0019 | SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '74909' AND id_match = '730040' |
| 0.0018 | 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=6623954
GROUP BY rel.player_id
HAVING SUM(rel.votes) > 1
ORDER BY tpoints DESC, votes DESC
LIMIT 1 |
| 0.0018 | 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=6623957
GROUP BY rel.player_id
HAVING SUM(rel.votes) > 1
ORDER BY tpoints DESC, votes DESC
LIMIT 1 |
| 0.0030 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=730040 AND extraId = 74909 AND type_rel = 4 |
| 0.0023 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=525 AND type_rel = 3 |
| 0.0018 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 525 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0018 | 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 (1316662,1316485,1315869,1310289,1307870) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0018 | SELECT position FROM tables2024 WHERE team=6623954 AND league_id=74909 AND round=2 |
| 0.0018 | SELECT position FROM tables2024 WHERE team=6623957 AND league_id=74909 AND round=2 |
| 0.0018 | SELECT * FROM futbol.calendars_lineups WHERE id = 730040 AND league_id = 74909 AND year = 2024 |
Fanatiz
TyC Sports
TyC Sports Play
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
TyC Sports Internacional
