Untitled query #16231

SQL

USE commonswiki_p;
SELECT concat("File:", p.page_title) AS ad
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 cl2.cl_from
FROM categorylinks cl2 JOIN
(SELECT ppp.page_id AS id, ppp.page_title AS ad FROM page ppp WHERE ppp.page_namespace =14 
) AS pc
ON  pc.ad = cl2.cl_to
WHERE  pc.id not in 
(SELECT DISTINCT(pp_page) FROM page_props WHERE pp_propname IN ("hiddencat") )
)
AND cl_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 DAY), '%Y%m%d%H%i%s') 
group by p.page_id
order by p.page_latest asc
;
SQL

Checking query status...
