0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Ubuntu users and developers

SELECT 
    p.Id AS [Post Link], 
    p.CreationDate, 
    p.Score, 
    p.ViewCount, 
    p.Tags, 
    p.Title
FROM 
    Posts p
JOIN 
    Users u ON p.OwnerUserId = u.Id
JOIN 
    Badges b ON u.Id = b.UserId
WHERE 
    p.PostTypeId = 1  -- Questions only
    AND p.AnswerCount = 0  -- No answers
    AND p.Score < 0  -- Negative score
    AND p.ClosedDate IS NULL  -- Exclude closed questions
    AND u.Reputation >= 1 AND u.Reputation <= 1000  -- Reputation between 1 and 1000
    AND b.Class = 3  -- Bronze badge (Class 3 represents bronze badges)
    AND (
        (
            YEAR(p.CreationDate) = 2018 AND MONTH(p.CreationDate) >= 1
        ) OR (
            YEAR(p.CreationDate) > 2018 AND YEAR(p.CreationDate) < 2020
        ) OR (
            YEAR(p.CreationDate) = 2019 AND MONTH(p.CreationDate) <= 12
        )
    )
ORDER BY 
    p.CreationDate DESC;

fork query

created jun 13 anonymous