select as_item_choicesx.choice_id, as_item_choicesx.title from as_item_choicesx where as_item_choicesx.mc_id=:mc_id order by as_item_choicesx.sort_order select as_item_choicesx.choice_id, as_item_choicesx.title, as_item_choices.numeric_value, as_item_choicesx.sort_order from as_item_choicesx where as_item_choicesx.mc_id=:mc_id order by as_item_choicex.sort_order select as_itemsx.title, as_itemsx.required_p, 'radiobutton' AS presentation_type from as_itemsx where as_itemsx.as_item_id=:item_id