toop 50000 questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Earth Science

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT TOP 50000 
    Title, 
    Body, 
    Tags, 
    Id, 
    Score, 
    ViewCount, 
    AnswerCount,
    CreationDate
FROM Posts
WHERE PostTypeId = 1 
  AND ViewCount IS NOT NULL
  AND LEN(Tags) - LEN(REPLACE(Tags, '<', '')) >= 2
  AND CreationDate >= '2023-01-01'  -- Filtrer les questions récentes
ORDER BY ViewCount DESC, Score DESC

Enter Parameters

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