0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT u.Id AS [User Link],
	                            CONCAT('https://unix.stackexchange.com//users/', u.Id) AS [Profile Link],
	                            u.DisplayName,
	                            u.Location,
	                            u.WebsiteUrl,
	                            u.AboutMe,
	                            u.Views,
	                            u.UpVotes,
	                            u.DownVotes
	             FROM Users u
	             
	             INNER JOIN Posts AS a
	               ON u.Id = a.OwnerUserId
	             INNER JOIN Posts AS q
	               ON q.Id = a.ParentId
	             INNER JOIN PostTags AS pt
	               ON q.Id = pt.PostId
	             INNER JOIN Tags AS t
	               ON t.Id = pt.TagId
	             WHERE LOWER(t.TagName) = (SELECT LOWER(##Tag:string##)) 
	              AND 
                  LOWER(u.Location) LIKE (SELECT LOWER('%##Location##%'))

view current version

edited dec 12

created dec 12 anonymous