Above you have conflicting posts. This will make it hard to understand your problem and very difficult give you a good solution.

If you recieve too many e-mail then you have to look at the query inside the IF statement. Will this produce the results you expect for all different scenarios? Try to simulate this in a test-environment. Adjust the query if it needs modification. Copy/paste the final query as @query parameter if the query is working fine and the results are as expected.

If you need further help on this query you have to provide us with sample data that covers all situations.