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 ('books', 'op-eds', 'reports') AND ((prod_frey_posts.post_status = 'publish'))
GROUP BY prod_frey_posts.ID
ORDER BY prod_frey_postmeta.meta_value DESC
William H. Frey is a Ph.D. demographer and sociologist specializing in U.S. demographics.
This site provides links to publications, demographic issues, media stories, data tools and resources for teachers developed by projects with which Dr. Frey is associated.