title: Select the count of records by id in the last week
body: <p>Basically, I have a table in a MySQL database with the following rows and I want to be able to create a leader board based on how many views each user got on any of his monsters in the past week. The type is a tier going from 1 to 8 and has to be included in the query (the higher the <code>type</code> the higher the tier. Each row stores a single view.</p>
  <blockquote>
  <p>ViewId - Id of view, primary key</p>
  <p>MonsterId - Id of monster</p>
  <p>Username - Owner's name</p>
  <p>Time - PHP time() recorded</p>
  </blockquote>
  <p>This is probably going to involve the count() thingy but I'm really not sure.</p>