Voci di it.wiki con immagini richieste e un interwiki a Commons

SQL

USE itwiki_p;
SELECT DISTINCT CONCAT('# [[', page_title, ']]')
FROM page
WHERE page_namespace = 1
	AND page_id IN (
      SELECT tl_from
      FROM templatelinks
      WHERE tl_namespace = 10 AND ( tl_title = 'Richiesta_immagini' OR tl_title = 'Richiesta_foto' )
    )
	AND page_title IN (
		SELECT REPLACE(WIKI.ips_site_page, ' ', '_')
		FROM wikidatawiki_p.wb_items_per_site WIKI, wikidatawiki_p.wb_items_per_site EXT
		WHERE WIKI.ips_item_id = EXT.ips_item_id
			AND WIKI.ips_site_id = 'itwiki'
			AND EXT.ips_site_id = 'commonswiki'
	)
ORDER BY page_title
LIMIT 1000;

SQL

Checking query status...