Q&A for designers and users of artificial or invented languages, consciously developed instead of having developed naturally
DECLARE @Question INT = (SELECT Id FROM PostTypes WHERE Name = 'Question'); DECLARE @Answer INT = (SELECT Id FROM PostTypes WHERE Name = 'Answer'); SELECT DISTINCT /* Uncomment below if you want to limit the results */ TOP 1000 Posts.Id AS [Post Link] , PostTypes.Name AS [Post Type] , Posts.Score , Posts.CreationDate , Users.Id AS [User Link] , Users.Reputation , Phrase.Value , CHARINDEX( Posts.Title, Phrase.Value COLLATE Latin1_General_CI_AI ) FROM Posts INNER JOIN PostTypes on PostTypes.Id = Posts.PostTypeId CROSS APPLY STRING_SPLIT('please|review|improve|better|how to|how can i|how do i','|') Phrase LEFT OUTER JOIN Users ON Posts.OwnerUserId = Users.Id WHERE /* Filter out non-question posts */ Posts.PostTypeId = @Question /* Generic title */ /*AND CHARINDEX( Posts.Title, Phrase.Value COLLATE Latin1_General_CI_AI ) > 0 */ /* Post not closed yet */ AND Posts.ClosedDate IS NULL /* Question doesn't have positive score */ /* AND Posts.Score <= 0 */ /* User has low reputation - Un-comment to limit query further */ AND (Users.Id is NULL OR Users.Reputation <= 500) ORDER BY /* Lowest scores first - Change to DESC if you want Highest first */ Posts.Score ASC /* Newest first - Change to ASC if you want oldest first */ , Posts.CreationDate DESC