SELECT count(*), host, url, id
from log
group by host, url, id
You want to include your where and order by clauses - but that should get
you the results your looking for. I think :)
Steve
On Tue, 4 Jul 2000, Eric Jain wrote:
> Any ideas how the following two statements could be combined into a
> single one?
>
> This would greatly simplify the integration of this query into an
> existing web interface...
>
> SELECT DISTINCT host, url, id
> INTO TEMP
> FROM log
> WHERE
> host IN (SELECT host FROM robots)
> AND status IN (200, 304);
>
> SELECT host, COUNT(*) AS hits
> FROM TEMP
> GROUP BY host
> ORDER BY hits DESC;
>
>
> --
> Eric Jain
>