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)

Artificial Intelligence

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

SELECT 
    U.Id AS UserId,
    U.DisplayName AS Username,
    P.Id AS PostId,
    P.Title AS PostTitle,
    P.Body AS PostBody,
    B.Name AS BadgeName,
    U.Reputation AS ReputationScore
FROM 
    Users AS U
JOIN 
    Badges AS B ON U.Id = B.UserId
JOIN 
    Posts AS P ON U.Id = P.OwnerUserId
WHERE 
    B.Name IN ('illuminator', 'great answer', 'populist', 'reversal', 'unsung hero') -- Filter for specific badges
    AND U.Reputation >= 20000 -- Filter for reputation score above 20000
ORDER BY 
    U.Id, P.Id;

Enter Parameters

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