gregmercer · September 11, 2014 14:24
diff --git a/Views Query b/Views Query
 SELECT DISTINCT node.nid AS nid
 FROM 
 node node
 INNER JOIN field_data_field_academic_area_unlimited field_data_field_academic_area_unlimited ON node.nid = field_data_field_academic_area_unlimited.entity_id AND (field_data_field_academic_area_unlimited.entity_type = 'node' AND field_data_field_academic_area_unlimited.deleted = '0')
 INNER JOIN field_data_field_region_of_interest field_data_field_region_of_interest ON node.nid = field_data_field_region_of_interest.entity_id AND (field_data_field_region_of_interest.entity_type = 'node' AND field_data_field_region_of_interest.deleted = '0')
 WHERE (( (node.status = '1') AND (node.type IN  ('announcement')) )AND( (field_data_field_academic_area_unlimited.field_academic_area_unlimited_tid = '10001') OR (field_data_field_region_of_interest.field_region_of_interest_tid = '26551') ))
	SELECT DISTINCT node.nid AS nid
	FROM
	node node
	INNER JOIN field_data_field_academic_area_unlimited field_data_field_academic_area_unlimited ON node.nid = field_data_field_academic_area_unlimited.entity_id AND (field_data_field_academic_area_unlimited.entity_type = 'node' AND field_data_field_academic_area_unlimited.deleted = '0')
	INNER JOIN field_data_field_region_of_interest field_data_field_region_of_interest ON node.nid = field_data_field_region_of_interest.entity_id AND (field_data_field_region_of_interest.entity_type = 'node' AND field_data_field_region_of_interest.deleted = '0')
	WHERE (( (node.status = '1') AND (node.type IN ('announcement')) )AND( (field_data_field_academic_area_unlimited.field_academic_area_unlimited_tid = '10001') OR (field_data_field_region_of_interest.field_region_of_interest_tid = '26551') ))