Posts and tags since date

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

select top(20000)
  id AS [Post Link], Title, CreationDate, Tags 
from Posts
where PostTypeId = 1 
and Score = 0
and CreationDate >= '2019-1-01' and CreationDate < '2019-10-01'
and lower(Tags) like lower('%##TagName1##%')

Enter Parameters

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