SQL
AخA
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"
)
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.