All pastes #199495 Raw Edit

Stuff

public text v1 · immutable
#199495 ·published 2006-10-12 15:20 UTC
rendered paste body
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;