0

Please login or register to vote for this query.

(click on this box to dismiss)

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

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 > 10
    AND p.FavoriteCount > 3
    AND p.Score > 5
    AND p.AnswerCount > 0
    AND (LEN(p.Tags) - LEN(REPLACE(p.Tags, '<', ''))) / 2 >= 5 -- Au moins 5 tags
    AND p.CreationDate >= '2023-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

fork query

created jun 18 anonymous