LEFT JOIN content ON links.id = content.linkID
WHERE content.linkID IS NULL
ORDER BY links.linkName ASC
Try that. I'm terrible with null checking :P. I don't think MySQL support MINUS queries, but the above or using a subquery within the where should do the trick.