123

select distinct AE."Email", APT."ProductTypeId", PT."Name"
from "AgentEmails" as AE
join "Agents" A on ae."AgentId" = A."AgentId"
join "AgentProductTypes" APT on A."AgentId" = APT."AgentId"
join "ProductTypes" PT on APT."ProductTypeId" = PT."EnumId"
where APT."ProductTypeId" in (1, 4, 25)