Ligàmme a Commons sénsa template

SQL

USE lijwiki_p;
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 = 'Interprogetto'
OR tl_title = 'Ip'
OR tl_title = 'Commons'
OR tl_title = 'Commons_cat'
OR tl_title = 'Commons_category'
OR tl_title = 'Commons_cat_left'
OR tl_title = 'Commonscat'
OR tl_title = 'Commonscat-inline'
OR tl_title = 'Commonscat_left'
OR tl_title = '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 EXT
WHERE WIKI.ips_item_id = EXT.ips_item_id
AND WIKI.ips_site_id = 'lijwiki'
AND EXT.ips_site_id = 'commonswiki' )
ORDER BY page_title;
SQL

Checking query status...
