User talk:Multichill/Categorization stats
Jump to navigation
Jump to search
mysql> SELECT COUNT(*) FROM image JOIN page ON img_name=page_title JOIN templatelinks ON page_id=tl_from WHERE "20090101000000" < img_timestamp AND img_timestamp < "20090121000000" AND page_namespace=6 AND page_is_redirect=0 AND tl_namespac e=10 AND tl_title="Uncategorized"; +----------+ | COUNT(*) | +----------+ | 7379 | +----------+ 1 row in set (2 min 52.98 sec) mysql> SELECT COUNT(*) FROM image JOIN page ON img_name=page_title WHERE "20090101000000" < img_timestamp AND img_timestamp < "20090121000000" AND page_namespac e=6 AND page_is_redirect=0; +----------+ | COUNT(*) | +----------+ | 89762 | +----------+ 1 row in set (6.44 sec) mysql> SELECT COUNT(*) FROM image JOIN page ON img_name=page_title JOIN templatelinks ON page_id=tl_from WHERE "20090101000000" < img_timestamp AND img_timestamp < "20090121000000" AND page_namespace=6 AND page_is_redirect=0 AND tl_namespac e=10 AND tl_title="Check_categories"; +----------+ | COUNT(*) | +----------+ | 518 | +----------+ 1 row in set (7 min 6.78 sec) mysql>
Sudden drop
[edit]I'm trying to monitor this stat after 2013-04-17 when the UploadWizard uncollapsed the category field (bugzilla:31292, MediaWiki 1.22wmf2). In doing so I noticed a big drop of about 40k files between May 8 and 9, what happened? --Nemo 07:45, 22 May 2013 (UTC)