Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT TOP 50 Title, Body, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount FROM Posts WHERE PostTypeId = 1 AND ViewCount > 10 /* AND FavoriteCount > 10 */ AND Score > 5 AND AnswerCount > 0 AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 5 and tags LIKE '%python%'