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 [Voting Link],
Reputation,
CreationDate,
len(WebsiteUrl) WebSiteLength,
Location,
-- number of real chars in AboutMe
len(replace(replace(replace(AboutMe, '<p>', ''), '</p>', ''), ' ', '')) AboutMeLength,
Views,
UpVotes,
DownVotes,
case when ProfileImageUrl is null then 'none'
when ProfileImageUrl like '%i.stack.imgur.com%' then 'i.stack'
when ProfileImageUrl like '%www.gravatar.com%' then 'gravatar'
when ProfileImageUrl like '%www.facebook.com%' then 'facebook'
else ProfileImageUrl end ProfileImageSource,
Age
from users
where reputation >= 15
-- get users created in the last week
and creationDate > dateadd(day, -7 - datepart(weekday, getdate()), getdate())
and upvotes > 5
order by upvotes desc, reputation desc, creationdate desc;

Enter Parameters

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