I am just trying to make sense of the order of precedence in a query I have inherited and I am still checking my results.. As I understand it, the AND operator is evaluated before OR unless brackets are used to change the precedence.
Here is the code
DISTINCT c.customerid as Client,
FROM Customer c
INNER JOIN ReportingCampaign rc
ON c.customerid = rc.customerid
INNER JOIN Orders o
ON c.customerid = o.customerid
INNER JOIN deal d
ON d.customerid = o.customerid
AND d.product_No = o.product_No
AND d.product_code = o.product_code
INNER JOIN Product p
ON p.customerid = o.customerid
AND p.product_No = o.product_no
WHERE rc.CampaignID ='30'
and rc.emailaddress ='y'
and rc.priority = '1'
and (c.modified_date<>'1900-01-01 00:00:00.000' or c.modified_date<>'')
and p.product_code not in ('AA','AB','AC','AD')
OR (p.product_Code not in ('AA','AB','AC','AD') and o.order_quantity< '1' and d.deal_date between '2019-01-01 00:0:0' and '2019-12-01 00:0:0')
Am I correct in saying that the last part of the WHERE filter OR (p.product_Code not in ('AA','AB','AC','AD') and o.order_quantity< '1' and d.deal_date between '2019-01-01 00:0:0' and '2019-12-01 00:0:0') will be evaluated first? And the preceding AND's will be evaluated in the order they are written?
I don't normally use this many filters so I just want to feel confident in how the query is working. Any input would be appreciated.