Q&A about the site for Joomla! administrators, users, developers and designers
select top 50 * from Posts 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