Number of Posts in 2017

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

DECLARE @delimiter nvarchar(255) = '>';

SELECT Id, CreationDate, Tags
FROM Posts
--CROSS APPLY STRING_SPLIT(Tags, @delimiter) AS SepTags
WHERE YEAR(CreationDate) = 2017
ORDER BY Id


SELECT *
FROM Tags

Enter Parameters

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