Skip to content

Instantly share code, notes, and snippets.

/gist:7379243

Created November 8, 2013 23:21
Show Gist options
  • Save anonymous/7379243 to your computer and use it in GitHub Desktop.
Save anonymous/7379243 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT *
FROM node node
LEFT JOIN users users_node ON node.uid = users_node.uid
LEFT JOIN field_data_body field_data_body ON node.nid = field_data_body.entity_id AND (field_data_body.entity_type = 'node' AND field_data_body.deleted = '0')
LEFT JOIN field_data_field_image field_data_field_image ON node.nid = field_data_field_image.entity_id AND (field_data_field_image.entity_type = 'node' AND field_data_field_image.deleted = '0')
LEFT JOIN field_data_field_course_reference field_data_field_course_reference ON node.nid = field_data_field_course_reference.entity_id AND (field_data_field_course_reference.entity_type = 'node' AND field_data_field_course_reference.deleted = '0')
WHERE (( (node.type IN ('journal_entry')) AND( (users_node.uid = '1') )))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment