User:Yann/Images from Gallica
Jump to navigation
Jump to search
SELECT DISTINCT(page_title) FROM page INNER JOIN externallinks ON el_from = page_id AND el_to LIKE "%gallica.bnf.fr%" INNER JOIN image ON img_name = page_title AND img_user = 1 WHERE page_namespace = 6 ORDER BY img_timestamp;