CREATE VIEW "ProjectWithDomain" AS SELECT pd."projectId", pd."domainId", pd."txtRecord", pd.cname, pd."createdAt", COALESCE(pd."txtRecord" = d."txtRecord", false) AS verified, p."userId" FROM "ProjectDomain" pd LEFT JOIN "Domain" d ON pd."domainId" = d.id LEFT JOIN "Project" p ON pd."projectId" = p.id;
SELECT pd."projectId", pd."domainId", pd."txtRecord", pd.cname, pd."createdAt", COALESCE(pd."txtRecord" = d."txtRecord", false) AS verified, p."userId" FROM "ProjectDomain" pd LEFT JOIN "Domain" d ON pd."domainId" = d.id LEFT JOIN "Project" p ON pd."projectId" = p.id WHERE p."isDeleted" <> TRUE