spGetDataSourcesForLists

        CREATE Procedure [dbo].[spGetDataSourcesForLists]
        AS
        SELECT DISTINCT
            ds.DataSourceID, 
            ds.[Name], 
            ds.TypeNamespace, 
            ds.TypeName, 
            ds.IsEmailListSource, 
            ds.BackOfficeSystemId, 
            ds.Available,
            ds.ImportListID
            FROM DataSources ds
            INNER JOIN dbo.DATASOURCEPRODUCT dp ON ds.DataSourceID = dp.DATASOURCEID
            INNER JOIN dbo.INSTALLEDPRODUCTLIST ipl ON dp.PRODUCTID = ipl.ID
            WHERE ds.IsEmailListSource=1 AND ds.Available = 1 AND ds.Deleted = 0 and ds.DataSourceID <> 320
            ORDER BY ds.BackOfficeSystemId, ds.[Name]