genotyping_projects

SELECT project.project_id AS genotyping_project_id,

    project.name AS genotyping_project_name

   FROM (project

     JOIN projectprop USING (project_id))

  WHERE ((projectprop.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'design'::text))) AND (projectprop.value = 'genotype_data_project'::text));