Array
(
)
select sample.sample_pkey,
sample_age.sample_age_pkey,
sample.sample_id,
sample.igsn,
sample.laboratoryname,
sample.analyst_name,
sample.ecproject,
sample.latitude,
sample.longitude,
sample.userpkey,
sample.material,
sample.filename,
age_min, age_max, age_value, one_sigma, age_name,upstream,
getagetypes(sample.sample_pkey) as agetypes
from sample
left join sample_age on sample.sample_pkey = sample_age.sample_pkey
left join groupsamplerelate on sample.sample_pkey = groupsamplerelate.sample_pkey
left join grouprelate on groupsamplerelate.group_pkey = grouprelate.group_pkey
left join groups on grouprelate.group_pkey = groups.group_pkey
left join datasetrelate dr on dr.sample_pkey = sample.sample_pkey
left join datasetuserrelate dur on dur.dataset_pkey = dr.dataset_pkey
left join datasets ds on dr.dataset_pkey = ds.dataset_pkey
where 1=1
and sample.purpose in ('To constrain deformation timing of calcite syn-kinematic to the Taltal fault','To constrain deformation timing of calcite syn-kinematic to the Taltal fault system')
and (sample.publ=1 or sample.userpkey=99999 or ((dur.users_pkey=99999 and dur.confirmed=true) or ds.users_pkey=99999 ) or ((grouprelate.users_pkey=99999 and grouprelate.confirmed=true) or groups.users_pkey=99999))
group by
sample.sample_pkey,
sample_age.sample_age_pkey,
sample.sample_id,
sample.igsn,
sample.laboratoryname,
sample.analyst_name,
sample.ecproject,
sample.latitude,
sample.longitude,
sample.userpkey,
sample.material,
sample.filename,
age_min, age_max, age_value, one_sigma, age_name,upstream,
agetypes