Posts and tags since date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

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

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 >= 2
and CreationDate >= '2018-01-01' and CreationDate < '2019-01-01'
and lower(Tags) like lower('%##TagName1##%')
) AS MyDerivedTable
WHERE MyDerivedTable.RowNum BETWEEN 1 and 25000

Enter Parameters

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