Subversion Repositories SmartDukaan

-- ---------------------------------------------------------------------------

--  DEDUPE - one attributes row per catalog.

--

--  The old model allowed several date-windowed deals for the same catalog, so a

--  model re-promoted in a later window has more than one row. That is legal

--  history under the old design and a duplicate under the new one, where the

--  row IS the attributes. Keep the newest and drop the rest.

--

--  Found on prod 2026-09-15: catalog 1026529 (Realme) had two rows, created

--  2026-08-19 and 2026-09-02 by the same user, with IDENTICAL attributes - so

--  keeping the newest lost nothing. Verify that before running elsewhere; if the

--  attributes differ, decide which is current instead of taking MAX(id) blindly.

--

--  Must run before the unique key in schema PASS 2, which this is what makes

--  possible.

-- ---------------------------------------------------------------------------

DELETE m FROM catalog.model_hot_deal m

JOIN (SELECT catalog_item_id, MAX(id) AS keep_id

      FROM catalog.model_hot_deal

      GROUP BY catalog_item_id HAVING COUNT(*) > 1) d

  ON d.catalog_item_id = m.catalog_item_id AND m.id < d.keep_id;