here tag query

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 distinct CreationDate, title, LastActivityDate, Tags 
from posts p
inner join posttags pt on pt.postid = p.id
inner join tags t on pt.tagid = t.id
where t.tagname in ('here-api')
AND p.closeddate NOT BETWEEN '2019-08-01 00:00:00' AND GETDATE()
ORDER BY p.lastactivitydate DESC;

Enter Parameters

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