Test - Quarry

SQL

use commonswiki_p;
#describe categorylinks;
select * from page where page_title like "%Peenem%nde%" and page_namespace = 6 and page_is_redirect = 0;
# select * from categorylinks where cl_to = 'Pommern' and cl_type = 'subcat';
# SELECT CONCAT('*[[:File:', page_title, ']]') AS wikitext FROM commonswiki_p.page JOIN commonswiki_p.categorylinks ON cl_from = page_id JOIN commonswiki_p.templatelinks ON tl_from = page_id WHERE page_namespace = 6 AND cl_to IN (SELECT page_title FROM commonswiki_p.categorylinks JOIN commonswiki_p.page ON cl_from = page_id WHERE cl_to = 'Media_needing_categories') AND tl_namespace = 10 AND tl_title = 'De' ORDER BY page_title
SQL

Checking query status...
