SELECT s.content_id,s.content_title,s.content_date FROM modx_fts_content AS s WHERE s.content_type = 4 ORDER BY s.content_date DESC;
Join our newsletter and get the latest news