Q&A about the site for Joomla! administrators, users, developers and designers
select top 50 * from Posts p where PostTypeId = 1 and CAST(ClosedDate AS DATE) >= '2021-09-01' and CAST(ClosedDate AS DATE) < '2021-10-01' and EXISTS ( select 1 from Badges b where p.OwnerUserId = b.UserId ) order by score desc