SELECT accounts.id, accounts.name, calls.name subject
FROM accounts
INNER JOIN calls ON accounts.id = calls.parent_id
WHERE accounts.id=(
   SELECT c.parent_id
   FROM calls c
   WHERE c.parent_id = calls.parent_id
   ORDER BY c.date_modified DESC LIMIT 1
)