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.longitude >= -70 and sample.longitude <= -67 and sample.latitude >= -33 and sample.latitude <= -30
and sample.laboratoryname in ('University of Texas at Austin UTChron')
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
