User talk:Multichill/Categorization stats

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

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)