User:Kotepho/reports/queries, scripts, and scratch

Table for joining on when you want to get real page titles

Images by copyright status statistics: Complicated and with hacky perl code that probably needs to be thrown out and re-written.... I'll get around to it eventually I guess

/Images in pages in Cat: User templates:

/Media used in namespaces other than 0 that contain a template on the image description page that is in category:Non-free_image_copyright_tags:


 * both listed on their pages

/deleted page by time:

I think

/deleted page by page id:

/deleted page by cl_timestamp:

+ some one off seds that I don't recall atm (I probably also used into outfile to make it easier on my self, will troll .bash_history or redo it later)

/admin/total/ graphs:

comment out the total line with a # (or just don't use rollup, but I wanted it)

/admin/total/by_user:

/admin/total/blocks:

/admin/month/blocks:

Terribly slow--table scan, temporary table, filesort