Search for questions by query and user location

0

Please login or register to vote for this query.

(click on this box to dismiss)

Web Applications Meta

Q&A about the site for power users of web applications

SELECT     q.Id AS [Post Link],
           q.Score,
           q.Tags,
           q.Creationdate
FROM       Posts q
INNER JOIN Users u
ON         q.OwnerUserId = u.Id
WHERE      LOWER(u.Location) LIKE N'%' + LOWER(##Location:string##) + '%'
AND        LOWER(q.Tags) LIKE N'%' + LOWER(##SearchTerminTags:string##) + '%' 
AND        q.PostTypeId = 1 -- Questions

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results