Q&A about the site for Joomla! administrators, users, developers and designers
select top 50 * from Badges as badges left join Posts as posts on badges.UserId = posts.OwnerUserId where PostTypeId = 1 and CAST(ClosedDate AS DATE) >= '2021-09-01' and CAST(ClosedDate AS DATE) < '2021-10-01' and posts.OwnerUserId IN ( select distinct UserId from Badges ) order by score desc /* select distinct UserId from Badges -- where UserId = 637278 */