Fork of
Orphaned article talks on plwiki
by The Polish
This query is marked as a draft
This query has been published
by Darafsh.
SQL
AخA
use fawiki_p;
SELECT CONCAT("# [[بحث:",p1.page_title,"]]") AS page_title
FROM page AS p1
WHERE p1.page_title NOT LIKE '%/%'
AND p1.page_namespace = 1
AND NOT EXISTS (SELECT 1
FROM page AS p2
WHERE p2.page_namespace = 0
AND p1.page_title = p2.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.