Top users in a country

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sums up posts scores and user reputaion.

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

-- Top users in a country
-- Sums up posts scores and user reputaion.

SELECT US.ID as [User Link], US.LOCATION, US.REPUTATION, US.WebsiteUrl,
round(cast(Reputation as float)/DATEDIFF(dd,CreationDate,LastAccessDate),1) RepPerDay
FROM USERS AS US
WHERE (US.ID = 1823841 OR US.WebsiteUrl like '%mindfiresolutions%')
AND DATEDIFF(dd,CreationDate,LastAccessDate) > 30
order by RepPerDay desc;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results