SELECT id, age, coins_needed, Wands.power
FROM Wands,
(SELECT w.code,
age,
MIN(coins_needed) as min_coins,
power
FROM Wands w, Wands_Property wp
WHERE w.code = wp.code
AND is_evil = 0
GROUP BY w.code, age, power) AS min_price_table
WHERE Wands.code = min_price_table.code
AND Wands.coins_needed = min_price_table.min_coins
AND Wands.power = min_price_table.power
ORDER BY power DESC, age DESC;