postgresql7.2 select t.task_id, t.title, t.party_id, t.priority, s.title as status, tasks__relative_date(t.due_date) as due_date, t.description, CASE WHEN t.due_date < now() THEN 't'::boolean ELSE 'f'::boolean END as overdue_p, tasks__relative_date(t.due_date) as due_date, contact__name(t.party_id, :name_order) as contact_name, p.title as process_title, p.process_id, t.mime_type from t_task_status s, acs_objects ot, t_tasks t left outer join t_process_instances pi on (pi.process_instance_id = t.process_instance_id) left outer join t_processes p on (p.process_id = pi.process_id) where s.status_id = t.status_id and t.status_id <> 2 and ot.object_id = t.task_id and ot.package_id = :package_id and ot.creation_user = :user_id and t.start_date < now() and t.due_date < ( now() + '$tasks_interval days'::interval ) [template::list::page_where_clause -and -name tasks -key t.task_id] [template::list::orderby_clause -orderby -name tasks] select t.task_id from t_task_status s, acs_objects ot, t_tasks t left outer join t_process_instances pi on (pi.process_instance_id = t.process_instance_id) left outer join t_processes p on (p.process_id = pi.process_id) where s.status_id = t.status_id and t.status_id <> 2 and ot.object_id = t.task_id and ot.package_id = :package_id and ot.creation_user = :user_id and t.start_date < now() and t.due_date < ( now() + '$tasks_interval days'::interval ) [template::list::orderby_clause -orderby -name tasks] select count(*) from t_task_status s, acs_objects ot, t_tasks t left outer join t_process_instances pi on (pi.process_instance_id = t.process_instance_id) left outer join t_processes p on (p.process_id = pi.process_id) where s.status_id = t.status_id and t.status_id <> 2 and ot.object_id = t.task_id and ot.package_id = :package_id and ot.creation_user = :user_id and t.start_date < now() and t.due_date < ( now() + '$tasks_interval days'::interval )