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