         (sql-utils/query conn stmt)))
 
 (defn- add-missing-items-to-work-table
-  "Finds items that are missing in Metadata DB and adds it to the sync_work table."
+  "Finds all the items that were ingested between start-date and end-date in Catalog REST and adds
+  them to the sync_work table. These are all not necessarily missing from Metadata DB. We'll treat
+  them as if they were since we know ingest into Metadata DB is idempotent."
   [system provider-id concept-type start-date end-date]
   (truncate-work-table system)
   (let [sql (format "insert into sync_work (id, concept_id)


(defn- in-clause
  "Generates a sql in clause string. If there are more than the max values to put in the in clause
  it creates multiple an ANDs them together."
  [field num-values]
  (let [num-full (int (/ num-values 1000))
        num-in-partial (mod num-values 1000)

            [cmr.bootstrap.data.migration-utils :as mu]
            [cmr.common.util :as util]
            [cmr.common.concepts :as concepts]
            [cmr.common.config :as config]
            [clj-time.coerce :as cr]
            [clj-time.core :as t]
            [cmr.metadata-db.data.oracle.concept-tables :as tables]
