Slow query which crashes mysql

[tbar0970]

Attendance display
format=tabular
for several years

Probably the left-join onto a subquery is the killer.
Can this be avoided??

SELECT person.id, person.last_name, person.first_name,  person.status, ar.date, ar.present
				FROM person person
				JOIN age_bracket ab ON ab.id = person.age_bracketid
				JOIN family f ON person.familyid = f.id
				
				LEFT JOIN (
					SELECT personid, date, present
					FROM attendance_record ar
					WHERE ar.date BETWEEN '2006-01-02' AND '2012-01-01'
					AND ar.groupid = 0
				) ar ON ar.personid = person.id
				WHERE ((person.status <> "archived") OR (ar.present IS NOT NULL)) 
				 AND person.congregationid IN ('6') 
				ORDER BY person.status ASC, family_name ASC, familyid, ab.rank ASC, gender DESC

BACKTRACE:
Array
(
    [0] => Array
        (
            [file] => /home/jethro/code/2.30.1/db_objects/attendance_record_set.class.php
            [line] => 741
            [function] => query
            [class] => PDO
            [type] => ->
            [args] => Array
                (
                    [0] => SELECT person.id, person.last_name, person.first_name,  person.status, ar.date, ar.present
				FROM person person
				JOIN age_bracket ab ON ab.id = person.age_bracketid
				JOIN family f ON person.familyid = f.id
				
				LEFT JOIN (
					SELECT personid, date, present
					FROM attendance_record ar
					WHERE ar.date BETWEEN '2006-01-02' AND '2012-01-01'
					AND ar.groupid = 0
				) ar ON ar.personid = person.id
				WHERE ((person.status <> "archived") OR (ar.present IS NOT NULL)) 
				 AND person.congregationid IN ('6') 
				ORDER BY person.status ASC, family_name ASC, familyid, ab.rank ASC, gender DESC
                )

        )

    [1] => Array
        (
            [file] => /home/jethro/code/2.30.1/views/view_6_attendance__2_display.class.php
            [line] => 361
            [function] => getAttendances
            [class] => Attendance_Record_Set
            [type] => ::
            [args] => Array
                (
                    [0] => [Object/Array]
                    [1] => [Object/Array]
                    [2] => [Object/Array]
                    [3] => 2006-01-02
                    [4] => 2012-01-01
                )

        )

    [2] => Array
        (
            [file] => /home/jethro/code/2.30.1/views/view_6_attendance__2_display.class.php
            [line] => 73
            [function] => _printResultsTabular
            [class] => View_Attendance__Display
            [type] => ->
            [args] => Array
                (
                )

        )

    [3] => Array
        (
            [file] => /home/jethro/code/2.30.1/include/system_controller.class.php
            [line] => 186
            [function] => printView
            [class] => View_Attendance__Display
            [type] => ->
            [args] => Array
                (
                )

        )