Views of threads started by userid?

[beano33]

I assume this might be done with a query. What I'm looking to get is the number of views for threads started by a specific userid. In this case it's an RSS bot that I use to provide feeds across multiple forums. Can this be done? Thanks!

[Jake Bunce]

This query should do it:

SELECT SUM(views)
FROM thread
WHERE postuserid = [color=red]X[/color]

Where X is the userid your RSS poster.

[beano33]

Thanks! Where do I find the ballot bot to vote you most helpful?