SELECT recording.id, recording.gid, name.name,
                    recording.artist_credit AS artist_credit_id,
                    recording.length, recording.comment,
                    recording.edits_pending, recording.last_updated
                  FROM recording JOIN track_name name ON recording.name=name.id
             LEFT JOIN track t ON t.recording = recording.id
                  JOIN artist_credit_name acn
                    ON acn.artist_credit = recording.artist_credit
                 WHERE t.id IS NULL
                   AND acn.artist = $1
              ORDER BY musicbrainz_collate(name.name)
                OFFSET $2



SELECT recording.*
  FROM (
       SELECT recording.id, recording.gid, name.name,
             recording.artist_credit AS artist_credit_id,
             recording.length, recording.comment,
             recording.edits_pending, recording.last_updated
        FROM recording
        JOIN artist_credit_name acn
          ON acn.artist_credit = recording.artist_credit
        JOIN track_name name ON recording.name=name.id
       WHERE acn.artist = 17
  ) recording
LEFT JOIN track ON track.recording = recording.id
WHERE track.id IS NULL
ORDER BY musicbrainz_collate(recording.name)
OFFSET 0;