Posts and tags since date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

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

Enter Parameters

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