Orphans with incoming links

A on request version of Wikipedia:Database reports/Orphans_with_incoming_links (with 2+ links rather than 3+)

SQL

SELECT * FROM pagelinks LIMIT 10;
SHOW INDEX IN pagelinks; 
/*
SELECT p.page_title AS page, COUNT(link.pl_from) AS count
        FROM page p
        INNER JOIN categorylinks c ON p.page_id = c.cl_from
          AND c.cl_to = 'All_orphaned_articles'
        INNER JOIN pagelinks link ON p.page_title = link.pl_title
          AND p.page_namespace = link.pl_namespace
        INNER JOIN page p2 ON p2.page_id = link.pl_from
        WHERE
          link.pl_from_namespace = 0
          AND p2.page_is_redirect = 0
        GROUP BY
          p.page_title
        HAVING
          COUNT(link.pl_from) > 1       
        ORDER BY
          COUNT(link.pl_from) DESC, p.page_title ASC;*/

SQL

Checking query status...