0.1368 |
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-03-28 19:41:19'
AND cal.shedule < '2024-04-03 18:21:19'
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.0038 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6583633'
AND rel.team2 = '6583641'
AND rel.league_id = '72116'
AND rel.round = '30'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582482'
AND rel.team2 = '6582484'
AND rel.league_id = '72046'
AND rel.round = '27'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0038 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582486'
AND rel.team2 = '6582492'
AND rel.league_id = '72046'
AND rel.round = '27'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0038 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6623590'
AND rel.team2 = '6623602'
AND rel.league_id = '74880'
AND rel.round = '12'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0038 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6623581'
AND rel.team2 = '6623584'
AND rel.league_id = '74880'
AND rel.round = '12'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587543'
AND rel.team2 = '6587555'
AND rel.league_id = '72358'
AND rel.round = '30'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6635204'
AND rel.team2 = '6635201'
AND rel.league_id = '75643'
AND rel.round = '1'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6622706'
AND rel.team2 = '6618044'
AND rel.league_id = '74470'
AND rel.round = '7'
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.0038 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6582572'
AND rel.team2 = '6582580'
AND rel.league_id = '72053'
AND rel.round = '27'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6583679'
AND rel.team2 = '6583675'
AND rel.league_id = '72121'
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.0036 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587603'
AND rel.team2 = '6587610'
AND rel.league_id = '72362'
AND rel.round = '29'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587600'
AND rel.team2 = '6587596'
AND rel.league_id = '72362'
AND rel.round = '29'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587604'
AND rel.team2 = '6587609'
AND rel.league_id = '72362'
AND rel.round = '29'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6587608'
AND rel.team2 = '6587598'
AND rel.league_id = '72362'
AND rel.round = '29'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0037 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6586265'
AND rel.team2 = '6586255'
AND rel.league_id = '72268'
AND rel.round = '27'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0036 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6586231'
AND rel.team2 = '6589053'
AND rel.league_id = '72266'
AND rel.round = '27'
AND rel.language = 'spanish'
AND rel.active = 1
AND rel.media_id < 90000
ORDER BY m.type DESC,field(m.location,'es','en') DESC
|
0.0039 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6599011'
AND rel.team2 = '6599013'
AND rel.league_id = '73234'
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.0043 |
SELECT m.*
FROM rel_media_match rel LEFT JOIN media m ON m.id = rel.media_id
WHERE rel.team1 = '6602792'
AND rel.team2 = '6602787'
AND rel.league_id = '73472'
AND rel.round = '23'
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.0084 | SELECT dt.nameShow, dt.basealias, t.id
FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE 0 OR league_id = 72116 OR league_id = 72046 OR league_id = 74880 OR league_id = 72358 OR league_id = 75643 OR league_id = 74470 OR league_id = 72053 OR league_id = 72121 OR league_id = 72362 OR league_id = 72268 OR league_id = 72266 OR league_id = 73234 OR league_id = 73472 |