title: SQL Query need to show blank records
body: <p>I have a query where i'm selecting 50 ids from the DB and grouping them by the id.</p>
  
  <p>The only problem is that only 34 exists in the DB so it only shows 34 results.</p>
  
  <p>My desired result is to show 50 results with the ones that don't exists in.</p>
  
  <p>Is this possible?</p>
  
  <p>Thanks</p>
  
  <p><strong>My query</strong></p>
  
  <pre><code>SELECT no, count(no) as visits FROM DB 
  WHERE (no = '1' or no = '2'  or no = '3' or no = '4' or no = '5')
  GROUP BY no
  </code></pre>
  
  <p>This example will only give me 3 records even though i'm selecting 5 records</p>