Which of the following will show the most recent post (by date) from a custom taxonomy?
Answer
Correct Answer: select * from wp_posts where ID in( select ID from ( select wp_posts.ID , wp_posts.post_date, d.name from wp_posts as a join wp_term_relationships as b on ( a.ID = b.object_id) join wp_terms as d on (c.term_id = d.term_id) where c.taxonomy = 'post-series' group by d.name having (wp_posts.post_date = max(wp_posts.post_date)) )tmp)
Explanation:
Note: This Question is unanswered, help us to find answer for this one