Faculty & Staff Directory

SELECT *, (SELECT GROUP_CONCAT(DISTINCT(tt2.name) ORDER BY gmt2.group_id,tt2.name SEPARATOR '
') FROM group_member_tbl gmt2,type_tbl tt2 WHERE gmt2.directory_id = directory_tbl.id AND gmt2.group_member_title = tt2.id AND (gmt2.group_id = '1' OR gmt2.group_id = '7' OR gmt2.group_id = 8) AND tt2.name != 'Member') as titles FROM group_member_tbl LEFT JOIN directory_tbl ON group_member_tbl.directory_id = directory_tbl.id AND flags LIKE '%FSC%' LEFT JOIN phone_tbl ON group_member_tbl.directory_id = phone_tbl.directory_id AND phone_type = '16' LEFT JOIN email_tbl ON group_member_tbl.directory_id = email_tbl.directory_id AND email_type = '19' LEFT JOIN type_tbl ON type_tbl.id = group_member_tbl.group_member_title WHERE directory_tbl.id = 29670 AND directory_tbl.id NOT IN(5001,5002,7500) GROUP BY group_member_tbl.directory_id ORDER BY directory_tbl.last_name, directory_tbl.first_name

SELECT *, (SELECT GROUP_CONCAT(DISTINCT(tt2.name) ORDER BY gmt2.group_id,tt2.name SEPARATOR '
') FROM group_member_tbl gmt2,type_tbl tt2 WHERE gmt2.directory_id = directory_tbl.id AND gmt2.group_member_title = tt2.id AND (gmt2.group_id = '1' OR gmt2.group_id = '7' OR gmt2.group_id = 8) AND tt2.name != 'Member') as titles FROM group_member_tbl LEFT JOIN directory_tbl ON group_member_tbl.directory_id = directory_tbl.id AND flags LIKE '%FSC%' LEFT JOIN phone_tbl ON group_member_tbl.directory_id = phone_tbl.directory_id AND phone_type = '16' LEFT JOIN email_tbl ON group_member_tbl.directory_id = email_tbl.directory_id AND email_type = '19' LEFT JOIN type_tbl ON type_tbl.id = group_member_tbl.group_member_title WHERE group_member_tbl.group_id = 1516 AND directory_tbl.id != 29670 AND group_member_status IS NULL AND directory_tbl.id NOT IN(5001,5002,7500) GROUP BY group_member_tbl.directory_id ORDER BY directory_tbl.last_name, directory_tbl.first_name

SELECT *, (SELECT GROUP_CONCAT(DISTINCT(tt2.name) ORDER BY gmt2.group_id,tt2.name SEPARATOR '
') FROM group_member_tbl gmt2,type_tbl tt2 WHERE gmt2.directory_id = directory_tbl.id AND gmt2.group_member_title = tt2.id AND (gmt2.group_id = '1' OR gmt2.group_id = '7' OR gmt2.group_id = 8) AND tt2.name != 'Member') as titles FROM group_member_tbl LEFT JOIN directory_tbl ON group_member_tbl.directory_id = directory_tbl.id AND flags LIKE '%FSC%' LEFT JOIN phone_tbl ON group_member_tbl.directory_id = phone_tbl.directory_id AND phone_type = '16' LEFT JOIN email_tbl ON group_member_tbl.directory_id = email_tbl.directory_id AND email_type = '19' LEFT JOIN type_tbl ON type_tbl.id = group_member_tbl.group_member_title WHERE group_member_tbl.group_id IN (1,7,8) AND directory_tbl.id NOT IN (SELECT directory_id FROM group_member_tbl gmt2 WHERE gmt2.group_id = 1516 AND gmt2.group_member_status IS NULL) AND directory_tbl.id NOT IN(5001,5002,7500) GROUP BY group_member_tbl.directory_id ORDER BY directory_tbl.last_name, directory_tbl.first_name