Scanning the lookups are all the _ids the same in all collections for matching data? Is the PK the same in all collections?