title: SQL select and count at the same time
body: <p>I am trying to select all from stuff and count the total amount of items in morestuff where stuff id = morestuff id.</p>
  
  <pre><code>select *,
      COUNT(morestuff.items) as total
  from stuff,
      morestuff
  where stuff.id = '{$id}'
      and morestuff.id = stuff.id
  </code></pre>
  
  <p>Obviously there is something wrong with my query, can anyone help?</p>