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 < 2000*/ /* page length restriction */
/*AND page_len > 1000*/
AND page_title NOT IN (
  SELECT DISTINCT lt_title FROM linktarget		/*...that are linked only from pages not in NS0...*/
  WHERE lt_namespace = 0
  AND lt_title = page_title
  AND lt_id IN (
    SELECT pl_target_id
	FROM pagelinks
	WHERE pl_from_namespace = 0
    AND NOT pl_from = page_id		/*...and that are linked also from themselves...*/
    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 lt_title FROM linktarget
  WHERE lt_namespace = 0
  AND lt_title = page_title
  AND lt_id IN (
    SELECT pl_target_id
	FROM pagelinks
    WHERE pl_from_namespace = 0)))
  AND pl_from NOT IN			/*...and that are linked also from the pages reported in this special list...*/
      (SELECT DISTINCT cl_from
      FROM categorylinks, linktarget
      WHERE cl_to = lt_title
      AND lt_namespace = 14
      AND lt_id IN (
        SELECT pl_target_id
        FROM pagelinks
        WHERE 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_target_id IN
(SELECT DISTINCT lt_id
 FROM linktarget
 WHERE lt_namespace = 10
 AND lt_title IN ('O')))
  /*Soluzione temporanea...    
AND page_title NOT LIKE 'Nati_nel_%'
AND page_title NOT LIKE 'Morti_nel_%'
  Fine soluzione temporanea*/
ORDER BY page_len DESC;
SQL

Checking query status...
