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
Premier League
Serie A
FA Cup
Ligue 1
Copa Liga Profesional Argentina
Copa Libertadores
Primera Federación
Liga Portuguesa
Championship
Liga Turca
KNVB Beker
Segunda Federación
Liga Belga
Primera Nacional
Primera División Futsal
Primera B
Segunda Federación Femenina

  USO DE MEMORIA  
5,118,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Tvonline / Tv )  0.6352
Total Execution Time  0.6361
  CADENA URL  
/partidos-televisados
  GET DATOS  
$_GET['/partidos-televisados']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0863   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-04-20 22:24:14' AND cal.shedule < '2024-04-26 20:04:14' 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 = '6583639' AND rel.team2 = '6583648' AND rel.league_id = '72116' AND rel.round = '32' 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 = '6578408' AND rel.team2 = '6578407' AND rel.league_id = '71849' AND rel.round = '34' 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 = '6578402' AND rel.team2 = '6578405' AND rel.league_id = '71849' AND rel.round = '34' 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 = '6582455' AND rel.team2 = '6582442' AND rel.league_id = '72044' AND rel.round = '33' 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.0107   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6621909' AND rel.team2 = '6621939' AND rel.league_id = '72728' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582492' AND rel.team2 = '6582485' AND rel.league_id = '72046' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582483' AND rel.team2 = '6582492' AND rel.league_id = '72046' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582486' AND rel.team2 = '6582491' AND rel.league_id = '72046' 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.0109   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6637355' AND rel.team2 = '6637356' AND rel.league_id = '75870' 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.0109   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6635195' AND rel.team2 = '6635193' AND rel.league_id = '75641' 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.0107   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587551' AND rel.team2 = '6587544' AND rel.league_id = '72358' AND rel.round = '33' 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.0107   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587543' AND rel.team2 = '6587558' AND rel.league_id = '72358' AND rel.round = '33' 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 = '6582570' AND rel.team2 = '6582578' AND rel.league_id = '72053' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582580' AND rel.team2 = '6582581' AND rel.league_id = '72053' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582574' AND rel.team2 = '6582565' AND rel.league_id = '72053' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6582236' AND rel.team2 = '6582234' AND rel.league_id = '72033' AND rel.round = '44' 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.0107   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6585303' AND rel.team2 = '6585313' AND rel.league_id = '72225' AND rel.round = '33' 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.0107   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6618369' AND rel.team2 = '6614011' AND rel.league_id = '72637' AND rel.round = '8' 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.0107   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587601' AND rel.team2 = '6587600' AND rel.league_id = '72362' AND rel.round = '32' 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.0120   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6587661' AND rel.team2 = '6587658' AND rel.league_id = '72366' AND rel.round = '32' 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.0120   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6635284' AND rel.team2 = '6635282' AND rel.league_id = '75662' 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.0117   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626314' AND rel.team2 = '6626312' AND rel.league_id = '75057' 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.0120   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626326' AND rel.team2 = '6626324' AND rel.league_id = '75057' 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.0118   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626310' AND rel.team2 = '6626297' AND rel.league_id = '75057' 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.0118   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626295' AND rel.team2 = '6626299' AND rel.league_id = '75057' 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.0118   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626316' AND rel.team2 = '6626311' AND rel.league_id = '75057' 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.0117   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626315' AND rel.team2 = '6626304' AND rel.league_id = '75057' 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.0117   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626325' AND rel.team2 = '6626323' AND rel.league_id = '75057' 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.0119   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626294' AND rel.team2 = '6626313' AND rel.league_id = '75057' 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.0121   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626292' AND rel.team2 = '6626308' AND rel.league_id = '75057' 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.0119   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6599016' AND rel.team2 = '6599021' AND rel.league_id = '73234' 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.0120   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626338' AND rel.team2 = '6626345' AND rel.league_id = '75059' 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.0121   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626334' AND rel.team2 = '6626342' AND rel.league_id = '75059' 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.0119   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626350' AND rel.team2 = '6626349' AND rel.league_id = '75059' 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.0112   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626337' AND rel.team2 = '6626344' AND rel.league_id = '75059' 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.0110   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6626348' AND rel.team2 = '6626350' AND rel.league_id = '75059' 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.0108   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6602598' AND rel.team2 = '6602596' AND rel.league_id = '73459' AND rel.round = '28' 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.0244  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 = 71849 OR league_id = 72044 OR league_id = 72728 OR league_id = 72046 OR league_id = 75870 OR league_id = 75641 OR league_id = 72358 OR league_id = 72053 OR league_id = 72033 OR league_id = 72225 OR league_id = 72637 OR league_id = 72362 OR league_id = 72366 OR league_id = 75662 OR league_id = 75057 OR league_id = 73234 OR league_id = 75059 OR league_id = 73459