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

Partidos televisados

Primera División
Premier League
Bundesliga
Segunda RFEF
Premier Division Gibraltar
Serie B
Primera RFEF
Segunda RFEF
Tercera RFEF
Segunda RFEF
Segunda División
2. Bundesliga
Serie A
Primera División
Ligue 1
Liga Portuguesa
Apertura Primera División El Salvador
Primera Nacional
Etapas Finales Apertura MX
Segunda RFEF
Segunda División Femenina
Segunda RFEF
Primera RFEF
Segunda RFEF
Liga Rusa
División de Honor
Segunda RFEF
Primera Catalana
Segunda RFEF
Tercera RFEF
División de Honor
División Honor Senior
División de Honor
Eredivisie
Serie A
Segunda RFEF
Ligue 1
División de Honor
2. Bundesliga
Primera División
Segunda División
Liga Rusa
Bundesliga Austria
Premier League
Serie A
Bundesliga
Segunda División
Primera RFEF
Premier Division Gibraltar
Primera División
Primera RFEF
Segunda RFEF
Bundesliga Austria
Segunda RFEF
Liga Guatemala - Apertura
Segunda RFEF
Premier League
Bundesliga
División de Honor
Serie A
Liga Rusa
División Honor Senior
Segunda División
Segunda RFEF
Primera División
Premier Division Gibraltar
Liga Portuguesa
Liga Guatemala - Apertura
Primera Andaluza
Serie B
Serie A
Primera División
Liga Portuguesa
Primera Nacional
Etapas Finales Apertura MX
Liga Rusa
Championship
Primera División
Segunda División
Primera Nacional
Copa del Rey
Serie B
Copa del Rey
Serie A
Copa del Rey
Premier League
Copa del Rey
Serie B
Serie A
Premier Division Gibraltar
Copa del Rey
Premier League
Liga Portuguesa
Liga de Expansión MX - Apertura
Copa del Rey
Serie B
Copa del Rey
Serie A
Bundesliga Austria
Copa del Rey
Ligue 1
Copa del Rey
Premier League
Copa del Rey
Serie B
Serie A
Primera División
Copa del Rey
Ligue 1
Premier League
Liga de Expansión MX - Apertura
Copa del Rey
Serie A
Copa del Rey
Premier League
Copa del Rey
Premier League
Liga de Expansión MX - Apertura
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  
17,499,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Tvonline / Tv )  0.7149
Total Execution Time  0.7178
  CADENA URL  
/partidos-televisados
  GET DATOS  
