Or are you saying there is a third table involved???
I don't understand this:
I need to match "sid" (from news.news) with "page_id" (from comments.pages)
I don't see you using any table named comments.pages
anywhere in there. Your only query that mentions "comments" at all just does
SELECT ... FROM comments