         (listing->status_original_flag)::BOOLEAN = 'f'
     )
     UPDATE taxon_concepts
-    SET listing = COALESCE(listing, ''::HSTORE) || hstore(status_flag, inherited_cites_status)
-      || hstore('listing_updated_at', inherited_listing_updated_at) ||
-      hstore(status_original_flag, 'f') || hstore('cites_NC', NULL)
+    SET listing = COALESCE(listing, ''::HSTORE) ||
+      hstore(status_flag, inherited_cites_status) ||
+      hstore(status_original_flag, 'f') ||
+      hstore('cites_NC', NULL) ||
+      hstore(listing_updated_at_flag, inherited_listing_updated_at) ||
+      hstore('listing_updated_at', inherited_listing_updated_at) --TODO get rid of this
     FROM q
     WHERE taxon_concepts.id = q.id AND (
       listing IS NULL OR

      (
        SELECT  h.id, h.parent_id,
        listing->status_flag AS inherited_cites_status,
        (listing->'listing_updated_at')::TIMESTAMP AS inherited_listing_updated_at
        FROM    taxon_concepts h
        WHERE
          listing->status_flag = 'LISTED'

      exception_id int;
      status_flag varchar;
      status_original_flag varchar;
      listing_updated_at_flag varchar;
      flags_to_reset text[];
    BEGIN
    SELECT id INTO deletion_id FROM change_types
      WHERE designation_id = designation.id AND name = 'DELETION';
