May 27, 2016 at 7:44 pm
#31970
Syam Mohan
Keymaster
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