mysql数据库删除重复数据

DELETE FROM pay_shop_stock_card WHERE id IN 
(
	SELECT * FROM 
	(
		SELECT
		    MIN(id) 
		FROM
		    pay_shop_stock_card 
		    where
		    product_id = 524 
			 AND 
			 STATUS = 0
		GROUP BY
		    card_no
		HAVING
		    COUNT(*) > 1 
		ORDER BY
		    id DESC
	)  temp

)