QPaysTaxes "Bad Questions" query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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
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(
          Phrase.Value
        , Posts.Title 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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results