title: mySQL: Select WHERE causes error - why?
body: <p>I have this query:  </p>
  
  <pre><code>SELECT `manufacturers`.*, `languages`.*, COUNT(`products`.`id`) AS productcount
  FROM (`manufacturers`)
  WHERE `manufacturers`.`flushed` = `0`
  JOIN `languages` ON `manufacturers`.`lang` = `languages`.`id`
  LEFT OUTER JOIN `products` ON 
  `products`.`manuf` =  `manufacturers`.`mid`
  GROUP BY manufacturers.id
  ORDER BY `languages`.`id` asc, `manufacturers`.`mid` asc;
  </code></pre>
  
  <p>Without the WHERE row, everything works great, but with it, I get a Error 1064 (Syntax error) thrown in my face. I guess that it has something to do with the actual placement of the WHERE row in the query, so I tried to move it around, but without any luck.</p>
  
  <p>What can I do?</p>