Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
from badges as aa
right join ( select count ( b.id) as total,a.id, displayname, userid,
ORDER BY count ( b.id) desc
from users a
join badges b
where location='South Africa'
group by a.id, displayname,userid )as bb
and year (aa.date)='2016'