SELECT * FROM tq_whitelist WHERE advisor_id IN ( SELECT advisor_id FROM tq_whitelist GROUP BY advisor_id HAVING COUNT(1)>1 ) AND id NOT IN ( SELECT MIN(id) FROM tq_whitelist GROUP BY advisor_id HAVING COUNT(1)>1 )