trial_designs

SELECT projectprop.value AS trial_design_id,

    projectprop.value AS trial_design_name

   FROM (projectprop

     JOIN cvterm ON ((projectprop.type_id = cvterm.cvterm_id)))

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

  GROUP BY projectprop.value;