here tag query


Please login or register to vote for this query.

(click on this box to dismiss)


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 =
inner join tags t on pt.tagid =
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

Switch sites:
loading Hold tight while we fetch your results