title: SUM of COUNTs in the same table
body: <p>I'm doing many counts that I want to show in a table. And I want in the same table to show the sum of all counts. </p>
  
  <p>Here's what I got (simplified - I got 6 Counts):</p>
  
  <blockquote>
    <p>SELECT * FROM (SELECT COUNT(<em>) AS NB_book<br/>
     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;item as a1, metadatavalue as m1, metadatavalue as m12, <br/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE m1.field_id = 64 (because I need that field to exist)<br/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND m2.field_id = 66<br/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;And m2. = book<br/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND a1.in_archive  = TRUE )<br/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(SELECT COUNT(</em>) AS NB_toys<br/>
                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;metadatavalue as m1, metadatavalue as m12, <br/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE m1.field_id = 64 (because I need that field to exist)<br/>
                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AND m2.field_id = 66<br/>
                   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;And m2. = toys<br/>
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND a1.in_archive  = TRUE)<br/>
    )</p>
  </blockquote>
  
  <p>Now, I want the display to be like</p>
  
  <p>-------------table ----------<br/>
  |NB_book  | NB_Toys   | total_object |<br/>
  -----------------------------<br/>
  | &nbsp;&nbsp;&nbsp;12&nbsp; &nbsp; &nbsp;&nbsp; | &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|</p>