| 0.1199 |
SELECT cal.*,c.name as leagueName,c.logo,c.alias
FROM `rel_media_match` rel
INNER JOIN leagues l
ON rel.league_id = l.id
INNER JOIN categories c
ON c.id = l.categoryId
LEFT JOIN media m
ON m.id = rel.media_id
INNER JOIN calendars2024 cal
ON cal.league_id = l.id
AND cal.team1 = rel.team1
AND cal.team2 = rel.team2
WHERE rel.language = 'spanish'
AND rel.active = 1
AND cal.shedule > '2024-04-26 20:38:00'
AND cal.shedule < '2024-05-02 18:18:00'
AND rel.media_id < 90000
GROUP BY cal.id
ORDER BY c.coefficient DESC,cal.shedule ASC,m.type DESC,rel.id ASC,rel.media_id ASC LIMIT 100 |
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6622218'
AND rel.team2 = '6622220'
AND rel.league_id = '74790'
AND rel.round = '3'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6583642'
AND rel.team2 = '6583640'
AND rel.league_id = '72116'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0148 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6578401'
AND rel.team2 = '6578410'
AND rel.league_id = '71849'
AND rel.round = '35'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0151 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6578408'
AND rel.team2 = '6578392'
AND rel.league_id = '71849'
AND rel.round = '35'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0150 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582450'
AND rel.team2 = '6582446'
AND rel.league_id = '72044'
AND rel.round = '34'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0149 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582447'
AND rel.team2 = '6582441'
AND rel.league_id = '72044'
AND rel.round = '34'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0148 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582489'
AND rel.team2 = '6582490'
AND rel.league_id = '72046'
AND rel.round = '31'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582492'
AND rel.team2 = '6582481'
AND rel.league_id = '72046'
AND rel.round = '31'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0162 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582486'
AND rel.team2 = '6582484'
AND rel.league_id = '72046'
AND rel.round = '31'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0161 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587553'
AND rel.team2 = '6587557'
AND rel.league_id = '72358'
AND rel.round = '34'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0166 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587554'
AND rel.team2 = '6587543'
AND rel.league_id = '72358'
AND rel.round = '34'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0161 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6637351'
AND rel.team2 = '6637356'
AND rel.league_id = '75870'
AND rel.round = '2'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0168 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6637353'
AND rel.team2 = '6637358'
AND rel.league_id = '75870'
AND rel.round = '2'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0161 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582575'
AND rel.team2 = '6582567'
AND rel.league_id = '72053'
AND rel.round = '31'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0155 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587688'
AND rel.team2 = '6587690'
AND rel.league_id = '72365'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0151 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587603'
AND rel.team2 = '6587599'
AND rel.league_id = '72362'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0152 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587604'
AND rel.team2 = '6587601'
AND rel.league_id = '72362'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0154 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587600'
AND rel.team2 = '6587606'
AND rel.league_id = '72362'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0152 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587608'
AND rel.team2 = '6587605'
AND rel.league_id = '72362'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0151 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587634'
AND rel.team2 = '6587638'
AND rel.league_id = '72364'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0152 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587647'
AND rel.team2 = '6587648'
AND rel.league_id = '72364'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0158 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587646'
AND rel.team2 = '6587633'
AND rel.league_id = '72364'
AND rel.round = '33'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0165 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6586265'
AND rel.team2 = '6586252'
AND rel.league_id = '72268'
AND rel.round = '31'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0164 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6626329'
AND rel.team2 = '6626319'
AND rel.league_id = '75057'
AND rel.round = '13'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0161 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6626299'
AND rel.team2 = '6626296'
AND rel.league_id = '75057'
AND rel.round = '13'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0150 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6626297'
AND rel.team2 = '6626325'
AND rel.league_id = '75057'
AND rel.round = '13'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0148 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6626300'
AND rel.team2 = '6626295'
AND rel.league_id = '75057'
AND rel.round = '13'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0146 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6599013'
AND rel.team2 = '6599008'
AND rel.league_id = '73234'
AND rel.round = '28'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0149 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6630260'
AND rel.team2 = '6630257'
AND rel.league_id = '75295'
AND rel.round = '2'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6630263'
AND rel.team2 = '6630262'
AND rel.league_id = '75295'
AND rel.round = '2'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6588885'
AND rel.team2 = '6588876'
AND rel.league_id = '72467'
AND rel.round = '25'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6626349'
AND rel.team2 = '6626351'
AND rel.league_id = '75059'
AND rel.round = '14'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6626458'
AND rel.team2 = '6626466'
AND rel.league_id = '75066'
AND rel.round = '10'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6599053'
AND rel.team2 = '6599054'
AND rel.league_id = '73236'
AND rel.round = '26'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0147 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6602781'
AND rel.team2 = '6602791'
AND rel.league_id = '73472'
AND rel.round = '26'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
| 0.0167 | 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 = 74790 OR league_id = 72116 OR league_id = 71849 OR league_id = 72044 OR league_id = 72046 OR league_id = 72358 OR league_id = 75870 OR league_id = 72053 OR league_id = 72365 OR league_id = 72362 OR league_id = 72364 OR league_id = 72268 OR league_id = 75057 OR league_id = 73234 OR league_id = 75295 OR league_id = 72467 OR league_id = 75059 OR league_id = 75066 OR league_id = 73236 OR league_id = 73472 |
Varios canales
ESPN
Fox Sports
ESPN 2
ESPN 3
ESPN 2
Eurosport 2
TVG2
TNT Sports
GolTV
GolTV
GolTV
SFC TV
Betevé
7 TV Jaén
TyC Sports
TyC Sports Play
Teledeporte
TV3
Esport 3
ETB1
Teleporte