I tried DISTINCT and still have the same problem. Apparently DISTINCT filters duplicated records in query results, product of a many to many relation. My duplication is caused by a different nature (when one of the conditions in the WHERE clause is not met due to a BLANK field).