1	1	<?xml version="1.0"?>
			2	2	<queryset>
			3	3
			4		<fullquery name="pvt_home_user_info">
			5		<querytext>
			6
			7		select first_names, last_name, email, url, screen_name
			8		from cc_users
			9		where user_id=:user_id
			10	4
			11		</querytext>
			12		</fullquery>
			13
			14
			15		<fullquery name="biography">
				5	<fullquery name="get_portrait_info">
			16	6	<querytext>
			17	7
			18		select attr_value
			19		from acs_attribute_values
			20		where object_id = :user_id
			21		and attribute_id =
			22		(select attribute_id
			23		from acs_attributes
			24		where object_type = 'person'
			25		and attribute_name = 'bio')
			26		</querytext>
			27		</fullquery>
			28
			29
			30		<fullquery name="get_portrait_info">
			31		<querytext>
			32
			33	8	select cr.publish_date, cr.title as portrait_title, cr.description as portrait_description
			34	9	from cr_revisions cr, cr_items ci, acs_rels a
			35	10	where cr.revision_id = ci.live_revision
			36		and  ci.item_id = a.object_id_two
				11	and ci.item_id = a.object_id_two
			37	12	and a.object_id_one = :user_id
			38	13	and a.rel_type = 'user_portrait_rel'
			39	14
			40	15	</querytext>
			41	16	</fullquery>
			42	17
			43		<fullquery name="email_info">
			44		<querytext>
			45		select email
			46		from cc_users
			47		where user_iad=:user_id
			48		</querytext>
			49		</fullquery>
			50
			51
			52	18
			53	19	</queryset>