mysql查询重复数据

select * from hkby_facebookhistory_abroaddataall where ir_content in (select A.ir_content from((select ir_content from hkby_facebookhistory_abroaddataall group by ir_content having count(ir_content) > 1) as A)) ORDER BY ir_content;