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

SELECT   a.name, b.title, s.title, b.year
FROM     artist a, album b, song s
WHERE    a.id = b.artist_id
  AND    b.id = s.album_id
ORDER BY a.name, b.year, b.title, s.title
LIMIT    2;

##</code><code>##

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