According to mw:Manual:Text_table the actual wikitext of pages is stored in text table However when I try to search it for specific string in https://quarry.wmflabs.org/query/31044 I get error "Table 'commonswiki_p.text' doesn't exist". So is there a way to access that table?
Topic on Talk:Quarry
No. As far as I understand, the table, if it were available, would just be pointers to the text in 'external storage' and be pretty much meaningless anyways without access to this 'external storage'. You can however query the text with Special:Search, or use indirect queries like with categorylinks or externallinks to get the features of the text.
Doesn't the text table also contain information about deleted revisions which shouldn't be publicly available?
The documentation states that the text may be in various formats (gzipped, stored elsewhere etc.) so a simple search query might not work. Besides, with the LIKE operator used in quarry:31044, the execution time would be proportional to the total number of text revisions on Commons, which would maybe be too slow.
Ah. this search query shall do :)
Thank you both. I never fully trusted regular search, but it seems like in this case it is better than SQL query.