MySQL

select wp_posts. *
from wp_posts
left join wp_postmeta on ( wp_posts.id = wp_postmeta.post_id )
where 1=1
and wp_posts.post_date < now()
group by wp_posts.id
order by wp_posts.post_date desc
limit 0, 30;
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">