SELECT habari__posts.id AS id, habari__posts.slug AS slug, habari__posts.title AS title, habari__posts.guid AS guid, habari__posts.content AS content, habari__posts.cached_content AS cached_content, habari__posts.user_id AS user_id, habari__posts.STATUS AS STATUS, habari__posts.pubdate AS pubdate, habari__posts.updated AS updated, habari__posts.modified AS modified, habari__posts.content_type AS content_type FROM {posts}
LEFT JOIN {post_tokens} pt ON {posts}.id= pt.post_id
WHERE pt.token_id IN (5)