Find all badges issued for users in Moodle25

badges-issued.sql

select mb.name as badgename,
mu.username,
to_timestamp(mbi.dateissued) as dateissued
from mdl_badge_issued mbi
join mdl_badge mb on mbi.badgeid=mb.id
join mdl_user mu on mu.id=mbi.userid
order by to_timestamp(mbi.dateissued);