$_GET['/partidos-televisados']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (186)  
0.0679   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 > '2021-11-27 18:17:30' AND cal.shedule < '2021-12-03 15:57:30' 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 = '6443101' AND rel.team2 = '6442164' AND rel.league_id = '62728' AND rel.round = '15' 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 = '6442179' AND rel.team2 = '6442184' AND rel.league_id = '62729' AND rel.round = '13' 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 = '6442543' AND rel.team2 = '6442539' AND rel.league_id = '62742' AND rel.round = '13' 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 = '6447057' AND rel.team2 = '6447056' AND rel.league_id = '62381' 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 = '6448964' AND rel.team2 = '6448961' AND rel.league_id = '63212' AND rel.round = '5' 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 = '6442531' AND rel.team2 = '6442853' AND rel.league_id = '62741' AND rel.round = '14' 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 = '6444898' AND rel.team2 = '6444912' AND rel.league_id = '62378' AND rel.round = '14' 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 = '6444927' AND rel.team2 = '6444911' AND rel.league_id = '62378' AND rel.round = '14' 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 = '6444950' AND rel.team2 = '6444936' AND rel.league_id = '62379' AND rel.round = '14' 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 = '6444946' AND rel.team2 = '6444930' AND rel.league_id = '62379' AND rel.round = '14' 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 = '6447066' AND rel.team2 = '6447069' AND rel.league_id = '62381' AND rel.round = '13' 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 = '6447093' AND rel.team2 = '6447098' AND rel.league_id = '62383' AND rel.round = '13' 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 = '6447033' AND rel.team2 = '6447032' AND rel.league_id = '62380' AND rel.round = '13' 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 = '6447062' AND rel.team2 = '6447059' AND rel.league_id = '62381' AND rel.round = '13' 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 = '6448476' AND rel.team2 = '6448481' AND rel.league_id = '62386' AND rel.round = '15' 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 = '6447072' AND rel.team2 = '6447074' AND rel.league_id = '62382' AND rel.round = '13' 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 = '6447089' AND rel.team2 = '6447092' AND rel.league_id = '62383' AND rel.round = '13' 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 = '6443476' AND rel.team2 = '6443461' AND rel.league_id = '62832' 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 = '6442972' AND rel.team2 = '6442570' AND rel.league_id = '62743' AND rel.round = '15' 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 = '6442710' AND rel.team2 = '6442317' AND rel.league_id = '62734' AND rel.round = '14' 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 = '6442173' AND rel.team2 = '6442160' AND rel.league_id = '62728' AND rel.round = '15' 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 = '6442586' AND rel.team2 = '6442583' AND rel.league_id = '62745' AND rel.round = '15' 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 = '6442682' AND rel.team2 = '6442683' AND rel.league_id = '62752' AND rel.round = '12' 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 = '6456791' AND rel.team2 = '6456786' AND rel.league_id = '63650' 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 = '6491621' AND rel.team2 = '6491618' AND rel.league_id = '65889' 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 = '6489790' AND rel.team2 = '6489786' AND rel.league_id = '65761' 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 = '6489793' AND rel.team2 = '6489784' AND rel.league_id = '65761' 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 = '6447095' AND rel.team2 = '6447106' AND rel.league_id = '62383' AND rel.round = '13' 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 = '6454866' AND rel.team2 = '6454865' AND rel.league_id = '63472' AND rel.round = '11' 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 = '6447117' AND rel.team2 = '6447121' AND rel.league_id = '62384' AND rel.round = '13' 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 = '6447071' AND rel.team2 = '6447086' AND rel.league_id = '62382' AND rel.round = '13' 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 = '6444900' AND rel.team2 = '6444926' AND rel.league_id = '62378' AND rel.round = '14' 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 = '6444906' AND rel.team2 = '6444902' AND rel.league_id = '62378' AND rel.round = '14' 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 = '6444919' AND rel.team2 = '6444905' AND rel.league_id = '62378' AND rel.round = '14' 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 = '6444941' AND rel.league_id = '62379' AND rel.round = '14' 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 = '6447048' AND rel.team2 = '6447049' AND rel.league_id = '62380' AND rel.round = '13' 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 = '6447082' AND rel.team2 = '6447085' AND rel.league_id = '62382' AND rel.round = '13' 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 = '6447111' AND rel.team2 = '6447119' AND rel.league_id = '62384' 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 = '6447107' AND rel.team2 = '6447116' AND rel.league_id = '62384' AND rel.round = '13' 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 = '6443511' AND rel.team2 = '6443512' AND rel.league_id = '62835' AND rel.round = '16' 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 = '6457473' AND rel.team2 = '6457476' AND rel.league_id = '63682' AND rel.round = '13' 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 = '6447087' AND rel.team2 = '6447078' AND rel.league_id = '62382' AND rel.round = '13' 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 = '6453674' AND rel.team2 = '6453683' AND rel.league_id = '63410' AND rel.round = '9' 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 = '6447104' AND rel.league_id = '62383' AND rel.round = '13' 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 = '6448440' AND rel.team2 = '6448431' AND rel.league_id = '62394' AND rel.round = '13' 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 = '6448895' AND rel.team2 = '6448892' AND rel.league_id = '62401' AND rel.round = '13' 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 = '6457518' AND rel.team2 = '6457525' AND rel.league_id = '63686' AND rel.round = '15' 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 = '6462402' AND rel.team2 = '6462410' AND rel.league_id = '63951' AND rel.round = '11' 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 = '6457470' AND rel.team2 = '6457481' AND rel.league_id = '63682' AND rel.round = '13' 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 = '6442645' AND rel.team2 = '6442635' AND rel.league_id = '62749' AND rel.round = '14' 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 = '6442327' AND rel.team2 = '6442315' AND rel.league_id = '62734' AND rel.round = '14' 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 = '6447103' AND rel.team2 = '6447100' AND rel.league_id = '62383' AND rel.round = '13' 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 = '6448354' AND rel.team2 = '6447102' AND rel.league_id = '62383' AND rel.round = '13' 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 = '6447105' AND rel.team2 = '6447125' AND rel.league_id = '62383' AND rel.round = '13' 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 = '6442590' AND rel.team2 = '6442589' AND rel.league_id = '62745' AND rel.round = '15' 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 = '6459248' AND rel.team2 = '6459249' AND rel.league_id = '63685' AND rel.round = '13' 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 = '6442565' AND rel.team2 = '6442558' AND rel.league_id = '62743' AND rel.round = '15' 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 = '6442169' AND rel.team2 = '6442166' AND rel.league_id = '62728' AND rel.round = '15' 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 = '6445761' AND rel.team2 = '6443463' AND rel.league_id = '62832' AND rel.round = '18' 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 = '6443504' AND rel.team2 = '6443500' AND rel.league_id = '62835' AND rel.round = '16' 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 = '6447234' AND rel.team2 = '6447241' AND rel.league_id = '63138' AND rel.round = '16' 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 = '6442969' AND rel.team2 = '6442183' AND rel.league_id = '62729' AND rel.round = '13' 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 = '6442180' AND rel.team2 = '6442191' AND rel.league_id = '62729' AND rel.round = '13' 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 = '6442185' AND rel.team2 = '6442194' AND rel.league_id = '62729' AND rel.round = '13' 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 = '6442187' AND rel.team2 = '6442192' AND rel.league_id = '62729' AND rel.round = '13' 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 = '6442320' AND rel.team2 = '6442324' AND rel.league_id = '62734' AND rel.round = '14' 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 = '6442325' AND rel.team2 = '6442312' AND rel.league_id = '62734' AND rel.round = '14' 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 = '6442544' AND rel.team2 = '6442552' AND rel.league_id = '62742' AND rel.round = '13' 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 = '6443471' AND rel.team2 = '6443469' AND rel.league_id = '62832' 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 = '6443474' AND rel.team2 = '6443467' AND rel.league_id = '62832' 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 = '6444947' AND rel.team2 = '6444942' AND rel.league_id = '62379' AND rel.round = '14' 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 = '6448956' AND rel.team2 = '6448962' AND rel.league_id = '63212' AND rel.round = '5' 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 = '6442175' AND rel.team2 = '6442168' AND rel.league_id = '62728' AND rel.round = '15' 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 = '6444895' AND rel.team2 = '6444903' AND rel.league_id = '62378' AND rel.round = '14' 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 = '6444923' AND rel.team2 = '6444917' AND rel.league_id = '62378' AND rel.round = '14' 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 = '6444929' AND rel.team2 = '6444951' AND rel.league_id = '62379' AND rel.round = '14' 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 = '6444934' AND rel.league_id = '62379' AND rel.round = '14' 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 = '6447045' AND rel.team2 = '6447043' AND rel.league_id = '62380' AND rel.round = '13' 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 = '6447079' AND rel.team2 = '6447080' AND rel.league_id = '62382' AND rel.round = '13' 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 = '6447081' AND rel.team2 = '6447083' AND rel.league_id = '62382' AND rel.round = '13' 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 = '6447030' AND rel.team2 = '6447031' AND rel.league_id = '62380' AND rel.round = '13' 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 = '6447239' AND rel.team2 = '6447237' AND rel.league_id = '63138' AND rel.round = '16' 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 = '6447122' AND rel.team2 = '6447110' AND rel.league_id = '62384' AND rel.round = '13' 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 = '6447355' AND rel.team2 = '6447358' AND rel.league_id = '63155' AND rel.round = '21' 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 = '6447054' AND rel.team2 = '6447068' AND rel.league_id = '62381' AND rel.round = '13' 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 = '6442181' AND rel.team2 = '6442188' AND rel.league_id = '62729' AND rel.round = '13' 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 = '6442549' AND rel.team2 = '6442541' AND rel.league_id = '62742' AND rel.round = '13' 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 = '6457498' AND rel.team2 = '6457501' AND rel.league_id = '63684' AND rel.round = '13' 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 = '6442322' AND rel.team2 = '6442326' AND rel.league_id = '62734' AND rel.round = '14' 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 = '6443499' AND rel.team2 = '6443509' AND rel.league_id = '62835' AND rel.round = '16' 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 = '6462398' AND rel.team2 = '6462414' AND rel.league_id = '63951' AND rel.round = '11' 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 = '6443470' AND rel.team2 = '6443475' AND rel.league_id = '62832' 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 = '6447050' AND rel.team2 = '6447047' AND rel.league_id = '62380' AND rel.round = '13' 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 = '6442161' AND rel.team2 = '6442159' AND rel.league_id = '62728' AND rel.round = '15' 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 = '6448958' AND rel.team2 = '6448957' AND rel.league_id = '63212' AND rel.round = '5' 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 = '6442694' AND rel.team2 = '6442695' AND rel.league_id = '62752' AND rel.round = '12' 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 = '6447347' AND rel.team2 = '6447357' AND rel.league_id = '63155' AND rel.round = '21' 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 = '6463316' AND rel.team2 = '6463315' AND rel.league_id = '64025' AND rel.round = '9' 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 = '6442528' AND rel.team2 = '6442530' AND rel.league_id = '62741' AND rel.round = '14' 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 = '6442321' AND rel.team2 = '6442319' AND rel.league_id = '62734' AND rel.round = '14' AND rel.language = 'spanish' AND rel.active = 1 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 = '6442170' AND rel.team2 = '6442171' AND rel.league_id = '62728' AND rel.round = '15' 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 = '6442692' AND rel.team2 = '6442696' AND rel.league_id = '62752' AND rel.round = '12' 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 = '6491617' AND rel.team2 = '6491620' AND rel.league_id = '65889' 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 = '6489792' AND rel.team2 = '6489787' AND rel.league_id = '65761' 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 = '6489791' AND rel.team2 = '6489785' AND rel.league_id = '65761' AND rel.round = '2' 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 = '6443507' AND rel.team2 = '6443506' AND rel.league_id = '62835' AND rel.round = '16' 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 = '6443498' AND rel.team2 = '6443503' AND rel.league_id = '62835' AND rel.round = '16' 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 = '6442204' AND rel.team2 = '6442211' AND rel.league_id = '62730' 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 = '6442167' AND rel.team2 = '6442163' AND rel.league_id = '62728' AND rel.round = '15' 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 = '6443473' AND rel.team2 = '6446919' AND rel.league_id = '62832' 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 = '6491619' AND rel.team2 = '6491622' AND rel.league_id = '65889' 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 = '6491739' AND rel.team2 = '6491694' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6491738' AND rel.team2 = '6491712' AND rel.league_id = '65506' 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 = '6442520' AND rel.team2 = '6442521' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6442523' AND rel.team2 = '6442531' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6491746' AND rel.team2 = '6491688' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6442311' AND rel.team2 = '6442710' AND rel.league_id = '62734' AND rel.round = '15' 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 = '6491736' AND rel.team2 = '6491667' AND rel.league_id = '65506' 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 = '6491765' AND rel.team2 = '6491689' AND rel.league_id = '65506' 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 = '6491737' AND rel.team2 = '6491711' AND rel.league_id = '65506' 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 = '6442189' AND rel.team2 = '6442195' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6491729' AND rel.team2 = '6491714' AND rel.league_id = '65506' 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 = '6442524' AND rel.team2 = '6446983' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6442525' AND rel.team2 = '6442517' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6442526' AND rel.team2 = '6442522' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6442527' AND rel.team2 = '6442533' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6442329' AND rel.team2 = '6442318' AND rel.league_id = '62734' AND rel.round = '15' 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 = '6448960' AND rel.team2 = '6448965' AND rel.league_id = '63212' AND rel.round = '5' 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 = '6491759' AND rel.team2 = '6491669' AND rel.league_id = '65506' 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 = '6491740' AND rel.team2 = '6491674' AND rel.league_id = '65506' 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 = '6491666' AND rel.team2 = '6491727' AND rel.league_id = '65506' 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 = '6491676' AND rel.team2 = '6491668' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6442184' AND rel.team2 = '6442182' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6442693' AND rel.team2 = '6442697' AND rel.league_id = '62752' AND rel.round = '12' 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 = '6492891' AND rel.team2 = '6494319' AND rel.league_id = '65968' 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 = '6491757' AND rel.team2 = '6491713' AND rel.league_id = '65506' 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 = '6442530' AND rel.team2 = '6442518' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6491748' AND rel.team2 = '6491730' AND rel.league_id = '65506' 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 = '6442317' AND rel.team2 = '6442325' AND rel.league_id = '62734' AND rel.round = '15' 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 = '6447238' AND rel.team2 = '6447241' AND rel.league_id = '63138' AND rel.round = '14' 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 = '6491752' AND rel.team2 = '6491721' AND rel.league_id = '65506' 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 = '6491728' AND rel.team2 = '6491726' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6442578' AND rel.team2 = '6442584' AND rel.league_id = '62745' AND rel.round = '16' 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 = '6491754' AND rel.team2 = '6491710' AND rel.league_id = '65506' 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 = '6491764' AND rel.team2 = '6491683' AND rel.league_id = '65506' 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 = '6491758' AND rel.team2 = '6491690' AND rel.league_id = '65506' 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 = '6491762' AND rel.team2 = '6491731' AND rel.league_id = '65506' 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 = '6491720' AND rel.team2 = '6491682' AND rel.league_id = '65506' 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 = '6491733' AND rel.team2 = '6491680' AND rel.league_id = '65506' 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 = '6442194' AND rel.team2 = '6442181' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6442192' AND rel.team2 = '6442179' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6442193' AND rel.team2 = '6442180' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6442190' AND rel.team2 = '6442185' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6491761' AND rel.team2 = '6491704' AND rel.league_id = '65506' 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 = '6491735' AND rel.team2 = '6491717' AND rel.league_id = '65506' 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 = '6491743' AND rel.team2 = '6491716' AND rel.league_id = '65506' 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 = '6491687' AND rel.team2 = '6491725' AND rel.league_id = '65506' 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 = '6491698' AND rel.team2 = '6491734' AND rel.league_id = '65506' 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 = '6491715' AND rel.team2 = '6491681' AND rel.league_id = '65506' 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 = '6491677' AND rel.team2 = '6491672' AND rel.league_id = '65506' 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 = '6442853' AND rel.team2 = '6442528' AND rel.league_id = '62741' AND rel.round = '15' 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 = '6442324' AND rel.team2 = '6442321' AND rel.league_id = '62734' AND rel.round = '15' 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 = '6442315' AND rel.team2 = '6442320' AND rel.league_id = '62734' AND rel.round = '15' 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 = '6442170' AND rel.team2 = '6442158' AND rel.league_id = '62728' AND rel.round = '9' 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 = '6491750' AND rel.team2 = '6491702' AND rel.league_id = '65506' 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 = '6442589' AND rel.team2 = '6442586' AND rel.league_id = '62745' AND rel.round = '16' 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 = '6442178' AND rel.team2 = '6442187' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6442183' AND rel.team2 = '6442186' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6492892' AND rel.team2 = '6494321' AND rel.league_id = '65968' 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 = '6491751' AND rel.team2 = '6491695' AND rel.league_id = '65506' 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 = '6442326' AND rel.team2 = '6442328' AND rel.league_id = '62734' AND rel.round = '15' 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 = '6491741' AND rel.team2 = '6491684' AND rel.league_id = '65506' 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 = '6491763' AND rel.team2 = '6491700' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6491744' AND rel.team2 = '6491678' AND rel.league_id = '65506' 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 = '6491756' AND rel.team2 = '6491722' AND rel.league_id = '65506' 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 = '6491742' AND rel.team2 = '6491732' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6491760' AND rel.team2 = '6491692' AND rel.league_id = '65506' 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 = '6491747' AND rel.team2 = '6491699' AND rel.league_id = '65506' 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 = '6442191' AND rel.team2 = '6442969' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6491745' AND rel.team2 = '6491706' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6491753' AND rel.team2 = '6491696' AND rel.league_id = '65506' 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 = '6491755' AND rel.team2 = '6491719' AND rel.league_id = '65506' AND rel.round = '2' 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 = '6442188' AND rel.team2 = '6442177' AND rel.league_id = '62729' AND rel.round = '14' 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 = '6492893' AND rel.team2 = '6494318' AND rel.league_id = '65968' AND rel.round = '2' AND rel.language = 'spanish' AND rel.active = 1 ORDER BY m.type DESC, field(m.location,'es','en') DESC
0.0080  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 = 62728 OR league_id = 62729 OR league_id = 62742 OR league_id = 62381 OR league_id = 63212 OR league_id = 62741 OR league_id = 62378 OR league_id = 62379 OR league_id = 62383 OR league_id = 62380 OR league_id = 62386 OR league_id = 62382 OR league_id = 62832 OR league_id = 62743 OR league_id = 62734 OR league_id = 62745 OR league_id = 62752 OR league_id = 63650 OR league_id = 65889 OR league_id = 65761 OR league_id = 63472 OR league_id = 62384 OR league_id = 62835 OR league_id = 63682 OR league_id = 63410 OR league_id = 62394 OR league_id = 62401 OR league_id = 63686 OR league_id = 63951 OR league_id = 62749 OR league_id = 63685 OR league_id = 63138 OR league_id = 63155 OR league_id = 63684 OR league_id = 64025 OR league_id = 62730 OR league_id = 65506 OR league_id = 65968