SQL
x
select
page_id,
page_title,
concat("Talk:", page_title) as page_full_title
from page
where
page_namespace = 1
and page_title not in (
select 1
from pagelinks
where pl_from = 65539331 -- User:MajavahBot/DYK blurb not found
and pl_namespace = 1
)
and exists (
select 1
from categorylinks
where cl_from = page_id
and cl_to = "Pages_using_DYK_talk_with_a_missing_entry"
)
limit 50;
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.