Q&A about the site for Joomla! administrators, users, developers and designers
SELECT Id, CreationDate, Score, ViewCount, Body, Title, Tags FROM Posts WHERE Score >= 1 AND Tags LIKE '%JCA%';