1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT 
    Users.Id as [User Link],
    Users.Reputation,
    Users.Location,
    Users.AboutMe
FROM Posts
INNER JOIN PostTags ON Posts.ParentId = PostTags.PostId
INNER JOIN Tags ON PostTags.TagId = Tags.id
INNER JOIN Users ON Users.Id = OwnerUserId
WHERE 
    Posts.PostTypeId = 2
    and tags.TagName like '%facebook%'
    and users.aboutme like '%Facebook%'
GROUP BY
    Users.Id, Users.Reputation, Users.Location, Users.AboutMe
ORDER BY
    users.reputation desc

fork query

edited feb 8 12

created feb 7 12 OffBySome