     SET listing = COALESCE(listing, ''::HSTORE) ||
       hstore(status_flag, inherited_cites_status) ||
       hstore(status_original_flag, 'f') ||
-      hstore('listing_updated_at', inherited_listing_updated_at::VARCHAR)
+      hstore(listing_updated_at_flag, inherited_listing_updated_at::VARCHAR) ||
+      hstore('listing_updated_at', inherited_listing_updated_at::VARCHAR) --TODO get rid of this
     FROM qq
     WHERE taxon_concepts.id = qq.id
      AND (

        (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)
    FROM q
    WHERE taxon_concepts.id = q.id AND (
      listing IS NULL OR

          ELSE inherited_cites_status
        END,
        CASE
          WHEN (listing->listing_updated_at_flag)::TIMESTAMP IS NOT NULL
          THEN (listing->listing_updated_at_flag)::TIMESTAMP
          ELSE inherited_listing_updated_at
        END
        FROM    q
