Hi,

Most the time, I canot display user agent statistics.

Please, let me know if you need more informations.

MySQL error!

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay(Errno=1104)

Your query: Results::Query()

SELECT agnt_signature, agnt_type, COUNT( hit_ID ) AS hit_count

FROM evo_useragents LEFT JOIN evo_hitlog ON agnt_ID = hit_agnt_ID
WHERE agnt_type IN ('browser','robot','rss','unknown')

GROUP BY agnt_ID
ORDER BY hit_count DESC
LIMIT 0, 20