Remove duplicate rows on tables

remove_duplicate_rows.sql

/* Remove duplicate rows on table by simple query.
   Repeate until no more query is removed */

delete from shop_product_price 
       where id in 
       (select tmp.id from 
        (select *, count(*) as num from shop_product_price 
                                   group by shop_id, product_id, price, min_quantity, shipping_fee 
                                   having num >= 2) as tmp);