SELECT w.id, wp.age, w.coins_needed, w.power
FROM Wands w
INNER JOIN Wands_Property wp ON w.code = wp.code
WHERE (w.power, w.code, w.coins_needed) IN (SELECT power, code, MIN(coins_needed) FROM Wands GROUP BY power, code) AND wp.is_evil = 0
ORDER BY w.power DESC, wp.age DESC;