Exclusion List Based on Doman
Wed Jun 05 2024 15:14:25 GMT+0000 (Coordinated Universal Time)
Saved by
@kathrynhefner
SELECT a.Contact_Email
FROM (
SELECT b.Contact_Email
FROM [OAG_Profile_Expansion_Master] b
WHERE 1 = 1
AND LOWER(
RIGHT (
b.Contact_Email,
LEN(b.Contact_Email) - CHARINDEX('@', b.Contact_Email)
)
) IN (
SELECT LOWER(x.Domain)
FROM ent.[Dealer Domains] x
)
) a
UNION ALL
SELECT a.Contact_Email
FROM (
SELECT b.Contact_Email
FROM [OAG_Profile_Expansion_Master] b
WHERE 1 = 1
AND LOWER(
RIGHT (
b.Contact_Email,
LEN(b.Contact_Email) - CHARINDEX('@', b.Contact_Email)
)
) IN (
SELECT LOWER(x.Domain)
FROM ent.[Cat_Agency_Domains] x
)
) a
UNION ALL
SELECT a.Contact_Email
FROM (
SELECT b.Contact_Email
FROM [OAG_Profile_Expansion_Master] b
WHERE 1 = 1
AND LOWER(
RIGHT (
b.Contact_Email,
LEN(b.Contact_Email) - CHARINDEX('@', b.Contact_Email)
)
) IN (
SELECT LOWER(x.Domain)
FROM ent.[Competitor Domains] x
)
) a
content_copyCOPY
Comments