Voci orfane senza interwiki di piccole dimensioni (<1KB)

SQL

USE itwiki_p;
SELECT DISTINCT CONCAT('# [[',REPLACE(page_title,'_',' '),']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title NOT IN (
  SELECT DISTINCT pl_title
  FROM pagelinks
  WHERE pl_from_namespace = 0
  AND pl_namespace = 0
  AND pl_title = page_title
  AND pl_from NOT IN
  (SELECT DISTINCT cl_from
   FROM categorylinks, pagelinks
   WHERE cl_to = pl_title
   AND pl_namespace = 14
   AND pl_from = 4195411)) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
AND page_id NOT IN
   (SELECT DISTINCT cl_from
    FROM categorylinks, pagelinks
    WHERE cl_to = pl_title
    AND pl_namespace = 14
    AND pl_from = 4195411) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
    /*
AND page_title NOT IN (
SELECT DISTINCT page_title
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id IN
(SELECT DISTINCT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
 AND tl_title = 'O'))
 */
ORDER BY page_len DESC
LIMIT 10;
SQL

Checking query status...
