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

SQL

USE itwiki_p;
SELECT CONCAT('# [[',REPLACE(page_title,'_',' '),']]') /*Check all the pages in NS0...*/
FROM page, pagelinks
WHERE page_namespace = 0
AND page_is_redirect = 0 
AND page_title IN (
  SELECT pl_title /*...that are linked only from pages not in NS0...*/
  FROM pagelinks
  WHERE pl_from_namespace = 0
  AND pl_namespace = 0
  AND pl_title = page_title
  AND page_id NOT IN					/*...and that are not the pages reported in this special list...*/
   (SELECT DISTINCT cl_from
    FROM categorylinks, pagelinks
    WHERE cl_to = pl_title
    AND pl_namespace = 14
    AND pl_from = 4195411) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
GROUP BY pl_title
  HAVING COUNT(*) = 1)
  AND pl_from_namespace = 0
  AND pl_namespace = 0
  AND pl_title = page_title
  AND page_id NOT IN					/*...and that are not the pages reported in this special list...*/
   (SELECT DISTINCT cl_from
    FROM categorylinks, pagelinks
    WHERE cl_to = pl_title
    AND pl_namespace = 14
    AND pl_from = 4195411) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
GROUP BY pl_title
  HAVING COUNT(*) = 1
LIMIT 1;
SQL

Checking query status...
