OR conflict between other conditions

Question

I have the following query:

    SELECT * FROM `Contacts` 
WHERE `Zona` = '1' 
AND `Responsable` = '9' 
AND `AllowComercialVisit` = 'Call_Again'
-- the problem are OR's --
OR `AllowComercialVisit` = 'Busy' 
OR `AllowComercialVisit` = 'Not_answered' 
-- the problem are OR's --
AND `DateRecall` <= '2016-06-20 13:04:52' 
AND `DateRecall` >= '2016-06-20 12:39:52' 
ORDER BY `DateRecall` ASC LIMIT 1

The problem is that the query should ONLY shows the rows between the first and the second 'DateRecall' , but return all the rows with 'Call_Again','Busy' and 'Not_answered' without filtering the date.

Any solution will be appreciated !

Answer 1

A simple IN() would solve this:

SELECT * FROM `Contacts` 
WHERE `Zona` = '1' 
    AND `Responsable` = '9' 
    AND `AllowComercialVisit` IN ('Call_Again','Busy','Not_answered') 
    AND `DateRecall` BETWEEN '2016-06-20 12:39:52'
                         AND '2016-06-20 13:04:52' 
ORDER BY `DateRecall` ASC
LIMIT 1

In general, AND has precedence over OR , when using OR try using parentheses ->

WHERE COND1 AND COND2 AND (COND3 OR COND4) AND COND5

Which will force the optimizer to follow your precedence and not the default one.