Symfony doctrine multiple count
<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>