aaa

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

select top 1000 
 Users.Id, Users.AccountId, Users.DisplayName, Users.UpVotes,
 count(Badges.Name) as Badges_Count
 
from Users
left join Badges
 on Users.Id = Badges.Id
 
where Users.LastAccessDate > '2020-01-01' and
Users.UpVotes > 0

group by Users.Id, Users.AccountId, Users.DisplayName, 
Users.UpVotes, Badges.Id, Badges.Name

order by Users.UpVotes desc;

Enter Parameters

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