0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for computer graphics researchers and programmers

SELECT 
distinct Users.Id [User Link], users.DisplayName, Users.Location, Tags.tagname
FROM Users
   INNER JOIN Posts ON  Posts.OwnerUserId = Users.Id
   INNER JOIN PostTags ON PostTags.TagId = Posts.ParentId
   INNER JOIN Tags ON PostTags.TagId = Tags.id
WHERE Tags.tagname like '%php%' AND LOWER(Users.Location) = 'slovakia'

fork query

edited jul 19

created sep 16 13 anonymous