0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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