SELECT * FROM ( SELECT ps_customfields.getcf('Students',id,'short_name') short_name, COUNT(*) AS num FROM students WHERE enroll_status = 0 AND ps_customfields.getcf('Students',id,'short_name') IS NOT NULL GROUP BY ps_customfields.getcf('Students',id,'short_name') ) thelist WHERE num > 1