SELECT posts.id, posts.post_title, posts.isanon, posts.post_time, authors.name FROM posts,authors,tags WHERE posts.authorid = authors.id AND posts.id = tags.postid AND tags.tag = :tag;