SELECT node.nid AS nid,
   node_data_field_status.field_status_value AS node_data_field_status_field_status_value,
   node.type AS node_type,
   node.vid AS node_vid,
   node_data_field_status.field_type_value AS node_data_field_status_field_type_value,
   node_data_field_status.field_faculty_id_value AS node_data_field_status_field_faculty_id_value,
   node_data_field_status.field_photo_value AS node_data_field_status_field_photo_value,
   node_data_field_status.field_first_name_value AS node_data_field_status_field_first_name_value,
   node_data_field_status.field_middle_name_value AS node_data_field_status_field_middle_name_value,
   node_data_field_status.field_last_name_value AS node_data_field_status_field_last_name_value,
   node_data_field_status.field_title1_value AS node_data_field_status_field_title1_value,
   node_data_field_status.field_title2_value AS node_data_field_status_field_title2_value,
   node_data_field_status.field_title3_value AS node_data_field_status_field_title3_value,
   node_data_field_status.field_department_value AS node_data_field_status_field_department_value,
   node_data_field_status.field_email_value AS node_data_field_status_field_email_value,
   node_data_field_status.field_phone_value AS node_data_field_status_field_phone_value,
   node_data_field_status.field_fax_value AS node_data_field_status_field_fax_value,
   node_data_field_status.field_website_value AS node_data_field_status_field_website_value,
   node_data_field_status.field_bio_value AS node_data_field_status_field_bio_value,
   node_data_field_status.field_publications_value AS node_data_field_status_field_publications_value,
   node_data_field_status.field_research_area_value AS node_data_field_status_field_research_area_value,
   node_data_field_status.field_teaching_area_value AS node_data_field_status_field_teaching_area_value
 FROM node node 
 LEFT JOIN content_type_facultybio node_data_field_status ON node.vid = node_data_field_status.vid
 WHERE UPPER(node_data_field_status.field_status_value) = UPPER('active')
   ORDER BY node_data_field_status_field_department_value ASC