Get data

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT TOP 50000 Title, Body, FORMAT(CreationDate, 'yyyy-MM-dd') 
AS CreationDate, Score, Tags FROM Posts 
WHERE ViewCount > 20 
AND Score > 20 
AND AnswerCount > 1 
AND LEN(Tags) - LEN(REPLACE(Tags, '<','')) >= 5 
AND PostTypeId = 1 -- 1 corresponds aux questions
ORDER BY Score DESC;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results