List published WordPress posts sorted by latest

SELECT
	ID,
	post_title,
	post_date,
	post_modified
FROM
	wp_posts
WHERE
	post_type = 'post'
	AND post_status = 'publish'
ORDER BY
	post_date DESC;

Tagged: WordPress