My query

4

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select
'site://admin/show-user-votes/' + CAST(id AS nvarchar) +
    '|' + DisplayName [Votes],
Reputation Rep,
CreationDate Created,
case when WebsiteUrl is null or len(WebsiteUrl) = 0 then ''
else len(WebsiteUrl) end UrlLen,
Location,
-- number of real chars in AboutMe
case when AboutMe is null or len(AboutMe) = 0 then ''
else len(replace(replace(replace(AboutMe, '<p>', ''), '</p>', ''), ' ', '')) end AboutLen,
Views,
UpVotes Up,
DownVotes Down,
case when ProfileImageUrl is null or len(ProfileImageUrl) = 0 then ''
when ProfileImageUrl like '%i.stack.imgur.com%' then 'i.stack'
when ProfileImageUrl like '%www.gravatar.com%' then 'gravatar'
when ProfileImageUrl like '%.facebook.com%' then 'facebook'
else ProfileImageUrl end ImgSrc,
Age
from users
where reputation between 15 and 100
-- get users created in the last (default 2) weeks
and creationDate > dateadd(day, (-7 * ##weeks:int?2##) - datepart(weekday, getdate()), getdate())
and upvotes > (##weeks## * 5)
order by upvotes/reputation desc, reputation desc, creationdate desc;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results