<?xml version="1.0"?>
<queryset>

<fullquery name="count_users">      
<querytext>
      
select count(*) as num_users from ttl_v_users where package_id = :package_id

</querytext>
</fullquery>



<fullquery name="get_area">
<querytext>
      
select ta.area_id,
       ta.name
  from ttl_va_areas ta
  where ta.context_id = :package_id 
  order by ta.nameselect 

</querytext>
</fullquery>
 
</queryset>