enwiki: All non-free media usage

SQL

select  file_title,
        file_size,
        file_uploader,
        file_uploader_o,
        file_upload_timestamp,
        file_desc_timestamp,
        page_namespace,
        page_title
from	(
			select	cl_from as file_id
			from	categorylinks
			where	cl_to = "All_non-free_media" and cl_type = "file"
			limit	10
		) cl
		natural left join
		(
			select	page_id as file_id,
					page_title as file_title,
					page_latest as file_rev_id
			from	page
			where	page_namespace = 6
		) p
		natural left join
		(
			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
		) img
		natural left join
		(
			select	rev_id as file_rev_id,
					rev_timestamp  as file_desc_timestamp
			from	revision
		) rev
		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
        natural left join
        (
            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
                        outer 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
        ) old
;
SQL

Checking query status...
