<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
                xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="xml" omit-xml-declaration="yes" indent="yes" encoding="ISO-8859-1"/>
<xsl:strip-space elements="*"/>

<xsl:variable name="englishdb" select="document('lfdb.en.xml')"/>

<xsl:variable name="version" select="0.1"/>

<xsl:template match="/">
  <h3>Recent vertaald</h3>
  <ul>
  <xsl:for-each select="/database/articles//article">
    <xsl:sort select="translation/finished" order="descending"/>
    <xsl:if test="position() &lt;= 10">
      <xsl:variable name="id"><xsl:value-of select="@id"/></xsl:variable>
      <xsl:variable name="theme"><xsl:value-of select="$englishdb/database/articles/article[@id=$id]/theme/@href"/></xsl:variable>
      <li><xsl:value-of select="translation/finished"/>: 
        <xsl:element name="a">
          <xsl:attribute name="href">
            <xsl:value-of select="$englishdb/database/articles/article[@id=$id]/issue/@href"/>
            <xsl:text>/article</xsl:text>
            <xsl:value-of select="@id"/>
            <xsl:text>.shtml</xsl:text>
          </xsl:attribute>
          <xsl:value-of select="title[@xml:lang='nl']"/>
        </xsl:element>
        (<xsl:value-of select="@id"/>, 
        <xsl:value-of select="/database/themes/theme[@id=$theme]"/>)</li>
    </xsl:if>
  </xsl:for-each>
  </ul>
</xsl:template>

</xsl:stylesheet>