Voci orfane e senza interlink create fino al 2011

Fork of Voci di IP con tag O (2018) e senza interlink per data di creazione by Mess

This query is marked as a draft This query has been published by Mess.

SQL

USE itwiki_p;
SELECT CONCAT("# [[", page_title, "]], (", rev_timestamp, ")")
FROM page, revision
WHERE page_id = rev_page
AND rev_parent_id = 0
AND page_is_redirect = 0
AND page_namespace = 0
AND page_id IN (SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('O'))
AND page_id NOT IN
(SELECT ll_from
FROM langlinks)
AND page_id IN (
SELECT page_id
FROM page, revision
WHERE page_id = rev_id
AND rev_timestamp < 20120101000000) 
/* ORDER BY page_len DESC; */
ORDER BY rev_timestamp;

SQL

Checking query status...