NFC in BLPs - Quarry

SQL

select	*
from	(
  			select	*
            from	(
                select	cl_from as file_id
                from	categorylinks
                where	cl_to = 'All_non-free_media' and cl_type = 'file'
            ) cl1
            natural left join
            (
                select	page_id as file_id,
                        page_title as file_title
                from	page
                where	page_namespace = 6
            ) p
        )
        natural join
		(
			select	file_title,
					page_namespace,
					page_title
			from	(
						select	il_to as file_title,
								il_from as page_id
						from imagelinks
					) links
          			natural join
          			(
                        select	cl_from as page_id
                        from	categorylinks
                        where	cl_to = 'Living_people' and cl_type = 'page'
                    ) cl2
          			natural join
					(
						select	page_id,
								page_namespace,
								page_title
						from	page
                        where	page_namespace = 0
					) pages
		) file_usage
;
SQL

Checking query status...
