Q&A for professional and enthusiast programmers
SELECT P.Title, 'http://stackoverflow.com/questions/' + CAST(P.Id AS nvarchar) FROM Posts P WHERE (SELECT Count(P2.Id) FROM Posts P2, PostTypes Pt WHERE P.Id = P2.ParentId AND Pt.Id = P2.PostTypeId AND Pt.Id=2) > 10 AND (SELECT Count(V.Id) FROM Votes V, VoteTypes Vt WHERE P.Id = V.PostId AND Vt.Id = V.VoteTypeId AND Vt.Id = 5) > 10 AND (SELECT Count(C.Id) FROM Comments C WHERE P.Id = C.PostId) > 10 AND P.ClosedDate IS NULL AND P.Title IS NOT NULL AND P.CommunityOwnedDate IS NOT NULL AND P.OwnerUserId = 1