A bit of java or cgi help needed

[Battery Powered]

I run an apache server and have some log files which i want to get some statistics from, for example one log file is for peoples browsers which looks like;

Mozilla/5.0 (compatible; Konqueror/3.0.0-10; Linux)
Mozilla/5.0 (compatible; Konqueror/3.0.0-10; Linux)
Mozilla/5.0 (compatible; Konqueror/3.0.0-10; Linux)
Mozilla/5.0 (compatible; Konqueror/3.0.0-10; Linux)

another log file is for refer information which looks like;

http://site.net/Top100/list.php?status=NOV -> /gifs/logo.jpg
http://site.com/top50/list.php?status=NOK -> /gifs/logo.jpg
http://site.com/top50/list.php?status=NOK -> /gifs/logo.jpg

So i would like to get a script to get some statistics from these log files, like which is the most common, overall counts etc..

Could anyone help me with this one, or point to any scripts you've tried or use,
thx everyone,
James