| 0.0110 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=141 AND type_rel = 3 |
| 0.0205 | 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.0112 | 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 (1314218,1314042,1313937,1313503,1313338) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0116 | SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74881 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0124 | SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 74881 AND c.`round` = 13 ORDER BY shedule ASC LIMIT 200 |
| 0.0183 | SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 17 AND e.real_date IS NOT NULL AND e.league_id = 74881 ORDER BY total DESC LIMIT 100 |
| 0.0113 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 01:17:06' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0111 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 01:17:06' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0110 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 01:17:06' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0110 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 01:17:06' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0328 | SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 74881 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74881 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10 |
| 0.0247 | SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 74881 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74881 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10 |
| 0.0115 | SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 74881 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74881 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10 |
| 0.0223 | SELECT *,(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 = 74881
AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC |
Gol Willer Ditta 18'
Toluca 0-1 Cruz Azul
Gol G. Ferrareis 9'
Puebla 1-2 América
Gol S. Reyes 21'
Gol R. Alvarado 74'
Atlas Guadalajara 0-1 Chivas Guadalajara
Gol B. Vázquez 86'
Necaxa 2-5 Monterrey
Gol Heriberto Jurado 96'
Tarjeta Roja Raúl Gudiño 78'
Gol G. Berterame 50'
Gol Sergio Canales 52'
Gol D. Cambindo 59'
Gol A. González 81'
Gol R. Sandoval 46'
Querétaro 1-1 Pumas UNAM
Gol E. Salvio 67'
Gol de penalti Juan Brunetta 81'
Tigres UANL 4-1 Tijuana
Gol A. Gignac 13'
Gol S. Córdova 61'
Gol J. Zúñiga 83'
Gol N. Ibáñez 93'
Gol de Falta Sébastien Salles 56'
Santos Laguna 0-3 Atl. San Luis
Gol Yan Philipe 17'
Gol F. Boli 30'
Tarjeta Roja Víctor Barajas 93'
FC Juárez 1-1 León
Gol Edson 40'
Gol Adonis Frías 59'
Gol O. Idrissi 67'
Pachuca 1-1 Mazatlán
Gol F. Almada 83'
