Salesforce REST SOQL返回的结果少于预期

我使用以下一组查询从Salesforce REST端点提取数据:

SELECT COUNT(Id) FROM Table1__c WHERE CreatedDate < 2017-10-18T16:16:03Z

返回结果:216

SELECT Id FROM Table1__c WHERE CreatedDate < 2017-10-18T16:16:03Z ORDER BY CreatedDate ASC LIMIT 100 OFFSET 0

这将返回所需的100个结果,我将其格式化为下一个查询的格式:

'result1', 'result2',...,'result100'

然而,此查询仅返回 87 在所需的100条记录中:

SELECT 
Id, CreatedDate, A whole lotta fields,
(SELECT Name, more fields FROM Table2__r),
(SELECT Name, Even more fields FROM Table3__r),
(SELECT Name, Yeah, more fields FROM Table4__r),
(SELECT Name, You guessed it! more fields FROM Table5__r),
(SELECT Name, finally, the last fields FROM Table6__r) 
FROM Table1__c WHERE Id IN (previous formatted result)

Table1__c 并将结果限制为仅来自上一个查询的ID。然而,where子句似乎迫使它在 表1\uu c 其他的故事呢?我不完全确定。我正在查询Salesforce v39 REST接口。