NFC in BLPs - Quarry

SQL

select  concat('[[:File:',blp.file_title,']]') as file, concat('[[',blp.page_title,']]') as article
from    (
            select  page_title as file_title
            from    (
                        select  cl_from
                        from    categorylinks
                        where   cl_to = 'All_non-free_media' and cl_type = 'file'
                    ) as cl1
                    left join
                    (
                        select  page_id,
                                page_title
                        from    page
                        where   page_namespace = 6
                    ) as p1
                    on cl1.cl_from = p1.page_id
        ) as nfm
        join
        (
            select  il_to as file_title,
                    page_title
            from    (
                        select  il_to,
                                il_from
                        from imagelinks
                    ) as il
                    join
                    (
                        select  cl_from
                        from    categorylinks
                        where   cl_to = 'Living_people' and cl_type = 'page'
                    ) as cl2
                    on il.il_from = cl2.cl_from
                    join
                    (
                            select  page_id,
                                    page_title
                            from    page
                            where   page_namespace = 0
                    ) as p2
                    on il.il_from = p2.page_id
        ) as blp
        on nfm.file_title = blp.file_title
        order by file_title, page_title
;
SQL

Checking query status...
