I'm trying to find a list of all posts on my blog, with author, date, title and url included.
I'm at work trying to figure this out. My boss is trying to get a list of all of the permalinks of posts on our company's blog so we an do SEO analysis on them.
I exported wp_posts and cleaned it up, removing all but those 4 fields, but it just shows the unpretty permalink "?p=664" for example, which isn't the way that google's SEO data is listed, they use "blogname.com/date/title-of-the-post". The post title and date are in the wp_posts, so I guess I could figure out some macro or regexp to add the columns together and replace all the spaces with dashes, but there must be a simpler way.