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_... . 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]]
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_... . 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.orgmailto:Commons-l@lists.wikimedia.org