Mysql count data > 1

SELECT profile_id, COUNT(profile_id) FROM wp_npn_profile_list GROUP BY profile_id HAVING COUNT(profile_id) > 1;

SELECT user_id, COUNT(user_id) FROM wp_npn_profile_list GROUP BY user_id HAVING COUNT(user_id) > 1;