WITH t_fraud_list_found_duplicates AS (
  SELECT id
    FROM t_fraud_list
   WHERE ROWID NOT IN (
     SELECT MIN(ROWID)
       FROM t_fraud_list
      GROUP BY listid, VALUE
    )
);
DELETE
  FROM t_fraud_list_item_parent
 WHERE list_item_id IN (SELECT id FROM t_fraud_list_found_duplicates)
    OR parent_id IN (SELECT id FROM t_fraud_list_found_duplicates);

DELETE
  FROM t_fraud_list_parameters
 WHERE list_item_id IN (SELECT id FROM t_fraud_list_found_duplicates);

-- FIXME: удалишь дубликаты два раза... похоже этот запрос лишний...
/*
delete
  from t_fraud_list
 where rowid not in (
   select min(rowid)
     from t_fraud_list
    group by listid, value
  );
*/
DELETE
  FROM t_fraud_list_item_parent
 WHERE list_item_id IN (SELECT id FROM t_fraud_list_found_duplicates)
    OR parent_id IN (SELECT id FROM t_fraud_list_found_duplicates);

DELETE
  FROM t_fraud_list_parameters
 WHERE list_item_id IN (SELECT id FROM t_fraud_list_found_duplicates);

-- FIXME: еще раз удалить, может скопировано не так?
/*
delete
  from t_fraud_list
 where rowid not in (
   select min(rowid)
     from t_fraud_list
    group by listid, value
  );
*/
-- NOTE: переписал запрос который выше, плиз проверь его еще раз...
DELETE
  FROM t_fraud_list
 WHERE id IN (SELECT id FROM t_fraud_list_found_duplicates);