Unnamed

SELECT post.id
    FROM list_posts AS post
    LEFT OUTER JOIN private ON (post.id = private.pid)
    LEFT OUTER JOIN count_comments AS ccount ON (post.id = ccount.pid)
    WHERE
        post.id = 41
        AND (
            EXISTS (SELECT 1 FROM official_user WHERE user = 1)
            OR post.private = false
            OR private.uid IS NOT null
        )
    LIMIT 1;