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 50k questions
SELECT TOP 50000 Title, Body, Tags, Score, AnswerCount
FROM Posts
WHERE PostTypeId = 1 -- (1 for questions)

--filter
AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 3
AND Score > 5
AND AnswerCount > 10

fork query

edited mar 11

created mar 11 anonymous