Hey guys I'm having an issue getting my first inner select working and just haven't gotten it to work no matter what I've tried. Does anyone see why I can't select User.Name, User.Email and User.SmallPhotoUrl? I would just use CreatedBy, but the issue is that the SObject NAME does not provide SmallPhotoUrl =(
I get errors like this
MALFORMED_QUERY: FeedComment.CreatedBy.ProfileId = Users.ProfileId ^ ERROR at Row:13:Column:72 unexpected token: 'Users.ProfileId'
SELECT Id, Type, ParentId, RelatedRecordId, ( SELECT Name, Email, SmallPhotoUrl FROM Users WHERE ( Users.ProfileId = UserFeed.CreatedBy.ProfileId ) ) Title, Body, CommentCount, LikeCount, LinkUrl, ContentFileName, ContentDescription, ContentType, ContentSize, CreatedDate, LastModifiedDate, ( SELECT Id, FeedItemId, ParentId, CommentBody, CommentType, RelatedRecordId, CreatedDate FROM FeedComments ORDER BY CreatedDate ASC ) FROM UserFeed WHERE ( ( ParentId = '005i0000000ZeaDAAS' ) AND ( LastModifiedDate > 2013-05-31T20:28:42.000000Z ) AND Type IN ( 'TextPost', 'LinkPost', 'ContentPost' ) ) OR ( ( CommentCount > 0 ) AND ( CreatedDate > 2013-05-31T20:28:42.000000Z ) AND Type IN ( 'TextPost', 'LinkPost', 'ContentPost' ) ) ORDER BY CreatedDate DESC