select --ra.ParentResourceGuid
         --,ra.ChildResourceGuid
       bi.Name as bulletin
       ,si.Name as [update]
       ,ia.Enabled

  from ResourceAssociation ra
  join vRM_Software_Bulletin_Item bi            --Bulletins check
    on bi.Guid = ra.ParentResourceGuid

  join vRM_Software_Update_Item si              --Updatu check
    on si.Guid = ra.ChildResourceGuid

  JOIN ItemReference ir                         --need to choose correct status of update
    ON ir.ChildItemGuid = ra.ChildResourceGuid
   AND ir.Hint = 'swu'
  JOIN ItemActive ia                            --check status of update (enabled)
    ON ir.ParentItemGuid = ia.Guid  
  left join Inv_Software_Update_Category cat    --add category
    on cat._ResourceGuid = ra.ChildResourceGuid   
  join Inv_Software_Bulletin sb
    ON ra.ParentResourceGuid = sb._ResourceGuid  
 where ResourceAssociationTypeGuid = '7EEAB03A-839C-458D-9AF2-55DB6B173293' -- choose from ra only bulletins and update

   and cat.Category = '28709c41-a9d0-4118-84b6-cf324a2dee9c'
order by bulletin