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;