SELECT node.nid AS nid,
   node.title AS node_title,
   node_data_field_building_role.field_building_role_value AS node_data_field_building_role_field_building_role_value,
   node.type AS node_type,
   node.vid AS node_vid,
   node.uid AS node_uid,
   node_revisions.format AS node_revisions_format,
   node_data_field_draggable_sort.field_draggable_sort_value AS node_data_field_draggable_sort_field_draggable_sort_value,
   term_data_7.name AS term_data_7_name,
   term_data_7.vid AS term_data_7_vid,
   term_data_7.tid AS term_data_7_tid,
   flag_content.content_id AS flag_content_content_id
 FROM node node 
 LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 2
 LEFT JOIN content_type_lerp_internal_contact node_data_field_building_role ON node.vid = node_data_field_building_role.vid
 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
 LEFT JOIN content_field_draggable_sort node_data_field_draggable_sort ON node.vid = node_data_field_draggable_sort.vid
 LEFT JOIN term_node term_node ON node.vid = term_node.vid
 LEFT JOIN term_data term_data_7 ON term_node.tid = term_data_7.tid AND term_data_7.vid = 7
 LEFT JOIN flag_content flag_content ON node.nid = flag_content.content_id AND (flag_content.fid = 2 AND flag_content.uid = ***CURRENT_USER***)
 WHERE (node.type in ('lerp_internal_contact')) AND (node.status <> 0)
   ORDER BY node_data_field_draggable_sort_field_draggable_sort_value ASC