delete qq_cards_500 from qq_cards_500 ,(select id from qq_cards_500 group by cards_sn having count(*)>1 limit 100000) as t2 where qq_cards_500.id=t2.id