title: Count() and left join problem
body: <p>I'm having a problem with the a query which displays a list of shops with the number of products associated with it. I've been playing around with left joins etc for quite a while now but to no avail. The tables have the following structures:</p>
  
  <p>Shops table containing columns: <code>id</code>, <code>name</code></p>
  
  <p>Products table containing columns: <code>id</code>, <code>name</code>, <code>status</code>, <code>shop</code></p>
  
  <p>The query is as follows:</p>
  
  <pre><code>select s.name
         , p.name
         , count(p.id) 
  from   Product as p 
         left join Shop as s on p.shop=s.id
  where  p.status &lt;&gt; '8796107276379'
  group by 
         s.id
  </code></pre>
  
  <p>I'm not getting the shops which have 0 products. How can I achieve this please?</p>
  
  <p>The underlying database is MySQL. </p>
  
  <p>Thanks! 
  Krt_Malta</p>