Untitled query #28158

SQL

USE commonswiki_p;
SELECT concat('File:', p.page_title) AS fqp
FROM page p JOIN categorylinks cl ON cl.cl_from = p.page_id WHERE p.page_namespace = 6 AND p.page_id NOT IN
(SELECT fcj.cl_from
FROM categorylinks fcj JOIN
(SELECT ppp.page_id AS id, ppp.page_title AS fqp
FROM page ppp
WHERE ppp.page_namespace = '14'
) AS pc
ON  pc.fqp = fcj.cl_to
WHERE  pc.id not in
(SELECT DISTINCT(pp_page)
FROM page_props
WHERE pp_propname IN ('hiddencat') )
)
AND page_id not in
(
SELECT
  page_id
FROM page
JOIN templatelinks
ON page_id = tl_from
WHERE (tl_title='Uncategorized' OR tl_title='Uncategorized-Geograph' OR tl_title='Check_categories')
AND tl_namespace = '10'
)
AND page_is_redirect = '0'
group by p.page_id
order by p.page_latest asc
;
SQL

Checking query status...
