redmine queries

gistfile1.txt

-- Select the sum of hours invested in a roadmap
select i.id, i.subject, s.name, sum(t.hours) 
    FROM issue_statuses s, issues i
    LEFT JOIN time_entries t
    ON (t.issue_id = i.id)
    WHERE i.project_id = XX and i.fixed_version_id = XX
    AND i.status_id = s.id
    GROUP BY 1,2,3;