第四题

select title,content from topic t
join user u on u.id=t.userid
join rank r on r.id=u.rankid
where r.edit=1 and t.belongid=5