0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited aug 24 19 rene

created jun 11 15 jon.doe16279