Tried, never reached

What puts someone on this list

p.last_contacted_at IS NULL AND (SELECT MAX(occurred_at) FROM touches tt WHERE tt.person_id = p.id) IS NOT NULL AND (SELECT MAX(occurred_at) FROM touches tt WHERE tt.person_id = p.id) < UTC_TIMESTAMP() - INTERVAL 1 DAY AND p.stage NOT IN ('archived','nurture')

Nobody is added or removed by hand. The list re-runs on every page load, so logging a conversation drops that person off it immediately.