I changed it around a bit to count distict requests and dates and
group by ip. This did the trick!
On 6/8/07, Ally Messi <[EMAIL PROTECTED]> wrote:
Can someone please help me with the following:
code so far
SELECT DISTINCT ip, COUNT(DISTINCT
round_to_nearest_five_minutes(date)) as url_hit_cou
Can someone please help me with the following:
code so far
SELECT DISTINCT ip, COUNT(DISTINCT
round_to_nearest_five_minutes(date)) as url_hit_count, request from
logs_empty GROUP BY substring_index(request, '/', 3) ;
I would like to add on to the the code an additional column that adds
up the
