genotyping_projectsxyears

SELECT projectprop.project_id AS genotyping_project_id,

    projectprop.value AS year_id

   FROM projectprop

  WHERE ((projectprop.project_id IN ( SELECT projectprop_1.project_id

           FROM projectprop projectprop_1

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

                   FROM cvterm

                  WHERE ((cvterm.name)::text = 'design'::text))) AND (projectprop_1.value = 'genotype_data_project'::text)))) AND (projectprop.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'project year'::text))));