I have the following SQL statement that I'd like to add to. It's used to create a report
that's emailed to me showing hits to our site that didn't provide a referrer. However, I
only want to report on multiple hits from the same IP address - not just a single hit by
How can I add a condition to only show hits by someone who's hit the site 2 or more times
with the same IP? I tried GROUP BY but that didn't return all the hits - one one per IP.
WHERE (`time_stamp` BETWEEN date_add( CURDATE(), INTERVAL -1 DAY ) AND CURDATE() -
INTERVAL 1 SECOND)
AND TRIM(`referrer`) LIKE ''
ORDER BY INET_ATON(`ip`), `time_stamp`
I hope I'm explaining this correctly.
Superior Shelving Systems::::....
The (Storage|Office|Home|Warehouse) Shelving Specialists