Select Code to Download

-- I took the liberty of using table aliases as well

...
  AND    b.id = s.album_id
ORDER BY a.name, b.year, b.title, s.title
LIMIT    2;

CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;