2.855.770 resultados, 9.127.069 comentarios, 804.045 imágenes, 79.786 vídeos, 85.880 noticias

Partidos televisados

Liga MX - Clausura
Apertura Colombia
Liga MX - Clausura
Apertura Colombia
Liga MX - Clausura
Segunda RFEF
Primera División B Femenina
Segunda RFEF
Primera RFEF
Segunda RFEF
División de Honor
División Honor Senior
Segunda RFEF
Serie A
Segunda RFEF
Primera División
Segunda División
Eredivisie
Premier League
Serie A
Bundesliga
Segunda División
Primera RFEF
Segunda RFEF
Premier Division Gibraltar
División de Honor
Primera División
Segunda RFEF
Serie B
Primera RFEF
Segunda RFEF
Tercera RFEF
Premier League
Bundesliga
Serie A
Segunda División
Primera División
Premier Division Gibraltar
Serie B
Liga Guatemala - Clausura
Liga Portuguesa
Liga MX - Clausura
Primera Andaluza
Primera B Colombia - Apertura
Ligue 1
Serie A
Primera División
Segunda División
Liga Portuguesa
Liga Guatemala - Clausura
Apertura Colombia
Liga de Expansión MX - Clausura
Apertura Colombia
Liga MX - Clausura
Apertura Colombia
Championship
Segunda División
Liga MX Femenil - Clausura
Primera B Colombia - Apertura
Liga MX Femenil - Clausura
Primera RFEF
Championship
Apertura Colombia
División Honor Senior
Liga de Expansión MX - Clausura
Apertura Colombia
Liga de Expansión MX - Clausura
Apertura Colombia
Liga de Expansión MX - Clausura
Primera RFEF
Segunda RFEF
Primera RFEF
Serie B
Primera RFEF
Apertura Colombia
Primera RFEF
Apertura Colombia
Primera RFEF
Liga MX Femenil - Clausura
Primera RFEF
Liga Portuguesa
Apertura Colombia
Liga de Expansión MX - Clausura
Liga MX Femenil - Clausura
Championship
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  
15,592,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Tvonline / Tv )  0.5593
Total Execution Time  0.5604
  CADENA URL  
/partidos-televisados
  GET DATOS  
