<?xml version="1.0"?>

<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="get_lists_user_is_subscribed">
      <querytext>
      
    select l.list_id, l.name
    from ml_mailing_lists l, ml_mailing_list_user_map m
    where l.package_id = :package_id
    and l.list_id = m.list_id
    and l.expiration_date > sysdate
    and m.user_id = :user_id
    and m.subscribed_p = 't'
    order by lower(l.name)

      </querytext>
</fullquery>

<fullquery name="get_lists_by_language">
      <querytext>

     select l.list_id, l.name, l.teaser, c.tree_id, c.category_id,
            nvl(m.subscribed_p, 'f') as subscribed_p
     from ml_mailing_lists l, ml_mailing_list_user_map m,
          category_object_map cm, categories c
     where l.package_id = :package_id
     and l.list_id = m.list_id(+)
     and m.user_id(+) = :user_id
     and l.public_p = 't'
     and l.locale = :locale
     and l.expiration_date > sysdate
     and cm.object_id = l.list_id
     and cm.category_id = c.category_id
     order by c.tree_id, c.category_id, lower(l.name)

      </querytext>
</fullquery>
 
<fullquery name="get_lists_by_language_new">
      <querytext>

     select l.list_id, l.name, l.teaser,
            nvl(m.subscribed_p, 'f') as subscribed_p
     from ml_mailing_lists l, ml_mailing_list_user_map m
     where l.package_id = :package_id
     and l.list_id = m.list_id(+)
     and m.user_id(+) = :user_id
     and l.public_p = 't'
     and l.locale = :locale
     and l.expiration_date > sysdate
     order by lower(l.name)

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