select question_page.id as page_id, max(audit_action.time) as lastupdated FROM development_plan
left outer join devplan_template on development_plan.template_id = devplan_template.id
left outer join question_page on question_page.devplantemplate_id = devplan_template.id
left outer join question_chunk on question_chunk.question_page_id = question_page.id
left outer join question on question.question_chunk_id = question_chunk.id
left outer join answer on answer.question_id = question.id
left outer join audit_info on answer.auditinfo_id = audit_info.id
left outer join audit_action on audit_action.audit_info_id = audit_info.id
where development_plan.id = 75
and answer.devplan_id = 75
and audit_action.action = 2
group by question_page.id;