title: SQL request for query in every week/month even if no record exist
body: <p>I  am using MySQL and I have a hard time to get the count per month including months with no records.</p>
  
  <p>This is my table "Plays":</p>
  
  <pre>
  idplay    idplayer    day
  ------    --------    ---
  1             26        17-11-2015
  2             37        22-12-2015
  3             65        24-04-2016
  4             12        16-05-2016
  5             37        17-05-2016
  6             37        30-05-2016
  7             14        30-06-2016
  </pre>
  
  <p>I want to get the number of times the player "37" has played in every month the last 6 month and get 0 when he has not played. </p>
  
  <p>Somthing like this:</p>
  
  <pre>
  Month          Playtimes
  ----           -------
  11-2015             0
  12-2015             1
  01-2016             0
  02-2016             0
  03-2016             0
  04-2016             0
  05-2016             5
  </pre>