0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

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 'itext' 
AND        q.PostTypeId = 1 -- Questions

fork query

edited oct 23 19 anonymous

created sep 23 19 Glorfindel