azfdethfhyjh

0

Please login or register to vote for this query.

(click on this box to dismiss)

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT TOP 50000
    p.Id,
    p.Title,
    p.ViewCount,
    p.FavoriteCount,
    p.Score,
    p.Body,
    p.Tags,
    p.CreationDate,
    p.AnswerCount
FROM 
    Posts p
WHERE 
    p.PostTypeId = 1 -- 1 pour les questions
    AND p.ViewCount > 0
    AND p.Score > 0
    AND p.AnswerCount > 0
    AND p.CreationDate >= '2011-01-01' -- Date de création après le 1er janvier 2020
    AND p.Tags LIKE '%<python>%' -- Un des tags doit contenir "python"
ORDER BY 
    p.ViewCount DESC

Enter Parameters

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