Skip to content

Instantly share code, notes, and snippets.

@steinmb
Created January 14, 2015 15:33
Show Gist options
  • Save steinmb/726898be8b679535c7aa to your computer and use it in GitHub Desktop.
Save steinmb/726898be8b679535c7aa to your computer and use it in GitHub Desktop.
SELECT node.title AS node_title, node.nid AS nid, node.language AS node_language, users_node.name AS users_node_name, users_node.uid AS users_node_uid, 'user' AS field_data_field_bar_user_entity_type
FROM
{node} node
LEFT JOIN {users} users_node ON node.uid = users_node.uid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment