Untitled
user_9914919852
mysql
4 years ago
282 B
3
Indexable
SELECT w.id, wp.age, w.coins_needed, w.power FROM Wands w JOIN Wands_property wp on w.code = wp.code WHERE wp.is_evil = 0 AND w.coins_needed = ( SELECT min(w2.coins_needed) FROM Wands w2 WHERE w2.power = w.power and w2.code = w.code) ORDER BY w.power DESC, wp.age DESC;
Editor is loading...