Prova così:

codice:
SELECT l.link_content, l.link_title, l.link_url, c.category_name FROM news_links l, news_categories c WHERE c.category_id = l.link_category LIMIT 1, 100