Open Community Wiki Questions with the most Answers and Favorites


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT P.Title, '' + CAST(P.Id AS nvarchar)
FROM Posts P, PostTypes Pt, PostHistory Ph, PostHistoryTypes Pht
Pt.Id = P.PostTypeId
AND (SELECT Count(P2.Id) FROM Posts P2 WHERE P.Id = P2.ParentId AND P2.PostTypeId=2) > 50
AND (SELECT Count(V.Id) FROM Votes V WHERE P.Id = V.PostId AND V.VoteTypeId = 5) > 10
AND (SELECT Count(C.Id) FROM Comments C WHERE P.Id = C.PostId) > 20
AND P.Id = Ph.PostId
AND Pht.Id = Ph.PostHistoryTypeId
AND Pt.Id = 1
AND Pht.Id = 16

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results