Untitled query #72742

SQL

select  p1.page_id,p1.page_title from categorylinks
        inner join page p1 on p1.page_id = categorylinks.cl_from
        where cl_to in (select page_title from page where page_id in (1899093)) and cl_type in ("page") and p1.page_namespace = 0
        AND (p1.page_id, p1.page_title) NOT IN (
          select p1.page_id,p1.page_title from pagelinks
          inner join page p1 on p1.page_id = pagelinks.pl_from
          where pl_from_namespace = 0 and pl_namespace = 100 and pl_title in (select page_title from page where page_id in (5428388))
        )
SQL

Checking query status...
