0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Tridion developers and administrators

SELECT TOP 500000 Title, Body, Tags, Id, Score, ViewCount, FavoriteCount, AnswerCount, CreationDate
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 CreationDate > '2012-01-01 00:00:00'

fork query

edited may 20

created may 20 anonymous