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 SELECTwpp.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 permalinkFROMwp_kympstfnsd_posts wppJOIN wp_kympstfnsd_options wpo ON wpo.option_name = ‘permalink_structure’WHEREwpp.post_type = ‘post’AND wpp.post_status = ‘publish’ORDER BYwpp.post_date DESC;