I have observed very weired nature in Lists result.

I run this query in query editor:

```
select id, Title, Description, FileType,FeaturedContentDate,FeaturedContentBoost,ContentDocumentId,TagCsv
from  ContentVersion
where FeaturedContentDate!=null and FeaturedContentBoost!=null
Order By CreatedDate Desc

```

**I got 2 records.**

I used same query in Apex: for sfdc user- 2 records,partner users-87 records

I received very shocking result for partner users:

```
system.debug('before content list-->'+contentList); //zero
for(ContentVersion cont:[
    select id, Title, Description, FileType,FeaturedContentDate,FeaturedContentBoost,ContentDocumentId,TagCsv
    from  ContentVersion
    where FeaturedContentDate!=null and FeaturedContentBoost!=null
    Order By CreatedDate Desc]
    ){
    contentList.add(cont);    
}
system.debug('--contentList size()--->'+contentList.size()); //87

```

**I received 87 records.**

How its possible?

* I logged in as partner user & tried this logic works in sandbox (its working as expected) & moving the code to another sandbox,while doing the testing I rec ivied above result.

**I have used withsharing also.but I can see same result**

for testing purpose:

```
public class testContent {
public static void test(){
    List<ContentVersion>contentList1=[select id, Title, Description, FileType,FeaturedContentDate,FeaturedContentBoost,ContentDocumentId,TagCsv from  ContentVersion
                                      where FeaturedContentDate!=null and FeaturedContentBoost!=null  Order By CreatedDate Desc];
    system.debug('----contentList1----'+contentList1.size());
}

}

```

***for sfdc user i will getlist count is 2.for partner user result is 87*** .