Mysql query results from last 604800 seconds
<p>I'm trying to get my query results from last week.
The database uses UNIX Timestamp, so it's in seconds.</p>

<p>I've come up with this, but that doesn't seem to work. It gives me the all-time results. I just needs the results from the last 604.800 seconds.</p>

<pre><code>    SELECT `mod_id`, COUNT(`mod_id`) m from `history_spottings` WHERE (`created` - 604800)
GROUP BY `mod_id`
ORDER BY m DESC;
</code></pre>