I have almost figured out the problem with the multiple sites problem (I have been experiencing the same thing). I have added to Mike provided:
<xsl:text disable-output-escaping="yes">
<![CDATA[<a href="/]]>
</xsl:text>
<xsl:value-of select="@NEED SITE URL"/>
<xsl:text disable-output-escaping="yes">
<![CDATA[</Lists/Posts/ViewPost.aspx?ID=]]>
</xsl:text>
<xsl:value-of select="@ID"/>
<xsl:text disable-output-escaping="yes"><![CDATA[">]]>
</xsl:text>
<xsl:value-of select="$DisplayTitle"/>
<xsl:text disable-output-escaping="yes"><![CDATA[</a>]]>
</xsl:text>
I just need to figure out how to pull the site url name from SharePoint; I have figured out ways to pull the site name, but that displays with spaces and such.
Thanks!