Untitled query #4707

SQL

#select page_title from page join revision on page_latest = rev_id
#where page_namespace=0 and page_is_redirect=0
#and rev_timestamp between 20000101000000 and 20201102000000;
#select concat('# [[:نقاش المستخدم:',page_title,']]') from page
#where page_namespace=3
#and page_is_redirect=0
#order by page_title asc
#limit 150000;
/*
SELECT
  page_namespace,
  page_title,
  page_id,
  page_latest,
  page_touched,
  page_links_updated
FROM page
WHERE page_links_updated IS NULL;*/

			SELECT
				p2.page_title,
				p2.page_namespace,
				p2.page_id,
				p2.page_is_redirect
			FROM page as p1
			RIGHT JOIN page as p2
				ON p1.page_title = p2.page_title
				AND p1.page_namespace = 14
			WHERE p2.page_namespace = 15
            AND p2.page_title NOT LIKE "%/%"
			AND   p1.page_title IS NULL
            limit 5;
SQL

Checking query status...
