enwiki: All non-free media usage

This query is marked as a draft This query has been published by JJMC89.

SQL

select  file_title,
                    file_uploader as file_uploader_o
            from    (
                        select  oi_name as file_title,
                                oi_archive_name as archive_name,
                                oi_user_text as file_uploader
                        from    oldimage
                        union
                        select  fa_name as file_title,
                                fa_archive_name as archive_name,
                                fa_user_text as file_uploader
                        from    filearchive
                    )
            group by file_title
            having  min(archive_name)=archive_name
            limit 10;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...