Öksüz Madde Kontrolü

SQL

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 =  'Öksüz_maddeler_Haziran_2024' 
        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) > 0
        ORDER BY
          COUNT(pl.pl_from) DESC, orphan.page_title ASC;
SQL

Checking query status...
