第四题

select * from topic,user u,rank r where belongid=5 and userid=u.id and u.rankid=r.id and r.edit=1