Commons deletion requests which haven't been transcluded

These are normally to be added to a daily log page. Note that the list also contains a few deletion request archives and other pages which are not to be added there.

SQL

USE commonswiki_p;
SELECT CONCAT('{{Commons:', p.page_title, '}}') FROM page p
LEFT JOIN (templatelinks t1 INNER JOIN page p2 ON p2.page_id = t1.tl_from AND p2.page_title LIKE 'Deletion_requests/%')
   ON p.page_title = t1.tl_title AND t1.tl_from_namespace = 4 AND t1.tl_namespace = 4
LEFT JOIN templatelinks t2 ON p.page_id = t2.tl_from AND t2.tl_namespace = 10 AND t2.tl_title = 'DeletionHeader'
WHERE t1.tl_from IS NULL
AND t2.tl_from IS NULL
AND p.page_namespace = 4
AND p.page_title LIKE 'Deletion_requests/%'
AND p.page_title NOT LIKE 'Deletion_requests/Archive/%'
AND p.page_is_redirect = 0

SQL

Checking query status...