enwiki: All non-free media usage

SQL

use enwiki_p;
select  files.*,
        file_desc_timestamp,
        page_namespace,
        page_title
from    (
            select  img_name as file_title,
                    img_width*img_height as file_size,
                    img_user_text as file_uploader,
                    img_timestamp as file_upload_timestamp
            from    image
        ) files
        natural left join
        (
            select  file_title,
                    rev_timestamp as file_desc_timestamp
            from    (
                        select  page_title as file_title,
                                page_latest as rev_id
                        from    page
                        where   page_namespace = 6
                    ) file_desc
                    natural left join
                    (
                        select  rev_id,
                                rev_timestamp
                        from    revision
                    ) rev
        ) curr_file_desc
        natural left join
        (
            select  file_title,
                    page_namespace,
                    page_title
            from    (
                        select  il_to as file_title,
                                il_from as page_id
                        from imagelinks
                    ) links
                    natural left join
                    (
                        select  page_id,
                                page_namespace,
                                page_title
                        from    page
                    ) pages
        ) file_usage
;
SQL

Checking query status...
