http://netvouz.com/Karzin/tag/join?feed=rss Karzin's bookmarks tagged "join" on Netvouz http://stackoverflow.com/questions/3464701/export-list-of-pretty-permalinks-and-post-title 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' and wpo.blog_id=0 INNER JOIN wp_options wpo_su on wpo_su.option_name='siteurl' and wpo_su.blog_id=wpo.blog_id WHERE wpp.post_type = 'post' AND wpp.post_status = 'publish' ORDER BY wpp.post_date DESC Karzin Fri, 25 May 2012 20:01:44 GMT http://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html A Visual Explanation of SQL Joins Tutorial Karzin Thu, 16 Dec 2010 15:04:13 GMT