Q&A for professional and enthusiast programmers
Select Posts.Id AS [Post Link], Body From PendingFlags INNER JOIN Posts on Posts.Id = PendingFlags.PostId Where Posts.ClosedDate IS NULL AND Posts.Tags LIKE '%android%' ---AND PendingFlags.CloseAsOffTopicReasonTypeId = 8 GROUP BY Posts.Id, Posts.Body HAVING Count(*) > 3 ORDER BY Count(*)