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

Partidos televisados

Primera División
Ligue 1
Copa Liga Profesional Argentina
Primera Federación
Copa Libertadores
Copa de Francia
Liga Portuguesa
Liga Escocia
Segunda Federación
Tercera Federación
Primera División Futsal
Primera Federación Femenina
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,436,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Tvonline / Tv )  0.2503
Total Execution Time  0.2512
  CADENA URL  
/partidos-televisados
  GET DATOS  
$_GET['/partidos-televisados']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.1368   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 calendars2024 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-03-28 19:41:19' AND cal.shedule < '2024-04-03 18:21:19' 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.0038   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6583633' AND rel.team2 = '6583641' AND rel.league_id = '72116' AND rel.round = '30' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582482' AND rel.team2 = '6582484' AND rel.league_id = '72046' AND rel.round = '27' 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.0038   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582486' AND rel.team2 = '6582492' AND rel.league_id = '72046' AND rel.round = '27' 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.0038   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6623590' AND rel.team2 = '6623602' AND rel.league_id = '74880' AND rel.round = '12' 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.0038   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6623581' AND rel.team2 = '6623584' AND rel.league_id = '74880' AND rel.round = '12' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587543' AND rel.team2 = '6587555' AND rel.league_id = '72358' AND rel.round = '30' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6635204' AND rel.team2 = '6635201' AND rel.league_id = '75643' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6622706' AND rel.team2 = '6618044' AND rel.league_id = '74470' AND rel.round = '7' 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.0038   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582572' AND rel.team2 = '6582580' AND rel.league_id = '72053' AND rel.round = '27' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6583679' AND rel.team2 = '6583675' AND rel.league_id = '72121' AND rel.round = '31' 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.0036   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587603' AND rel.team2 = '6587610' AND rel.league_id = '72362' AND rel.round = '29' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587600' AND rel.team2 = '6587596' AND rel.league_id = '72362' AND rel.round = '29' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587604' AND rel.team2 = '6587609' AND rel.league_id = '72362' AND rel.round = '29' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587608' AND rel.team2 = '6587598' AND rel.league_id = '72362' AND rel.round = '29' 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.0037   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6586265' AND rel.team2 = '6586255' AND rel.league_id = '72268' AND rel.round = '27' 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.0036   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6586231' AND rel.team2 = '6589053' AND rel.league_id = '72266' AND rel.round = '27' 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.0039   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6599011' AND rel.team2 = '6599013' AND rel.league_id = '73234' AND rel.round = '25' 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.0043   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6602792' AND rel.team2 = '6602787' AND rel.league_id = '73472' AND rel.round = '23' 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.0084  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 = 72116 OR league_id = 72046 OR league_id = 74880 OR league_id = 72358 OR league_id = 75643 OR league_id = 74470 OR league_id = 72053 OR league_id = 72121 OR league_id = 72362 OR league_id = 72268 OR league_id = 72266 OR league_id = 73234 OR league_id = 73472