<facet name="contenttype" enabled="true" datatype="integer" mode="or" allowinvert="true" displayname="Contenttype">
    <facet_fields>ct.Nr, vt.Count, ct.Name, ROW_NUMBER() OVER (ORDER BY vt.Count DESC) AS rownum </facet_fields>
    <search_fields> count(*) as Count, c.ContentType </search_fields>
    <query><![CDATA[
        SELECT {this.facetselectfields()} FROM (
        {this.searchquery()}
        GROUP BY c.ContentType
        ) vt
        JOIN ContentTypes ct ON vt.contenttype=ct.nr
        ]]>
    </query>
    <joins></joins>
    <where> c.ContentType=?:contenttype </where>
</facet>