0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

SELECT TOP 50000 Title, Body, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount
FROM Posts 
WHERE PostTypeId = 1 AND 
ViewCount > 100 AND 
Score > 1000 AND 
LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 2

fork query

edited jul 18

created jul 18 anonymous