Search questions that matches specific criteria

0

Please login or register to vote for this query.

(click on this box to dismiss)

Find questions in SO that matches certain criteria - the idea is to find questions, read them at this side of the spectrum.

Joomla

Q&A for Joomla! administrators, users, developers and designers

-- Search questions that matches specific criteria
/*
  PostTypes:
  1 - Q
  2 - A
*/

SELECT TOP 10 P.Title, P.Body, P.Score, P.OwnerDisplayName, P.Tags
FROM Posts AS P INNER JOIN PostTags PT 
ON P.Id = PT.PostId
WHERE PT.TagId IN (SELECT T.Id FROM Tags T WHERE T.TagName = 'c#')
AND CAST(P.CreationDate AS DATE) BETWEEN '2019-11-07 00:00:00' 
AND CAST(GETDATE() AS DATE)
AND P.PostTypeId = 1
ORDER BY P.CreationDate DESC;

Enter Parameters

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