0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT DISTINCT TOP 1000Users.Id AS [User Link],
    Users.WebsiteUrl,
    Users.EmailHash,
    Users.Reputation
FROM
    Users
INNER JOIN Comments ON Comments.UserId=Users.ID
INNER JOIN Posts ON Posts.OwnerUserId=Users.ID
WHERE
    LOWER(Users.Location) LIKE '%hanoi%'
    AND ( (LOWER(Comments.Text) LIKE '%react%') OR (LOWER(Posts.Title) LIKE '%react%'))
ORDER BY
    Users.Reputation DESC

fork query

created jan 18 anonymous