query for redmine issue

gistfile1

select id, substr(subject, 1, 15), category_id, project_id, created_on from issues order by updated_on;



select issues.id, substr(subject, 1, 15), category_id, project_id, created_on 
FROM `issues` INNER JOIN issue_statuses ist on ist.id = issues.status_id WHERE (1 = 1
 and (issues.assigned_to_id = 3
 and issues.start_date < '2013-02-11 00:00:00'
 and ist.is_closed != 1))
;