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 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 GETDATE()
AND P.PostTypeId = 1*/
P.Id = 58750546
ORDER BY P.CreationDate DESC;

--SELECT T.* FROM Tags T WHERE T.TagName = 'c#';

Enter Parameters

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