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'
order by score desc
select top 100 *
where UserId = 637278