Posts and tags since date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Skeptics

Q&A for scientific skepticism

SELECT
  MyDerivedTable.id AS [Post Link], MyDerivedTable.Title, MyDerivedTable.CreationDate, MyDerivedTable.Tags 
FROM (
    SELECT id,Title,CreationDate,Tags,PostTypeId, Score,
    ROW_NUMBER() OVER (ORDER BY id) AS RowNum
    FROM Posts
    WHERE PostTypeId = 1 
and Score = 0 
and CreationDate >= '2019-1-01' and CreationDate < '2020-01-01'
and lower(Tags) like lower('%##TagName1##%')
) AS MyDerivedTable
WHERE MyDerivedTable.RowNum BETWEEN 100001 and 125000

Enter Parameters

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