SELECT *
FROM request
INNER JOIN artist ON artist.id=request.artist_id
INNER JOIN album ON album.id=request.album_id
ORDER BY request.created DESC, request.weight DESC, artist.name ASC, album.name ASC, request.name ASC
LIMIT 50