breeding_programs

SELECT project.project_id AS breeding_program_id,

    project.name AS breeding_program_name

   FROM (project

     JOIN projectprop USING (project_id))

  WHERE (projectprop.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE ((cvterm.name)::text = 'breeding_program'::text)))

  GROUP BY project.project_id, project.name;