0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for 3D printing enthusiasts

DECLARE @FavouriteCount int = ##Favourited##

SELECT  TOP 100
  Count(*),
  u.ID as UserID, 
  u.displayname as Username, 
  u.reputation as Rep, 
  p.id as PostID, 
  p.score as 'Post Score', 
  p.answercount as Answers, 
  p.owneruserid as 'Owner UserID', 
  p.favoritecount as Favourited
FROM Users U
  INNER JOIN posts p
  ON u.ID = p.owneruserid 
GROUP BY u.Id, u.displayname, u.reputation, 
        p.id, p.score, p.answercount, p.owneruserid, p.favoritecount
HAVING count(*) >= @FavouriteCount
ORDER BY Favourited DESC, Rep DESC

view current version

edited aug 17 18

created aug 17 18 anonymous