mysql 중복 데이타 검색

 SELECT count_ip, referer_url, COUNT(*) as cnt FROM wave_count  GROUP BY count_ip HAVING COUNT(count_ip) > 1 AND COUNT(referer_url) > 1 order by cnt DESC limit 100;