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 BETWEEN 1600 AND 1700
AND page_title IN (
SELECT DISTINCT lt_title FROM linktarget
WHERE lt_namespace = 0
AND lt_title = page_title
AND lt_id IN (
  SELECT DISTINCT pl_target_id
	FROM pagelinks
	WHERE pl_from_namespace = 0
  AND pl_from NOT IN
  (SELECT DISTINCT page_id
   FROM page
   WHERE page_is_redirect = 1)
  AND pl_from NOT IN
  (SELECT DISTINCT cl_from
   FROM categorylinks, linktarget
   WHERE cl_to = lt_title
   AND lt_namespace = 14
   AND lt_id IN
   (SELECT DISTINCT pl_target_id
    FROM pagelinks
    WHERE pl_from = 4195411
   )
  )
  GROUP BY pl_target_id HAVING COUNT(*)=1
)
)
AND page_id NOT IN
     (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
   )
     )
AND page_id NOT IN
(SELECT cl_from
 FROM categorylinks 
 WHERE cl_to LIKE 'Brocardi%'
 OR cl_to LIKE 'Proverbi%'
 OR cl_to LIKE 'Motti%'
 OR cl_to LIKE 'Frasi%'
 OR cl_to LIKE 'Modi_di_dire%'
 OR cl_to LIKE 'Terminologia%latina' 
 OR cl_to LIKE 'Prenomi%'
 OR cl_to LIKE 'Cognomi%'
 OR cl_to LIKE '%Groenlandia'
 OR cl_to LIKE '%araldiche'
)
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 ('Aeromobile','Album','Alimentare','Area_protetta','Artista_musicale','Auto','Azienda','Biblioteca','Bio','Brano_musicale','Canale_radio','Casata','Cascata','Centrale_idroelettrica','Cimitero','Cocktail','Collegio_elettorale','Competizione_sportiva','Composizione_musicale','Composto_chimico','Computer','Coro','Corpo_celeste','Diga','Disclaimer','Discografia','Divisione_amministrativa','Dramma','Edificio_civile','Edificio_religioso','Emittente_TV','Esogeologia','FictionTV','Film','Fiume','Fotocamera_digitale','Fumetto_e_animazione','Gastronomia','Gioco','Grotta','Gruppi_EC','Impianto_sportivo','Infobox_nave','Isola','Libro','Massa_d''acqua','Medaglia','Minerale','Montagna','Motore','Museo','Nazionale_di_baseball','Onorificenza','Opera','Opera_d''arte','Opera_urbana','Organizzazione','Periodico','Personaggio','Porto','Programma','ReteTV','Rifugio','Santo','Sito_archeologico','Software','Squadra_di_pallacanestro','Stagione_squadra','Stazione_meteorologica','Strada','Struttura_militare','Tassobox','Telefono_cellulare','Trattato','Valico','Veicolo_militare','Videogioco','Vino','Vitigno')))
AND page_id NOT IN
(SELECT ll_from
FROM langlinks)
ORDER BY rev_timestamp;
SQL

Checking query status...
