Thank you I was not familiar with revision table.

Jarek T.

[[user:jarekt]]

From: commons-l-bounces@lists.wikimedia.org [mailto:commons-l-bounces@lists.wikimedia.org] On Behalf Of Ricordisamoa
Sent: Tuesday, September 15, 2015 4:31 PM
To: commons-l@lists.wikimedia.org
Subject: Re: [Commons-l] SQL help needed

Just join with the revision table: https://quarry.wmflabs.org/query/5207

Il 15/09/2015 21:25, Tuszynski, Jarek W. ha scritto:

Lately I wrote https://quarry.wmflabs.org/query/5201 to find Commons license templates with no transclusions, which were then listed for deletion at https://commons.wikimedia.org/wiki/Commons:Deletion_requests/Unused_license_templates .  Now I would like to also get list of creators of those templates, so I can alert them about the discussion. Is there some easy way to do it, or do I need to modify the query somehow to get it? If so does anybody have some example queries that do it?

Thanks

Jarek T.

[[user:jarekt]]

_______________________________________________
Commons-l mailing list
Commons-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/commons-l