0.0019 | SELECT z.name,z.alias,c.CountryCode,c.location,c.continent,c.top,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN zones z ON z.location = c.CountryCode WHERE z.alias = 'gales' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC |
0.0026 | SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId WHERE dt.main_image = 1 AND c.troncal = 1 AND l.year=c.active_year AND c.CountryCode = 'wa' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30 |
0.0021 | SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches_history lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-29 22:21:45' ORDER BY lm.creation_date DESC LIMIT 8 |
0.0021 | SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches_history lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-23 22:21:45' ORDER BY lm.creation_date DESC LIMIT 15 |
0.0022 | SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.active_year = l.year AND c.CountryCode = 'wa' ORDER BY c.coefficient |
0.0023 | SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date<'2024-05-10' AND l.end_date >'2024-05-05' AND c.active_year = l.year AND c.CountryCode = 'wa' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC |
0.0023 | SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.end_date <'2024-05-05' AND c.active_year = l.year AND c.CountryCode = 'wa' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC |
0.0023 | SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date >'2024-05-05' AND c.active_year = l.year AND c.CountryCode = 'wa' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.coefficient DESC |
0.0018 | SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-04-29' AND categoryId = 39 |