Sorry for late response. Here are the queries.

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts 
WHERE 1=1 
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 11061
AND wp_posts.post_status = 'private')
AND wp_posts.id NOT IN (SELECT post_id
FROM wp_wpfront_ure_post_type_permissions
WHERE role IN ('subscriber','fund_news_members','fund_seminar_members','seminar_basic','seminar_advanced','seminar_deals','seminar_practices','retirement_financial_members')
AND enable_permissions = 1
AND has_read = 0
GROUP BY post_id
HAVING COUNT(*) = 8) 
ORDER BY wp_posts.post_date DESC
LIMIT 0, 15

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts 
INNER JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (865) )
AND wp_posts.post_type = 'post'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_author = 11061
AND wp_posts.post_status = 'private')
AND wp_posts.id NOT IN (SELECT post_id
FROM wp_wpfront_ure_post_type_permissions
WHERE role IN ('subscriber','fund_news_members','fund_seminar_members','seminar_basic','seminar_advanced','seminar_deals','seminar_practices','retirement_financial_members')
AND enable_permissions = 1
AND has_read = 0
GROUP BY post_id
HAVING COUNT(*) = 8) 
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 4