UPDATE external_match SET approved = TRUE FROM (

        SELECT em.external_object_id, em.partner_button_type_code
        FROM
          external_match em
          JOIN external_object eo ON em.external_object_id = eo.id
        WHERE
          em.match_precision = 100
          AND em.approved IS FALSE
          AND eo.partner_id = 11
        GROUP BY eo.partner_id, em.external_object_id, em.partner_button_type_code
        HAVING COUNT(external_object_id) = 1
      ) exact_ext, (
        SELECT place_id
        FROM
          external_match em2
          JOIN external_object eo ON em2.external_object_id = eo.id
        WHERE
          em2.match_precision = 100
          AND em2.approved IS FALSE
          AND eo.partner_id = 11
        GROUP BY eo.partner_id, em2.place_id
        HAVING COUNT(em2.place_id) = 1
      ) exact_poi
      WHERE
        external_match.external_object_id = exact_ext.external_object_id
        AND external_match.external_object_id NOT IN (
          SELECT
            DISTINCT external_object_id
          FROM
            external_match
          WHERE
            approved IS TRUE
        )
        AND external_match.place_id = exact_poi.place_id
        AND external_match.place_id NOT IN (
          SELECT
            DISTINCT em2.place_id
          FROM
            external_match em2
          WHERE
            em2.approved IS TRUE
            AND em2.partner_button_type_code = exact_ext.partner_button_type_code
        )
        AND match_precision = 100