Selecting a multiple min(xxx) in a date range

[matthew horrocks]

Hi,

I have the following table. How can I select the lowest `place` for each `query` for each `date` (some queries appear twice as they have a different `fullurl`).

Thanks for your help.

Matt

+-------+---------------+--------------------------------+------------+
| place | query         | fullurl                        | date       |
+-------+---------------+--------------------------------+------------+
|     2 | query 1       | http://yyy.co.uk/zzz.html      | 1288051200 |
|     2 | query 2       | http://yyy.co.uk/xxx.html      | 1288051200 |
|     1 | query 2       | http://yyy.co.uk/              | 1288051200 |
|     5 | query 3       | http://yyy.co.uk/              | 1288051200 |
|     3 | query 1       | http://yyy.co.uk/xxx.html      | 1288051200 |
|     3 | query 2       | http://yyy.co.uk/zzz.html      | 1288051200 |
|     1 | query 1       | http://yyy.co.uk/              | 1288051200 |
|     2 | query 2       | http://yyy.co.uk/xxx.html      | 1287964800 |
|     3 | query 2       | http://yyy.co.uk/zzz.html      | 1287964800 |
|     1 | query 1       | http://yyy.co.uk/              | 1287964800 |
|     2 | query 1       | http://yyy.co.uk/zzz.html      | 1287964800 |
|     3 | query 1       | http://yyy.co.uk/xxx.html      | 1287964800 |
|     5 | query 3       | http://yyy.co.uk/              | 1287964800 |
|     1 | query 2       | http://yyy.co.uk/              | 1287964800 |
|     1 | query 1       | http://yyy.co.uk/              | 1287878400 |
|     2 | query 1       | http://yyy.co.uk/zzz.html      | 1287878400 |
|     3 | query 1       | http://yyy.co.uk/xxx.html      | 1287878400 |
|     5 | query 3       | http://yyy.co.uk/              | 1287878400 |
|     1 | query 2       | http://yyy.co.uk/              | 1287878400 |
|     2 | query 2       | http://yyy.co.uk/xxx.html      | 1287878400 |
|     3 | query 2       | http://yyy.co.uk/zzz.html      | 1287878400 |