Hi Jack,

Try these

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')
ORDER BY wp_posts.post_date DESC
LIMIT 0, 15

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

Thanks

Syam