Get data

0

Please login or register to vote for this query.

(click on this box to dismiss)

Latin Language

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

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