Facility flags

SELECT *
FROM (
    SELECT [Site Inspire ID] as siteInspireId,
    [Facility Inspire Id] as facilityInspireId,
    *
    FROM [IED].[DB_VERSION].[facility_flags]
) as flags
WHERE facilityInspireId IS NOT NULL