rp2 categories containing no "disamb" in DAB pages

SQL

USE fawiki_p;
SELECT concat('[[رده:',REPLACE(cl_to,'_',' '),']]'),COUNT(cl_to)#,CONCAT ('# [[',page_title,']]')
FROM page INNER JOIN categorylinks ON cl_from = page_id INNER JOIN page_props ON pp_page=cl_from
WHERE cl_to NOT LIKE '%ابهام%'
AND pp_propname <> 'hiddencat'
AND page_namespace = 0
AND page_is_redirect = 0
AND page_title IN (
  SELECT page_title
  FROM page
  WHERE page_id IN (
    SELECT pp_page
    FROM page_props
    WHERE pp_propname = 'disambiguation')
)
GROUP BY cl_to
ORDER BY COUNT(cl_to) DESC;

SQL

Checking query status...