Skip to content

Instantly share code, notes, and snippets.

@tmbritton
Created June 4, 2015 23:12
Show Gist options
  • Save tmbritton/43947d66fdd51506f359 to your computer and use it in GitHub Desktop.
Save tmbritton/43947d66fdd51506f359 to your computer and use it in GitHub Desktop.
Select store titles and paths
SELECT f.field_store_name_value as "Store Path",
n.title as "Store Name",
n.nid as "Drupal Node ID"
FROM field_data_field_store_name f
LEFT JOIN node n
ON f.entity_id = n.nid
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment