I have a site that provides free polls for webmasters. All polls can have multiple questions. In my terms of service it says: "Accounts that are inactive for a period of 60 days are subject to removal."

I need your help creating a query that will find all pollid that are inactive (=no votes) for a period of 60 days or more.

I have a table "Votes" that stores the votes of all the polls. This is an example of how the table looks like:

+-----+-------+------------+--------+--------+--------+--------+-------+--------------+
| key | pollid | question | vote1 | vote2 | vote3 | vote4 | vote5 | date |
+-----+-------+------------+--------+--------+--------+--------+-------+--------------+
| 1 | 1001 | 1 | 10 | 20 | 0 | 40 | 50 | 20030801 |
+-----+-------+------------+--------+--------+--------+--------+-------+--------------+
| 2 | 1001 | 2 | 50 | 10 | 30 | 0 | 50 | 20020101 |
+-----+-------+------------+--------+--------+--------+--------+-------+--------------+
| 3 | 1002 | 1 | 10 | 20 | 10 | 10 | 50 | 20020101 |
+-----+-------+------------+--------+--------+--------+--------+-------+--------------+
| 4 | 1002 | 2 | 40 | 0 | 30 | 40 | 50 | 20020101 |
+-----+-------+------------+--------+--------+--------+--------+-------+--------------+
| 5 | 1002 | 3 | 10 | 60 | 20 | 20 | 50 | 20020101 |
+-----+-------+------------+--------+--------+--------+--------+-------+--------------+
| 6 | 1003 | 1 | 20 | 20 | 30 | 40 | 50 | 20030801 |
+-----+-------+------------+--------+--------+--------+--------+-------+--------------+

key = INT(10) PRIMARY_KEY AUTO_INCREMENT NOT_NULL
pollid = VARCHAR(4) NOT_NULL
rank = VARCHAR(2) NOT_NULL
vote1 = INT(5) NOT_NULL
vote2 = INT(5) NOT_NULL
vote3 = INT(5) NOT_NULL
vote4 = INT(5) NOT_NULL
vote5 = INT(5) NOT_NULL
date = TIMESTAMP(8)

In the example above we see the following:

- there are 3 polls in the database with ids 1001,1002 and 1003.

- poll 1001 is a poll with 2 questions, poll 1002 is a poll with 3 questions,
and poll 1003 is a poll with 1 questions.

- (the field date is the date of the last vote for the question)
the last vote for question 1 of poll 1001 was a couple of days ago (20030801=Aug 1, 2003);
the last vote for question 2 of poll 1001 was in 2002!

What I want to do is create a query that will select all ids for which ALL question hasn't received a vote for 60 days.

Poll 1001 does not fit the condition above because although question 2 hasn't received a vote for over a year, question 1 has received a vote a few days ago!

Poll 1002 does fit the condition above. All 3 question hasn't received votes for over 60 days!

Poll 1003 does not fit the condition above because question 1 has received a vote a couple of days ago!

Who can help me?