SELECT 
        post.id AS post_id
    FROM 
        post, tag, post_tag
    WHERE 
        post.deleted = ? AND 
        tag.name = ? AND 
        post.id = post_tag.post_id AND 
        tag.id = post_tag.tag_id AND 
        tag.name = ? AND 
        post.id = post_tag.post_id AND 
        tag.id = post_tag.tag_id 
    ORDER BY 
        date DESC
    LIMIT 250 OFFSET 0