Here I would say you SHOULDN'T use a "LEFT JOIN", because we're specifically looking for users WITH statuses.