BuddyPress.org

<– Note that this will delete all activity items related to blog id 1. If you need only to delete new blog post notifications:
`DELETE FROM wp_bp_activity WHERE type = ‘new_blog_post’ AND item_id = ‘1’;`