根据用户的上一个视图获取每个主题的新帖子数

I cant figure out how to do the mysql query for it. I have mysql table for topics (id,name) and posts (user,topic,post,time) and user last topic views (topic,user,time)I cant figure out how to do the mysql query for