File talk pages with no templates or wikilinks

SQL

SELECT CONCAT('https://en.wikipedia.org/wiki/File_talk:', p.page_title) AS 'Page', TIMESTAMP(r.rev_timestamp) AS 'Last revision', p.page_len AS 'Page length'
FROM page p
LEFT JOIN templatelinks tl ON p.page_id = tl.tl_from
LEFT JOIN pagelinks pl ON p.page_id = pl.pl_from
INNER JOIN revision r ON p.page_latest = r.rev_id
WHERE p.page_namespace = 7
AND tl.tl_from IS NULL
AND pl.pl_from IS NULL
AND p.page_len > 0
-- AND pl.pl_namespace = 4 AND pl.pl_title = 'Signatures'
ORDER BY r.rev_timestamp DESC

SQL

Checking query status...