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
*/

SELECT
  page_title,
  cat_pages,
  cat_subcats
FROM page
JOIN categorylinks
ON cl_to = page_title
RIGHT JOIN category
ON cat_title = page_title
WHERE page_id = cl_from
AND page_namespace = 14;
SQL

Checking query status...
