WP:T unlinked subpages

SQL

-- USE huwiki_p;
SELECT page.page_title, revision.rev_timestamp
FROM page
INNER JOIN revision ON page.page_latest = revision.rev_id
WHERE page.page_namespace = 4 # project namespace 
	AND page.page_title LIKE 'Törlésre_javasolt_lapok/%' # subpages of WP:T
    AND page.page_id NOT IN ( # page not marked as archived by template
    	SELECT tl_from 
        FROM templatelinks 
        INNER JOIN linktarget ON tl_target_id = lt_id
        WHERE lt_title = 'Ta' OR lt_title = 'Lt' OR lt_title = 'Kiürített_lap'
	)
    AND 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.page_id NOT IN ( # page not manually marked as archived
		SELECT categorylinks.cl_from
        FROM categorylinks
      	WHERE categorylinks.cl_to = 'Archivált_törlési_javaslatok'
    )
    AND page.page_is_redirect = 0 # not a redirect
    AND page.page_title NOT LIKE 'Törlésre javasolt lapok/Reform (2007)'
ORDER BY revision.rev_timestamp DESC;
SQL

Checking query status...
