itwiki/File/File senza template

Output (2) raw

# [[:File:2468 naruto-shippuden-ultimate-ninja-4.png]]
# [[:File:Lago Re di Sole.jpg]]

Information

Last run: 2024-05-04 13:08:54.438096
Last runtime: 14.898841
Author: Incola
License: CC-BY-SA
Frequency: daily
Query run 1554 times taking averagely 50.632092 seconds.

Query

SELECT CONCAT('# [[:File:', page_title, ']]')
FROM page
WHERE page_namespace = 6
AND page_is_redirect = 0
AND page_id NOT IN
(SELECT tl_from
FROM templatelinks)
AND page_title IN
(SELECT img_name
FROM image)
ORDER BY page_title;