breeding_programsxgenotyping_projects

SELECT project_relationship.object_project_id AS breeding_program_id,

    project.project_id AS genotyping_project_id

   FROM ((project

     LEFT JOIN projectprop ON ((project.project_id = projectprop.project_id)))

     LEFT JOIN project_relationship ON ((project.project_id = project_relationship.subject_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));