0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam

SELECT TOP 500000 Name, Title, Body, Tags, Posts.Id, Score, ViewCount, FavoriteCount, AnswerCount
FROM Posts
JOIN PostTypes on Posts.PostTypeId = PostTypes.Id
WHERE PostTypeId = 1
AND ViewCount > 10
AND Score > 5
AND AnswerCount > 0
AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 5
ORDER BY Posts.Id

view current version

edited mar 23

created mar 23 jon.doe41507