<?xml version='1.0' encoding='UTF-8'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.1">

<xsl:template match="/">
	<xsl:apply-templates select="nathguil/wp_posts"/>
</xsl:template>

<xsl:template match="wp_posts">
	<xsl:variable name="dir">
		<xsl:choose>
			<xsl:when test="post_type/text() = 'post'"><xsl:text>posts</xsl:text></xsl:when>
			<xsl:when test="post_type/text() = 'page'"><xsl:text>pages</xsl:text></xsl:when>
		</xsl:choose>
	</xsl:variable>
	<xsl:variable name="filename" select="post_name/text()"/>
	<xsl:variable name="author" select="post_author/text()"/>
	<xsl:variable name="id" select="ID/text()"/>
	<xsl:if test="post_type/text() = 'post' or post_type/text() = 'page'">
		<xsl:value-of select="$id"/><xsl:text> </xsl:text><xsl:value-of select="$dir"/><xsl:text> </xsl:text><xsl:value-of select="$filename"/><xsl:text> </xsl:text><xsl:value-of select="post_title/text()"/><xsl:text>
</xsl:text>
	</xsl:if>
</xsl:template>

</xsl:stylesheet>

Source