upvoted long posts in a given tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

SELECT TOP 200
       P.CreationDate as Created,
       P.Id AS [Post Link],
       U.Id as [User Link],
       U.Reputation,
       PostTypeId,
       Score,
       LEN(Body) AS Length
   FROM Posts P
   INNER JOIN Users U ON (P.OwnerUserId = U.Id)
   INNER JOIN PostTags PT ON (PT.PostId = P.Id)
   INNER JOIN Tags T on (PT.TagID = T.ID) AND (T.TagName = '##TagName##')
     WHERE LEN(Body)>=##minlen:int?2000## 
     AND (PostTypeId=2 OR ##answersonly:int?1##=0)
     AND Score>=##minscore:int?40##
ORDER BY LEN(Body) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results