matthiasmullie added a comment.
In T226093#5657414 <https://phabricator.wikimedia.org/T226093#5657414>, @Ramsey-WMF wrote: > Matthias will look into discrepancies between number of files with mediainfo slots vs. what's indexed in Cirrus. It looks like the difference is mostly revisions vs files. The 5.5+ number closely matches the amount of revisions with a mediainfo `slots` record: `SELECT COUNT(*) FROM slots WHERE slot_role_id = 2` = **6161688** That number includes all edits though (SDC edits as well as regular file page edits once the page got its first structured data) mediainfo slots grouped by page is more similar to the results we get from Cirrus: `SELECT COUNT(DISTINCT rev_page) FROM slots INNER JOIN revision ON slot_revision_id = rev_id WHERE slot_role_id = 2` = **2918327** (This number also includes pages that once had structured data, but which has since been deleted) TASK DETAIL https://phabricator.wikimedia.org/T226093 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: matthiasmullie Cc: Ladsgroup, Abit, matthiasmullie, Marostegui, Mholloway, Addshore, Ramsey-WMF, jcrespo, Yann, MarkTraceur, ArielGlenn, Aklapper, darthmon_wmde, Legado_Shulgin, DannyS712, Nandana, JKSTNK, Davinaclare77, Qtn1293, Techguru.pc, Lahi, PDrouin-WMF, Gq86, E1presidente, Cparle, Anooprao, SandraF_WMF, GoranSMilovanovic, Lunewa, Th3d3v1ls, Hfbn0, QZanden, Tramullas, Acer, LawExplorer, Salgo60, Zppix, Silverfish, _jensen, rosalieper, Scott_WUaS, Susannaanas, Wong128hk, gnosygnu, Jane023, Wikidata-bugs, Base, aude, Ricordisamoa, Wesalius, Lydia_Pintscher, Fabrice_Florin, Raymond, faidon, Steinsplitter, Mbch331, Jay8g, fgiunchedi
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
