I have recently used the 'top_n_by_rank' clause in a full text
query in order to reduce the query execution time.

Here is the senario - we have a table called 'article' that has
three fields.
ID int,
Active bit,
Body varchar(8000)

I want use the top_n_by_rank clause to only return the top 10 articles.
Simple enough but out of the top 10 articles returned only 2 of those
were active.
Is there a way to conditionally query a catalogue field?

My FT query is below:

SELECT
*
FROM
    Article AS FT_TBL
        INNER  JOIN CONTAINSTABLE(Article,
                    Body,
                    @vchQuery,
                    10
                    ) AS KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY]
WHERE
    FT_TBL.Active = 1

This seems to return the top 10 articles from the catalogue then
filters based on the where clause. I would like it to filter before
doing the FT search.

Thanks