select u.Id as [User Link], u.WebsiteUrl, u.Location from...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Freelancing Meta

Q&A about the site for self-employed and freelance workers

select 
  u.Id as [User Link],
  u.WebsiteUrl,
  u.Location
from Users as u
inner join (
  select a.OwnerUserId, sum(a.Score) as ScoreSum from Posts as a
  inner join Posts as q on q.Id = a.ParentId
  inner join PostTags as pt on pt.PostId = q.Id
  inner join Tags as t on t.Id = pt.TagId
  where t.TagName = ##Tag:string?seo##
  group by a.OwnerUserId
  order by ScoreSum desc
  offset ##Offset:int?0## rows
  fetch next ##Limit:int?100## rows only
) as s on s.OwnerUserId = u.Id
where u.WebsiteUrl is not null and len(trim(u.WebsiteUrl)) > 0;

Enter Parameters

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