Referral query help please

[dilbert]

I would like help writing a query.

I'd like to get a count of referrals for a time range for users.

Here is what I'd like:
Top 10 user names
Count of referrals
Date range (3/1/2006 - 5/31/2006)
Where user not Cliff (me)
Sort by count of referral desc

Thanks!

[UK Jimbo]

There are a couple of v3.5 plugins recently posted in the Plugins section that do similar stuff. Have a look at their source code or perhaps just install the plugin if it does what you're after :)