You are viewing a single comment's thread. Return to all comments →
SELECT A.id , B.age , A.coins_needed , A.power FROM Wands A INNER JOIN Wands_Property B ON A.code = B.code WHERE NOT is_evil AND (A.code, A.coins_needed, A.power) IN ( SELECT code , MIN(coins_needed) , power FROM Wands GROUP BY code , power ) ORDER BY A.power DESC , B.age DESC
Seems like cookies are disabled on this browser, please enable them to open this website
Ollivander's Inventory
You are viewing a single comment's thread. Return to all comments →