Problem you have encountered:
I have an app that allows people to create travel blogs and tag them with the cities that are the subject of the blog. I want users to view a feed of blogs (ordered by most recent) by specifying the cities they want to see blogs contain information about, for example Tokyo, Kyoto and Osaka. The data should be delivered in pages.
There is no support for a logical AND on an array field while also ordering by a timestamp and specifying a limit.

What you expected to happen:
A logical AND can be performed on an array field with order by and limit

Steps to reproduce:
* create a collection containing documents with an array and a timestamp
* attempt to query the collection to get results where the query array is a subset of the document's array, the results are ordered by timestamp and the results are limited for pagination

Other information (workarounds you have tried, documentation consulted, etc):
I have tried using maps instead of arrays as described here:
https://stackoverflow.com/questions/63852721/firestore-query-array-contains-all
This doesn't work with order by

I also tried a reverse lookup as described by:
https://stackoverflow.com/questions/47960930/how-to-automatically-create-indexes-for-cloud-firestore
This also doesn't work with order by