SELECT C.cate_id, N.news_id, P.post_id
FROM category AS C, news as N, post as P
WHERE C.cate_id = N.cate_id AND P.news_id = N.news_id AND c.cate_id = 1