| 0.0023 | SELECT * FROM quiniela_r WHERE status = 'enb' AND rewards IS NOT NULL ORDER BY year DESC, round DESC LIMIT 1 |
| 0.0052 | SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2024 AND q.round=54 ORDER BY idq ASC |
| 0.0019 | SELECT * FROM quiniela_r WHERE round = 32 ORDER BY year DESC |
| 0.0038 | SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2024 AND q.round=32 ORDER BY idq ASC |
| 0.0020 | SELECT * FROM quiniela_r WHERE status = 'enb' AND ((NOW()>=init_date AND NOW()<=end_date) OR init_date>NOW()) ORDER BY init_date ASC LIMIT 1 |
| 0.0037 | SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2024 AND q.round=55 ORDER BY idq ASC |
| 0.0018 | SELECT MAX(round) AS max_round FROM quiniela_r WHERE status='enb' AND year=2024 |
| 0.0036 | SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2024 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '32' AND q.year=2024 ORDER BY q.idq ASC |
| 0.0037 | SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2024 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '32' AND q.year=2024 ORDER BY q.idq ASC |
| 0.0037 | SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2024 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '32' AND q.year=2024 ORDER BY q.idq ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577292 AND r1<99 ORDER BY shedule ASC |
| 0.0020 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577257 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577321 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577248 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577335 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577247 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577274 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577262 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577290 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577256 AND r1<99 ORDER BY shedule ASC |
| 0.0022 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577267 AND r1<99 ORDER BY shedule ASC |
| 0.0026 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577254 AND r1<99 ORDER BY shedule ASC |
| 0.0024 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577259 AND r1<99 ORDER BY shedule ASC |
| 0.0026 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577264 AND r1<99 ORDER BY shedule ASC |
| 0.0031 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577260 AND r1<99 ORDER BY shedule ASC |
| 0.0025 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577261 AND r1<99 ORDER BY shedule ASC |
| 0.0024 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577272 AND r1<99 ORDER BY shedule ASC |
| 0.0026 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577255 AND r1<99 ORDER BY shedule ASC |
| 0.0023 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577276 AND r1<99 ORDER BY shedule ASC |
| 0.0028 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577258 AND r1<99 ORDER BY shedule ASC |
| 0.0026 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577279 AND r1<99 ORDER BY shedule ASC |
| 0.0025 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577249 AND r1<99 ORDER BY shedule ASC |
| 0.0025 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577281 AND r1<99 ORDER BY shedule ASC |
| 0.0026 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577252 AND r1<99 ORDER BY shedule ASC |
| 0.0029 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577295 AND r1<99 ORDER BY shedule ASC |
| 0.0023 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577250 AND r1<99 ORDER BY shedule ASC |
| 0.0025 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6616089 AND r1<99 ORDER BY shedule ASC |
| 0.0021 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577253 AND r1<99 ORDER BY shedule ASC |
| 0.0022 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team1 = 6577269 AND r1<99 ORDER BY shedule ASC |
| 0.0022 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 71759 AND team2 = 6577268 AND r1<99 ORDER BY shedule ASC |
