重複するデータを削除する SQL。出典 https://chaika.hatenablog.com/entry/2019/02/21/120000

.sql

DELETE FROM
    table_a
WHERE id NOT IN (
    SELECT
        id
    FROM(
        SELECT
            *
        FROM
            table_a AS t1
        WHERE 1 = (
            SELECT
                COUNT(*)
            FROM
                table_a AS t2
            WHERE
                t1.shop_id = t2.shop_id
                AND t1.date = t2.date
                AND t1.id >= t2.id
        )
    ) AS tmp
);