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