postgresql7.1 select distinct interaction_originator from ec_customer_serv_interactions select i.interaction_id, i.customer_service_rep, i.interaction_date, to_char(i.interaction_date,'YYYY-MM-DD HH24:MI:SS') as full_interaction_date, i.interaction_originator, i.interaction_type, i.user_identification_id, reps.first_names as rep_first_names, reps.last_name as rep_last_name, customer_info.user_identification_id, customer_info.user_id as customer_user_id, customer_info.first_names as customer_first_names, customer_info.last_name as customer_last_name from ec_customer_serv_interactions i LEFT JOIN cc_users reps on (i.customer_service_rep=reps.user_id), (select id.user_identification_id, id.user_id, u2.first_names, u2.last_name from ec_user_identification id LEFT JOIN cc_users u2 on (id.user_id=u2.user_id)) as customer_info where i.user_identification_id=customer_info.user_identification_id $rep_query_bit $interaction_originator_query_bit $interaction_type_query_bit $interaction_date_query_bit order by $order_by and now()-i.interaction_date <= timespan_days(1) and now()-i.interaction_date <= timespan_days(7) and now()-i.interaction_date <= '1 month'::interval