SELECT u.Id AS UserId, u.DisplayName AS UserName, b.Name ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Retrocomputing Meta

Q&A about the site for vintage-computer hobbyists interested in restoring, preserving, and using the classic computer and gaming systems of yesteryear

SELECT
    u.Id AS UserId,
    u.DisplayName AS UserName,
    b.Name AS BadgeName,
    b.Class AS BadgeClass
FROM
    Users u
JOIN
    Badges b ON u.Id = b.UserId
WHERE
    b.Class = 1
    AND b.Name LIKE '%gold%'

Enter Parameters

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