title: Left join that is not showing all left table values
body: <p>A LEFT JOIN should show all rows on the left table however when running the following query, I am only getting place values where there is a count of 1 or more. Please can someone give me some guidance as to where I might be going wrong:</p>
  
  <pre><code>SELECT places.placeId,
         placeName,
         COUNT(orderId) AS orderCount
  FROM   places
         LEFT JOIN orders
           ON places.placeId = orders.placeId
  WHERE  places.companyId = 1
         AND stateId = 1
         AND orderstateId = 1
         AND orderName NOT LIKE 'Delivery%'
  GROUP  BY places.placeId,
            places.placeName
  ORDER  BY orderCount DESC,
            placeName ASC 
  </code></pre>
  
  <p>Thanks in advance</p>