SELECT v_UpdateComplianceStatus.ResourceID, v_UpdateComplianceStatus.Status, v_GS_COMPUTER_SYSTEM.Name0, v_CICategories_All.ModelName, v_CICategories_All.CategoryTypeName, v_UpdateInfo.BulletinID, v_UpdateInfo.ArticleID, v_StateNames.StateName, v_StateNames.StateID, v_StateNames.TopicType
FROM v_UpdateComplianceStatus INNER JOIN v_GS_COMPUTER_SYSTEM ON v_UpdateComplianceStatus.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceID INNER JOIN v_CICategories_All ON v_UpdateComplianceStatus.CI_ID = v_CICategories_All.CI_ID INNER JOIN v_UpdateInfo ON v_UpdateComplianceStatus.CI_ID = v_UpdateInfo.CI_ID INNER JOIN v_StateNames ON v_UpdateComplianceStatus.Status = v_StateNames.StateID
WHERE (v_CICategories_All.CategoryTypeName = N'UpdateClassification') AND (v_StateNames.TopicType = 500) AND (v_UpdateInfo.BulletinID = N'MS13-004')