enwiki: All non-free media usage

SQL

select	file_title,
		file_size,
		file_uploader,
		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'
		) 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
;
SQL

Checking query status...
