missingtopics - Quarry

SQL

/*
SELECT p0.page_id
FROM categorylinks
INNER JOIN page p0 ON p0.page_id = categorylinks.cl_from
WHERE
  categorylinks.cl_type = 'page'
  AND p0.page_namespace IN (0)
  AND (
    categorylinks.cl_to LIKE 'كيمياء'
    OR categorylinks.cl_to IN (
      SELECT p0.page_title
      FROM categorylinks
      INNER JOIN page p0 ON p0.page_id = categorylinks.cl_from
      WHERE categorylinks.cl_to LIKE 'كيمياء'
      AND categorylinks.cl_type = 'subcat'
      AND p0.page_namespace IN (14)
    )
)


*/
SELECT pl_title, COUNT(*) AS count
FROM pagelinks
WHERE pl_namespace IN (0)
AND pl_from_namespace IN (0)
AND pl_from in (

  SELECT p0.page_id
    FROM categorylinks
    INNER JOIN page p0 ON p0.page_id = categorylinks.cl_from
    WHERE
      categorylinks.cl_type = 'page'
      AND p0.page_namespace IN (0)
      AND (
        categorylinks.cl_to LIKE 'كيمياء'
       /*
        OR categorylinks.cl_to IN (
          SELECT p0.page_title
          FROM categorylinks
          INNER JOIN page p0 ON p0.page_id = categorylinks.cl_from
          WHERE categorylinks.to LIKE 'كيمياء'
          AND categorylinks.cl_type = 'subcat'
          AND p0.page_namespace IN (14)
        )
        */
    )

)
AND NOT EXISTS (
    SELECT 1
    FROM page
    WHERE page_title = pl_title
    AND page_namespace = 0
)
GROUP BY pl_title;
SQL

Checking query status...
