USE itwiki_p;

SELECT CONCAT('[[', page_title, ']]')

FROM page

WHERE page_namespace = 0

AND page_is_redirect = 0

AND page_title NOT IN (

  SELECT pl_title

  FROM pagelinks

  WHERE pl_from_namespace = 0

  AND pl_namespace = 0

  AND pl_title = page_title

  AND pl_from NOT IN

  (SELECT page_id

   FROM page

   LEFT JOIN pagelinks

   ON pl_title = page_title

   AND pl_namespace = page_namespace

   WHERE page_namespace=0

   AND page_is_redirect=1

   AND pl_namespace IS NULL)

  AND pl_from NOT IN

  (SELECT 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 cl_from

    FROM categorylinks, pagelinks

    WHERE cl_to = pl_title

    AND pl_namespace = 14

    AND pl_from = 4195411) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */

ORDER BY page_len DESC;