SELECT prod_frey_posts.* FROM prod_frey_posts INNER JOIN prod_frey_postmeta ON ( prod_frey_posts.ID = prod_frey_postmeta.post_id ) INNER JOIN prod_frey_postmeta AS mt1 ON ( prod_frey_posts.ID = mt1.post_id ) WHERE 1=1 AND ( prod_frey_postmeta.meta_key = 'pub_date' AND ( ( mt1.meta_key = 'pub_featured_story' AND mt1.meta_value = '1' ) ) ) AND prod_frey_posts.post_type IN ('reports', 'op-eds', 'books') AND ((prod_frey_posts.post_status = 'publish')) GROUP BY prod_frey_posts.ID ORDER BY prod_frey_postmeta.meta_value DESC

Recent

Latest Books & Reports

August 4, 2017
Scroll to Top