postgresql7.1 select first_names, last_name, email, url from persons, parties where persons.person_id = parties.party_id and party_id =:user_id select bea.valid_p, bea.frequency, bea.keywords, bt.topic, bea.rowid from bboard_email_alerts bea, bboard_topics bt where bea.user_id = :user_id and bea.topic_id = bt.topic_id order by bea.frequency select cea.valid_p, ad.domain, cea.alert_id, cea.expires, cea.frequency, cea.alert_type, cea.category, cea.keywords from classified_email_alerts cea, ad_domains ad where user_id = :user_id and ad.domain_id = cea.domain_id and sysdate <= expires order by expires desc