Voci orfane prive di tag O

SQL

USE itwiki_p;
SELECT CONCAT('# [[',REPLACE(page_title,'_',' '),']]') /*Check all the pages in NS0...*/
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0 
AND page_len < 1050 /* page length restriction */
AND page_len > 1010
AND page_title NOT IN (
  SELECT DISTINCT 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 pl_from NOT IN
  (SELECT DISTINCT page_id		/*...and that are linked also from orphaned redirects...*/
   FROM page
   WHERE page_namespace=0
   AND page_is_redirect=1
  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			/*...and that are linked also from 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 */
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 */
AND page_id NOT IN					/*...and that are not tagged previously as orphaned pages*/
(SELECT DISTINCT tl_from
FROM templatelinks
WHERE tl_namespace = 10
AND tl_title IN ('O'))
ORDER BY page_len DESC
LIMIT 100;
SQL

Checking query status...
