Extensions with no source code location

SQL

use mediawikiwiki_p;
select
  concat("Extension:",(select page_title from page where page_id=a.cl_from)) as "title"
from
  categorylinks a
where 
  a.cl_to = "All_extensions"
  and not exists (
    select
      1
    from
      categorylinks b
    where
      b.cl_from = a.cl_from
      and b.cl_to in (
        "Extensions_which_host_their_code_in-wiki",
        "Extensions_in_GitHub_version_control",
        "Extensions_in_GitLab_version_control",
        "Extensions_in_Wikimedia_version_control",
        "Extensions_in_Google_Code_version_control",
        "Extensions_in_SourceForge_version_control",
        "Extensions_in_BitBucket_version_control",
        "Extensions_with_a_broken_download_link"
      )
  )
SQL

Checking query status...
