Q&A for Joomla! administrators, users, developers and designers
SELECT b.UserId, b.Date DateReceived, u.DisplayName FROM Users u, Badges b WHERE b.name='Gold' and b.class=3 and u.Id=b.UserId GROUP BY b.Date, b.UserId, u.DisplayName