Wikipedia:Elenchi generati offline/Interprogetto mancante

Elenco delle voci la cui relativa scheda su Wikidata ha valorizzato il parametro "commonswiki" ma che non includono nessuno dei seguenti template:

• {{interprogetto}}
• {{ip}}
• {{commons}}
• {{commons cat}}
• {{commons category}}
• {{commons cat left}}
• {{commonscat}}
• {{commonscat-inline}}
• {{commonscat left}}
• {{disambigua}}

Query

SELECT DISTINCT CONCAT('# [[', page_title, ']]')
FROM page
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_id NOT IN (
SELECT tl_from
FROM templatelinks
WHERE tl_namespace = 10
AND tl_title IN (
'Interprogetto',
'Ip',
'Commons',
'Commons_cat',
'Commons_category',
'Commons_cat_left',
'Commonscat',
'Commonscat-inline',
'Commonscat_left',
'Disambigua' ) )
AND page_title IN (
SELECT REPLACE(WIKI.ips_site_page, ' ', '_')
FROM wikidatawiki_p.wb_items_per_site WIKI, wikidatawiki_p.wb_items_per_site COMMONS
WHERE WIKI.ips_item_id = COMMONS.ips_item_id
AND WIKI.ips_site_id = 'itwiki'
AND COMMONS.ips_site_id = 'commonswiki' )
ORDER BY page_title;