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 concat("# [[:Category talk:", p2.page_title, "]]")
			#	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   p1.page_title IS NULL
            AND p2.page_title NOT LIKE "%/%"
            limit 5000;*/
SQL

Checking query status...
