CREATE DEFINER=`jhise`@`localhost` PROCEDURE `projects_get_by_dataset`(in i_dataset_access_key char(32))
BEGIN
	select
	p.access_key project_access_key
		from
			project p
				join project_dataset_jct jct on jct.project_id = p.id
		where
			jct.dataset_access_key = i_dataset_access_key;
END
