Build list of (line) transcriptions from a given (page) element

Using a recursive query in sqlite, we should be able to list all the children elements of a given element, and immediately INNER JOIN on the transcriptions table.

That would provide us a recursive list of all transcriptions using the local cache.