Get a list of permalinks from Wordpress 3.8 via MySQL

gistfile1.sql

SELECT
  wpp.post_title,
  wpp.guid,
  wpp.post_date,
  CONCAT(wpo_su.option_value, 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_posts wpp
  INNER JOIN wp_options wpo
    ON wpo.option_name = 'permalink_structure'
  INNER JOIN wp_options wpo_su
    ON wpo_su.option_name = 'siteurl'
WHERE wpp.post_type = 'post' AND wpp.post_status = 'publish'
ORDER BY wpp.post_date DESC