Redmine query aimed at the "my page" route.

gistfile1.sql

-- The following query conbines the task due-date with the priority and sorts with the combined value.

SELECT id, project_id, subject, due_date, status_id,priority_id,author_id, priority_id * EXTRACT(EPOCH FROM AGE(due_date))
FROM issues
WHERE assigned_to_id=3 OR
      author_id=3 AND
      status_id IN (SELECT id FROM issue_statuses WHERE NOT is_closed)
ORDER BY (priority_id * EXTRACT(EPOCH FROM AGE(due_date))) DESC NULLS LAST, 
         priority_id DESC;