<?xml version="1.0"?>

<queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>

    <fullquery name="select_non_dotlrn_users_count">
        <querytext>
            select count(*)
            from (select acs_rels.object_id_two
                  from acs_rels, membership_rels
                  where acs_rels.object_id_one = (select acs__magic_object_id('registered_users') from dual)
                  and acs_rels.rel_id = membership_rels.rel_id                  
                  and acs_rels.object_id_two not in (                  
                      select acs_rels.object_id_two
                             from acs_rels,
                             dotlrn_user_types
                       where acs_rels.object_id_one = dotlrn_user_types.group_id)) as foo
        </querytext>
    </fullquery>
</queryset>