$mysql->query("SELECT ROUND(AVG(votes.value), 2) AS `avg`,
COUNT(votes.value) AS `num_votes`,
users.id AS `id`,
users.username AS `username`,
users.name AS `name`,
users.photoname AS `photoname`,
cities.description AS `city`,
profile.maxim as `maxim`,
profile.description AS `description`
FROM `users`, `votes`, `profile`
LEFT JOIN `cities` ON profile.city = cities.id
WHERE MONTH(votes.date) = '$get_month' AND
YEAR(votes.date) = '$get_year' AND
profile.uid = users.id AND
votes.to = users.id AND
users.sex = 'f'
GROUP BY votes.to
ORDER BY `avg` DESC, `num_votes` DESC, users.username ASC
LIMIT 1");
supponendo di avere questa query, è possibile invece di farne due, una per sex = 'f' ed una per sex = 'm', farne una solamente? (sempre prenendo un record per sex = f ed uno per sex = m)