>This might sound silly and not 'best practiced' but if the original query performs good enough could you just wrap it as sub-query and then filter the result?
>Select * From
>(previous query) a
>Where filterfield = 1
>
>Silly me....
>
May be.