title: Query and get three expected results
body: <pre><code>SELECT
  (
      `members`.`id`
      SELECT COUNT(`members`.`id`) FROM `members` WHERE `gender` = 0 AS `Unknown`
      SELECT COUNT(`members`.`id`) FROM `members` WHERE `gender` = 1 AS `Female`
      SELECT COUNT(`members`.`id`) FROM `members` WHERE `gender` = 2 AS `Male`
  ) FROM `members` INNER JOIN `mapMember`
  ON `mapMember`.`id` = `members`.`id`
  WHERE `mapMember`.`mapper_id` = 3
  </code></pre>
  
  <p>My expected result:</p>
  
  <pre><code>Unknown     Female      Male
  0           1           3
  </code></pre>
  
  <p>However I get SYNTAX error. Cant' figure out what's wrong.</p>
  
  <p>I also tried:</p>
  
  <pre><code>SELECT COUNT(`members`.id) AS `members`, `gender`  
              FROM `members` INNER JOIN `mapMember`
               ON `mapMember`.`id` = `members`.`id`   
              WHERE `mapMember`.`mapper_id` = 3 GROUP BY `gender` ORDER BY `gender` ASC
  </code></pre>
  
  <p>Which gives me almost the result I want to have, the only difference is If the there are no members with the given gender, there won't be a 0 result back. (no row that is) I always expect three rows back.</p>