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,
					archive_name,
					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
					) o
			group by file_title
			having	min(archive_name)=archive_name
		) old
;
SQL

Checking query status...
