SELECT a.nid as node_id, a.title as title_id, f.field_hidden_geolocation_lat as hiddenlat, f.field_hidden_geolocation_lng as hiddenlng, g.field_geolocation_lat_lon_lat as geolat, g.field_geolocation_lat_lon_lng as geolng, h.field_basic_geolocation_map_lat as basiclat, h.field_basic_geolocation_map_lng as basiclng, i.field_phosphates_select_value as phos, j.field_nitrates_select_value as nit, k.field_secchi_tube_result_value as tubr, l.field_g_water_quality_secchi_t_value as tub FROM node as a LEFT join field_data_field_hidden_geolocation as f on (a.nid=f.entity_id) LEFT join field_data_field_ms_sample_for_group as o on (a.nid=o.entity_id) LEFT join field_data_field_geolocation_lat_lon as g on (a.nid=g.entity_id) LEFT join field_data_field_basic_geolocation_map as h on (a.nid=h.entity_id) left join field_data_field_phosphates_select as i on (a.nid=i.entity_id) left join field_data_field_nitrates_select as j on (a.nid=j.entity_id) left join field_data_field_secchi_tube_result as k on (a.nid=k.entity_id) left join field_data_field_g_water_quality_secchi_t as l on (a.nid=l.entity_id) where a.type='sample' and o.bundle='sample' AND o.field_ms_sample_for_group_target_id =147151