0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT DISTINCT
    p.Id AS [Post Link], 
    p.CreationDate, 
    p.Score, 
    p.ViewCount, 
    p.Tags, 
    p.Title,
    u.Id AS UserId,
    b.Class AS BadgeClass
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 p.CreationDate BETWEEN '2018-01-01' AND '2019-12-31'  -- Posts between 2018 and 2019
ORDER BY 
    p.CreationDate DESC;

fork query

created jun 13 anonymous