Adrian_dlcspm

SELECT
        firstName, lastName, DATE_FORMAT( MAX(sundays_date), "%M %D %Y" ) AS "lastSpoke",
        DATE_FORMAT( MAX(C.date), "%M %D %Y" ) AS "lastPrayed"
FROM members A
	LEFT JOIN components B ON
	(
		A.id = B.type_id
		AND B.branch = A.branch
		AND B.events_id IN (200, 201, 202, 203, 204)
	)
	LEFT JOIN prayers C ON
	(
		members_id = A.id
		AND C.branch_id = A.branch
	)
WHERE A.branch = 1
GROUP BY A.id
ORDER BY lastName ASC, firstName ASC