Why is this query not returning only the jobs in the date range I've set?

Question

I've written this query to return all jobs sent in the last month. For some reason, it's returning jobs as far back as March 2017 - a full 6 months. There should be about 120, but it's showing 9,000 rows. I know Data Views only keep 6 months of data, so it looks like the date part of this query isn't being read at all - can anyone help?

SELECT EmailName, EmailSubject, CreatedDate As sendDate
FROM _Job
WHERE [CreatedDate] >= DATEADD(MONTH, -1, CAST(GETDATE() AS date))
AND EmailSubject Not Like '%Test Send%'
AND EmailName Like '%-APP-%'
OR EmailName Like '%-HIS-%'
OR EmailName Like '%-PAD-%'
OR EmailName Like '%-EXT-%'
OR EmailName Like '%-UNP-%'
OR EmailName Like '%-CLE-%'
OR EmailName Like '%-UTT-%'
OR EmailName Like '%-PRO-%'
OR EmailName Like '%-PAR-%'
OR EmailName Like '%-ADV-%'

Answer 1

The issue was due to the OR statements in your original. This was ignoring your original 'AND' WHERE clauses if the email name was similar to your listed strings.

To get around this, try the following enclosed in parenthesis.

SELECT EmailName, EmailSubject, CreatedDate As sendDate
FROM _Job
WHERE [CreatedDate] >= DATEADD(MONTH, -1, CAST(GETDATE() AS date))
AND EmailSubject Not Like '%Test Send%'
AND (EmailName Like '%-APP-%'
OR EmailName Like '%-HIS-%'
OR EmailName Like '%-PAD-%'
OR EmailName Like '%-EXT-%'
OR EmailName Like '%-UNP-%'
OR EmailName Like '%-CLE-%'
OR EmailName Like '%-UTT-%'
OR EmailName Like '%-PRO-%'
OR EmailName Like '%-PAR-%'
OR EmailName Like '%-ADV-%')

I also recommend using DateDiff as I have found it to be faster and more accurate in SFMC:
(just my opinion, others disagree)

WHERE DateDiff(month, sendDate, GetDate()) < 1