/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP (1000) [ID]
      ,[Name]
      ,[CultureID]
      ,[ProductGroupID]
      ,[IsMultiple]
      ,[SpecificationKeyName]
      ,bs.[ProductGroupMapName]
      ,[SummaryIndex]
      ,[FilterIndex]
      ,ks.[LastSeenDate]
  FROM [Presentation].[Filter] as bs
  left join [Kieskeurig].[Specification] as ks on ks.[KeyName] = bs.[SpecificationKeyName] and ks.[ProductGroupMapName] = bs.[ProductGroupMapName]
  where bs.productgroupmapname = 'tv_led'