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

Partidos televisados

Europa League
FA Cup
Ligue 1
Liga Turca
Liga Brasileña
Copa Argentina
Champions League Femenina
Primera B
Serie A - Ecuador
Europeo Sub 17
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  
8,156,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Tvonline / Tv )  0.4193
Total Execution Time  0.4202
  CADENA URL  
/partidos-televisados
  GET DATOS  
$_GET['/partidos-televisados']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0335   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 calendars2023 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 > '2023-05-30 03:08:44' AND cal.shedule < '2023-06-05 00:48:44' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6559218' AND rel.team2 = '6559252' AND rel.league_id = '70409' AND rel.round = '5' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6561992' AND rel.team2 = '6561993' AND rel.league_id = '68334' AND rel.round = '14' 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.0123   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6515027' AND rel.team2 = '6515017' AND rel.league_id = '67675' AND rel.round = '38' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6517317' AND rel.team2 = '6517312' AND rel.league_id = '67815' AND rel.round = '36' 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.0110   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562860' AND rel.team2 = '6562852' AND rel.league_id = '70714' AND rel.round = '9' 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.0109   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562857' AND rel.team2 = '6562850' AND rel.league_id = '70714' AND rel.round = '9' 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.0109   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562851' AND rel.team2 = '6562853' AND rel.league_id = '70714' AND rel.round = '9' 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.0110   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562849' AND rel.team2 = '6562854' AND rel.league_id = '70714' AND rel.round = '9' 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.0110   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562866' AND rel.team2 = '6562863' AND rel.league_id = '70714' AND rel.round = '9' 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.0133   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562859' AND rel.team2 = '6562865' AND rel.league_id = '70714' AND rel.round = '9' 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.0124   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562862' AND rel.team2 = '6562867' AND rel.league_id = '70714' AND rel.round = '9' 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.0124   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562864' AND rel.team2 = '6562855' AND rel.league_id = '70714' AND rel.round = '9' 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.0114   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6562861' AND rel.team2 = '6562856' AND rel.league_id = '70714' AND rel.round = '9' 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.0114   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6563603' AND rel.team2 = '6563653' AND rel.league_id = '70412' 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.0119   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6569001' AND rel.team2 = '6569006' AND rel.league_id = '71049' 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.0110   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6564988' AND rel.team2 = '6564981' AND rel.league_id = '70844' AND rel.round = '16' 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.0110   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6564986' AND rel.team2 = '6564983' AND rel.league_id = '70844' AND rel.round = '16' 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.0114   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6567368' AND rel.team2 = '6567373' AND rel.league_id = '70963' AND rel.round = '13' 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.0114   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6567367' AND rel.team2 = '6567359' AND rel.league_id = '70963' AND rel.round = '13' 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.0113   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6577920' AND rel.team2 = '6577921' AND rel.league_id = '71813' AND rel.round = '2' 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.0127   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6577924' AND rel.team2 = '6577927' AND rel.league_id = '71813' AND rel.round = '2' 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.0265  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 = 70409 OR league_id = 68334 OR league_id = 67675 OR league_id = 67815 OR league_id = 70714 OR league_id = 70412 OR league_id = 71049 OR league_id = 70844 OR league_id = 70963 OR league_id = 71813