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 from as_item_choicesx where as_item_choicesx.mc_id=:mc_id order by as_item_choicesx.sort_order select as_itemsx.title, as_itemsx.required_p from as_itemsx where as_itemsx.as_item_id=:item_id