select
as_item_choices.choice_id, as_item_choices.choice_text
from
as_item_choices, as_item_choice_map, as_items
where
as_item_choice_map.choice_id=as_item_choices.choice_id and as_items.item_id=as_item_choice_map.item_id and as_item_choice_map.item_id=:item_id
order by
as_item_choice_map.sort_order
select
as_item_choices.choice_id, as_item_choices.choice_text, as_item_choice_map.item_id, as_item_choices.numeric_value, as_item_choice_map.sort_order
from
as_item_choices, as_item_choice_map, as_items
where
as_item_choice_map.choice_id=as_item_choices.choice_id and as_items.item_id=as_item_choice_map.item_id and as_item_choice_map.item_id=:item_id
order by
as_item_choice_map.sort_order
select
as_items.item_text, as_items.required_p, as_item_display_types.presentation_type
from
as_items, as_item_display_types
where
as_items.item_display_type_id=as_item_display_types.item_display_type_id and as_items.item_id=:item_id