<searchbases>
    <searchbase>
        <weights default="1" agefactor="0.05" seopriority="200"
            contenttypeweight="200" popularityweight="300" />
        <query><![CDATA[
            SELECT [KEY] AS Nr, (RANK {sys.iif(this.isbasequery(),
                "+" + this.seopriority("c.seopriority") +
                "+" + this.contenttypeweight("c.contenttype_weight") +
                "+" + this.popularityweight("LOG(ISNULL(pr.visits,1))/LOG(" +  sys.eval(maxvisits(), smartlet.number()) + ")"))})
             * {this.fieldweight("dbo.fn_tsAgeInDays(c.moddate)", default="(c."+this.fieldname()+"_weight - 1)")} AS SearchRank, 
             {sys.iif(this.isbasequery() || this.mode()!=SearchQuery, '1', 'NULL')} AS BaseSearch 
            FROM CONTAINSTABLE({this.searchgroupviewname()}, {this.fieldname(default="(QueryData,CTSpecificBinary1)")}, ?:searchterm)
            JOIN {this.searchgroupviewname()} c WITH (NOEXPAND) ON [KEY]=c.Nr
            {sys.iif(this.isbasequery(), "LEFT JOIN PageRequests pr ON c.Nr=pr.Nr")}
            {sys.iif(!this.isbasequery() AND this.mode()==SearchQuery,
                 "WHERE " + this.fieldweight("",default="c."+this.fieldname()+"_weight") + ">1")}
            ]]>
        </query>
    </searchbase>
    <searchbase name="like" type="native">
        <weights default="1">
            <field name="c.title" weight="4" />
            <field name="c.description" weight="2" />
        </weights>
        <query><![CDATA[
            SELECT c.Nr, {this.rankingstatment(content)}*100 as SearchRank
            FROM {this.searchgroupviewname()} c WITH (NOEXPAND)
            WHERE {this.searchcondition(content)}
            ]]>
        </query>
        <wherefields>c.title,c.description,c.querydata</wherefields>
    </searchbase>
</searchbases>