Pages with afd template with no corresponding discussion page

Fork of Pages with afd template with no corresponding discussion page by FoBe

This query is marked as a draft This query has been published by Rpi153.

SQL

SELECT DISTINCT page.page_title, revision.rev_timestamp
FROM page
INNER JOIN revision ON page.page_latest = revision.rev_id
INNER JOIN templatelinks ON page_id = tl_from
INNER JOIN linktarget ON tl_target_id = lt_id
WHERE lt_title IN ("Törlés", "Törlés2", "Törlésre_jelölve")
	AND CONCAT('Törlésre_javasolt_lapok/',page.page_title) NOT IN ( # page is not listed on WP:T
		SELECT lt_title
		FROM templatelinks 
        INNER JOIN linktarget ON tl_target_id = lt_id
		WHERE tl_from = 362
    )
    AND page_title NOT LIKE 'Sablonok_listája/Törlés'
ORDER BY revision.rev_timestamp DESC;

SQL

Checking query status...