select w.id, wp.age, w.coins_needed, w.power
from wands as w
inner join (select code, min(coins_needed) as cn, power
from wands
group by code, power) mc
on w.code=mc.code and w.coins_needed=mc.cn and w.power=mc.power
inner join wands_property as wp
on w.code=wp.code
where wp.is_evil=0
order by w.power desc, wp.age desc;