postgresql7.4
select as_assessmentsx.name, as_assessmentsx.title, as_assessmentsx.creator_id, as_assessmentsx.description
from as_assessmentsx
where as_assessmentsx.assessment_id=:assessment_id
SELECT distinct as_itemsx.as_item_id, as_itemsx.name, as_itemsx.title, 'radiobutton' as presentation_type
FROM as_itemsx