title: delete user comment but keep it - count
body: <p>When an user deletes a post or a comment I just set is as 1 on <code>delete</code> column.</p>
  
  <p>The problem is, I use a count to show user how many comments he has on the post.</p>
  
  <pre><code>select c.nome, p.foto, c.user, p.user, count(DISTINCT comentarios.id) as comentarios_count from posts p 
  join cadastro c on p.user=c.id 
  left join comentarios on comentarios.foto = p.id
  where p.delete='0' and comentarios.delete='0'
  group by p.id
  order by p.id desc limit ?
  </code></pre>
  
  <p>the problem is comentarios.delete='0' will select only posts that has at least one comment. I want to select all posts, but only count the comments that <code>delete</code> is set to 0.
  what is wrong?</p>