Thank you so much for this, this is very useful. But i am getting compilation error.
This is working fine "SELECT Type, ParentId, Parent.Type, title,body,Parent.Name, CreatedBy.FirstName FROM FeedItem". But above code give us compilation error.
Have you tried this query ?

Hi Manish,
Yes, I've successfully used the final query in the post. Is this the one that's giving you an error? What is the error?

SELECT Id, Body, Title, Parent.Name, CreatedDate
TYPEOF InsertedBy WHEN User THEN Name, MediumPhotoUrl END
FROM FeedItem
WHERE CreatedDate = LAST_N_DAYS:30
ORDER BY CreatedDate DESC

Hi Jami,
Yes I am using last query posted on this article. I am getting compilation error.
Please have a look on below error. https://uploads.disquscdn.c...

You need to add a comma after CreatedDate. I'll update the gist.

https://gist.github.com/jam...

Thank you, this is working now.