SELECT s.content_id,s.content_title,s.content_date, (SELECT COUNT(resource) FROM modx_tagger_tag_resources WHERE resource = s.content_id AND tag = 10) as sig FROM modx_fts_content AS s HAVING (sig = 1) ORDER BY s.content_date DESC;
Join our newsletter and get the latest news