SELECT measurements.id measurement_id,measures.id measure_id, measurement,measurement_class,measurement_type,method,units,measure_value,v_error,v_error_units,v_type,v_n,lat,lng,sample_geo_unit,sample_lith,lith_id,sample_descrip,ref_id,GROUP_CONCAT(unit_id)
FROM measures
JOIN measurements ON measures.measurement_id=measurements.id
JOIN measuremeta ON measures.measuremeta_id=measuremeta.id
LEFT JOIN unit_measures ON unit_measures.measuremeta_id=measuremeta.id
WHERE measurement='238U-206PB'
GROUP BY measures.id
parameters should be all fields from defs/measurements
ideally taking unit_id as argument would be possible too
parameters should be all fields from defs/measurements ideally taking unit_id as argument would be possible too