MIM metaverse SQL query - manager contributing MA

This is a sequel (no pun intended) to my old post, FIM metaverse SQL query - employeeID contributing MA.  Since 'manager' is a reference attribute, you need a slightly different query than for scalar attributes.

set transaction isolation level read uncommitted

SELECT TOP 1000

       mv.object_type

       ,mv.accountName

       ,mv.domain

       ,l.attribute_name

       ,ma_mgr.ma_name as [manager MA]

FROM [FIMSynchronizationService].[dbo].[mms_mv_link] l

join [FIMSynchronizationService].dbo.mms_metaverse mv

on l.object_id = mv.object_id

left join [FIMSynchronizationService].[dbo].[mms_lineage_cross_reference] cr_mgr

on cr_mgr.lineage_id = l.lineage_id

left join [FIMSynchronizationService].[dbo].[mms_management_agent] ma_mgr

on ma_mgr.ma_id = cr_mgr.ma_id

where object_type = 'person'

and l.attribute_name = 'manager'