Skip to content

Instantly share code, notes, and snippets.

@jonlambert
Created July 11, 2013 10:00
Show Gist options
  • Save jonlambert/5974179 to your computer and use it in GitHub Desktop.
Save jonlambert/5974179 to your computer and use it in GitHub Desktop.
SELECT node.title,
field_data_gsl_addressfield.gsl_addressfield_country,
field_data_gsl_addressfield.gsl_addressfield_postal_code,
field_data_gsl_props_phone.gsl_props_phone_value,
field_data_gsl_geofield.gsl_geofield_lat,
field_data_gsl_geofield.gsl_geofield_lon
FROM node
WHERE field_data_gsl_addressfield.gsl_addressfield_country = "GB"
INNER JOIN field_data_gsl_addressfield ON field_data_gsl_addressfield.entity_id = node.nid
INNER JOIN field_data_gsl_props_phone ON field_data_gsl_props_phone.entity_id = node.nid
INNER JOIN field_data_gsl_geofield ON field_data_gsl_geofield.entity_id = node.nid;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment