<masterquery>
    <query><![CDATA[
        SELECT {this.selectfields()}
        FROM {this.tableorview()} c
        JOIN (
              SELECT {this.rankingfields()}
              FROM  (
                    {this.searchquery(default="SELECT Nr, 0 As SearchRank FROM Contents WHERE Nr=-1")}
              ) rq
              GROUP BY rq.Nr
        ) vt2 ON c.Nr=vt2.Nr
        {this.joinclause(default="")}                    
        WHERE {this.whereclause(default="(1=1)")} 
        ]]>
    </query>
    <fields>
        ROW_NUMBER() OVER (ORDER BY searchrank DESC, c.Nr) AS rownum, c.Nr AS Nr, CAST(vt2.searchrank AS INT) AS searchrank, c.contenttype, c.author, c.ModDate AS ModDate, c.Title AS Title, c.Description AS Description, c.Body AS Body, ft.FileExtension
    </fields>
    <joins>
        JOIN FileTypes ft ON c.FileType=ft.Nr
    </joins>
    <unionclause> UNION ALL </unionclause>
    <rankingfields>
        nr, SUM(searchrank) AS searchrank
    </rankingfields>
    <paging><![CDATA[
         SELECT * FROM (
            {this.searchquery(default="SELECT Nr, 0 As SearchRank FROM Contents WHERE Nr=-1")}
        ) x
        WHERE rownum BETWEEN ?:lowerbound AND ?:upperbound
        ]]>
    </paging>
</masterquery>