SELECT  s.name AS "Segment Name", COUNT(s_c.se_segment_contacts_1contacts_idb) "Mismatched Segment FS Count" FROM se_segment s, se_segment_contacts_1_c s_c,  contacts_cstm c_cstm,  contacts c, se_segment_cstm s_cstm WHERE s.id = s_c.se_segment_contacts_1se_segment_ida AND s.id = s_cstm.id_c AND s_c.se_segment_contacts_1se_segment_ida = s_cstm.id_c AND s_c.se_segment_contacts_1contacts_idb = c.id AND s_c.deleted=0 AND c.deleted = 0 AND c.id = c_cstm.id_c AND ( s_cstm.profile_prompts_segment_c != c_cstm.defaultprofile_prompts_count_c OR s_cstm.steps_c_segment_c != c_cstm.steps_c_default_c OR s_cstm.feature_switches_segment_c != c_cstm.feature_switches_segment_c) GROUP BY s_c.se_segment_contacts_1se_segment_ida HAVING COUNT(s_c.se_segment_contacts_1contacts_idb) > 0 ORDER BY s.name ASC;