DELETE FROM books_shop_copy1 where id in (SELECT id from (SELECT min(id) as id FROM books_shop_copy1 GROUP BY pcode,quality,shop_id,url HAVING count(*)>1) aa)
