have a look at sample_group_sampling_contexts

[johanvonboer]

This data:
select * from tbl_sample_group_sampling_contexts join tbl_sample_group_description_type_sampling_contexts on tbl_sample_group_description_type_sampling_contexts.sampling_context_id=tbl_sample_group_sampling_contexts.sampling_context_id join tbl_sample_group_descriptions on tbl_sample_group_descriptions.sample_group_description_type_id=tbl_sample_group_description_type_sampling_contexts.sample_group_description_type_id