0 rows
SELECT observable.cvterm_id,
observable.name
FROM (phenotype me
JOIN cvterm observable ON ((observable.cvterm_id = me.observable_id)))
GROUP BY observable.cvterm_id, observable.name;
