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 Posts.Id > 8339076
AND ViewCount > 10
AND Score > 5
AND AnswerCount > 0
AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 5
ORDER BY Posts.Id

fork query

edited mar 23

created mar 23 jon.doe41507