Which of the following will show the most recent
post (by date) from a custom taxonomy?
Answers:
1.
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_term_taxonomy as c on (b.term_taxonomy_id = c.term_taxonomy_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)
2.
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_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)
3.
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_term_taxonomy as c on (b.term_taxonomy_id = c.term_taxonomy_id) join
wp_terms as d on (c.term_id = d.term_id) having (wp_posts.post_date =
max(wp_posts.post_date)) )tmp)
4.
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)