select first_names, last_name, email, url, screen_name from cc_users where user_id=:user_id select attr_value from acs_attribute_values where object_id = :user_id and attribute_id = (select attribute_id from acs_attributes where object_type = 'person' and attribute_name = 'bio') select cr.publish_date, cr.title as portrait_title, cr.description as portrait_description from cr_revisions cr, cr_items ci, acs_rels a where cr.revision_id = ci.live_revision and ci.item_id = a.object_id_two and a.object_id_one = :user_id and a.rel_type = 'user_portrait_rel' select email from cc_users where user_iad=:user_id