SELECT lt.lt_title, count(lt.lt_title)
FROM templatelinks AS t
LEFT JOIN linktarget AS lt
    ON lt.lt_id = t.tl_target_id
    AND lt.lt_namespace = 10
LEFT JOIN page AS p
    ON p.page_title = lt.lt_title
WHERE t.tl_from_namespace = 0
    AND EXISTS (
        SELECT NULL
        FROM categorylinks AS c
        WHERE c.cl_from = p.page_id
            AND c.cl_to = 'Шаблоны:Незавершённые_статьи:Все'
        )
GROUP BY lt.lt_title
ORDER BY count(lt.lt_title) DESC
;