SELECT

DISTINCT ON ("PLT_CN")

*

,

    (

        "STDAGE"::integer>80

        AND ("TRTCD1"='0' OR "TRTCD1" IS NULL)

        AND (("DSTRBCD1"<>'30' AND "DSTRBCD1"<>'31' AND "DSTRBCD1"<>'32' AND "DSTRBCD1"<>'80') OR "DSTRBCD1" IS NULL)

        AND ("STUMP_CD_PNWRS"='N' OR "STUMP_CD_PNWRS" IS NULL)

        AND "HARVEST_TYPE1_SRS" IS NULL

        AND "PRESNFCD" IS NULL

        AND ("STDORGCD"='0' OR "STDORGCD" IS NULL)

    )

    OR "STND_COND_CD_PNWRS"='7'

    AS oldgrowth

FROM "COND"

;

ALTER TABLE :table ADD PRIMARY KEY ("PLT_CN");