Pages which link to themselves without using {{Cite ...}}

SQL

WITH lt AS (SELECT lt_id AS lt FROM linktarget WHERE lt_namespace=10 AND lt_title LIKE "Cite%"
           UNION SELECT lt_id AS lt FROM linktarget WHERE lt_namespace=10 AND lt_title = "Short_description")
SELECT page_title
FROM page
JOIN linktarget ON  lt_namespace=0 AND lt_title=page_title
JOIN templatelinks TLa ON TLa.tl_from=page_id AND TLa.tl_target_id=lt_id
LEFT JOIN templatelinks TLt ON TLt.tl_from=page_id AND TLt.tl_target_id IN (SELECT lt FROM lt)
WHERE page_namespace=0 AND page_title LIKE "A%"
AND TLt.tl_from IS NULL

SQL

Checking query status...