Fork of
mp7.4 Pages having (disambiguation) in the title while not having DAB template (including set index articles)
by Saeidpourbabak
This query is marked as a draft
This query has been published
by Yamaha5.
SQL
x
USE fawiki_p;
SELECT CONCAT ('# [[',page_title,']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title LIKE "%(ابهام%زدا%"
AND page_id NOT IN (
SELECT pp_page
FROM page_props
WHERE pp_propname = 'disambiguation'
)
ORDER BY page_title;
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.