Oh thanks for the tip! I cracked open the sqlite3 file and found 5119 rows matching that MimeType. But when I look at the schema for the content table, I don't see an obvious way to map a row to the numbered folders containing the text. There has to be some way the Kobo is looking up which folder to load for an article, is it somewhere else in the database? These are the columns on "content":
Code:
ContentID, ContentType, MimeType, BookID, BookTitle, ImageId, Title, Attribution, Description, DateCreated, ShortCoverKey, adobe_location, Publisher, IsEncrypted, DateLastRead, FirstTimeReading, ChapterIDBookmarked, ParagraphBookmarked, BookmarkWordOffset, NumShortcovers, VolumeIndex, ___NumPages, ReadStatus, ___SyncTime, ___UserID, PublicationId, ___FileOffset, ___FileSize, ___PercentRead, ___ExpirationStatus, FavouritesIndex, Accessibility, ContentURL, Language, BookshelfTags, IsDownloaded, FeedbackType, AverageRating, Depth, PageProgressDirection, InWishlist, ISBN, WishlistedDate, FeedbackTypeSynced, IsSocialEnabled, EpubType, Monetization, ExternalId, Series, SeriesNumber, Subtitle, WordCount, Fallback, RestOfBookEstimate, CurrentChapterEstimate, CurrentChapterProgress, PocketStatus, UnsyncedPocketChanges, ImageUrl, DateAdded, WorkId, Properties, RenditionSpread, RatingCount, ReviewsSyncDate, MediaOverlay, MediaOverlayType, RedirectPreviewUrl, PreviewFileSize, EntitlementId, CrossRevisionId, DownloadUrl, ReadStateSynced, TimesStartedReading, TimeSpentReading, LastTimeStartedReading, LastTimeFinishedReading, ApplicableSubscriptions, ExternalIds, PurchaseRevisionId, SeriesID, SeriesNumberFloat, AdobeLoanExpiration, HideFromHomePage, IsInternetArchive, titleKana, subtitleKana, seriesKana, attributionKana, publisherKana, IsPurchaseable, IsSupported, AnnotationsSyncToken, DateModified, StorePages, StoreWordCount, StoreTimeToReadLowerEstimate, StoreTimeToReadUpperEstimate, Duration, IsAbridged, SyncConflictType