check.sql

select
	people.id as person,
	statuses.status as original,
	actions.status_code as copy,
	statuses.created_at,
	actions.occurred_at
from
people
JOIN attendances ON attendances.person_id = people.id
JOIN statuses ON statuses.id = attendances.current_status_id
JOIN actions ON actions.id = attendances.latest_status_change_action_id
WHERE 
statuses.attendance_id = actions.attendance_id
AND
NOT (statuses.status = actions.status_code)