SELECT cm_firstname, cm_lastname, parent_cmid 
FROM identitytable 
WHERE cm_type=268440329
ORDER BY cm_firstname, cm_lastname;