title: MYSQL SELECT clause giving unwanted results. Multiple WHERE AND statements
body: <pre><code>SELECT `post`.*, `user_account`.`project_name` 
  FROM 
  `post` 
  INNER JOIN `user_account` ON `post`.`user_id` = `user_account`.`user_id` 
  WHERE 
  `post`.`deleted_at` IS NULL 
  AND `is_active` = 1 
  AND `deleted_at` IS NULL 
  AND `end` &gt; '2013-10-09' 
  AND `user_account`.`project_name` LIKE '%intensiivkursus%' 
  OR ( 
  `title` LIKE '%intensiivkursus%' 
  OR `topics` LIKE '%intensiivkursus%' 
  OR `target_group` LIKE '%intensiivkursus%' 
  OR `lectors` LIKE '%intensiivkursus%' 
  OR `timetable` LIKE '%intensiivkursus%' 
  ) 
  GROUP BY 
  `post`.`id` 
  ORDER BY 
  `post`.`created_at` DESC
  </code></pre>
  
  <p>I would expect this to give results only with <code>is_active = 1</code>, but for some reason, it gives the opposite. I get 5 results, all with <code>is_active = 0</code> <br/>
  What am I missing here ?</p>