Get WordPress Permalinks from MySQL Directly

Thanks to Sully AND KEN the original source of the almost working query. Validation was substantially eased by EverSQL.com

SELECT
wpp.post_title,
wpp.guid,
wpp.post_date,
REPLACE(
REPLACE(
REPLACE(
REPLACE(
wpo.option_value,
‘%year%’,
DATE_FORMAT(wpp.post_date, ‘%Y’)
),
‘monthnum%’,
DATE_FORMAT(wpp.post_date, ‘%m’)
),
‘% day %’,
DATE_FORMAT(wpp.post_date, ‘ %d ‘)
),
‘%postname%’,
wpp.post_name
) AS permalink
FROM
wp_kympstfnsd_posts wpp
JOIN wp_kympstfnsd_options wpo ON wpo.option_name = ‘permalink_structure’
WHERE
wpp.post_type = ‘post’
AND wpp.post_status = ‘publish’
ORDER BY
wpp.post_date DESC;