Untitled query #63531

SQL

select
  distinct page_title
from
  globalimagelinks
  join page on page_namespace = 6
  and page_title = gil_to
where
  gil_wiki = "metawiki"
  and gil_page_namespace_id=2
  and gil_page_title like "%WMF%" and gil_page_title not like "%/%" and gil_page_title not like "%WMFr"
  and not exists (
    select
      1
    from
      categorylinks parent
    where
      parent.cl_from = page_id
      and (
        parent.cl_to = "Wikimedia_Foundation_staff"
        or exists (
          select
            1
          from
            categorylinks grandparent
            join page ppage on ppage.page_namespace = 14
            and ppage.page_title = parent.cl_to
          where
            grandparent.cl_from = ppage.page_id
            and grandparent.cl_to in  ("Wikimedia_Foundation_staff","Wikimedia_Foundation_former_staff_members")
        )
      )
  )
SQL

Checking query status...
