/*SELECT U.DisplayName, B.Name FROM Users AS U JOIN Badge...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Monero Meta

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

/*SELECT U.DisplayName, B.Name
FROM Users AS U JOIN Badges as B ON B.UserId = U.Id
WHERE U.Reputation > 1000;*/

/*SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000
   ) AS DisplayName,
   B.Name
FROM Badges AS B
WHERE EXISTS DisplayName
ORDER BY B.Date*/

SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000) AS DisplayName,
   B.Name
FROM Badges AS B
WHERE B.UserId IN (SELECT U.Id
                   FROM Users U
                   WHERE U.reputation > 1000)
ORDER BY B.Date

/*SELECT
  U.Id,
  (SELECT B.Names
   FROM Badges AS B
   WHERE B.UserId = U.Id AND U.Reputation > 1000) AS names
FROM Users AS U*/

/*SELECT
(SELECT U.DisplayName
 FROM Users AS U
 WHERE U.Id = B.UserId AND U.Reputation > 1000)
 FROM Badges as B
 WHERE*/

  
/*SELECT U.DisplayName, U.test
FROM USers U
WHERE U.Reputation > 1000 AND U.test = (SELECT B.NAME
                                      FROM Badges AS B
                                      WHERE B.UserId = U.Id);*/
/*SELECT
  (SELECT U.DisplayName
   FROM Users AS U
   WHERE U.Id = B.UserId AND U.Reputation > 1000
   ) AS DisplayName
FROM Badges AS B
WHERE EXISTS DisplayName
ORDER BY B.Date*/

Enter Parameters

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