SELECT U.Id AS UserId, U.DisplayName AS Username, P.Id AS...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
    U.Id AS UserId,
    U.DisplayName AS Username,
    P.Id AS PostId,
    P.Title AS PostTitle,
    P.Body AS PostBody,
    P.Tags AS PostTags
FROM
    Users AS U
JOIN
    Badges AS B ON U.Id = B.UserId
JOIN
    Posts AS P ON U.Id = P.OwnerUserId
WHERE
    B.Class = 1 -- Class 1 represents gold badges
    AND U.Reputation > 20000 -- Filter for users with a reputation score above 20,000
    AND B.Date = '2018-01-01' -- Filter for badges awarded on or after January 1, 2018
    --AND B.Date < '2020-01-01' -- Filter for badges awarded before January 1, 2020
    AND P.Score > 10 -- Filter for posts with a score higher than 10
    AND P.PostTypeId = 1 -- Filter for questions (change to 2 for answers if needed)
ORDER BY
    U.Id, P.Id;

Enter Parameters

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