Query test 14 - Quarry

SQL

SELECT pl_target_id FROM pagelinks
GROUP BY pl_target_id HAVING COUNT(*)<=1
LIMIT 10;

/*SELECT lt_title, lt_id FROM linktarget
WHERE lt_namespace = 0
LIMIT 100;*/

/*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 1275 AND 1300
AND page_title IN (
SELECT DISTINCT lt_title FROM linktarget
WHERE lt_namespace = 0
AND lt_id IN (
  SELECT pl_target_id
	FROM pagelinks
	WHERE pl_from_namespace = 0
  AND pl_from NOT IN
  (SELECT 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 pl_target_id
    FROM pagelinks
    WHERE pl_from = 4195411
   )
   AND pl_target_id IN
   (SELECT pl_target_id FROM pagelinks
    GROUP BY pl_target_id HAVING COUNT(*)<=1
   )
   )
)
);*/

/*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 1275 AND 1300 
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
   )
   )
    LIMIT 10;
*/

/*SELECT pl_backlinks_namespace_target_id
	FROM pagelinks
	WHERE pl_from_namespace = 0
	AND pl_backlinks_namespace.pl_namespace = 0
	AND pl_backlinks_namespace.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 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
   )
   )*/
SQL

Checking query status...
