Untitled query #70351

SQL

/*SELECT page.page_title
FROM page
JOIN categorylinks AS cl ON cl.cl_to = page.page_title
WHERE cl.cl_to NOT IN (SELECT cl2.cl_to FROM categorylinks AS cl2 WHERE cl2.cl_type = 'subcat')
AND page.page_namespace = 14
GROUP BY cl.cl_to
HAVING COUNT(*) = 1
*/
SELECT page.page_title
FROM page
LEFT JOIN categorylinks AS cl ON cl.cl_to = page.page_title
LEFT JOIN categorylinks AS cl2 ON cl2.cl_to = page.page_title AND cl2.cl_type = 'subcat'
WHERE cl.cl_to IS NULL
AND cl2.cl_to IS NULL
AND page.page_namespace = 14
SQL

Checking query status...
