Selecting countries with different situations
I have formatted the queries. I am not able to test it, so if you can give the schema for this, or create it at SQL fiddle, that will be great. Data is not required.

SELECT cou.id, 
       cou.title 
FROM   countries cou 
       LEFT OUTER JOIN continents con 
                     ON  cou.continents_id = con.id 
WHERE  (con.deliver = 1 AND con.active = 1 ) OR 
       (cou.deliver = 1 AND cou.deliver = 0)


Please let me know in case there are any concerns.