title: Symfony doctrine multiple count
body: <p>I try to retrieve multiple count in a single query on a single table.</p>
  
  <pre><code>return $this-&gt;getEntityManager()-&gt;createQuery(
          'SELECT COUNT(c1) AS enabled, COUNT(c2) AS disabled, COUNT(c3) AS locked
          FROM AcmeUserBundle:User c1, AcmeUserBundle:User c2, AcmeUserBundle:User c3
          WHERE c1.enabled = 1
          AND c2.enabled = 0
          AND c3.locked = 1'
      )-&gt;getSingleResult();
  </code></pre>
  
  <p>With this action I get this result:</p>
  
  <pre><code>array [
    "enabled" =&gt; "4"
    "disabled" =&gt; "4"
    "locked" =&gt; "4"
  ]
  </code></pre>
  
  <p>The result that I expected would be this:</p>
  
  <pre><code>array [
    "enabled" =&gt; "2"
    "disabled" =&gt; "1"
    "locked" =&gt; "1"
  ]
  </code></pre>
  
  <p>I get that a simple count of the entire table.</p>
  
  <p>Some body knows how i can make it?</p>