List published WordPress posts sorted by latest
26 June 2022 (Updated 26 June 2022)
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