0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gardeners and landscapers

SELECT TOP 20
  ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
  u.Id AS [User Link], 
  Reputation,
  t.TagName
FROM
  Users AS u 

JOIN 
  Posts AS p ON u.Id = p.OwnerUserId

JOIN (
  SELECT * 
  FROM PostTags AS pt
  JOIN Tags AS t ON pt.TagId = t.Id
) 
AS t ON p.ParentId = t.PostId

JOIN (
  SELECT PostId, Name, CreationDate
  FROM Votes AS v 
  JOIN VoteTypes AS vt ON v.VoteTypeId = vt.Id
) AS v ON p.Id = v.PostId
  
WHERE
  LOWER(Location) LIKE '%indonesia%'
  AND p.PostTypeId = 2
  AND TagName IN('vue.js', 'vuejs2', 'vuejs3')
  AND v.Name = 'AcceptedByOriginator'
 -- AND u.Id = 3634538
    
--ORDER BY
--  Reputation DESC;

fork query

edited dec 29 20

created dec 29 20 anonymous