trials

SELECT trial.project_id AS trial_id,

    trial.name AS trial_name

   FROM (((project breeding_program

     JOIN project_relationship ON (((breeding_program.project_id = project_relationship.object_project_id) AND (project_relationship.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

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

     JOIN project trial ON ((project_relationship.subject_project_id = trial.project_id)))

     JOIN projectprop ON ((trial.project_id = projectprop.project_id)))

  WHERE (NOT (projectprop.type_id IN ( SELECT cvterm.cvterm_id

           FROM cvterm

          WHERE (((cvterm.name)::text = 'cross'::text) OR ((cvterm.name)::text = 'trial_folder'::text) OR ((cvterm.name)::text = 'folder_for_trials'::text) OR ((cvterm.name)::text = 'folder_for_crosses'::text) OR ((cvterm.name)::text = 'folder_for_genotyping_trials'::text)))))

  GROUP BY trial.project_id, trial.name;