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