I wrote a query in the Developer Console, and when I ran it, at the top of the screen it shows "Query Results - Total Rows: 258". Below that, in the preview panel, it only shows 8 records.
I know that normally when the "Query Results - Total Rows" count is in the thousands, it won't display all the records in the preview, which is fine. However, I've never had it refuse to show more than a handful of records when the total is that much higher.
Any idea as to why I'm not seeing the remaining records?
SELECT Id, Name, CreatedDate, Createdby.Name, Old_Org_Id__c, (SELECT Id FROM Orders), (SELECT Id from Opportunities), (SELECT Id From Contacts), (SELECT Id from Tasks), (SELECT Id from Events) FROM Account WHERE BillingStreet = null AND BillingCity = null AND BillingState = null AND BillingPostalCode = null AND ShippingStreet = null AND ShippingCity = null AND ShippingState = null AND ShippingPostalCode = null AND AP_Account__c = null AND AR_Account__c = null AND (NOT Name LIKE '%DADM%')