vwEmailTemplateDataSources

CREATE  VIEW [dbo].[vwEmailTemplateDataSources]
    AS

select 
    ds.DataSourceID,
    ds.[Name] as DataSourceName,
    ds.BackOfficeSystemId
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.IsEmailTemplateSource=1 
    AND ds.Available = 1 AND ds.Deleted = 0
    and (ImportListId is null or ImportListId=0)
union

select 
    ds.DataSourceID,
    el.[Name] as DataSourceName,
    ds.BackOfficeSystemId
    from DataSources ds left outer join EmailList el on ds.ImportListID = el.id
WHERE ds.IsEmailTemplateSource=1 
    AND ds.Available = 1 AND ds.Deleted = 0
    and ImportListId > 0