You are viewing a single comment's thread. Return to all comments →
MySQL
select w.id, wp.age, w.coins_needed, w.power from wands w join wands_property wp using (code) join ( select age, min(coins_needed) min_coin, power from wands www join wands_property wwp using (code) where is_evil = 0 group by age, power ) sub on (wp.age = sub.age) and (w.power = sub.power) and (w.coins_needed = sub.min_coin) order by w.power desc, wp.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 →
MySQL