0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT u.Id AS [User Link],
	                            CONCAT('https://networkengineering.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##%'))

fork query

edited dec 11

created dec 11 anonymous