4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Partidos televisados

Liga MX - Apertura Liga MX - Apertura
Partidos Amistosos Partidos Amistosos
Supercopa Belga Supercopa Belga
Primera Costa Rica - Apertura Primera Costa Rica - Apertura

  USO DE MEMORIA  
4,323,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0008
Controller Execution Time ( Tvonline / Tv )  0.0954
Total Execution Time  0.0963
  CADENA URL  
/partidos-televisados
  GET DATOS  
$_GET['/partidos-televisados']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0112   SELECT cal.*,c.name as leagueName,c.logo,c.alias FROM `rel_media_match` rel INNER JOIN leagues l ON rel.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId LEFT JOIN media m ON m.id = rel.media_id INNER JOIN calendars2025 cal ON cal.league_id = l.id AND cal.team1 = rel.team1 AND cal.team2 = rel.team2 WHERE rel.language = 'spanish' AND rel.active = 1 AND cal.shedule > '2024-07-15 12:52:40' AND cal.shedule < '2024-07-21 10:32:40' AND rel.media_id < 90000 GROUP BY cal.id ORDER BY c.coefficient DESC,cal.shedule ASC,m.type DESC,rel.id ASC,rel.media_id ASC LIMIT 100
0.0024   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643121' AND rel.team2 = '6643129' AND rel.league_id = '76385' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0021   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643119' AND rel.team2 = '6643113' AND rel.league_id = '76385' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0021   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643116' AND rel.team2 = '6643120' AND rel.league_id = '76385' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0022   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643123' AND rel.team2 = '6643124' AND rel.league_id = '76385' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0020   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643823' AND rel.team2 = '6643921' AND rel.league_id = '75586' AND rel.round = '45' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0020   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6637131' AND rel.team2 = '6637130' AND rel.league_id = '75586' AND rel.round = '47' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0020   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6641158' AND rel.team2 = '6641156' AND rel.league_id = '75586' AND rel.round = '47' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0021   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6640761' AND rel.team2 = '6640762' AND rel.league_id = '76212' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0020   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643073' AND rel.team2 = '6643082' AND rel.league_id = '76377' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0020   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643074' AND rel.team2 = '6643081' AND rel.league_id = '76377' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0020   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643075' AND rel.team2 = '6643080' AND rel.league_id = '76377' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0019   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6643079' AND rel.team2 = '6643077' AND rel.league_id = '76377' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 AND rel.media_id < 90000 ORDER BY m.type DESC,field(m.location,'es','en') DESC
0.0139  SELECT dt.nameShow, dt.basealias, t.id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE 0 OR league_id = 76385 OR league_id = 75586 OR league_id = 76212 OR league_id = 76377