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 = '16') as tagged FROM modx_fts_content AS s HAVING (tagged = 1) ORDER BY s.content_date DESC;
Join our newsletter and get the latest news