Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
SELECT a.Id AS [Post Link], a.Score, au.Id AS [User Link] FROM Posts p Join Posts a ON p.Id = a.ParentId Join Users au ON a.OwnerUSerId = au.Id WHERE p.PostTypeId = 1 AND p.tags like ('%React%') and a.Score > 10 and au.location like ('%San Francisco%') ORDER BY a.Score DESC