title: Mysql count return Zero if no record found
body: <p>I have a two tables.</p>
  
  <pre><code>cities - id_city, city_name
  properties - id_property, id_city, property_name
  </code></pre>
  
  <p>I want to display <code>cities.city_name</code> and next to it <code>[properties.count(id_city)]</code></p>
  
  <p>How do I make a query that still returns zero if no records are found instead of <code>NULL</code>, so that I get results like this:</p>
  
  <pre><code>London [123]
  New York [0]
  Berlin [11]
  </code></pre>
  
  <p>where "New York" is [0], not <code>NULL</code> and not 1?</p>