Query test 6 - Quarry

SQL

SELECT CONCAT( "# [[:File:", page_title, "]]")
FROM page
WHERE page_namespace = 6
AND page_id IN
(SELECT tl_from
FROM templatelinks
WHERE tl_target_id IN
(SELECT lt_id
 FROM linktarget
 WHERE lt_namespace = 10
 AND lt_title IN ('NowCommons')))
 AND page_title NOT IN ('Oil_Prices_1971_2007.svg.png', 'Pepe.jpg', 'Poloniny_2008a.jpg', 'Portulaca_oleracea.jpg', 'Re-magi-interno.jpg', 'Repubblica_di_Bobbio.jpg.jpg', 'S8000042.JPG', 'SCA08.jpg', 'SMOM_12._GM_Alfonse_de_Portugal.jpg', 'Serie_B_2011-2012.PNG', 'Spissky_Hrhov_church.jpg', 'Stream_in_Stuzica.jpg', 'Stuzica_forest.jpg', 'Stuzica.jpg', 'Tessuto.jpg', 'Testina.jpg', 'Themepark_ita_icon.png')
ORDER BY page_title;
SQL

Checking query status...
