Untitled query #55128

SQL

/* pagelinks changed - trying to work out fix...  */
SELECT orphan.page_title AS page, COUNT(pl.pl_from) AS count
        FROM page orphan
        INNER JOIN categorylinks cl ON orphan.page_id = cl.cl_from
         	AND cl.cl_to = 'Orphaned_articles_from_July_2014'
        INNER JOIN linktarget ON orphan.page_title = lt_title AND orphan.page_namespace = lt_namespace
        INNER JOIN pagelinks pl ON lt_id = pl_target_id
        INNER JOIN page p2 ON p2.page_id = pl.pl_from
        WHERE
          pl.pl_from_namespace = 0
          AND p2.page_is_redirect = 0
        GROUP BY
          orphan.page_title
        HAVING
          COUNT(pl.pl_from) > 1
        ORDER BY
          COUNT(pl.pl_from) DESC, orphan.page_title ASC;
/*
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 linktarget ON p.page_title = lt_title
   AND p.page_namespace = lt_namespace
INNER JOIN pagelinks link ON lt_id = link.pl_target_id
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) > 2
        ORDER BY
          COUNT(link.pl_from) DESC, p.page_title ASC;
          */
/*
select page_title  from page, pagelinks
where pl_namespace = 14 and pl_from_namespace = 14 and page_id = pl_from
and pl_from in (select tl_from from templatelinks where tl_target_id in (
  select lt_id from linktarget where lt_title = 'Category_redirect' and lt_namespace = 10
))
and pl_title not in (select page_title from page where page_namespace = 14);
*/

/* SELECT page_title, lt_title from page
INNER JOIN linktarget ON page_title = lt_title AND page_namespace = lt_namespace
INNER JOIN pagelinks ON lt_id = pl_target_id
WHERE lt_namespace = 14 and pl_from_namespace = 14 and page_id = pl_from
and pl_from in (select tl_from from templatelinks where tl_target_id in (
  select lt_id from linktarget where lt_title = 'Category_redirect' and lt_namespace = 10
))
and lt_title not in (select page_title from page where page_namespace = 14);*/
SQL

Checking query status...
