Untitled query #17569

SQL

USE svwiki_p;


SELECT p1.page_title, cl_to FROM categorylinks 
INNER JOIN page p1 ON cl_from=p1.page_id 
INNER JOIN category ON cl_to=cat_title
INNER JOIN page p2 ON cat_title=p2.page_title
INNER JOIN page_props ON p2.page_id=pp_page
WHERE p1.page_namespace = 2
AND p1.page_title LIKE '%/%'
MINUS 
SELECT p1.page_title, cl_to FROM categorylinks 
INNER JOIN page p1 ON cl_from=p1.page_id 
INNER JOIN category ON cl_to=cat_title
INNER JOIN page p2 ON cat_title=p2.page_title
INNER JOIN page_props ON p2.page_id=pp_page
WHERE p1.page_namespace = 2
AND p1.page_title LIKE '%/%'
AND pp_propname = 'hiddencat'
LIMIT 10
/*
AND NOT pp_propname = 'wikibase_item'
AND NOT pp_propname = 'defaultsort'
AND NOT pp_propname = 'page_image_free'
LIMIT 1000
*/
/*
SELECT * FROM page_props INNER JOIN page ON pp_page=page_id
WHERE pp_propname = 'hiddencat'
LIMIT 100
*/
SQL

Checking query status...
