Low quality post

0

Please login or register to vote for this query.

(click on this box to dismiss)

Hinduism Meta

Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism

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  -- Joining Badges table based on 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 = 1  -- Bronze badge (Class 1 represents bronze badges)
    AND p.CreationDate BETWEEN '2018-01-01' AND '2019-12-31'  -- Posts between 2018 and 2019
ORDER BY 
    p.CreationDate DESC;

Enter Parameters

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