This is the SQL that we use at dloHaiti to delete duplicated receipts introduced by the old POS app.

delete-duplicated-receipts.sql

set @kid = 102;
set @start_date = '2018-11-0';
set @end_date = '2018-12-0';

SET SQL_SAFE_UPDATES = 0;

DELETE FROM receipt 
WHERE
    id IN (SELECT 
        a.id
    FROM
        (SELECT 
            created_date, id
        FROM
            receipt
        
        WHERE
            created_date BETWEEN @start_date AND @end_date and date_format(created_date, "%h%i%s") <> "000000"
            AND kiosk_id = @kid) AS a,
        (SELECT 
            created_date, id
        FROM
            receipt
        
        WHERE
            created_date BETWEEN @start_date AND @end_date and date_format(created_date, "%h%i%s") <> "000000"
            AND kiosk_id = @kid) AS b
    
    WHERE
        a.created_date = b.created_date
        AND a.id < b.id);

SET SQL_SAFE_UPDATES = 1;