SELECT Users.DisplayName, Users.Location, Badges.Name, B...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

--SELECT * FROM Badges 
--WHERE Name = 'Enlightened' AND (date >'2015-12-31 00:00:00' AND date < '2017-01-01 00:00:00');

--select Date from Badges;
SELECT Users.DisplayName, Users.Location, Badges.Name, Badges.Date
FROM Users
INNER JOIN Badges ON Users.Id = Badges.Id
WHERE Users.Location LIKE '%South Africa' --AND Badges.Name = 'Enlightened'
--(Badges.date >'2015-12-31 00:00:00' AND Badges.date < '2017-01-01 00:00:00')
--AND Users.Location LIKE '%South Africa' AND Badges.Name = 'Enlightened'
ORDER BY Users.Reputation DESC;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results