Voci senza interlink e con un solo link in ingresso (ricerca per dimensione)

SQL

SELECT CONCAT("# [[", page_title, "]], (", DATE_FORMAT(rev_timestamp, '%e %b %Y, %H:%i'), ")")
FROM page, revision
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_page = page_id
AND rev_parent_id = 0
AND page_len < 1000
AND page_title 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
   WHERE page_is_redirect = 1)
    AND pl_from NOT IN
  (SELECT cl_from
   FROM categorylinks, pagelinks
   WHERE cl_to = pl_title
   AND pl_namespace = 14
   AND pl_from = 4195411)
  	GROUP BY pl_title HAVING COUNT(*)=1
)
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)
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks
 WHERE cl_to LIKE 'Dipinti%'
OR cl_to LIKE 'Frasi%'
OR cl_to LIKE 'Prenomi%'
OR cl_to LIKE 'Vini%')
AND page_id NOT IN
(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 ('Bio','Esogeologia','Film','Libro','Minerale')))
AND page_id NOT IN
(SELECT ll_from
FROM langlinks)
ORDER BY rev_timestamp;

/*SELECT DISTINCT page_title
FROM page, revision
WHERE page_id = rev_page
AND rev_parent_id = 0
AND page_namespace = 0
AND page_is_redirect = 0
AND page_len < 1000
AND page_title 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
   WHERE page_is_redirect = 1)
    AND pl_from NOT IN
  (SELECT cl_from
   FROM categorylinks, pagelinks
   WHERE cl_to = pl_title
   AND pl_namespace = 14
   AND pl_from = 4195411)
  	GROUP BY pl_title HAVING COUNT(*)=1
)
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks, pagelinks
WHERE cl_to = pl_title
AND pl_namespace = 14
AND pl_from = 4195411)
AND page_id NOT IN
(SELECT ll_from
FROM langlinks)
AND page_id NOT IN
(SELECT cl_from
FROM categorylinks
WHERE cl_to LIKE 'Cortometraggi%'
OR cl_to LIKE 'Dipinti%'
OR cl_to LIKE 'Film%'
OR cl_to LIKE 'Frasi%'
OR cl_to LIKE 'Prenomi%'
OR cl_to LIKE 'Vini%'
OR cl_to LIKE '%Groenlandia'
OR cl_to LIKE '%italiani'
OR cl_to LIKE '%italiani%')
AND page_id NOT IN 
	(SELECT tl_from
    FROM templatelinks
	WHERE tl_namespace = 10
	AND tl_title IN ('Esogeologia', 'Minerale'))
ORDER BY rev_timestamp
LIMIT 1;*/
SQL

Checking query status...
