React engineer query Hanoi

0

Please login or register to vote for this query.

(click on this box to dismiss)

Philosophy Meta

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

SELECT DISTINCT TOP 1000
    Users.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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results