         NULLIF(TRIM(o.Significance_Representativeness), 0)        AS Significance_Representativeness,
         NULLIF(TRIM(o.SizeMass), '')                              AS SizeMass,
         NULLIF(TRIM(o.StatementOfSignificance), '')               AS StatementOfSignificance,
-        NULLIF(TRIM(o.TertiaryClass), '')                         AS TertiaryClass,
+        IF(o.ItemType = 'Photograph',
+           NULL,
+           NULLIF(TRIM(o.TertiaryClass), '')
+        )                                                         AS TertiaryClass,
         NULLIF(TRIM(o.TitleDetails), '')                          AS TitleDetails,
         NULLIF(TRIM(o.TreatmentCompleteYesNo), '')                AS TreatmentCompleteYesNo,
         NULLIF(TRIM(o.TreatmentPriority), '')                     AS TreatmentPriority,

                         IF(Significance_Condition = 1, 'condition', NULL),
                         IF(Significance_Representativeness = 1, 'representativeness', NULL)
               ), '')                                             AS ComparativeCriteria,
        COALESCE(
            NULLIF(TRIM(o.TertiaryClass), ''),
            NULLIF(TRIM(o.SecondaryClass), ''),
            NULLIF(TRIM(o.PrimaryClass), '')
        )                                                         AS Classification,
        # Conservation fields
        NULLIF(TRIM(c.ConservationHistoryID), '')                 AS ConservationHistoryID,
        NULLIF(TRIM(c.ConservationBy), '')                        AS ConservationBy,

        pc.Condition                                              AS PhysicalConditionCode,
        pc.ConditionDescription                                   AS PhysicalConditionDescription,
        # When SecondaryClass is blank then PrimaryClass's value is already in `Classification`
        CASE WHEN o.ItemType = 'Photograph'
            THEN NULL
        WHEN
            TRIM(o.SecondaryClass) = ''
            THEN NULL
        WHEN TRIM(o.PrimaryClass) = ''
