From: Hoo man <hoo@online.de>

Date: Sat, 10 Sep 2011 15:11:33

First of all I guess you want that on commons?! And what data do you need in detail? File name - file size - upload time or even more? I think it's possible, though it will be slow...

From: Avicennasis <Avicennasis@gmail.com>

Date: Sat, 10 Sep 2011 15:15:26

Actually, I was looking for this on EnWp. ![][1] AFAIK, there is no tracking category of orphaned images on Commons. On EnWp, the cat has ~87k images.

I believe mainly the upload date and size will help users cleanup the category. Can't think of much else that would really help.

[1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif

From: Hoo man <hoo@online.de>

Date: Sat, 10 Sep 2011 15:17:36

Ah ok, so what data do you need in detail?

From: Hoo man <hoo@online.de>

Date: Sat, 10 Sep 2011 15:58:35

SQL:

SELECT /* SLOW_OK */ img_name, img_timestamp, LEFT(img_timestamp, 6), img_size, img_user_text, img_minor_mime FROM categorylinks INNER JOIN page ON cl_from = page_id INNER JOIN image ON img_name = page_title WHERE cl_to = 'Orphan_images' AND page_namespace = 6

Result:
http://toolserver.org/~hoo/dbq/dbq-154.txt (plain text)

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: hoo@online.de
CC list: hoo@online.de, Avicennasis@gmail.com