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, value
--FROM Posts
--CROSS APPLY STRING_SPLIT(Tags, @delimiter) AS Sep
--WHERE YEAR(CreationDate) = 2017
--ORDER BY Id


SELECT *
FROM Tags

SELECT a.Id,
        a.CreationDate,
        a.Tags,
        b.*
FROM Posts AS a
LEFT JOIN Tags AS b
ON a.Tags LIKE CONCAT('%',b.TagName,'%')
WHERE YEAR(a.CreationDate) = 2017

Enter Parameters

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