Topic on Talk:Quarry

Lately I was adding SDC statements P7482=Q66458942 to files that have {{Own}} template on Commons, using https://quarry.wmflabs.org/query/40759 query. User:Schlurcher pointed out cases where people are incorrectly using {{Own}} template for files where person listed as author is not the uploader. I would like to exclude such cases in the future query and find files where I added P7482, but where uploader is not the same as the author listed in {{Information}} template.

https://quarry.wmflabs.org/query/40838 query can find my edits from this month to files and can find the name of the original uploader. Anybody knows how to find the name listed as "author"? Extension:Media Viewer displays "author" so I assume it is stored somewhere. Any ideas?

You will have to use API (or parsing of desciption pages). Database doesn't have that info. Also Mediaviewer gets author with API: today's POTD example

Edgars2007, Thank you for reply. API is not a very useful solution as I was hoping to write SQL query that compares the uploader to the author (listed in {{information}} template). Do SQL queries have access to the wikitext of the files? I could just get the author through regular expressions.

Yes, I understand that it's not useful, creates a headache etc.  :)

And no, database doesn't have the wikitext of pages.