title: MySQL Query with count and group by
body: <p>I've got table a table with different records for publishers, each record have a date in a column of type timestamp.</p>
  
  <pre><code>id | id_publisher | date
  1           1      11/2012 03:09:40 p.m.
  2           1      12/2012 03:09:40 p.m.
  3           2      01/2013 03:09:40 p.m.
  4           3      01/2013 03:09:40 p.m.
  5           4      11/2012 03:09:40 p.m.
  6           4      02/2013 03:09:40 p.m.
  7           4      02/2012 03:09:40 p.m.
  </code></pre>
  
  <p>I need a count for number of records published by each  publisher for each month. For example</p>
  
  <pre><code>Month    |  id_publisher         | num
  11/2012  |          1            |   1
  11/2012  |          2            |   0
  11/2012  |          3            |   0
  11/2012  |          4            |   1
  .....
  02/2013  |          4            |   2
  </code></pre>
  
  <p>I tried with 
  <code>select count(id) from raw_occurrence_record group by month(date), id_publisher;</code></p>
  
  <p>but, it did not work.</p>