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

SQL

USE itwiki_p;
SELECT DISTINCT CONCAT('# [[', main.page_title, ']]')
FROM page main, page talk
WHERE CONCAT('Discussioni:', main.page_title) = talk.page_title
	main.page_namespace = 0 AND talk.page_namespace = 1
	AND main.page_is_redirect = 0
	AND talk.page_id IN (
		SELECT tl_from
		FROM templatelinks
		WHERE tl_namespace = 10 AND ( tl_title = 'Richiesta immagini' OR tl_title = 'Richiesta foto' )
	)
	AND main.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;

SQL

Checking query status...