postgresql7.1
select l.list_id, l.name, l.teaser, c.tree_id, c.category_id
from ml_mailing_lists l
inner join category_object_map cm
on (cm.object_id = l.list_id)
inner join categories c using (category_id)
where l.public_p = 't'
and 0 = (select count(*) from ml_mailing_list_user_map m where l.list_id = m.list_id and m.user_id = :user_id)
and l.locale = :locale
DEI
and l.expiration_date > current_timestamp
order by c.tree_id, c.category_id, lower(l.name)
select l.list_id, l.name
from ml_mailing_lists l, ml_mailing_list_user_map m
where l.list_id = m.list_id
and l.expiration_date > current_timestamp
and m.user_id = :user_id
and m.subscribed_p = 't'
order by lower(l.name)
select email_verified_p
from users
where user_id = :user_id