years

SELECT projectprop.value AS year_id,

    projectprop.value AS year_name

   FROM projectprop

  WHERE (projectprop.type_id = ( SELECT cvterm.cvterm_id

           FROM cvterm

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

  GROUP BY projectprop.value;