SELECT personnel.ID, personnel.bioImg, personnel.bio, CONCAT_WS(' ', personnel.given, personnel.middle, personnel.surname) AS fullName, jobGroups.grpName, jobTitles.title FROM personnel LEFT JOIN jobXref on personnel.ID=jobXref.persID LEFT JOIN jobTitles on jobXref.titleID=jobTitles.ID LEFT JOIN jobGroups ON jobTitles.grpID=jobGroups.ID WHERE personnel.ID=27 AND jobGroups.divID="1" ; Co-Director Co-Director, Choreographer