$_GET['/partidos-televisados']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (142)  
0.0352   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 calendars2022 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 > '2022-01-22 23:07:23' AND cal.shedule < '2022-01-28 20:47:23' AND rel.media_id < 90000 GROUP BY cal.id ORDER BY cal.shedule ASC, c.coefficient_es DESC,m.type DESC,rel.id ASC,rel.media_id ASC
0.0022   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6496350' AND rel.team2 = '6496360' AND rel.league_id = '66176' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0035   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6499354' AND rel.team2 = '6499369' AND rel.league_id = '66290' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0035   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6496353' AND rel.team2 = '6496357' AND rel.league_id = '66176' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0031   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6499351' AND rel.team2 = '6499355' AND rel.league_id = '66290' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 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 = '6496347' AND rel.team2 = '6496349' AND rel.league_id = '66176' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0035   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447091' AND rel.team2 = '6447104' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6450857' AND rel.team2 = '6450862' AND rel.league_id = '63313' AND rel.round = '15' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0031   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447123' AND rel.team2 = '6447107' AND rel.league_id = '62384' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0031   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444906' AND rel.team2 = '6444925' AND rel.league_id = '62378' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444919' AND rel.team2 = '6444895' AND rel.league_id = '62378' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444923' AND rel.team2 = '6444911' AND rel.league_id = '62378' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0029   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444930' AND rel.team2 = '6444929' AND rel.league_id = '62379' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444944' AND rel.team2 = '6444932' AND rel.league_id = '62379' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444942' AND rel.team2 = '6444934' AND rel.league_id = '62379' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447048' AND rel.team2 = '6447039' AND rel.league_id = '62380' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0035   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447043' AND rel.team2 = '6447049' AND rel.league_id = '62380' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0034   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447072' AND rel.team2 = '6447087' AND rel.league_id = '62382' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447082' AND rel.team2 = '6447078' AND rel.league_id = '62382' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0033   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447080' AND rel.team2 = '6447076' AND rel.league_id = '62382' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447095' AND rel.team2 = '6447098' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0031   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447089' AND rel.team2 = '6447102' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0032   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447092' AND rel.team2 = '6447100' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0031   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447111' AND rel.team2 = '6447114' AND rel.league_id = '62384' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0031   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447032' AND rel.team2 = '6447041' AND rel.league_id = '62380' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447085' AND rel.team2 = '6447073' AND rel.league_id = '62382' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447071' AND rel.team2 = '6447083' AND rel.league_id = '62382' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0030   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447121' AND rel.team2 = '6447118' AND rel.league_id = '62384' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0033   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6457498' AND rel.team2 = '6457489' AND rel.league_id = '63684' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0032   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6462414' AND rel.team2 = '6462411' AND rel.league_id = '63951' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0032   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6462402' AND rel.team2 = '6462399' AND rel.league_id = '63951' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0033   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447103' AND rel.team2 = '6447093' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0033   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442313' AND rel.team2 = '6442314' AND rel.league_id = '62734' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0027   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6448354' AND rel.team2 = '6447105' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0025   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447106' AND rel.team2 = '6447094' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0026   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6447077' AND rel.team2 = '6447081' AND rel.league_id = '62382' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0028   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442165' AND rel.team2 = '6442167' AND rel.league_id = '62728' AND rel.round = '22' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0025   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6443472' AND rel.team2 = '6445761' AND rel.league_id = '62832' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0027   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442643' AND rel.team2 = '6442635' AND rel.league_id = '62749' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442177' AND rel.team2 = '6442180' AND rel.league_id = '62729' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442182' AND rel.team2 = '6442186' AND rel.league_id = '62729' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0024   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442185' AND rel.team2 = '6442179' AND rel.league_id = '62729' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442321' AND rel.team2 = '6442329' AND rel.league_id = '62734' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442549' AND rel.team2 = '6442553' AND rel.league_id = '62742' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6443478' AND rel.team2 = '6443471' AND rel.league_id = '62832' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444935' AND rel.team2 = '6444947' AND rel.league_id = '62379' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447066' AND rel.team2 = '6447057' AND rel.league_id = '62381' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6448962' AND rel.team2 = '6448965' AND rel.league_id = '63212' AND rel.round = '11' AND rel.language = 'spanish' AND rel.active = 1 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 = '6457583' AND rel.team2 = '6457579' AND rel.league_id = '63683' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442170' AND rel.team2 = '6442163' AND rel.league_id = '62728' AND rel.round = '22' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447113' AND rel.team2 = '6447122' AND rel.league_id = '62384' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442527' AND rel.team2 = '6442853' AND rel.league_id = '62741' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444892' AND rel.team2 = '6444907' AND rel.league_id = '62378' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444912' AND rel.team2 = '6444917' AND rel.league_id = '62378' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444946' AND rel.team2 = '6444931' AND rel.league_id = '62379' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447040' AND rel.team2 = '6447047' AND rel.league_id = '62380' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447065' AND rel.team2 = '6447053' AND rel.league_id = '62381' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447061' AND rel.team2 = '6447060' AND rel.league_id = '62381' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447079' AND rel.team2 = '6447074' AND rel.league_id = '62382' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447096' AND rel.team2 = '6447125' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447119' AND rel.team2 = '6447109' AND rel.league_id = '62384' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447055' AND rel.team2 = '6447069' AND rel.league_id = '62381' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447034' AND rel.team2 = '6447030' AND rel.league_id = '62380' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447054' AND rel.team2 = '6447063' AND rel.league_id = '62381' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447101' AND rel.team2 = '6447090' AND rel.league_id = '62383' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447124' AND rel.team2 = '6447110' AND rel.league_id = '62384' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6448481' AND rel.team2 = '6448475' AND rel.league_id = '62386' AND rel.round = '22' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442181' AND rel.team2 = '6442191' AND rel.league_id = '62729' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442546' AND rel.team2 = '6442543' AND rel.league_id = '62742' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442328' AND rel.team2 = '6442322' AND rel.league_id = '62734' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6446919' AND rel.team2 = '6443464' AND rel.league_id = '62832' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 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 = '6443477' AND rel.team2 = '6443467' AND rel.league_id = '62832' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442168' AND rel.team2 = '6442164' AND rel.league_id = '62728' AND rel.round = '22' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6446920' AND rel.team2 = '6442158' AND rel.league_id = '62728' AND rel.round = '22' AND rel.language = 'spanish' AND rel.active = 1 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 = '6448961' AND rel.team2 = '6448959' AND rel.league_id = '63212' AND rel.round = '11' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442522' AND rel.team2 = '6442520' AND rel.league_id = '62741' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6498884' AND rel.team2 = '6498893' AND rel.league_id = '66256' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0025   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442687' AND rel.team2 = '6442691' AND rel.league_id = '62752' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0025   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6496359' AND rel.team2 = '6496362' AND rel.league_id = '66176' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 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 = '6463319' AND rel.team2 = '6463320' AND rel.league_id = '64025' AND rel.round = '13' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6499705' AND rel.team2 = '6499703' AND rel.league_id = '66308' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442589' AND rel.team2 = '6442591' AND rel.league_id = '62745' AND rel.round = '22' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0024   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442320' AND rel.team2 = '6442318' AND rel.league_id = '62734' AND rel.round = '23' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0024   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442157' AND rel.team2 = '6442160' AND rel.league_id = '62728' AND rel.round = '22' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0026   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6443460' AND rel.team2 = '6443466' AND rel.league_id = '62832' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0029   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6442692' AND rel.team2 = '6442686' AND rel.league_id = '62752' AND rel.round = '19' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498892' AND rel.team2 = '6498890' AND rel.league_id = '66256' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499349' AND rel.team2 = '6499344' AND rel.league_id = '66290' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498063' AND rel.team2 = '6498077' AND rel.league_id = '66236' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499350' AND rel.team2 = '6499345' AND rel.league_id = '66290' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 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 = '6496361' AND rel.team2 = '6496356' AND rel.league_id = '66176' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499340' AND rel.team2 = '6499347' AND rel.league_id = '66290' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442200' AND rel.team2 = '6442207' AND rel.league_id = '62730' AND rel.round = '28' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0025   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6445142' AND rel.team2 = '6443473' AND rel.league_id = '62832' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 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 = '6443475' AND rel.team2 = '6443461' AND rel.league_id = '62832' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498087' AND rel.team2 = '6498095' AND rel.league_id = '66237' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499698' AND rel.team2 = '6499696' AND rel.league_id = '66308' AND rel.round = '1' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498078' AND rel.team2 = '6498086' AND rel.league_id = '66237' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498082' AND rel.team2 = '6498092' AND rel.league_id = '66237' AND rel.round = '3' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444905' AND rel.team2 = '6444928' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444903' AND rel.team2 = '6444902' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444941' AND rel.team2 = '6444940' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444951' AND rel.team2 = '6444949' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442206' AND rel.team2 = '6442201' AND rel.league_id = '62730' AND rel.round = '24' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499348' AND rel.team2 = '6499346' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6462413' AND rel.team2 = '6462415' AND rel.league_id = '63951' AND rel.round = '17' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498074' AND rel.team2 = '6498075' AND rel.league_id = '66236' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499356' AND rel.team2 = '6499339' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498076' AND rel.team2 = '6498072' AND rel.league_id = '66236' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499343' AND rel.team2 = '6499353' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498071' AND rel.team2 = '6498064' AND rel.league_id = '66236' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444900' AND rel.team2 = '6444927' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444912' AND rel.team2 = '6444919' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444917' AND rel.team2 = '6444908' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444947' AND rel.team2 = '6444936' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444934' AND rel.team2 = '6444948' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444937' AND rel.team2 = '6444935' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6447066' AND rel.team2 = '6447063' AND rel.league_id = '62381' AND rel.round = '17' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444911' AND rel.team2 = '6444895' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442522' AND rel.team2 = '6442527' AND rel.league_id = '62741' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444950' AND rel.team2 = '6444939' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6499352' AND rel.team2 = '6499354' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444898' AND rel.team2 = '6444892' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444925' AND rel.team2 = '6444913' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0023   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444931' AND rel.team2 = '6444942' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0025   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444933' AND rel.team2 = '6444930' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444932' AND rel.team2 = '6444946' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0025   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6444929' AND rel.team2 = '6444944' AND rel.league_id = '62379' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499350' AND rel.team2 = '6499365' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499345' AND rel.team2 = '6499344' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499342' AND rel.team2 = '6499351' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444926' AND rel.team2 = '6444923' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0024   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6498081' AND rel.team2 = '6498082' AND rel.league_id = '66237' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 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 = '6444907' AND rel.team2 = '6444906' AND rel.league_id = '62378' AND rel.round = '20' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442698' AND rel.team2 = '6443102' AND rel.league_id = '62752' AND rel.round = '18' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499369' AND rel.team2 = '6499340' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0024   SELECT m.* FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id WHERE rel.team1 = '6499355' AND rel.team2 = '6499349' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6499347' AND rel.team2 = '6499341' AND rel.league_id = '66290' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498062' AND rel.team2 = '6498065' AND rel.league_id = '66236' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 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 = '6498087' AND rel.team2 = '6498083' AND rel.league_id = '66237' AND rel.round = '4' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442205' AND rel.team2 = '6442214' AND rel.league_id = '62730' AND rel.round = '29' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0100  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 = 66176 OR league_id = 66290 OR league_id = 62383 OR league_id = 63313 OR league_id = 62384 OR league_id = 62378 OR league_id = 62379 OR league_id = 62380 OR league_id = 62382 OR league_id = 63684 OR league_id = 63951 OR league_id = 62734 OR league_id = 62728 OR league_id = 62832 OR league_id = 62749 OR league_id = 62729 OR league_id = 62742 OR league_id = 62381 OR league_id = 63212 OR league_id = 63683 OR league_id = 62741 OR league_id = 62386 OR league_id = 66256 OR league_id = 62752 OR league_id = 64025 OR league_id = 66308 OR league_id = 62745 OR league_id = 66236 OR league_id = 62730 OR league_id = 66237