missingtopics - Quarry

SQL

/*
SELECT p0.page_title
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 from pagelinks
where pl_namespace in (0)
and pl_from_namespace in (2) and pl_from in (9210005)
inner join page on page.page_title = pagelinks.pl_title
and page.page_namespace in (0)
SQL

Checking query status...
