I think your problem is that you need to tell SQL what you mean more specificaly. Right now you have

... WHERE <condition1> OR <condition2> OR <condition3> AND <condition4
+>
[download]

like this if conditions 1 or 2 are true 3 and 4 won't even be checked as they are irrelivent you already have a true try re-writing your statement with brackets, something like this.

... WHERE (<condition1> OR <condition2> OR <condition3>) AND <conditio
+n4>
[download]

Written like this its saying any of the first 3 conditions may be true but must be combined with condition 4 being true (ie you active state check).
Hope this helps

---If it doesn't fit use a bigger hammer