qfthq

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bitcoin Meta

Q&A about the site for Bitcoin crypto-currency enthusiasts

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.CreationDate >= '2024-04-01' -- Date de création après le 1er janvier 2020
    AND p.Tags LIKE '%<python>%' -- Un des tags doit contenir "python"
    AND p.ViewCount > 10
    AND p.FavoriteCount > 10
    AND p.Score > 5
    AND p.AnswerCount > 0
    AND (LEN(p.Tags) - LEN(REPLACE(p.Tags, '<', ''))) / 2 >= 5 -- Au moins 5 tags

ORDER BY 
    p.ViewCount DESC

Enter Parameters

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