Custom Query on a view does not display the correct number of pages for Service Now Alerts

Here is the SWQ:L query 

SELECT
ai.IncidentNumber as [Incident Number],
ai.State as [Incident Status],
o.EntityCaption AS [ALERT OBJECT],
ai.AssignmentGroup AS [Assignment Group],
ai.AssignedTo as [Assigned]
FROM Orion.ServiceNow.AlertIncident AS ai
INNER JOIN Orion.AlertObjects AS o ON o.AlertObjectId = ai.alertobjectid
where (ai.State = 'Pending' OR ai.State = 'New' or ai.State = 'In Progress') and ai.AssignmentGroup = 'Field Infrastructure Services - Firewalls'

The query works, it is to display 5 rows.  The query return 14 records  at the bottom it display Page 1 of 0.  If I click on show all, it shows all 14 of them. If I make the query removing the inner join  and the field the inner join returns  it display correct it says  Page 1 of 3

SELECT
ai.IncidentNumber as [Incident Number],
ai.State as [Incident Status],
ai.AssignmentGroup AS [Assignment Group],
ai.AssignedTo as [Assigned]
FROM Orion.ServiceNow.AlertIncident AS ai
where (ai.State = 'Pending' OR ai.State = 'New' or ai.State = 'In Progress') and ai.AssignmentGroup = 'Field Infrastructure Services - Firewalls'

Any ideas why?