Thank you I was not familiar with revision table. Jarek T. [[user:jarekt]] From: commons-l-bounces(a)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(a)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.org<mailto:Commons-l@lists.wikimedia.org> https://lists.wikimedia.org/mailman/listinfo/commons-l