wordpress_permalinks.sql

SELECT SUBSTR(
    CONCAT(
        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 )
    )
, 2) as permalink FROM wp_posts wpp INNER JOIN wp_options wpo on wpo.option_name='permalink_structure' WHERE wpp.post_type = 'post' AND wpp.post_status = 'publish' ORDER BY wpp.post_date DESC