SELECT   DISTINCT posts.id             AS id,
                  posts.slug           AS slug,
                  posts.title          AS title,
                  posts.guid           AS guid,
                  posts.content        AS content,
                  posts.cached_content AS cached_content,
                  posts.user_id        AS user_id,
                  posts.STATUS         AS STATUS,
                  posts.pubdate        AS pubdate,
                  posts.updated        AS updated,
                  posts.modified       AS modified,
                  posts.content_type   AS content_type
FROM     posts
         LEFT JOIN post_tokens pt_allowed
           ON posts.id = pt_allowed.post_id
              AND pt_allowed.token_id IN (21)
         LEFT JOIN post_tokens pt_denied
           ON posts.id = pt_denied.post_id
              AND pt_denied.token_id IN (21)
WHERE    ((STATUS = ?
           AND content_type = ?))
         AND ((posts.content_type IN (2)
                OR pt_allowed.post_id IS NOT NULL)
              AND (pt_denied.post_id IS NULL))
ORDER BY pubdate DESC
LIMIT    5