SQL - 执行此查询的最有效方法？

I basically have three tables, posts, images and postimages (this simply contains the ids of both the other tables and allows more than one image in each post and each image to be reused in multiple posts if necessary).I basically have three tables, posts, images an