Skip to content

Instantly share code, notes, and snippets.

@gregmercer

gregmercer/Views Query

Created September 11, 2014 14:24
Show Gist options
  • Save gregmercer/b61d82c018d16a8047a1 to your computer and use it in GitHub Desktop.
Save gregmercer/b61d82c018d16a8047a1 to your computer and use it in GitHub Desktop.
Download ZIP
Query created by Drupal Views module
Raw
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') ))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment