0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese 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